9 συμβουλές για να αποφύγουμε το κρυολόγημα
- Γράφτηκε από
- Κατηγορία Health
Κύριο
ΚΟΙΝΟΠΟΙΗΣΤΕ
Η Dr. Μαρία Ψωμά MD, PhD, DU, Ιατρός - Βιοπαθολόγος, Διδάκτωρ Πανεπιστημίου Αθηνών, Μεταπτυχιακό στην "Ιατρική και Χειρουργική της Παχυσαρκίας" στην Ιατρική Σχόλη Πανεπιστημίου Παρισιού (PARIS VI), αναφέρει στο Υγείαonline.gr, 9 συμβουλές για να αποφύγουμε το κρυολόγημα και την γρίπη.
Όταν είστε άρρωστοι, θέλετε να αναρρώσετε γρήγορα. Αυτές οι συμβουλές θα σας βοηθήσουν να αντιμετωπίσετε το κρυολόγημα και να γίνετε πιο γρήγορα καλά.
1. Ζεστό τσάι με μέλι και λεμόνι: Όταν υποφέρετε από κοινό κρυολόγημα ή γρίπη, να πίνετε άφθονα υγρά για να μένει ο οργανισμός σας ενυδατωμένος ενώ θα πρέπει να βεβαιωθείτε ότι είναι ζεστά.
Το μαύρο τσάι βοηθά στην καταπράυνση του πονόλαιμου καθώς επίσης βοηθά ώστε να μην νιώθετε ρίγος, λόγω του μεγάλου ποσοστού ιντερφερόνης η οποία μάχεται τον ιό. Προσθέστε μια κουταλιά μέλι για αντιοξειδωτικά σε συνδυασμό με το λεμόνι για περισσότερη βιταμίνη C.
2. Χυμός πορτοκάλι: Πιείτε χυμό πορτοκάλι όταν είστε άρρωστοι, καθώς είναι πλούσιος σε βιταμίνη C. Προτιμήστε όλο το πορτοκάλι στο μπλέντερ.
Όταν είστε άρρωστοι, θέλετε να αναρρώσετε γρήγορα. Αυτές οι συμβουλές θα σας βοηθήσουν να αντιμετωπίσετε το κρυολόγημα και να γίνετε πιο γρήγορα καλά.
1. Ζεστό τσάι με μέλι και λεμόνι: Όταν υποφέρετε από κοινό κρυολόγημα ή γρίπη, να πίνετε άφθονα υγρά για να μένει ο οργανισμός σας ενυδατωμένος ενώ θα πρέπει να βεβαιωθείτε ότι είναι ζεστά.
Το μαύρο τσάι βοηθά στην καταπράυνση του πονόλαιμου καθώς επίσης βοηθά ώστε να μην νιώθετε ρίγος, λόγω του μεγάλου ποσοστού ιντερφερόνης η οποία μάχεται τον ιό. Προσθέστε μια κουταλιά μέλι για αντιοξειδωτικά σε συνδυασμό με το λεμόνι για περισσότερη βιταμίνη C.
2. Χυμός πορτοκάλι: Πιείτε χυμό πορτοκάλι όταν είστε άρρωστοι, καθώς είναι πλούσιος σε βιταμίνη C. Προτιμήστε όλο το πορτοκάλι στο μπλέντερ.
Η βιταμίνη C μπορεί να βοηθήσει ώστε να μειωθεί η διάρκεια ενός κρυολογήματος και συμβάλει και ως φυσικό αποσυμφορητικό. Θα πρέπει να λαμβάνετε 500 mg βιταμίνης C τέσσερις φορές την ημέρα. Υπολογίστε πως ένα φλιτζάνι περιέχει 124 mg βιταμίνης c. Άλλες καλές πηγές βιταμίνης C είναι οι φράουλες, οι ντομάτες, και το μπρόκολο.
3. Καυτερές πιπεριές: Οι καυτερές πιπεριές περιέχουν καψαϊκίνη, η ένωση αυτή λειτουργεί ως αποσυμφορητικό για την βουλωμένη μύτη.
Εάν δεν μπορείτε να καταναλώσετε τόσο καυτερά τότε διαλέξτε ήπιου καψίματος πιπεριές οι οποίες μπορούν επίσης να βοηθήσουν πάρα πολύ. Δεν περιέχουν καψαϊκίνη, αλλά είναι γεμάτες από βιταμίνη C.
4. Καταναλώστε κοτόσουπα: Ένα μπολ σούπα κοτόπουλου θα σας κάνει να νιώσετε καλύτερα ενώ είστε άρρωστοι.
Αυτή τη φορά, το φάρμακο που παίρνουμε από την σούπα είναι η κυστεΐνη, ένα αμινοξύ που είναι χημικά παρόμοιο με ένα φάρμακο που δίνεται στην βρογχίτιδα για να βοηθήσει στη μείωση της φλεγμονής. Ο αλμυρός ζωμός βοηθά επίσης στη μείωση της βλέννας, ενώ η πρωτεΐνη του κοτόπουλου, σας βοηθά να παραχθούν αντισώματα για την καταπολέμηση της νόσου.
5. Σκόρδο και τζίντζερ: Τόσο το σκόρδο όσο και το τζίντζερ μπορούν να προσφέρουν ανακούφιση από το κρυολόγημα και την γρίπη.
Το σκόρδο βοηθά στην ενίσχυση του ανοσοποιητικού συστήματος ώστε να αποφευχθεί κάποια μόλυνση. Επίσης το τζίντζερ βοηθάει να μειωθούν να συμπτώματα της ναυτίας. Προσθέστε λίγο τζίντζερ και σκόρδο στην κοτόσουπα σας για να ενισχύσετε το ανοσοποιητικό σας και να δημιουργήσετε αντισώματα απέναντι στο κρυολόγημα και την γρίπη.
6. Ζεστό μπάνιο: Υπάρχει λόγος για τον οποίο αισθάνεστε καλύτερα μετά από ένα ζεστό ντους.
Ο ατμός συρρικνώνει τη βλέννα στη μύτη και το λαιμό και ενθαρρύνει ώστε να αποβληθεί η βλέννα. Αυτό έχει σαν αποτέλεσμα την αποσυμφόρηση της βουλωμένης μύτης.
7. Ιβουπροφαίνη ή ακεταμινοφαίνη: Καταπολεμήστε τον πυρετό και την γρίπη.
Πάρτε ακεταμινοφαίνη ή ιβουπροφαίνη και θα σας βοηθήσει να μειώσετε τον πυρετό. Αν ο πυρετός σας παραμένει πάνω από 39 βαθμούς Κελσίου για περισσότερο από δύο ώρες (ειδικά στα παιδιά), επικοινωνήστε με τον γιατρό σας.
8. Πλιγούρι: Τα δημητριακά ολικής αλέσεως, όπως το πλιγούρι βρώμης, περιέχει σελήνιο, ψευδάργυρο, και β-γλυκάνη, αυτά τα συστατικά βοηθούν στην τόνωση του ανοσοποιητικού σας συστήματος και μάχονται το κρύο και τις λοιμώξεις.
Επίσης προσθέστε μια μεγάλη κουταλιά γιαούρτι, καθώς τα προβιοτικά που περιέχει μπορούν να βοηθήσουν να κρατηθεί ο ιός μακριά από το αναπνευστικό σας σύστημα.
9. Ρινικό αποσυμφορητικό σπρέι: Ένα ρινικό σπρέι μπορεί να συμβάλει στη μείωση της κυκλοφοριακής συμφόρησης.
Ωστόσο μην το παρακάνετε. Χρησιμοποιώντας ένα ρινικό, αποσυμφορητικό σπρέι για περισσότερο από τρεις ημέρες μπορεί να προκαλέσει τα αντίθετα αποτελέσματα και μεγαλύτερη συμφόρηση.
Dr. Μαρία Αθ. Ψωμά MD, PhD, DU
Ιατρός - Βιοπαθολόγος - Διδάκτωρ Πανεπιστημίου Αθηνών
Μεταπτυχιακό στην "Ιατρική και Χειρουργική της Παχυσαρκίας"
στην Ιατρική Σχόλη Πανεπιστημίου Παρισιού (PARIS VI)
www.psoma.gr
{fcomments}
Τελευταία τροποποίηση στιςΔευτέρα, 27 Ιανουαρίου 2014 15:13
ΚΟΙΝΟΠΟΙΗΣΤΕ
Ετικέτες
Σχετικά Άρθρα
-
Κρυολόγημα: Ειδικός απαντά αν αποτελούν "θεραπείες" οι βιταμίνη C και ψευδάργυρος
-
Τι να προσέξετε στη διατροφή σας λόγω καύσωνα!
-
Τρέξιμο στη ζέστη: Συμβουλές και τρόποι προστασίας
-
8 συμβουλές για σούπερ στέγνωμα!
-
Γρήγορες συμβουλές για σωστή τεχνική όταν προπονείσαι μόνος σου
loading...
Template Design © Joomla Templates | GavickPro. All rights reserved.
Κονσόλα Αποσφαλμάτωσης του Joomla!
{
"__default": {
"session": {
"counter": 2,
"timer": {
"start": 1782014383,
"last": 1782014383,
"now": 1782014386
},
"token": "BEQYfedAlnArDINdlBYpY9ZpjOnReBo7"
},
"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
},
"com_mailto": {
"links": {
"0daeaeede6c7b174880b569d5973606b3b8e407d": {
"link": "https://www.ifitnessbook.com/nutrition/%CE%B4%CE%B9%CE%B1%CF%84%CF%81%CE%BF%CF%86%CE%B7/%CF%84%CE%B1-%CE%B1%CE%BC%CF%8D%CE%B3%CE%B4%CE%B1%CE%BB%CE%B1-%CE%BA%CE%B1%CE%B9-%CF%84%CE%B1-%CE%B1%CF%80%CE%AF%CF%83%CF%84%CE%B5%CF%85%CF%84%CE%B1-%CE%BF%CF%86%CE%AD%CE%BB%CE%B7-%CE%B3%CE%B9%CE%B1-%CF%84%CE%BF-%CF%83%CF%8E%CE%BC%CE%B1-%CE%BC%CE%B1%CF%82",
"expiry": 1782014385
},
"1b8ebb7e0548c70521fd5d5d7fb6c9c6c3c81191": {
"link": "https://www.ifitnessbook.com/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/9-symvoules-gia-na-apofygoume-to-kryologima?print=1&tmpl=component",
"expiry": 1782014386
}
}
}
}
}
Χρόνος
Μνήμη
Χρόνος: 24.88 ms / 24.88 ms Μνήμη: 0.410 MB / 0.75 MB Application: afterLoad
Χρόνος: 56.49 ms / 81.37 ms Μνήμη: 1.123 MB / 1.87 MB Application: afterInitialise
Χρόνος: 75.78 ms / 157.15 ms Μνήμη: 1.010 MB / 2.88 MB Application: afterRoute
Χρόνος: 1.45 ms / 158.60 ms Μνήμη: 0.081 MB / 2.96 MB Application: beforeRenderComponent com_k2
Χρόνος: 0.21 ms / 158.81 ms Μνήμη: 0.018 MB / 2.98 MB Application: Before Access::preloadComponents (all components)
Χρόνος: 0.95 ms / 159.75 ms Μνήμη: 0.063 MB / 3.04 MB Application: After Access::preloadComponents (all components)
Χρόνος: 0.02 ms / 159.78 ms Μνήμη: -0.002 MB / 3.04 MB Application: Before Access::getAssetRules (id:54 name:com_k2)
Χρόνος: 0.84 ms / 160.62 ms Μνήμη: 0.008 MB / 3.05 MB Application: After Access::getAssetRules (id:54 name:com_k2)
Χρόνος: 174.31 ms / 334.93 ms Μνήμη: 1.538 MB / 4.59 MB Application: afterRenderComponent com_k2
Χρόνος: 11.42 ms / 346.35 ms Μνήμη: 0.013 MB / 4.60 MB Application: afterDispatch
Χρόνος: 67.04 ms / 413.39 ms Μνήμη: 0.297 MB / 4.90 MB Application: afterRender
Ολικές επερωτήσεις βάσης δεδομένων¨157.82 ms
6,03 MB (6.317.792 Bytes)
Καταγράφηκαν 68 ερωτήματα 157.82 ms
- Χρόνος επερώτησης:1.07 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 1.031 MB Σειρές που επιστράφηκαν:1
SELECT `data`
FROM `plzh7_session`
WHERE `session_id` = X'3031646630623466316432343564396330386666306130373364343737326530'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.11 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.04 ms System lock 0.03 ms table lock 0.03 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.03 ms Unlocking tables 0.03 ms Preparing 0.04 ms Executing 0.03 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 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.95 ms Μετά την τελευταία επερώτηση:5.29 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.137 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.11 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.04 ms Executing 0.03 ms Sending data 0.08 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.00 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.150 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.09 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.03 ms Unlocking tables 0.03 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.06 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.94 ms Μετά την τελευταία επερώτηση:18.01 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 1.634 MB Σειρές που επιστράφηκαν:0
SELECT `value`
FROM `plzh7_admintools_storage`
WHERE `key` = 'cparams'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.11 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.04 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:409 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:892 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.90 ms Μετά την τελευταία επερώτηση:0.34 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.643 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.04 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.05 ms Executing 0.03 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.06 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:729 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.18 ms Μετά την τελευταία επερώτηση:9.18 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.838 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/9-symvoules-gia-na-apofygoume-to-kryologima') 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/9-symvoules-gia-na-apofygoume-to-kryologima?print=1&tmpl=component') 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/9-symvoules-gia-na-apofygoume-to-kryologima?print=1&tmpl=component' 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.16 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.05 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.03 ms Sending data 0.04 ms Creating sort index 0.09 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.04 ms Reset for next command 0.04 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 - Χρόνος επερώτησης:46.99 ms Μετά την τελευταία επερώτηση:14.85 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 2.784 MB Σειρές που επιστράφηκαν:1
SELECT id
FROM plzh7_k2_items
WHERE alias = '9-symvoules-gia-na-apofygoume-to-kryologima'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_items ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 13384 Using where Status Duration Starting 0.10 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.05 ms Executing 0.03 ms Sending data 46.00 ms End of update loop 0.05 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.04 ms Query end 0.04 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.04 ms Reset for next command 0.04 ms # Καλών Αρχείο και αριθμός σειράς 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_k2/router.php:503 11 getItemId() JROOT/components/com_k2/router.php:353 10 k2ParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.48 ms Μετά την τελευταία επερώτηση:3.35 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 2.794 MB
UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"31edb4c774d939000c6441e1257e61d5\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `plzh7_extensions` SET `params` = '{\"mediaversion\":\"31edb4c774d939000c6441e1257e61d5\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.08 ms Updating 0.04 ms End of update loop 0.01 ms Query end 0.01 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.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 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 - Χρόνος επερώτησης:0.76 ms Μετά την τελευταία επερώτηση:15.19 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 2.987 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.08 ms checking permissions 0.02 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.02 ms Statistics 0.10 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.15 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 # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:1.25 ms Μετά την τελευταία επερώτηση:8.91 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.178 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.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.62 ms End of update loop 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.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/helpers/permissions.php:274 13 K2HelperPermissions::canAddItem() JROOT/components/com_k2/views/item/view.html.php:36 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.73 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.062 MB Μνήμη πριν την επερώτηση: 3.185 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_items
WHERE id=3422
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_items const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 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 Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.24 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:35 13 K2ModelItem->getData() JROOT/components/com_k2/views/item/view.html.php:42 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.20 ms Μετά την τελευταία επερώτηση:0.53 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.288 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.02 ms closing tables 0.01 ms checking permissions 0.02 ms Opening tables 0.36 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.02 ms Filling schema table 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms checking permissions 0.10 ms closing tables 0.02 ms checking permissions 0.02 ms Executing 0.01 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.01 ms Removing tmp table 0.14 ms closing tables 0.02 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 # Καλών Αρχείο και αριθμός σειράς 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2category.php:36 15 TableK2Category->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:72 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.60 ms Μετά την τελευταία επερώτηση:1.16 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.312 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '31'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 15 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 14 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.52 ms Μετά την τελευταία επερώτηση:1.59 ms Μνήμη με επερώτηση: 0.029 MB Μνήμη πριν την επερώτηση: 3.348 MB Σειρές που επιστράφηκαν:76
SELECT id, name, parent
FROM plzh7_k2_categories
WHERE published=1
AND trash=0
AND access IN(1,1,5)
ORDER BY parentid 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.07 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.87 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:1245 16 K2ModelItemlist->getCategoriesTree() JROOT/components/com_k2/helpers/route.php:314 15 K2HelperRoute::_findItem() JROOT/components/com_k2/helpers/route.php:58 14 K2HelperRoute::getCategoryRoute() JROOT/components/com_k2/models/item.php:76 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.85 ms Μετά την τελευταία επερώτηση:1.69 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.443 MB Σειρές που επιστράφηκαν:2
SELECT tag.*
FROM plzh7_k2_tags AS tag JOIN plzh7_k2_tags_xref AS xref
ON tag.id = xref.tagID
WHERE tag.published=1
AND xref.itemID = 3422
ORDER BY xref.id ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE xref ref tagID,itemID itemID 4 const 2 Using where; Χρήση ταξινόμησης αρχείου 1 SIMPLE tag eq_ref PRIMARY,published PRIMARY 4 ifitness_ifitnew.xref.tagID 1 Using where Status Duration Starting 0.09 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.02 ms Creating sort index 0.09 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.02 ms Query end 0.04 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1387 14 K2ModelItem->getItemTags() JROOT/components/com_k2/models/item.php:107 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.58 ms Μετά την τελευταία επερώτηση:1.18 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.457 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_k2_attachments
WHERE itemID=3422id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_attachments ref itemID itemID 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1680 14 K2ModelItem->getItemAttachments() JROOT/components/com_k2/models/item.php:188 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.51 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.467 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_k2_rating
WHERE itemID = 3422id 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.04 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.03 ms Statistics 0.04 ms Preparing 0.02 ms Executing 0.02 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1011 15 K2ModelItem->getRating() JROOT/components/com_k2/models/item.php:1066 14 K2ModelItem->getVotesPercentage() JROOT/components/com_k2/models/item.php:194 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.59 ms Μετά την τελευταία επερώτηση:1.27 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 3.498 MB Σειρές που επιστράφηκαν:17
SHOW FULL COLUMNS
FROM `plzh7_users`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_users`Status Duration Starting 0.04 ms checking permissions 0.02 ms closing tables 0.02 ms checking permissions 0.02 ms Opening tables 0.41 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms checking permissions 0.13 ms closing tables 0.03 ms checking permissions 0.02 ms Executing 0.03 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.03 ms closing tables 0.02 ms Removing tmp table 0.17 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 24 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 23 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 22 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 21 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 20 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 19 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 18 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 17 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 16 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 15 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 14 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:246 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.52 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.529 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM `plzh7_users`
WHERE `id` = 64id 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.04 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.04 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.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 19 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 18 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 17 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 16 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 15 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 14 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:246 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.54 ms Μετά την τελευταία επερώτηση:1.45 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.546 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=64id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 14 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.55 ms Μετά την τελευταία επερώτηση:0.26 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.554 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=3422
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.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 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.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 15 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.82 ms Μετά την τελευταία επερώτηση:2.30 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.567 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.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.28 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54 16 PlgContentPerfect_everything_in_everyway->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 15 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 14 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_k2/models/item.php:537 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:54 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.69 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.576 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.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.04 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.03 ms Sending data 0.06 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.03 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.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73 16 PlgContentPerfect_everything_in_everyway->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 15 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 14 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_k2/models/item.php:537 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:54 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.64 ms Μετά την τελευταία επερώτηση:3.32 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.667 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item-media'
AND (fc.category_id IS NULL OR fc.category_id IN (31,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.15 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.08 ms Creating tmp table 0.08 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.47 ms Creating sort index 0.05 ms Removing tmp table 0.11 ms Creating sort index 0.02 ms End of update loop 0.03 ms Query end 0.01 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.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 20 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 19 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 18 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 17 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 16 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:54 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.52 ms Μετά την τελευταία επερώτηση:1.90 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.716 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.item'
AND (fc.category_id IS NULL OR fc.category_id IN (31,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.14 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Creating tmp table 0.07 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.44 ms Creating sort index 0.04 ms Removing tmp table 0.10 ms Creating sort index 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 17 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 16 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 15 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 14 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:744 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:54 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.18 ms Μετά την τελευταία επερώτηση:0.63 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 3.733 MB Σειρές που επιστράφηκαν:36
SHOW FULL COLUMNS
FROM `plzh7_k2_items`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_items`Status Duration Starting 0.04 ms checking permissions 0.01 ms closing tables 0.01 ms checking permissions 0.01 ms Opening tables 0.28 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Filling schema table 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.16 ms closing tables 0.02 ms checking permissions 0.02 ms Executing 0.01 ms Sending data 0.08 ms End of update loop 0.02 ms Query end 0.01 ms closing tables 0.01 ms Removing tmp table 0.13 ms closing tables 0.02 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 # Καλών Αρχείο και αριθμός σειράς 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/k2item.php:58 15 TableK2Item->__construct() JROOT/libraries/src/Table/Table.php:328 14 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_k2/models/item.php:917 13 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:136 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:39.92 ms Μετά την τελευταία επερώτηση:0.11 ms Μνήμη με επερώτηση: 0.007 MB Μνήμη πριν την επερώτηση: 3.779 MB
UPDATE plzh7_k2_items
SET `hits` = (`hits` + 1)
WHERE `id` = '3422'Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE plzh7_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '3422'Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms Waiting for table level lock 38.96 ms table lock 0.06 ms init for update 0.14 ms Updating 0.21 ms End of update loop 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.08 ms closing tables 0.04 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.04 ms Updating status 0.06 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 14 Joomla\CMS\Table\Table->hit() JROOT/components/com_k2/models/item.php:918 13 K2ModelItem->hit() JROOT/components/com_k2/views/item/view.html.php:136 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.47 ms Μετά την τελευταία επερώτηση:0.15 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.783 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_k2_comments
WHERE itemID=3422
AND published=1
ORDER BY commentDate DESC
LIMIT 0, 10id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_comments range itemID,published,latestComments,countComments latestComments 4 NULL 1 Using where Status Duration Starting 0.13 ms checking permissions 0.04 ms Opening tables 0.06 ms After opening tables 0.05 ms System lock 0.03 ms table lock 0.04 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.15 ms Preparing 0.09 ms Sorting result 0.03 ms Executing 0.03 ms Sending data 0.09 ms End of update loop 0.04 ms Query end 0.05 ms Commit 0.05 ms Query end 0.06 ms closing tables 0.03 ms Unlocking tables 0.06 ms closing tables 0.03 ms Query end 0.04 ms Starting cleanup 0.05 ms Freeing items 0.06 ms Updating status 0.07 ms Reset for next command 0.05 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/item.php:1703 13 K2ModelItem->getItemComments() JROOT/components/com_k2/views/item/view.html.php:242 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:6.40 ms Μετά την τελευταία επερώτηση:1.02 ms Μνήμη με επερώτηση: 0.135 MB Μνήμη πριν την επερώτηση: 3.792 MB Σειρές που επιστράφηκαν:5
SELECT i.*, c.alias as categoryalias
FROM plzh7_k2_items as i
LEFT JOIN plzh7_k2_categories c
ON c.id = i.catid
WHERE i.id != 3422
AND i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-21 03:59:46' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 03:59:46' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND i.created_by = 64
AND i.created_by_alias=''
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
ORDER BY i.created DESC
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i index PRIMARY,item,catid,created_by created 5 NULL 22 Using where 1 SIMPLE c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 ifitness_ifitnew.i.catid 1 Using index condition; Using where Status Duration Starting 0.17 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.13 ms Optimizing 0.12 ms Statistics 0.26 ms Preparing 0.12 ms Sorting result 0.04 ms Executing 0.03 ms Sending data 5.02 ms End of update loop 0.03 ms Query end 0.03 ms closing tables 0.02 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.02 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.11 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:871 13 K2ModelItemlist->getAuthorLatest() JROOT/components/com_k2/views/item/view.html.php:291 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.45 ms Μετά την τελευταία επερώτηση:7.98 ms Μνήμη με επερώτηση: 0.028 MB Μνήμη πριν την επερώτηση: 3.893 MB Σειρές που επιστράφηκαν:183
SELECT DISTINCT itemID
FROM plzh7_k2_tags_xref
WHERE tagID IN (207,820)
AND itemID!=3422id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_tags_xref range tagID,itemID tagID 4 NULL 167 Using index condition; Using where; Using temporary Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Creating tmp table 0.04 ms Executing 0.02 ms Sending data 0.72 ms Removing tmp table 0.02 ms Sending data 0.02 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/models/itemlist.php:927 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:5.00 ms Μετά την τελευταία επερώτηση:0.23 ms Μνήμη με επερώτηση: 0.072 MB Μνήμη πριν την επερώτηση: 3.921 MB Σειρές που επιστράφηκαν:5
SELECT i.*, c.alias as categoryalias
FROM plzh7_k2_items as i
LEFT JOIN plzh7_k2_categories c
ON c.id = i.catid
WHERE i.published = 1
AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-06-21 03:59:46' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-06-21 03:59:46' )
AND i.access IN(1,1,5)
AND i.trash = 0
AND c.published = 1
AND c.access IN(1,1,5)
AND c.trash = 0
AND (i.id) IN (84,918,955,970,982,991,1094,1097,1243,1414,1755,1890,1959,2004,2145,2593,2836,2894,55,3056,3096,3136,3178,3182,3191,3211,2104,2558,3346,3395,3439,3470,3501,3731,3742,3761,3835,3893,3897,3899,3900,3908,3916,3927,3937,3945,3970,3984,3997,4010,4029,4111,4124,4130,4133,4183,4184,4200,4262,4264,940,3469,4430,4447,4496,4576,4605,4663,4737,4748,4942,5097,5104,5144,5172,5187,5208,5153,5288,5393,5423,5482,5491,5512,5539,5576,5590,5718,5813,5868,5895,5906,5980,6075,6127,6203,6319,6661,6670,6675,6755,6771,6785,6846,7234,7240,7267,7281,7404,7407,7428,7440,7557,7562,7582,7586,7603,7625,7635,7671,7732,7738,7813,7831,7854,7866,7874,7885,7893,7918,7947,7949,7987,7991,8017,8021,8043,8094,8098,8109,8112,8204,8205,8266,8287,8340,8349,8387,8394,8440,8449,8459,8485,8555,8572,8601,8627,8651,8741,8845,8867,8871,8874,8924,9003,9160,9268,9411,9461,9683,9799,9959,10025,10104,10114,10188,10208,10339,605,736,7188,8904,14553)
ORDER BY i.created DESC
LIMIT 0, 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE i range PRIMARY,item,catid PRIMARY 4 NULL 183 Using index condition; Using where; Χρήση ταξινόμησης αρχείου 1 SIMPLE c eq_ref PRIMARY,category,published,access,trash PRIMARY 4 ifitness_ifitnew.i.catid 1 Using index condition; Using where Status Duration Starting 0.19 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.14 ms Optimizing 0.10 ms Statistics 0.34 ms Preparing 0.30 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.05 ms Creating sort index 3.30 ms End of update loop 0.04 ms Query end 0.04 ms closing tables 0.06 ms Unlocking tables 0.04 ms closing tables 0.03 ms Query end 0.05 ms Starting cleanup 0.05 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php:975 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.91 ms Μετά την τελευταία επερώτηση:0.17 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.992 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '183'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.03 ms System lock 0.04 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Unlocking tables 0.02 ms Preparing 0.05 ms Executing 0.03 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.04 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.05 ms Query end 0.05 ms Starting cleanup 0.05 ms Freeing items 0.05 ms Updating status 0.06 ms Reset for next command 0.04 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.58 ms Μετά την τελευταία επερώτηση:1.83 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.062 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.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.03 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.02 ms Query end 0.02 ms 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.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:94 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.64 ms Μετά την τελευταία επερώτηση:2.43 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.087 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=14553
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.06 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.02 ms Query end 0.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.02 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.70 ms Μετά την τελευταία επερώτηση:1.45 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.074 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (183,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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.15 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.08 ms Optimizing 0.09 ms Statistics 0.14 ms Preparing 0.06 ms Creating tmp table 0.07 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.41 ms Creating sort index 0.04 ms Removing tmp table 0.10 ms Creating sort index 0.02 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.03 ms Unlocking tables 0.01 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.42 ms Μετά την τελευταία επερώτηση:0.85 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.086 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (183,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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.12 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.01 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.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.40 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.02 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.01 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:744 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.46 ms Μετά την τελευταία επερώτηση:0.39 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.097 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '184'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_categories const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.47 ms Μετά την τελευταία επερώτηση:3.47 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.177 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM `plzh7_users`
WHERE `id` = 850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_users const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.02 ms Preparing 0.02 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 # Καλών Αρχείο και αριθμός σειράς 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 20 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 19 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 18 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 17 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 16 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 15 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:246 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.47 ms Μετά την τελευταία επερώτηση:1.09 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.189 MB Σειρές που επιστράφηκαν:2
SELECT `g`.`id`,`g`.`title`
FROM `plzh7_usergroups` AS g
INNER JOIN `plzh7_user_usergroup_map` AS m
ON m.group_id = g.id
WHERE `m`.`user_id` = 850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref PRIMARY PRIMARY 4 const 2 Using index 1 SIMPLE g eq_ref PRIMARY PRIMARY 4 ifitness_ifitnew.m.group_id 1 Status Duration Starting 0.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.02 ms Optimizing 0.02 ms Statistics 0.05 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.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 20 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Table/User.php:112 19 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 18 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 17 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 16 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 15 Joomla\CMS\Factory::getUser() JROOT/components/com_k2/models/item.php:246 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.42 ms Μετά την τελευταία επερώτηση:0.41 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.196 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 15 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.44 ms Μετά την τελευταία επερώτηση:0.40 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.205 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 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.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.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.41 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.213 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=8572
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.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.04 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.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.32 ms Μετά την τελευταία επερώτηση:0.91 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.200 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (184,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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.11 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.06 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.38 ms Creating sort index 0.04 ms Removing tmp table 0.09 ms Creating sort index 0.02 ms End of update loop 0.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.02 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.02 ms # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.35 ms Μετά την τελευταία επερώτηση:0.80 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.212 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (184,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering 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.12 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.06 ms Optimizing 0.05 ms Statistics 0.12 ms Preparing 0.05 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.38 ms Creating sort index 0.05 ms Removing tmp table 0.10 ms Creating sort index 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:744 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.54 ms Μετά την τελευταία επερώτηση:0.46 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.223 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '34'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.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.04 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.43 ms Μετά την τελευταία επερώτηση:4.17 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.303 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.02 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 15 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.37 ms Μετά την τελευταία επερώτηση:0.39 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.311 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 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.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.320 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=8627
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.03 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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.07 ms Μετά την τελευταία επερώτηση:0.90 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.306 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (34,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.09 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.09 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.30 ms Creating sort index 0.03 ms Removing tmp table 0.07 ms Creating sort index 0.01 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 # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.11 ms Μετά την τελευταία επερώτηση:0.84 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.318 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (34,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.12 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.06 ms Optimizing 0.04 ms Statistics 0.09 ms Preparing 0.04 ms Creating tmp table 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.30 ms Creating sort index 0.03 ms Removing tmp table 0.07 ms Creating sort index 0.01 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 # Καλών Αρχείο και αριθμός σειράς 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:744 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.37 ms Μετά την τελευταία επερώτηση:0.27 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.329 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '18'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.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.03 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:3.83 ms Μετά την τελευταία επερώτηση:2.54 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.409 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 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.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 15 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.35 ms Μετά την τελευταία επερώτηση:0.27 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.417 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 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.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.37 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.425 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=8266
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.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.04 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.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.15 ms Μετά την τελευταία επερώτηση:0.63 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.412 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (18,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.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.06 ms Optimizing 0.04 ms Statistics 0.10 ms Preparing 0.04 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.32 ms Creating sort index 0.03 ms Removing tmp table 0.08 ms Creating sort index 0.01 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 # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.10 ms Μετά την τελευταία επερώτηση:0.64 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.424 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (18,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.13 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.09 ms Preparing 0.04 ms Creating tmp table 0.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.30 ms Creating sort index 0.03 ms Removing tmp table 0.07 ms Creating sort index 0.01 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 # Καλών Αρχείο και αριθμός σειράς 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:744 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.29 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.435 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_categories
WHERE id = '6'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.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.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.54 ms Μετά την τελευταία επερώτηση:2.94 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.515 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.06 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 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.02 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.02 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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 15 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.47 ms Μετά την τελευταία επερώτηση:0.31 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.524 MB Σειρές που επιστράφηκαν:0
SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users
WHERE userID=850id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_users ref userID userID 4 const 1 Status Duration Starting 0.05 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.04 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.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.49 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.532 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=8874
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.04 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.06 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.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.98 ms Μετά την τελευταία επερώτηση:0.66 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.519 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag-media'
AND (fc.category_id IS NULL OR fc.category_id IN (6,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.20 ms checking permissions 0.02 ms Opening tables 0.07 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.12 ms Optimizing 0.09 ms Statistics 0.24 ms Preparing 0.09 ms Creating tmp table 0.12 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.52 ms Creating sort index 0.05 ms Removing tmp table 0.12 ms Creating sort index 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.87 ms Μετά την τελευταία επερώτηση:0.76 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.531 MB Σειρές που επιστράφηκαν:0
SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
FROM plzh7_fields AS a
LEFT JOIN `plzh7_languages` AS l
ON l.lang_code = a.language
LEFT JOIN plzh7_users AS uc
ON uc.id=a.checked_out
LEFT JOIN plzh7_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN plzh7_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN plzh7_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `plzh7_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_k2.relatedByTag'
AND (fc.category_id IS NULL OR fc.category_id IN (6,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.22 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.12 ms Optimizing 0.09 ms Statistics 0.21 ms Preparing 0.09 ms Creating tmp table 0.11 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.47 ms Creating sort index 0.05 ms Removing tmp table 0.13 ms Creating sort index 0.02 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.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 23 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 22 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 21 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 20 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 19 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:404 18 PlgSystemFields->display() JROOT/plugins/system/fields/fields.php:324 17 PlgSystemFields->onContentAfterTitle() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:744 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.27 ms Μετά την τελευταία επερώτηση:0.50 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 4.520 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_items
WHERE id != 3422
AND catid=31
AND ordering > 3
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-21 03:59:46' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-21 03:59:46' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering ASC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_items ref PRIMARY,item,catid,ordering catid 4 const 20 Using where; Χρήση ταξινόμησης αρχείου Status Duration Starting 0.11 ms checking permissions 0.02 ms Opening tables 0.02 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.10 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.03 ms Creating sort index 0.47 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.03 ms Updating status 0.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1835 13 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:323 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.29 ms Μετά την τελευταία επερώτηση:1.31 ms Μνήμη με επερώτηση: 0.070 MB Μνήμη πριν την επερώτηση: 4.547 MB Σειρές που επιστράφηκαν:1
SELECT *
FROM plzh7_k2_items
WHERE id != 3422
AND catid=31
AND ordering < 3
AND published=1
AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-06-21 03:59:46' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-06-21 03:59:46' )
AND access IN(1,1,5)
AND trash=0
ORDER BY ordering DESC
LIMIT 0, 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_k2_items ref|filter PRIMARY,item,catid,ordering catid|ordering 4|4 const 20 (1%) Using where; Χρήση ταξινόμησης αρχείου; Using rowid filter Status Duration Starting 0.09 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.09 ms Optimizing 0.06 ms Statistics 0.11 ms Preparing 0.06 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.15 ms Creating sort index 0.44 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.02 ms Updating status 0.02 ms Reset for next command 0.06 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1791 13 K2ModelItem->getPreviousItem() JROOT/components/com_k2/views/item/view.html.php:364 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.07 ms Μετά την τελευταία επερώτηση:29.99 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 4.715 MB Σειρές που επιστράφηκαν:124
SHOW TABLES
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW TABLESStatus Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms checking permissions 0.44 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.01 ms Removing tmp table 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 # Καλών Αρχείο και αριθμός σειράς 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.51 ms Μετά την τελευταία επερώτηση:3.41 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.775 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_metainfo
WHERE `linkurl` = 'https://www.ifitnessbook.com/fitness-2/προγράμματα-γυμναστικής/9-symvoules-gia-na-apofygoume-to-kryologima?print=1&tmpl=component'
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.04 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 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.02 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.02 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.38 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.781 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_canonicals
WHERE `linkurl` = 'https://www.ifitnessbook.com/fitness-2/προγράμματα-γυμναστικής/9-symvoules-gia-na-apofygoume-to-kryologima?print=1&tmpl=component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_jmap_canonicals ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 1 Using where Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 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.02 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 - Χρόνος επερώτησης:1.11 ms Μετά την τελευταία επερώτηση:47.51 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.894 MB Σειρές που επιστράφηκαν:0
SELECT *
FROM plzh7_jmap_headings
WHERE `linkurl` = 'https://www.ifitnessbook.com/fitness-2/προγράμματα-γυμναστικής/9-symvoules-gia-na-apofygoume-to-kryologima?print=1&tmpl=component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_jmap_headings ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 1 Using where Status Duration Starting 0.10 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.05 ms Preparing 0.05 ms Executing 0.03 ms Sending data 0.07 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.04 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.04 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.05 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 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
Καταγράφηκαν 34 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.
ΕΠΙΛΟΓΗ από Πίνακες:
12 × 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.id9 × SELECT id, gender, description, image, url, `
group`, plugins
FROM plzh7_k2_users7 × SELECT *
FROM plzh7_k2_categories6 × SELECT COUNT(*)
FROM plzh7_k2_comments3 × SELECT *
FROM plzh7_k2_items2 × SELECT i.*, c.alias as categoryalias
FROM plzh7_k2_items as i
LEFT JOIN plzh7_k2_categories c
ON c.id = i.catid2 × SELECT *
FROM `plzh7_users`1 × SELECT `data`
FROM `plzh7_session`1 × SELECT *
FROM plzh7_jmap_canonicals1 × SELECT *
FROM plzh7_jmap_metainfo1 × SELECT `g`.`id`,`g`.`title`
FROM `plzh7_usergroups` AS g
INNER JOIN `plzh7_user_usergroup_map` AS m
ON m.group_id = g.id1 × SELECT DISTINCT itemID
FROM plzh7_k2_tags_xref1 × SELECT *
FROM plzh7_k2_comments1 × SELECT `ordering`
FROM `plzh7_extensions`1 × SELECT MAX(ordering)
FROM `plzh7_extensions`1 × SELECT *
FROM plzh7_k2_rating1 × SELECT id, rules
FROM `plzh7_viewlevels1 × SELECT *
FROM plzh7_k2_attachments1 × SELECT tag.*
FROM plzh7_k2_tags AS tag JOIN plzh7_k2_tags_xref AS xref
ON tag.id = xref.tagID1 × SELECT id, name, parent
FROM plzh7_k2_categories1 × SELECT id
FROM plzh7_k2_categories1 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `plzh7_assets`1 × SELECT id
FROM plzh7_k2_items1 × 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 *
FROM plzh7_jmap_headings
ΑΛΛΟΙ Πίνακες:
1 × UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"31edb4c774d939000c6441e1257e61d5\"}'1 × SHOW FULL COLUMNS
FROM `plzh7_k2_categories1 × SHOW FULL COLUMNS
FROM `plzh7_users1 × SHOW FULL COLUMNS
FROM `plzh7_k2_items1 × UPDATE plzh7_k2_items
SET `hits` = (`hits` + 1)1 × SHOW TABLE