Οι καλοκαιρινοί πειρασμοί που πρέπει να αποφύγεις!

Ιουλίου 18, 2016
Κατηγορία Διατροφή

- 1
- 2
- 3
- 4
- 5
(0 ψήφοι)

ΚΟΙΝΟΠΟΙΗΣΤΕ

Καλοκαίρι. Βόλτες, βουτιές, ξεγνοιασιά, bbq με φίλους, cocktails, παγωτά και… πριν το καταλάβεις παίρνεις πίσω τα κιλά που έχασες όλο τον χειμώνα. Για να μην αρχίσεις να βλέπεις τα παντελόνια να στενεύουν ξαφνικά, δες ποιοι είναι οι χειρότεροι καλοκαιρινοί πειρασμοί σε κάθε περίσταση και πως μπορείς να τους αποφύγεις…

Όταν είσαι με τους συναδέλφους σε Happy Hour
Απόφυγε τα τηγανητά και τις πικάντικες φτερούγες full σε κορεσμένα λίπη, έτοιμες σάλτσες με αλάτι και ζάχαρη και πλήθος θερμίδων. Αντιθέτως, προτίμησε ωμά ή βραστά snacks θαλασσινών, όπως cocktail γαρίδας ή φρέσκα λαχανικά.

Όταν είσαι στην πισίνα
Δύσκολα μπορείς να αντισταθείς σε ένα παγωτό που φαντάζει παράδεισος κάτω από τον καυτό ήλιο, αλλά μην το παρακάνεις. Η καλύτερη επιλογή είναι οι παγωμένοι φυσικοί χυμοί ή ακόμη και μία κρύα σοκολάτα που ενεργοποιεί τις καύσεις.

Όταν βρίσκεσαι σε γενέθλια ή καλοκαιρινά parties
Μείνε μακριά από τυροπιτάκια, chips και αναψυκτικά. Ψάξε για τοστ με γαλοπούλα, κριτσίνια ή τις σαλάτες του bar.

Όταν είσαι «αραχτός» στην παραλία
Προσπάθησε να αντισταθείς στα εντυπωσιακά μεν, παχυντικά δε cocktails με σιρόπι και ζάχαρη. Εάν θες κάτι να δροσιστείς, προτίμησε cocktails με βότανα, μυρωδικά, λεμόνι και σόδα που δεν θα σε πρήξουν.

ΚΟΙΝΟΠΟΙΗΣΤΕ

Ετικέτες

Σχετικά Άρθρα

Συμβουλές για να κάνετε το καλοκαιρινό τρέξιμο διασκεδαστικό και ασφαλές
Τα τρόφιμα που μας παχαίνουν το καλοκαίρι
Πώς θα μαυρίσεις με ασφάλεια φέτος το καλοκαίρι
Πώς να διατηρήσετε γυμνασμένο σώμα όλο το καλοκαίρι
Τα τρόφιμα που μας παχαίνουν το καλοκαίρι
Οι 9 εντολές του καλοκαιρινού στυλ

Κονσόλα Αποσφαλμάτωσης του Joomla!

Συνεδρία

{
    "__default": {
        "session": {
            "counter": 3,
            "timer": {
                "start": 1785676671,
                "last": 1785676672,
                "now": 1785676672
            },
            "token": "Dz6GT2CEc3TrEhwxixBqWOZ77wQyC3xU"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "1e5f8f7603a3c81a884f53b53de38971ae8bdf94",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "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": {
                "563bee7beba67818230d0dfdd29ccd13d9f77ac0": {
                    "link": "https://www.ifitnessbook.com/nutrition/%CE%B4%CE%AF%CE%B1%CE%B9%CF%84%CE%B5%CF%82/%CF%80%CE%BF%CE%B9%CE%BF%CF%82-%CE%B5%CE%AF%CE%BD%CE%B1%CE%B9-%CE%BF-%CF%81%CF%8C%CE%BB%CE%BF%CF%82-%CF%84%CE%BF%CF%85-%CE%BD%CE%B5%CF%81%CE%BF%CF%8D-%CF%83%CF%84%CE%BF-%CE%B1%CE%B4%CF%85%CE%BD%CE%AC%CF%84%CE%B9%CF%83%CE%BC%CE%B1?print=1&tmpl=component",
                    "expiry": 1785676671
                },
                "80c3a242723885ba353e9dfd4741701458e88e56": {
                    "link": "https://www.ifitnessbook.com/nutrition/%CE%B4%CE%B9%CE%B1%CF%84%CF%81%CE%BF%CF%86%CE%B7/%CE%BF%CE%B9-%CE%BA%CE%B1%CE%BB%CE%BF%CE%BA%CE%B1%CE%B9%CF%81%CE%B9%CE%BD%CE%BF%CE%AF-%CF%80%CE%B5%CE%B9%CF%81%CE%B1%CF%83%CE%BC%CE%BF%CE%AF-%CF%80%CE%BF%CF%85-%CF%80%CF%81%CE%AD%CF%80%CE%B5%CE%B9-%CE%BD%CE%B1-%CE%B1%CF%80%CE%BF%CF%86%CF%8D%CE%B3%CE%B5%CE%B9%CF%82?print=1&tmpl=component",
                    "expiry": 1785676673
                }
            }
        }
    }
}

Πληροφορίες Προφίλ

Χρήση Μνήμης

Ερωτήματα Βάσης Δεδομένων

Καταγράφηκαν 67 ερωτήματα 121.96 ms

12 διπλότυπα βρέθηκαν!

12 διπλότυπα: #31 #32 #36 #37 #42 #43 #48 #49 #53 #54 #57 #58

Χρόνος επερώτησης:1.08 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 1.032 MB Σειρές που επιστράφηκαν:1

SELECT `data`

  FROM `plzh7_session`

  WHERE `session_id` = X'3232313232306166333038623566363562646630396264663038616133303138'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_session	const	PRIMARY	PRIMARY	194	const	1

Προφίλ

Status	Duration
Starting	0.10 ms
checking permissions	0.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.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.00 ms Μετά την τελευταία επερώτηση:4.60 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.141 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.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.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	0.08 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.05 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.04 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.153 MB Σειρές που επιστράφηκαν:2

SELECT b.id

  FROM plzh7_usergroups AS a

  LEFT JOIN plzh7_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	Using where; Using index

Προφίλ

Status	Duration
Starting	0.09 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.11 ms
Preparing	0.03 ms
Unlocking tables	0.03 ms
Preparing	0.06 ms
Executing	0.03 ms
Sending data	0.06 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.05 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.93 ms Μετά την τελευταία επερώτηση:15.53 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 1.638 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.10 ms
checking permissions	0.03 ms
Opening tables	0.06 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.04 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.80 ms Μετά την τελευταία επερώτηση:0.35 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.647 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.07 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.05 ms
Executing	0.03 ms
Sending data	0.05 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.03 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.03 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:729
10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.19 ms Μετά την τελευταία επερώτηση:8.06 ms Μνήμη με επερώτηση: 0.021 MB Μνήμη πριν την επερώτηση: 1.843 MB Σειρές που επιστράφηκαν:0

SELECT `source`,`keepurlparams`

  FROM `plzh7_admintools_redirects`

  WHERE ((`dest` = 'nutrition/%CE%B4%CE%B9%CE%B1%CF%84%CF%81%CE%BF%CF%86%CE%B7/%CE%BF%CE%B9-%CE%BA%CE%B1%CE%BB%CE%BF%CE%BA%CE%B1%CE%B9%CF%81%CE%B9%CE%BD%CE%BF%CE%AF-%CF%80%CE%B5%CE%B9%CF%81%CE%B1%CF%83%CE%BC%CE%BF%CE%AF-%CF%80%CE%BF%CF%85-%CF%80%CF%81%CE%AD%CF%80%CE%B5%CE%B9-%CE%BD%CE%B1-%CE%B1%CF%80%CE%BF%CF%86%CF%8D%CE%B3%CE%B5%CE%B9%CF%82') OR (`dest` = 'nutrition/%CE%B4%CE%B9%CE%B1%CF%84%CF%81%CE%BF%CF%86%CE%B7/%CE%BF%CE%B9-%CE%BA%CE%B1%CE%BB%CE%BF%CE%BA%CE%B1%CE%B9%CF%81%CE%B9%CE%BD%CE%BF%CE%AF-%CF%80%CE%B5%CE%B9%CF%81%CE%B1%CF%83%CE%BC%CE%BF%CE%AF-%CF%80%CE%BF%CF%85-%CF%80%CF%81%CE%AD%CF%80%CE%B5%CE%B9-%CE%BD%CE%B1-%CE%B1%CF%80%CE%BF%CF%86%CF%8D%CE%B3%CE%B5%CE%B9%CF%82?print=1&tmpl=component') OR ('nutrition/%CE%B4%CE%B9%CE%B1%CF%84%CF%81%CE%BF%CF%86%CE%B7/%CE%BF%CE%B9-%CE%BA%CE%B1%CE%BB%CE%BF%CE%BA%CE%B1%CE%B9%CF%81%CE%B9%CE%BD%CE%BF%CE%AF-%CF%80%CE%B5%CE%B9%CF%81%CE%B1%CF%83%CE%BC%CE%BF%CE%AF-%CF%80%CE%BF%CF%85-%CF%80%CF%81%CE%AD%CF%80%CE%B5%CE%B9-%CE%BD%CE%B1-%CE%B1%CF%80%CE%BF%CF%86%CF%8D%CE%B3%CE%B5%CE%B9%CF%82?print=1&tmpl=component' LIKE `dest`)) 
  AND `published` = '1'

  ORDER BY `ordering` DESC 
  LIMIT 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_admintools_redirects	ALL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	1	Using where; Χρήση ταξινόμησης αρχείου

Προφίλ

Status	Duration
Starting	0.18 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
After opening tables	0.03 ms
System lock	0.03 ms
table lock	0.03 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.06 ms
Preparing	0.05 ms
Sorting result	0.03 ms
Executing	0.03 ms
Sending data	0.03 ms
Creating sort index	0.07 ms
End of update loop	0.03 ms
Query end	0.03 ms
Commit	0.03 ms
Query end	0.03 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.03 ms
Query end	0.03 ms
Starting cleanup	0.03 ms
Freeing items	0.05 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:91
10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
8	plgSystemAdmintools->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:47.27 ms Μετά την τελευταία επερώτηση:14.05 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 2.789 MB Σειρές που επιστράφηκαν:1

SELECT id 
  FROM plzh7_k2_items 
  WHERE alias = 'οι-καλοκαιρινοί-πειρασμοί-που-πρέπει-να-αποφύγεις'

Επεξήγηση

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.04 ms
Statistics	0.05 ms
Preparing	0.04 ms
Executing	0.03 ms
Sending data	46.41 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.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.51 ms Μετά την τελευταία επερώτηση:1.80 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 2.798 MB

UPDATE `plzh7_extensions`

  SET `params` = '{\"mediaversion\":\"5ddb504afc6b718d66e49140d0c49e4e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE `plzh7_extensions` SET `params` = '{\"mediaversion\":\"5ddb504afc6b718d66e49140d0c49e4e\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Προφίλ

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.01 ms
table lock	0.01 ms
init for update	0.09 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:460
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.69 ms Μετά την τελευταία επερώτηση:9.84 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 2.992 MB Σειρές που επιστράφηκαν:42

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `plzh7_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_fields','com_finder','com_installer','com_jce','com_jmap','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilemenuck','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_search','com_sitemapgenerator','com_tags','com_templates','com_users','com_wrapper')

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_assets	ALL	idx_asset_name	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	146	Using where

Προφίλ

Status	Duration
Starting	0.08 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.03 ms
init	0.04 ms
Optimizing	0.02 ms
Statistics	0.07 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.14 ms Μετά την τελευταία επερώτηση:6.58 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.183 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.05 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.60 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:274
13	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/item/view.html.php:36
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.61 ms Μετά την τελευταία επερώτηση:0.08 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 3.190 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_items 
  WHERE id=7628 
  LIMIT 0, 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_items	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
Starting	0.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.04 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.09 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.23 ms Μετά την τελευταία επερώτηση:0.48 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.277 MB Σειρές που επιστράφηκαν:14

SHOW FULL COLUMNS 
  FROM `plzh7_k2_categories`

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_categories`

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Opening tables	0.37 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.10 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Executing	0.02 ms
Sending data	0.08 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.01 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.51 ms Μετά την τελευταία επερώτηση:0.97 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.301 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.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
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.48 ms Μετά την τελευταία επερώτηση:2.45 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.373 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '1'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_categories	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Unlocking tables	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
14	TableK2Category->load()	JROOT/components/com_k2/models/item.php:94
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.67 ms Μετά την τελευταία επερώτηση:0.45 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.394 MB Σειρές που επιστράφηκαν:3

SELECT tag.*
			
  FROM plzh7_k2_tags AS tag
			JOIN plzh7_k2_tags_xref AS xref 
  ON tag.id = xref.tagID
			
  WHERE tag.published=1
			
  AND xref.itemID = 7628 
  ORDER BY xref.id ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	3	Using where; Χρήση ταξινόμησης αρχείου
1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	ifitness_ifitnew.xref.tagID	1	Using where

Προφίλ

Status	Duration
Starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.45 ms Μετά την τελευταία επερώτηση:1.29 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.409 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM plzh7_k2_rating 
  WHERE itemID = 7628

Επεξήγηση

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.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.03 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: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.47 ms Μετά την τελευταία επερώτηση:0.65 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.420 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=7628 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Executing	0.01 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.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
14	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
13	K2ModelItem->prepareItem()	JROOT/components/com_k2/views/item/view.html.php:51
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.66 ms Μετά την τελευταία επερώτηση:2.20 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.441 MB Σειρές που επιστράφηκαν:1

SELECT MAX(ordering)

  FROM `plzh7_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_extensions	ALL	extension	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	309	Using where

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:54
16	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
15	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
14	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_k2/models/item.php:537
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.50 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.449 MB Σειρές που επιστράφηκαν:1

SELECT `ordering`

  FROM `plzh7_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'content' 
  AND `element` = 'perfect_everything_in_everyway'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_extensions	ref	element_clientid,element_folder_clientid,extension	element_folder_clientid	804	const,const	1	Using index condition; Using where

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
17	JDatabaseDriver->loadResult()	JROOT/plugins/content/perfect_everything_in_everyway/perfect_everything_in_everyway.php:73
16	PlgContentPerfect_everything_in_everyway->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
15	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
14	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_k2/models/item.php:537
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.51 ms Μετά την τελευταία επερώτηση:3.29 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.485 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 (184,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.07 ms
Optimizing	0.06 ms
Statistics	0.14 ms
Preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.43 ms
Creating sort index	0.05 ms
Removing tmp table	0.09 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
16	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
14	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:668
13	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/item/view.html.php:54
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.52 ms Μετά την τελευταία επερώτηση:1.70 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.581 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 (184,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.14 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.06 ms
Statistics	0.14 ms
Preparing	0.06 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.44 ms
Creating sort index	0.04 ms
Removing tmp table	0.09 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.14 ms Μετά την τελευταία επερώτηση:0.60 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 3.598 MB Σειρές που επιστράφηκαν:36

SHOW FULL COLUMNS 
  FROM `plzh7_k2_items`

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_k2_items`

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
closing tables	0.01 ms
checking permissions	0.02 ms
Opening tables	0.30 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.02 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
checking permissions	0.15 ms
closing tables	0.02 ms
checking permissions	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.01 ms
Removing tmp table	0.10 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2item.php:58
15	TableK2Item->__construct()	JROOT/libraries/src/Table/Table.php:328
14	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/models/item.php:917
13	K2ModelItem->hit()	JROOT/components/com_k2/views/item/view.html.php:136
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.45 ms Μετά την τελευταία επερώτηση:0.11 ms Μνήμη με επερώτηση: 0.007 MB Μνήμη πριν την επερώτηση: 3.645 MB

UPDATE plzh7_k2_items

  SET `hits` = (`hits` + 1)

  WHERE `id` = '7628'

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:UPDATE plzh7_k2_items SET `hits` = (`hits` + 1) WHERE `id` = '7628'

Προφίλ

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 for update	0.05 ms
Updating	0.10 ms
End of update loop	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 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

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.55 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.649 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM plzh7_k2_comments 
  WHERE itemID=7628 
  AND published=1  
  ORDER BY commentDate DESC 
  LIMIT 0, 10

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	range	itemID,published,latestComments,countComments	latestComments	4	NULL	1	Using where

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 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.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:3.81 ms Μετά την τελευταία επερώτηση:0.81 ms Μνήμη με επερώτηση: 0.062 MB Μνήμη πριν την επερώτηση: 3.657 MB Σειρές που επιστράφηκαν:1067

SELECT DISTINCT itemID 
  FROM plzh7_k2_tags_xref 
  WHERE tagID IN (232,5186,180) 
  AND itemID!=7628

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_tags_xref	range	tagID,itemID	tagID	4	NULL	978	Using index condition; Using where; Using temporary

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Executing	0.01 ms
Sending data	3.23 ms
Removing tmp table	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:27.96 ms Μετά την τελευταία επερώτηση:0.30 ms Μνήμη με επερώτηση: 0.089 MB Μνήμη πριν την επερώτηση: 3.786 MB Σειρές που επιστράφηκαν:6

SELECT i.*, c.alias as categoryalias 
  FROM plzh7_k2_items as i
				
  LEFT JOIN plzh7_k2_categories c 
  ON c.id = i.catid
				
  WHERE i.published = 1
				
  AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2026-08-02 13:17:53' )
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-08-02 13:17:53' )  
  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 (60,67,68,72,211,265,305,336,350,355,382,446,451,461,470,471,474,482,488,489,490,496,505,492,580,583,582,601,605,612,617,620,623,628,630,631,632,636,641,643,656,658,665,671,682,689,692,698,706,709,710,716,712,717,718,723,726,729,734,735,738,746,753,761,762,757,767,768,769,776,778,782,785,788,789,797,799,811,818,822,823,837,838,840,845,847,849,855,858,861,885,887,892,899,900,901,902,930,938,941,963,965,969,971,973,975,976,977,978,979,980,982,983,991,996,998,966,1014,1015,1018,1022,1064,1068,1072,1075,1085,1088,1089,1093,1118,1119,1120,1121,1123,1125,1129,1131,1133,1135,1138,1139,704,1149,1153,1168,1169,1172,1173,1179,1199,1202,1206,1216,1219,1226,1228,1232,1247,1248,1258,1260,1265,1273,1277,1283,1298,1324,1336,1337,1348,1350,1351,1373,1381,1383,1401,1445,1449,1471,1494,1507,1508,1509,1551,1583,1601,1603,1639,1647,1657,1659,1660,1661,1683,1690,1727,1730,1731,1750,1755,1756,1764,1766,1769,1819,1820,1821,1825,1838,1856,1862,1865,1866,1907,1912,1901,1917,1923,1971,1975,1984,1993,2014,2018,2029,2045,2074,2087,2131,2147,2152,2153,2157,2198,2255,2260,2261,775,2270,2280,2289,2298,2304,2314,2324,2325,2364,2383,2394,2397,2398,2415,2424,2422,2425,2484,2510,2511,2513,2546,2550,2562,2579,2573,2584,2583,2574,2601,2602,2638,2647,2662,2682,2684,2694,2699,2698,2710,2433,1347,766,690,508,2749,2750,2766,2805,2812,1592,714,581,2907,2914,2934,2935,2949,2960,2965,2981,2985,3013,3058,345,597,585,579,499,3123,3148,3156,3190,3191,3204,1268,747,2681,3248,3256,3331,3332,3336,3383,3397,3454,3455,3482,3489,3108,3519,3523,3525,3524,3538,3555,3581,3582,3584,3603,3587,3588,3382,3622,3628,3636,3639,3641,3655,3575,3662,3670,3672,3676,3680,3684,3685,3651,3689,1322,3706,3710,3711,3720,3722,3725,3726,3727,3728,3731,3733,3738,3748,3751,3753,3754,3757,3761,3446,3424,3306,3766,3769,3776,3787,3790,3794,3797,3809,3576,3812,3825,3828,913,3833,3837,3838,3843,3846,3849,3852,3853,3854,3856,3859,3865,3868,3870,3875,3881,3885,3886,3888,3889,3891,3895,3897,3900,3902,3907,3909,3912,3913,3512,3918,3923,3929,3935,3940,3941,3953,3956,3950,3958,3961,3967,3975,3979,3981,3991,3992,3998,3999,3691,4005,4007,4010,4011,4014,4015,4016,4019,4030,4036,4039,4044,4046,4048,4049,4051,4057,4061,4067,4069,4072,4075,4084,4080,4088,4091,4094,4099,4102,4110,4113,4115,4120,4123,4126,4133,4128,4140,4145,4147,4155,4170,4171,4176,4178,4180,4182,4187,4189,4192,4193,4195,4200,4203,4210,4211,4216,4217,4224,4230,4231,4237,4240,4241,4245,4249,4251,4256,4265,4267,4270,4272,4277,4279,4283,4285,4287,4290,4291,4292,4294,4297,4304,4310,4313,4318,4321,4322,4327,4329,4333,421,4335,4343,4350,4354,4355,4359,4367,4368,4374,4376,4381,4384,4387,2987,4394,4401,4404,3752,4410,4425,4426,4437,4445,4454,4455,4456,4460,4463,4464,4469,4474,4477,4482,4483,4491,4494,4500,4501,4506,4517,4519,4521,4526,4531,4534,4540,4543,4558,4565,4572,4616,4623,4643,4653,4716,4630,4904,4927,4928,4901,4949,4968,648,4995,5014,5072,5101,5120,5132,5195,5197,5323,5344,5347,5357,5372,5396,5419,5429,5473,5528,5547,5550,5568,5577,5582,5592,5606,5632,5659,5661,5668,5680,5727,5775,5810,5816,5840,5841,5845,5859,5876,5886,5921,5925,5932,6058,6071,6153,6211,6227,6246,6274,6315,6318,6339,6341,6354,6213,6360,6365,5508,6630,6640,6641,6675,6677,6700,6714,6716,6722,6731,6737,6740,6751,6752,6789,6811,6814,6817,6863,7032,3378,5398,7172,7199,7207,7253,7263,7272,7252,7280,7284,7290,7297,7316,7344,7349,7354,7361,7367,7378,7382,7391,7401,7406,7409,7422,7423,7428,7434,7439,7481,7511,7564,7592,7596,7603,7651,7668,7671,7673,7677,7692,7693,7696,7699,7700,7707,7717,7721,7730,7735,7736,7745,7746,7757,7763,7768,7778,7786,7801,7828,7833,7841,7879,7883,7889,7902,7915,7919,7943,7944,7950,7971,7987,7989,7998,8001,8004,8025,8030,8045,8069,8079,8082,8083,8086,8091,8098,8102,8103,8104,8112,8115,8117,8120,8134,8139,8146,8152,8171,8176,8177,8182,8185,8190,8194,8207,8209,8210,8212,8233,8236,8256,8258,8262,8268,8274,8291,8296,8330,8342,8349,8355,8358,8362,8367,8376,8379,8409,8422,8451,8453,8454,8487,8495,8536,8537,8542,8548,8562,8567,8572,8576,8579,8599,8606,8608,8615,8619,8628,8641,8648,8651,8655,8668,8669,8670,8673,8685,8689,8699,8702,8706,8711,8721,8736,8768,8773,8792,8793,8795,8808,8815,8820,8829,8831,8836,8838,8850,8853,8857,8868,8875,8877,8898,8900,8908,8909,8922,8929,8937,8941,8963,8975,8976,8984,8987,8989,8997,9003,9009,9028,9041,9052,9056,9060,9063,9082,9085,9095,9104,9109,9115,9142,9149,9156,9164,9212,9254,9265,9294,9336,9341,9358,9361,9371,9390,9395,9413,9439,9457,9464,9505,9530,9576,9618,9628,9631,9689,9709,9738,9740,9745,9761,9783,9806,9815,9816,9837,9842,9844,9863,9882,9884,9888,9889,9901,9904,9906,9908,9924,9925,9937,9938,9944,9949,9959,9968,9972,9983,9988,9989,10007,10009,10010,10015,10019,10024,10031,10037,10042,10058,10064,10090,10094,10104,10105,10121,10134,10138,10161,10166,10226,10244,10255,10268,10314,10379,10414,10420,10423,14549,14552,74,1435,1997,2551,2569,2625,3911,3954,3968,4134,4199,4201,4278,4337,2675,4444,4446,4458,4537,4544,6039,6222,6262,6451,6609,7585,7608,7641,7669,7905,8253,8254,8304,8404,8524,8527,8557,8558,8563,8590,8594,8595,8609,8611,8625,8632,8645,8652,8656,8679,8692,8705,8729,8769,8824,9920,9926,9940,9967,9993,10012,10046,10047,10070,10111,10122,10129,10137,10150,10154,10160,10184,10188,10205,10225,10235,10237,10239,10245,10267,10270,10279,10289,10294,10301,10302,5043,9529)
				
  ORDER BY i.created DESC 
  LIMIT 0, 6

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<subquery2>	ALL	distinct_key	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	1067	Using temporary; Χρήση ταξινόμησης αρχείου
1	PRIMARY	i	eq_ref	PRIMARY,item,catid	PRIMARY	4	tvc_0._col_1	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	ifitness_ifitnew.i.catid	1	Using index condition; Using where
2	MATERIALIZED	<derived3>	ALL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	1067
3	DERIVED	NULL	NULL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	NULL	No tables used

Προφίλ

Status	Duration
Starting	0.35 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.24 ms
Optimizing	0.19 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.15 ms
Removing tmp table	0.01 ms
Sending data	23.18 ms
Creating sort index	3.00 ms
Removing tmp table	0.30 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Removing tmp table	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.05 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.40 ms Μετά την τελευταία επερώτηση:0.29 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.885 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.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:73
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.80 ms Μετά την τελευταία επερώτηση:6.92 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 3.971 MB Σειρές που επιστράφηκαν:17

SHOW FULL COLUMNS 
  FROM `plzh7_users`

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW FULL COLUMNS FROM `plzh7_users`

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.03 ms
checking permissions	0.01 ms
Opening tables	0.20 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Filling schema table	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.08 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

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
21	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
19	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:246
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.18 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.003 MB Σειρές που επιστράφηκαν:1

SELECT *

  FROM `plzh7_users`

  WHERE `id` = 850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_users	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
19	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
18	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
17	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
16	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
15	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:246
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:1.66 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.016 MB Σειρές που επιστράφηκαν:2

SELECT `g`.`id`,`g`.`title`

  FROM `plzh7_usergroups` AS g

  INNER JOIN `plzh7_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	2	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.m.group_id	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.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.01 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:1.28 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.028 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #32 #36 #37 #42 #43 #48 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:249
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.36 ms Μετά την τελευταία επερώτηση:0.32 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.037 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #36 #37 #42 #43 #48 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
15	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:250
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.052 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=10188 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.20 ms Μετά την τελευταία επερώτηση:1.13 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.041 MB Σειρές που επιστράφηκαν:0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM plzh7_fields AS a

  LEFT JOIN `plzh7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN plzh7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN plzh7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN plzh7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN plzh7_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `plzh7_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag-media' 
  AND (fc.category_id IS NULL OR fc.category_id IN (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 ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Creating tmp table	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.33 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.14 ms Μετά την τελευταία επερώτηση:0.78 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.053 MB Σειρές που επιστράφηκαν:0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM plzh7_fields AS a

  LEFT JOIN `plzh7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN plzh7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN plzh7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN plzh7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN plzh7_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `plzh7_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (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 ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.32 ms
Creating sort index	0.03 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.03 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.42 ms Μετά την τελευταία επερώτηση:3.15 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.126 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #37 #42 #43 #48 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.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.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

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.23 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.134 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #42 #43 #48 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
15	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:250
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.143 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=8599 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.20 ms Μετά την τελευταία επερώτηση:0.54 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.130 MB Σειρές που επιστράφηκαν:0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM plzh7_fields AS a

  LEFT JOIN `plzh7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN plzh7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN plzh7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN plzh7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN plzh7_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `plzh7_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag-media' 
  AND (fc.category_id IS NULL OR fc.category_id IN (184,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.04 ms
Statistics	0.10 ms
Preparing	0.05 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.37 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.23 ms Μετά την τελευταία επερώτηση:0.55 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.142 MB Σειρές που επιστράφηκαν:0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM plzh7_fields AS a

  LEFT JOIN `plzh7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN plzh7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN plzh7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN plzh7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN plzh7_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `plzh7_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (184,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.12 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.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.36 ms
Creating sort index	0.04 ms
Removing tmp table	0.07 ms
Creating sort index	0.02 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.41 ms Μετά την τελευταία επερώτηση:0.25 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.153 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '14'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_categories	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:67
15	TableK2Category->load()	JROOT/components/com_k2/models/item.php:73
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.40 ms Μετά την τελευταία επερώτηση:2.35 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.228 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #43 #48 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
15	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:249
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.38 ms Μετά την τελευταία επερώτηση:0.23 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.236 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #48 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.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.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1853
16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/helpers/utilities.php:53
15	K2HelperUtilities::getAvatar()	JROOT/components/com_k2/models/item.php:250
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.39 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.245 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=10225 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.06 ms Μετά την τελευταία επερώτηση:0.53 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.232 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 (14,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.05 ms
Statistics	0.10 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.27 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.03 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.95 ms Μετά την τελευταία επερώτηση:0.55 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.244 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 (14,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.27 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
18	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
17	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:744
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.35 ms Μετά την τελευταία επερώτηση:0.24 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.255 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '7'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_categories	const	PRIMARY	PRIMARY	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.34 ms Μετά την τελευταία επερώτηση:2.35 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.335 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #43 #49 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:0.24 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.344 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #43 #48 #53 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.32 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.352 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=7669 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.95 ms Μετά την τελευταία επερώτηση:0.53 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.340 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 (7,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.28 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:668
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.95 ms Μετά την τελευταία επερώτηση:0.57 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.352 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 (7,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.27 ms
Creating sort index	0.03 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
18	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
17	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:744
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.34 ms Μετά την τελευταία επερώτηση:2.47 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.425 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #43 #48 #49 #54 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.33 ms Μετά την τελευταία επερώτηση:0.23 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.433 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #43 #48 #49 #53 #57 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.442 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=8558 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.32 ms Μετά την τελευταία επερώτηση:0.49 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.428 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '161'

Επεξήγηση

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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.32 ms Μετά την τελευταία επερώτηση:2.33 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.503 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #43 #48 #49 #53 #54 #58

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.01 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:0.25 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.511 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #31 #32 #36 #37 #42 #43 #48 #49 #53 #54 #57

SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users 
  WHERE userID=850

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_users	ref	userID	userID	4	const	1

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.31 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.520 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=10301 
  AND published=1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_comments	ref	itemID,published,latestComments,countComments	countComments	8	const,const	1	Using index

Προφίλ

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/item.php:1723
15	K2ModelItem->countItemComments()	JROOT/components/com_k2/models/item.php:273
14	K2ModelItem->prepareItem()	JROOT/components/com_k2/models/itemlist.php:988
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.96 ms Μετά την τελευταία επερώτηση:0.53 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.507 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 (161,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.08 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.08 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.31 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:668
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.92 ms Μετά την τελευταία επερώτηση:0.60 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.519 MB Σειρές που επιστράφηκαν:0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM plzh7_fields AS a

  LEFT JOIN `plzh7_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN plzh7_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN plzh7_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN plzh7_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN plzh7_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `plzh7_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_k2.relatedByTag' 
  AND (fc.category_id IS NULL OR fc.category_id IN (161,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; Χρήση ταξινόμησης αρχείου
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	ifitness_ifitnew.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	ifitness_ifitnew.a.id	1	Using where; Using index; Distinct

Προφίλ

Status	Duration
Starting	0.08 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.08 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.26 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:404
18	PlgSystemFields->display()	JROOT/plugins/system/fields/fields.php:324
17	PlgSystemFields->onContentAfterTitle()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:744
14	K2ModelItem->execPlugins()	JROOT/components/com_k2/models/itemlist.php:989
13	K2ModelItemlist->getRelatedItems()	JROOT/components/com_k2/views/item/view.html.php:306
12	K2ViewItem->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
11	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
9	K2Controller->display()	JROOT/components/com_k2/controllers/item.php:84
8	K2ControllerItem->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
6	require_once JROOT/components/com_k2/k2.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.54 ms Μετά την τελευταία επερώτηση:0.40 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 4.413 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_items 
  WHERE id != 7628 
  AND catid=184 
  AND ordering > 238 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-02 13:17:53' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-02 13:17:53' )  
  AND access IN(1,1,5) 
  AND trash=0  
  ORDER BY ordering ASC 
  LIMIT 0, 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	8098	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.04 ms
Optimizing	0.03 ms
Statistics	0.06 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.52 ms Μετά την τελευταία επερώτηση:1.03 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 4.435 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_items 
  WHERE id != 7628 
  AND catid=184 
  AND ordering < 238 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-08-02 13:17:53' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-08-02 13:17:53' )  
  AND access IN(1,1,5) 
  AND trash=0  
  ORDER BY ordering DESC 
  LIMIT 0, 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_items	range	PRIMARY,item,catid,ordering	ordering	4	NULL	5289	Using where

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.13 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.08 ms Μετά την τελευταία επερώτηση:23.19 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 4.576 MB Σειρές που επιστράφηκαν:124

SHOW TABLES

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:SHOW TABLES

Προφίλ

Status	Duration
Starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 ms
Executing	0.02 ms
Filling schema table	0.02 ms
checking permissions	0.46 ms
Executing	0.02 ms
Sending data	0.06 ms
End of update loop	0.02 ms
Query end	0.02 ms
closing tables	0.01 ms
Removing tmp table	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.57 ms Μετά την τελευταία επερώτηση:2.32 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.673 MB Σειρές που επιστράφηκαν:0

SELECT *
 
  FROM plzh7_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.ifitnessbook.com/nutrition/διατροφη/οι-καλοκαιρινοί-πειρασμοί-που-πρέπει-να-αποφύγεις?print=1&tmpl=component'
 
  AND `published` = 1

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_jmap_metainfo	ref	linkurl,published	published	1	const	1	Using where

Προφίλ

Status	Duration
Starting	0.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.06 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.01 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.47 ms Μετά την τελευταία επερώτηση:0.03 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 4.684 MB Σειρές που επιστράφηκαν:0

SELECT *
 
  FROM plzh7_jmap_canonicals
 
  WHERE `linkurl` = 'https://www.ifitnessbook.com/nutrition/διατροφη/οι-καλοκαιρινοί-πειρασμοί-που-πρέπει-να-αποφύγεις?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.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.02 ms
Preparing	0.02 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

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:0.60 ms Μετά την τελευταία επερώτηση:4.44 ms Μνήμη με επερώτηση: 0.020 MB Μνήμη πριν την επερώτηση: 4.765 MB Σειρές που επιστράφηκαν:0

SELECT *
 
  FROM plzh7_jmap_headings
 
  WHERE `linkurl` = 'https://www.ifitnessbook.com/nutrition/διατροφη/οι-καλοκαιρινοί-πειρασμοί-που-πρέπει-να-αποφύγεις?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.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.03 ms
Preparing	0.03 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.03 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

Κλήση στοίβας

#	Καλών	Αρχείο και αριθμός σειράς
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

[Πρόσθήκη του xdebug.file_link_format απευθείας στο αρχείο php.ini για να έχετε συνδέσμους για αρχεία]

Καταγράφηκαν 32 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

12 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM plzh7_fields AS a 
  LEFT JOIN `plzh7_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN plzh7_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN plzh7_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN plzh7_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN plzh7_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `plzh7_fields_categories` AS fc 
  ON fc.field_id = a.id

12 × SELECT id, gender, description, image, url, `
  group`, plugins 
  FROM plzh7_k2_users

7 × SELECT COUNT(*) 
  FROM plzh7_k2_comments

6 × SELECT * 
  FROM plzh7_k2_categories

```
3 × SELECT * 
  FROM plzh7_k2_items
```

1 × SELECT `ordering` 
  FROM `plzh7_extensions`

1 × SELECT *  
  FROM plzh7_jmap_canonicals

1 × SELECT *  
  FROM plzh7_jmap_metainfo

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `plzh7_usergroups` AS g 
  INNER JOIN `plzh7_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `plzh7_users`
```

1 × SELECT i.*, c.alias as categoryalias 
  FROM plzh7_k2_items as i     
  LEFT JOIN plzh7_k2_categories c 
  ON c.id = i.catid

1 × SELECT DISTINCT itemID 
  FROM plzh7_k2_tags_xref

1 × SELECT * 
  FROM plzh7_k2_comments

1 × SELECT `data` 
  FROM `plzh7_session`

1 × SELECT MAX(ordering) 
  FROM `plzh7_extensions`

1 × SELECT id, rules 
  FROM `plzh7_viewlevels

```
1 × SELECT * 
  FROM plzh7_k2_rating
```

1 × SELECT tag.*    
  FROM plzh7_k2_tags AS tag    JOIN plzh7_k2_tags_xref AS xref 
  ON tag.id = xref.tagID

1 × SELECT id 
  FROM plzh7_k2_categories

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `plzh7_assets`

```
1 × SELECT id 
  FROM plzh7_k2_items
```

1 × SELECT `source`,`keepurlparams` 
  FROM `plzh7_admintools_redirects`

1 × SELECT * 
  FROM `plzh7_admintools_wafexceptions`

1 × SELECT `value` 
  FROM `plzh7_admintools_storage`

1 × SELECT b.id 
  FROM plzh7_usergroups AS a 
  LEFT JOIN plzh7_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT *  
  FROM plzh7_jmap_headings

ΑΛΛΟΙ Πίνακες:

1 × UPDATE `plzh7_extensions` 
  SET `params` = '{\"mediaversion\":\"5ddb504afc6b718d66e49140d0c49e4e\"}'

1 × SHOW FULL COLUMNS 
  FROM `plzh7_k2_categories

1 × SHOW FULL COLUMNS 
  FROM `plzh7_k2_items

1 × UPDATE plzh7_k2_items 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `plzh7_users

```
1 × SHOW TABLE
```

ΚΟΙΝΟΠΟΙΗΣΤΕ

ΚΟΙΝΟΠΟΙΗΣΤΕ

Σχετικά Άρθρα

Συμβουλές για να κάνετε το καλοκαιρινό τρέξιμο διασκεδαστικό και ασφαλές

Τα τρόφιμα που μας παχαίνουν το καλοκαίρι

Πώς θα μαυρίσεις με ασφάλεια φέτος το καλοκαίρι

Πώς να διατηρήσετε γυμνασμένο σώμα όλο το καλοκαίρι

Τα τρόφιμα που μας παχαίνουν το καλοκαίρι

Οι 9 εντολές του καλοκαιρινού στυλ

Κονσόλα Αποσφαλμάτωσης του Joomla!

Συνεδρία

Πληροφορίες Προφίλ

Χρόνος

Μνήμη

Χρήση Μνήμης

Ερωτήματα Βάσης Δεδομένων

Καταγράφηκαν 67 ερωτήματα 121.96 ms

12 διπλότυπα βρέθηκαν!

Καταγράφηκαν 32 είδη ερωτημάτων και ταξινομήθηκαν κατά την εμφάνισή τους.

ΕΠΙΛΟΓΗ από Πίνακες:

ΑΛΛΟΙ Πίνακες: