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}
ΚΟΙΝΟΠΟΙΗΣΤΕ
Σχετικά Άρθρα
-
Συμβουλές για να κάνετε το καλοκαιρινό τρέξιμο διασκεδαστικό και ασφαλές
-
Κρυολόγημα: Ειδικός απαντά αν αποτελούν "θεραπείες" οι βιταμίνη C και ψευδάργυρος
-
Τι να προσέξετε στη διατροφή σας λόγω καύσωνα!
-
Τρέξιμο στη ζέστη: Συμβουλές και τρόποι προστασίας
-
8 συμβουλές για σούπερ στέγνωμα!
Κονσόλα Αποσφαλμάτωσης του Joomla!
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1785911079,
"last": 1785911079,
"now": 1785911079
},
"token": "uBgTokZ4zx4DHC3b8gBqli28RHJXy2cE"
},
"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": {
"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": 1785911080
}
}
}
}
}
Χρόνος
Μνήμη
Καταγράφηκαν 67 ερωτήματα 298.54 ms
- Χρόνος επερώτησης:0.61 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 1.030 MB Σειρές που επιστράφηκαν:0
SELECT `data`
FROM `plzh7_session`
WHERE `session_id` = X'6639656334626336316431303865353134646235333434613435323236333338'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.07 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.03 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.03 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 # Καλών Αρχείο και αριθμός σειράς 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.33 ms Μετά την τελευταία επερώτηση:1.50 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 1.044 MB Σειρές που επιστράφηκαν:0
SELECT `session_id`
FROM `plzh7_session`
WHERE `session_id` = X'6639656334626336316431303865353134646235333434613435323236333338'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_session const PRIMARY PRIMARY 194 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.03 ms Preparing 0.01 ms Executing 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.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:56 - Χρόνος επερώτησης:3.92 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.004 MB Μνήμη πριν την επερώτηση: 1.050 MB
INSERT INTO `plzh7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6639656334626336316431303865353134646235333434613435323236333338', 1, 1785911079, 0, '', 0)Δεν είναι δυνατό το EXPLAIN στην επερώτηση:INSERT INTO `plzh7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6639656334626336316431303865353134646235333434613435323236333338', 1, 1785911079, 0, '', 0)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 for update 0.02 ms Update 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 3.57 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.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:56 - Χρόνος επερώτησης:0.53 ms Μετά την τελευταία επερώτηση:5.15 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.139 MB Σειρές που επιστράφηκαν:6
SELECT id, rules
FROM `plzh7_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_viewlevels ALL NULL ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 6 Status Duration Starting 0.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.01 ms Sending data 0.05 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 # Καλών Αρχείο και αριθμός σειράς 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.54 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.152 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.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.03 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 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 # Καλών Αρχείο και αριθμός σειράς 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.64 ms Μετά την τελευταία επερώτηση:19.52 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 1.636 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.07 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.05 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.03 ms Reset for next command 0.02 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.53 ms Μετά την τελευταία επερώτηση:0.37 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.645 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.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.03 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 # Καλών Αρχείο και αριθμός σειράς 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.06 ms Μετά την τελευταία επερώτηση:9.58 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.840 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.15 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.05 ms Preparing 0.04 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 0.06 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.04 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.04 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:91 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:46.49 ms Μετά την τελευταία επερώτηση:60.88 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 2.787 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 13397 Using where Status Duration Starting 0.10 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.06 ms Optimizing 0.05 ms Statistics 0.05 ms Preparing 0.05 ms Executing 0.03 ms Sending data 45.66 ms End of update loop 0.04 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 12 JDatabaseDriver->loadResult() JROOT/components/com_k2/router.php:503 11 getItemId() JROOT/components/com_k2/router.php:353 10 k2ParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.88 ms Μετά την τελευταία επερώτηση:3.21 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 2.797 MB
UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"6c51e5c53a37755c5d9d87e0f17ebcec\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `plzh7_extensions` SET `params` = '{\"mediaversion\":\"6c51e5c53a37755c5d9d87e0f17ebcec\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init for update 0.08 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.30 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.03 ms Freeing items 0.03 ms Updating status 0.02 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/k2/k2.php:460 8 plgSystemK2->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.33 ms Μετά την τελευταία επερώτηση:44.22 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 2.989 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.15 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.08 ms Optimizing 0.03 ms Statistics 0.14 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.24 ms End of update loop 0.02 ms Query end 0.04 ms Commit 0.04 ms Query end 0.02 ms closing tables 0.05 ms Unlocking tables 0.03 ms closing tables 0.05 ms Query end 0.04 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.04 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.88 ms Μετά την τελευταία επερώτηση:9.95 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.180 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.11 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.11 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.84 ms End of update loop 0.03 ms Query end 0.06 ms closing tables 0.06 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.04 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.06 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 - Χρόνος επερώτησης:1.20 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.062 MB Μνήμη πριν την επερώτηση: 3.187 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.06 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.03 ms System lock 0.04 ms table lock 0.04 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.10 ms Preparing 0.02 ms Unlocking tables 0.04 ms Preparing 0.04 ms Executing 0.03 ms Sending data 0.36 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.04 ms Freeing items 0.04 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php: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.86 ms Μετά την τελευταία επερώτηση:0.63 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.290 MB Σειρές που επιστράφηκαν:14
SHOW FULL COLUMNS
FROM `plzh7_k2_categories`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_categories`Status Duration Starting 0.05 ms checking permissions 0.02 ms closing tables 0.02 ms checking permissions 0.02 ms Opening tables 0.54 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms checking permissions 0.14 ms closing tables 0.03 ms checking permissions 0.04 ms Executing 0.03 ms Sending data 0.10 ms End of update loop 0.02 ms Query end 0.05 ms closing tables 0.04 ms Removing tmp table 0.20 ms closing tables 0.02 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 19 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 18 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 17 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 16 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_k2/tables/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.90 ms Μετά την τελευταία επερώτηση:1.26 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.313 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.06 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.02 ms Unlocking tables 0.02 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.04 ms Updating status 0.05 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:2.15 ms Μετά την τελευταία επερώτηση:1.64 ms Μνήμη με επερώτηση: 0.029 MB Μνήμη πριν την επερώτηση: 3.349 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.09 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.13 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.03 ms Creating sort index 1.17 ms End of update loop 0.03 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.05 ms Starting cleanup 0.05 ms Freeing items 0.06 ms Updating status 0.06 ms Reset for next command 0.06 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 - Χρόνος επερώτησης:1.14 ms Μετά την τελευταία επερώτηση:1.89 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.447 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.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.04 ms init 0.05 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.08 ms Sorting result 0.05 ms Executing 0.04 ms Sending data 0.04 ms Creating sort index 0.12 ms End of update loop 0.03 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.03 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.65 ms Μετά την τελευταία επερώτηση:1.27 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.461 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.06 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.03 ms init 0.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.52 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.469 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.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.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.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 - Χρόνος επερώτησης:52.44 ms Μετά την τελευταία επερώτηση:1.42 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 3.499 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.42 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.02 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.14 ms closing tables 0.02 ms checking permissions 0.03 ms Executing 0.03 ms Sending data 0.09 ms End of update loop 0.02 ms Query end 0.02 ms closing tables 0.02 ms Removing tmp table 0.14 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 # Καλών Αρχείο και αριθμός σειράς 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.99 ms Μετά την τελευταία επερώτηση:0.40 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.530 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.09 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.06 ms Optimizing 0.06 ms Statistics 0.07 ms Preparing 0.03 ms Executing 0.06 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.03 ms Query end 0.02 ms closing tables 0.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 # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:1.57 ms Μετά την τελευταία επερώτηση:4.00 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.547 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.11 ms checking permissions 0.03 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.06 ms table lock 0.08 ms init 0.07 ms Optimizing 0.07 ms Statistics 0.11 ms Preparing 0.07 ms Executing 0.03 ms Sending data 0.08 ms End of update loop 0.04 ms Query end 0.08 ms Commit 0.08 ms Query end 0.06 ms closing tables 0.04 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.06 ms Starting cleanup 0.04 ms Freeing items 0.08 ms Updating status 0.06 ms Reset for next command 0.03 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.96 ms Μετά την τελευταία επερώτηση:0.42 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.555 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.08 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.10 ms Preparing 0.08 ms Executing 0.03 ms Sending data 0.06 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.04 ms Query end 0.03 ms closing tables 0.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/components/com_k2/models/item.php:1723 14 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 13 K2ModelItem->prepareItem() JROOT/components/com_k2/views/item/view.html.php:51 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:2.05 ms Μετά την τελευταία επερώτηση:3.83 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.569 MB Σειρές που επιστράφηκαν:1
SELECT MAX(ordering)
FROM `plzh7_extensions`
WHERE `type` = 'plugin'
AND `folder` = 'content'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE plzh7_extensions ALL extension ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ NULL NULL 309 Using where Status Duration Starting 0.12 ms checking permissions 0.04 ms Opening tables 0.08 ms After opening tables 0.06 ms System lock 0.07 ms table lock 0.05 ms init 0.10 ms Optimizing 0.07 ms Statistics 0.10 ms Preparing 0.08 ms Executing 0.07 ms Sending data 0.47 ms End of update loop 0.06 ms Query end 0.05 ms Commit 0.05 ms Query end 0.07 ms closing tables 0.08 ms Unlocking tables 0.06 ms closing tables 0.04 ms Query end 0.03 ms Starting cleanup 0.05 ms Freeing items 0.06 ms Updating status 0.05 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 17 JDatabaseDriver->loadResult() JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54 16 PlgContentPerfect_everything_in_everyway->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 15 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 14 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/components/com_k2/models/item.php:537 13 K2ModelItem->execPlugins() JROOT/components/com_k2/views/item/view.html.php:54 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.37 ms Μετά την τελευταία επερώτηση:0.10 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.577 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.10 ms checking permissions 0.05 ms Opening tables 0.06 ms After opening tables 0.05 ms System lock 0.05 ms table lock 0.03 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.15 ms Preparing 0.09 ms Executing 0.06 ms Sending data 0.10 ms End of update loop 0.04 ms Query end 0.04 ms Commit 0.04 ms Query end 0.04 ms closing tables 0.07 ms Unlocking tables 0.04 ms closing tables 0.05 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.05 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 - Χρόνος επερώτησης:3.23 ms Μετά την τελευταία επερώτηση:5.53 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.668 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.33 ms checking permissions 0.03 ms Opening tables 0.10 ms After opening tables 0.03 ms System lock 0.05 ms table lock 0.03 ms init 0.17 ms Optimizing 0.14 ms Statistics 0.28 ms Preparing 0.12 ms Creating tmp table 0.13 ms Sorting result 0.05 ms Executing 0.03 ms Sending data 0.92 ms Creating sort index 0.09 ms Removing tmp table 0.22 ms Creating sort index 0.04 ms End of update loop 0.04 ms Query end 0.03 ms Commit 0.03 ms Query end 0.02 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.03 ms Updating status 0.03 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 - Χρόνος επερώτησης:2.64 ms Μετά την τελευταία επερώτηση:2.82 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.717 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.21 ms checking permissions 0.02 ms Opening tables 0.08 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.12 ms Optimizing 0.11 ms Statistics 0.21 ms Preparing 0.09 ms Creating tmp table 0.10 ms Sorting result 0.04 ms Executing 0.05 ms Sending data 0.73 ms Creating sort index 0.09 ms Removing tmp table 0.15 ms Creating sort index 0.03 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.05 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.03 ms Starting cleanup 0.05 ms Freeing items 0.05 ms Updating status 0.07 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 - Χρόνος επερώτησης:2.25 ms Μετά την τελευταία επερώτηση:1.04 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 3.734 MB Σειρές που επιστράφηκαν:36
SHOW FULL COLUMNS
FROM `plzh7_k2_items`Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_items`Status Duration Starting 0.06 ms checking permissions 0.03 ms closing tables 0.03 ms checking permissions 0.03 ms Opening tables 0.48 ms After opening tables 0.03 ms System lock 0.05 ms table lock 0.05 ms init 0.05 ms Optimizing 0.05 ms Statistics 0.06 ms Preparing 0.06 ms Executing 0.04 ms Filling schema table 0.04 ms Opening tables 0.04 ms After opening tables 0.02 ms checking permissions 0.25 ms closing tables 0.02 ms checking permissions 0.03 ms Executing 0.03 ms Sending data 0.14 ms End of update loop 0.05 ms Query end 0.07 ms closing tables 0.05 ms Removing tmp table 0.20 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.04 ms Query end 0.03 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:42.65 ms Μετά την τελευταία επερώτηση:0.24 ms Μνήμη με επερώτηση: 0.007 MB Μνήμη πριν την επερώτηση: 3.781 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.07 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.02 ms Waiting for table level lock 41.63 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.06 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.06 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.43 ms Μετά την τελευταία επερώτηση:0.23 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.785 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.12 ms checking permissions 0.05 ms Opening tables 0.06 ms After opening tables 0.06 ms System lock 0.04 ms table lock 0.06 ms init 0.07 ms Optimizing 0.08 ms Statistics 0.14 ms Preparing 0.11 ms Sorting result 0.04 ms Executing 0.02 ms Sending data 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.04 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.05 ms Starting cleanup 0.02 ms Freeing items 0.07 ms Updating status 0.06 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.79 ms Μετά την τελευταία επερώτηση:22.38 ms Μνήμη με επερώτηση: 0.088 MB Μνήμη πριν την επερώτηση: 3.793 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-08-05 06:24:40' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-05 06:24:40' )
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.21 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.05 ms table lock 0.05 ms init 0.15 ms Optimizing 0.16 ms Statistics 0.30 ms Preparing 0.14 ms Sorting result 0.05 ms Executing 0.05 ms Sending data 5.00 ms End of update loop 0.05 ms Query end 0.03 ms closing tables 0.04 ms Unlocking tables 0.04 ms closing tables 0.05 ms Query end 0.04 ms Starting cleanup 0.03 ms Freeing items 0.06 ms Updating status 0.05 ms Reset for next command 0.03 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 - Χρόνος επερώτησης:2.36 ms Μετά την τελευταία επερώτηση:7.58 ms Μνήμη με επερώτηση: 0.028 MB Μνήμη πριν την επερώτηση: 3.871 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.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.05 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.13 ms Preparing 0.06 ms Creating tmp table 0.07 ms Executing 0.03 ms Sending data 1.22 ms Removing tmp table 0.03 ms Sending data 0.03 ms End of update loop 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.02 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/components/com_k2/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 - Χρόνος επερώτησης:7.86 ms Μετά την τελευταία επερώτηση:0.17 ms Μνήμη με επερώτηση: 0.074 MB Μνήμη πριν την επερώτηση: 3.905 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-08-05 06:24:40' )
AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-05 06:24:40' )
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.32 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.22 ms Optimizing 0.16 ms Statistics 0.58 ms Preparing 0.54 ms Sorting result 0.04 ms Executing 0.03 ms Sending data 0.07 ms Creating sort index 5.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.03 ms Query end 0.01 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.03 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/components/com_k2/models/itemlist.php: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.47 ms Μετά την τελευταία επερώτηση:0.27 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.985 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.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.02 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.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.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.57 ms Μετά την τελευταία επερώτηση:2.17 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.055 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.05 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.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.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.02 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:94 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.76 ms Μετά την τελευταία επερώτηση:2.15 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.081 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.05 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.03 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.02 ms Sending data 0.03 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.03 ms closing tables 0.03 ms Query end 0.01 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.02 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.81 ms Μετά την τελευταία επερώτηση:1.18 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.094 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.06 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.04 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.05 ms Executing 0.01 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.01 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.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.56 ms Μετά την τελευταία επερώτηση:0.42 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.101 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.04 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.03 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.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.04 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.78 ms Μετά την τελευταία επερώτηση:0.41 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.109 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.06 ms After opening tables 0.05 ms System lock 0.06 ms table lock 0.03 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.06 ms Preparing 0.04 ms Executing 0.04 ms Sending data 0.04 ms End of update loop 0.04 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.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.03 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.01 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.118 MB Σειρές που επιστράφηκαν:1
SELECT COUNT(*)
FROM plzh7_k2_comments
WHERE itemID=10188
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.05 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.02 ms System lock 0.04 ms table lock 0.08 ms init 0.09 ms Optimizing 0.06 ms Statistics 0.09 ms Preparing 0.03 ms Executing 0.01 ms Sending data 0.03 ms End of update loop 0.04 ms Query end 0.03 ms Commit 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.04 ms closing tables 0.05 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.05 ms Updating status 0.03 ms Reset for next command 0.06 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.55 ms Μετά την τελευταία επερώτηση:1.55 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.105 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.13 ms checking permissions 0.03 ms Opening tables 0.09 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.03 ms init 0.08 ms Optimizing 0.06 ms Statistics 0.13 ms Preparing 0.07 ms Creating tmp table 0.06 ms Sorting result 0.02 ms Executing 0.02 ms Sending data 0.39 ms Creating sort index 0.04 ms Removing tmp table 0.08 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.02 ms Query end 0.05 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.02 ms Reset for next command 0.01 ms # Καλών Αρχείο και αριθμός σειράς 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 - Χρόνος επερώτησης:59.35 ms Μετά την τελευταία επερώτηση:1.04 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.117 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.02 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.05 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.35 ms Creating sort index 0.04 ms Removing tmp table 0.07 ms Creating sort index 0.03 ms End of update loop 0.02 ms Query end 0.02 ms Commit 0.02 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.03 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.02 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 - Χρόνος επερώτησης:1.32 ms Μετά την τελευταία επερώτηση:0.55 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.128 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.13 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.05 ms System lock 0.03 ms table lock 0.04 ms init 0.10 ms Optimizing 0.06 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.08 ms End of update loop 0.03 ms Query end 0.05 ms closing tables 0.04 ms Unlocking tables 0.03 ms closing tables 0.05 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.06 ms Updating status 0.08 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 - Χρόνος επερώτησης:1.19 ms Μετά την τελευταία επερώτηση:4.45 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.204 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.08 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.07 ms Statistics 0.15 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.08 ms End of update loop 0.04 ms Query end 0.04 ms Commit 0.04 ms Query end 0.04 ms closing tables 0.04 ms Unlocking tables 0.04 ms closing tables 0.04 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:3.14 ms Μετά την τελευταία επερώτηση:1.00 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.190 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.28 ms checking permissions 0.05 ms Opening tables 0.09 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.16 ms Optimizing 0.13 ms Statistics 0.27 ms Preparing 0.13 ms Creating tmp table 0.15 ms Sorting result 0.05 ms Executing 0.03 ms Sending data 0.95 ms Creating sort index 0.10 ms Removing tmp table 0.18 ms Creating sort index 0.03 ms End of update loop 0.03 ms Query end 0.03 ms Commit 0.04 ms Query end 0.03 ms closing tables 0.04 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/system/fields/fields.php:495 17 PlgSystemFields->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 16 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 15 JEventDispatcher->trigger() JROOT/components/com_k2/models/item.php:668 14 K2ModelItem->execPlugins() JROOT/components/com_k2/models/itemlist.php:989 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:3.00 ms Μετά την τελευταία επερώτηση:1.02 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.202 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.29 ms checking permissions 0.06 ms Opening tables 0.08 ms After opening tables 0.03 ms System lock 0.04 ms table lock 0.04 ms init 0.14 ms Optimizing 0.11 ms Statistics 0.26 ms Preparing 0.15 ms Creating tmp table 0.12 ms Sorting result 0.04 ms Executing 0.03 ms Sending data 0.86 ms Creating sort index 0.07 ms Removing tmp table 0.12 ms Creating sort index 0.05 ms End of update loop 0.05 ms Query end 0.04 ms Commit 0.05 ms Query end 0.05 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.05 ms Query end 0.03 ms Starting cleanup 0.04 ms Freeing items 0.03 ms Updating status 0.05 ms Reset for next command 0.04 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.99 ms Μετά την τελευταία επερώτηση:0.43 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.214 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.06 ms checking permissions 0.03 ms Opening tables 0.05 ms After opening tables 0.04 ms System lock 0.05 ms table lock 0.05 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.03 ms Unlocking tables 0.03 ms Preparing 0.05 ms Executing 0.04 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.04 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.04 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.66 ms Μετά την τελευταία επερώτηση:4.53 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.289 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.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.04 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.02 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 15 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.75 ms Μετά την τελευταία επερώτηση:0.44 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.297 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.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.04 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.03 ms Executing 0.02 ms Sending data 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.02 ms Freeing items 0.02 ms Updating status 0.03 ms Reset for next command 0.02 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.75 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.305 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.04 ms checking permissions 0.02 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.02 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.04 ms Executing 0.02 ms Sending data 0.05 ms End of update loop 0.02 ms Query end 0.03 ms Commit 0.03 ms Query end 0.02 ms closing tables 0.03 ms Unlocking tables 0.03 ms closing tables 0.02 ms Query end 0.03 ms Starting cleanup 0.03 ms Freeing items 0.03 ms Updating status 0.03 ms Reset for next command 0.04 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:2.07 ms Μετά την τελευταία επερώτηση:1.01 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.292 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.14 ms checking permissions 0.02 ms Opening tables 0.06 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.04 ms init 0.08 ms Optimizing 0.07 ms Statistics 0.16 ms Preparing 0.06 ms Creating tmp table 0.07 ms Sorting result 0.05 ms Executing 0.03 ms Sending data 0.54 ms Creating sort index 0.07 ms Removing tmp table 0.13 ms Creating sort index 0.02 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.03 ms Unlocking tables 0.04 ms closing tables 0.06 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.07 ms Updating status 0.03 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 - Χρόνος επερώτησης:2.12 ms Μετά την τελευταία επερώτηση:1.04 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.304 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.14 ms checking permissions 0.02 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.06 ms init 0.13 ms Optimizing 0.11 ms Statistics 0.20 ms Preparing 0.11 ms Creating tmp table 0.11 ms Sorting result 0.07 ms Executing 0.07 ms Sending data 0.53 ms Creating sort index 0.06 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.02 ms Unlocking tables 0.01 ms closing tables 0.03 ms Query end 0.02 ms Starting cleanup 0.04 ms Freeing items 0.03 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 - Χρόνος επερώτησης:1.29 ms Μετά την τελευταία επερώτηση:72.77 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.376 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.11 ms checking permissions 0.03 ms Opening tables 0.04 ms After opening tables 0.04 ms System lock 0.06 ms table lock 0.06 ms init 0.06 ms Optimizing 0.06 ms Statistics 0.09 ms Preparing 0.06 ms Executing 0.03 ms Sending data 0.08 ms End of update loop 0.03 ms Query end 0.04 ms Commit 0.04 ms Query end 0.03 ms closing tables 0.04 ms Unlocking tables 0.04 ms closing tables 0.04 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 # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 16 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 15 K2ModelItem->getUserProfile() JROOT/components/com_k2/models/item.php:249 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.86 ms Μετά την τελευταία επερώτηση:0.44 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.384 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.12 ms checking permissions 0.06 ms Opening tables 0.09 ms After opening tables 0.07 ms System lock 0.08 ms table lock 0.08 ms init 0.12 ms Optimizing 0.07 ms Statistics 0.14 ms Preparing 0.11 ms Executing 0.08 ms Sending data 0.13 ms End of update loop 0.09 ms Query end 0.03 ms Commit 0.04 ms Query end 0.06 ms closing tables 0.04 ms Unlocking tables 0.06 ms closing tables 0.06 ms Query end 0.05 ms Starting cleanup 0.05 ms Freeing items 0.06 ms Updating status 0.07 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:2.16 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.393 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.09 ms checking permissions 0.07 ms Opening tables 0.09 ms After opening tables 0.07 ms System lock 0.08 ms table lock 0.08 ms init 0.10 ms Optimizing 0.07 ms Statistics 0.15 ms Preparing 0.12 ms Executing 0.08 ms Sending data 0.12 ms End of update loop 0.05 ms Query end 0.08 ms Commit 0.08 ms Query end 0.08 ms closing tables 0.10 ms Unlocking tables 0.10 ms closing tables 0.10 ms Query end 0.08 ms Starting cleanup 0.13 ms Freeing items 0.09 ms Updating status 0.09 ms Reset for next command 0.08 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.52 ms Μετά την τελευταία επερώτηση:0.89 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.379 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.08 ms checking permissions 0.05 ms Opening tables 0.04 ms After opening tables 0.04 ms System lock 0.05 ms table lock 0.05 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.12 ms Preparing 0.05 ms Unlocking tables 0.05 ms Preparing 0.05 ms Executing 0.04 ms Sending data 0.12 ms End of update loop 0.05 ms Query end 0.08 ms closing tables 0.03 ms Unlocking tables 0.06 ms closing tables 0.06 ms Query end 0.07 ms Starting cleanup 0.07 ms Freeing items 0.08 ms Updating status 0.09 ms Reset for next command 0.06 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/administrator/components/com_k2/tables/k2category.php:67 15 TableK2Category->load() JROOT/components/com_k2/models/item.php:73 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.43 ms Μετά την τελευταία επερώτηση:4.38 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.458 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.11 ms checking permissions 0.04 ms Opening tables 0.04 ms After opening tables 0.05 ms System lock 0.05 ms table lock 0.04 ms init 0.07 ms Optimizing 0.05 ms Statistics 0.09 ms Preparing 0.07 ms Executing 0.04 ms Sending data 0.11 ms End of update loop 0.04 ms Query end 0.06 ms Commit 0.06 ms Query end 0.05 ms closing tables 0.06 ms Unlocking tables 0.06 ms closing tables 0.05 ms Query end 0.04 ms Starting cleanup 0.04 ms Freeing items 0.05 ms Updating status 0.06 ms Reset for next command 0.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 - Χρόνος επερώτησης:1.55 ms Μετά την τελευταία επερώτηση:0.44 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.466 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.07 ms checking permissions 0.03 ms Opening tables 0.03 ms After opening tables 0.02 ms System lock 0.02 ms table lock 0.06 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.06 ms Executing 0.07 ms Sending data 0.10 ms End of update loop 0.06 ms Query end 0.09 ms Commit 0.08 ms Query end 0.09 ms closing tables 0.08 ms Unlocking tables 0.08 ms closing tables 0.09 ms Query end 0.06 ms Starting cleanup 0.07 ms Freeing items 0.06 ms Updating status 0.08 ms Reset for next command 0.05 ms # Καλών Αρχείο και αριθμός σειράς 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1853 16 K2ModelItem->getUserProfile() JROOT/components/com_k2/helpers/utilities.php:53 15 K2HelperUtilities::getAvatar() JROOT/components/com_k2/models/item.php:250 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:1.30 ms Μετά την τελευταία επερώτηση:0.14 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.475 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.07 ms checking permissions 0.04 ms Opening tables 0.06 ms After opening tables 0.06 ms System lock 0.05 ms table lock 0.05 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.08 ms Executing 0.03 ms Sending data 0.07 ms End of update loop 0.04 ms Query end 0.05 ms Commit 0.03 ms Query end 0.05 ms closing tables 0.05 ms Unlocking tables 0.03 ms closing tables 0.04 ms Query end 0.05 ms Starting cleanup 0.05 ms Freeing items 0.06 ms Updating status 0.10 ms Reset for next command 0.07 ms # Καλών Αρχείο και αριθμός σειράς 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 16 JDatabaseDriver->loadResult() JROOT/components/com_k2/models/item.php:1723 15 K2ModelItem->countItemComments() JROOT/components/com_k2/models/item.php:273 14 K2ModelItem->prepareItem() JROOT/components/com_k2/models/itemlist.php:988 13 K2ModelItemlist->getRelatedItems() JROOT/components/com_k2/views/item/view.html.php:306 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:2.53 ms Μετά την τελευταία επερώτηση:1.04 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.462 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.20 ms checking permissions 0.03 ms Opening tables 0.10 ms After opening tables 0.04 ms System lock 0.02 ms table lock 0.02 ms init 0.11 ms Optimizing 0.11 ms Statistics 0.21 ms Preparing 0.09 ms Creating tmp table 0.13 ms Sorting result 0.05 ms Executing 0.04 ms Sending data 0.71 ms Creating sort index 0.09 ms Removing tmp table 0.17 ms Creating sort index 0.04 ms End of update loop 0.03 ms Query end 0.02 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.03 ms Query end 0.03 ms Starting cleanup 0.02 ms Freeing items 0.04 ms Updating status 0.03 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.89 ms Μετά την τελευταία επερώτηση:0.96 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.474 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.21 ms checking permissions 0.05 ms Opening tables 0.09 ms After opening tables 0.04 ms System lock 0.04 ms table lock 0.04 ms init 0.12 ms Optimizing 0.09 ms Statistics 0.19 ms Preparing 0.09 ms Creating tmp table 0.10 ms Sorting result 0.03 ms Executing 0.02 ms Sending data 0.40 ms Creating sort index 0.05 ms Removing tmp table 0.08 ms Creating sort index 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.02 ms Query end 0.02 ms closing tables 0.02 ms Unlocking tables 0.02 ms closing tables 0.02 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.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.17 ms Μετά την τελευταία επερώτηση:0.65 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 4.463 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-08-05 06:24:40' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-05 06:24:40' )
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 22 Using where; Χρήση ταξινόμησης αρχείου Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.02 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.05 ms Sorting result 0.03 ms Executing 0.01 ms Sending data 0.04 ms Creating sort index 0.42 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.04 ms Query end 0.02 ms Starting cleanup 0.03 ms Freeing items 0.04 ms Updating status 0.03 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php:1835 13 K2ModelItem->getNextItem() JROOT/components/com_k2/views/item/view.html.php:323 12 K2ViewItem->display() JROOT/libraries/src/Cache/Controller/ViewController.php:102 11 Joomla\CMS\Cache\Controller\ViewController->get() JROOT/libraries/src/MVC/Controller/BaseController.php:655 10 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_k2/controllers/controller.php:20 9 K2Controller->display() JROOT/components/com_k2/controllers/item.php:84 8 K2ControllerItem->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_k2/k2.php:63 6 require_once JROOT/components/com_k2/k2.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:59 - Χρόνος επερώτησης:0.90 ms Μετά την τελευταία επερώτηση:1.84 ms Μνήμη με επερώτηση: 0.070 MB Μνήμη πριν την επερώτηση: 4.491 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-08-05 06:24:40' )
AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-05 06:24:40' )
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 22 (1%) Using where; Χρήση ταξινόμησης αρχείου; Using rowid filter Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.08 ms Preparing 0.04 ms Sorting result 0.02 ms Executing 0.01 ms Sending data 0.08 ms Creating sort index 0.28 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.02 ms Reset for next command 0.03 ms # Καλών Αρχείο και αριθμός σειράς 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 14 JDatabaseDriver->loadObject() JROOT/components/com_k2/models/item.php: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.20 ms Μετά την τελευταία επερώτηση:186.97 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.650 MB Σειρές που επιστράφηκαν:124
SHOW TABLES
Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW TABLESStatus Duration Starting 0.08 ms checking permissions 0.02 ms Opening tables 0.05 ms After opening tables 0.03 ms System lock 0.03 ms table lock 0.03 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.02 ms Filling schema table 0.03 ms checking permissions 0.40 ms Executing 0.01 ms Sending data 0.08 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.05 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.56 ms Μετά την τελευταία επερώτηση:4.06 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.714 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.06 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 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.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: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.46 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.726 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.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 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.02 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.01 ms Freeing items 0.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.10 ms Μετά την τελευταία επερώτηση:86.22 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.838 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.07 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.05 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.05 ms Executing 0.04 ms Sending data 0.05 ms End of update loop 0.03 ms Query end 0.05 ms Commit 0.05 ms Query end 0.07 ms closing tables 0.07 ms Unlocking tables 0.04 ms closing tables 0.05 ms Query end 0.07 ms Starting cleanup 0.07 ms Freeing items 0.05 ms Updating status 0.08 ms Reset for next command 0.06 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
Καταγράφηκαν 36 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.
ΕΠΙΛΟΓΗ από Πίνακες:
10 × 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_users6 × 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_attachments1 × SELECT *
FROM plzh7_k2_rating1 × SELECT `session_id`
FROM `plzh7_session`1 × 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 id, rules
FROM `plzh7_viewlevels1 × SELECT *
FROM plzh7_jmap_headings
ΑΛΛΟΙ Πίνακες:
1 × INSERT INTO `plzh7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'6639656334626336316431303865353134646235333434613435323236333338', 1, 1785911079, 0, '', 01 × UPDATE `plzh7_extensions`
SET `params` = '{\"mediaversion\":\"6c51e5c53a37755c5d9d87e0f17ebcec\"}'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

