Λιώνει στη γυμναστική πριν από τη πρεμιέρα! (ΦΩΤΟ)

Οκτωβρίου 28, 2014
Κατηγορία Gossip

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

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

Στροφή 180 μοιρών έχει κάνει στην εξωτερική της εμφάνιση η λαϊκή τραγουδίστρια και δεν είναι τυχαίο, αλλά αποτέλεσμα σκληρής και εντατικής γυμναστικής.

Η Βασιλική Νταντά τον τελευταίο καιρό έχει εντείνει το πρόγραμμα γυμναστικής της, αφού θέλει να είναι καθόλα έτοιμη για την πρεμιέρα της στις 14 Νοέμβρη στο Romeo, στο πλευρό του Λευτέρη Πανταζή, μαζί με τους Γιώργο Δασκαλάκη, τον Θοδωρή Φέρρη και τον Tus.

{fcomments}

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

Ετικέτες

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

Πώς να συνδυάσεις γυμναστική με νηστεία
Πως να κάνετε γυμναστική ακόμα και στην πισίνα του ξενοδοχείου (vid)
Πώς να φτιάξεις σώμα για παραλία σε λιγότερο από μήνα
Οι μύες που γυμνάζονται στο κολύμπι (video)
Πώς θα μετατρέπεις κάθε τροφή σε καύσιμο
Τι πρέπει να κάνεις μετά τη γυμναστική για να δεις άμεσα αποτελέσματα στο σώμα σου

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

Συνεδρία

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1778014559,
                "last": 1778014559,
                "now": 1778014559
            },
            "token": "ePLiyzycpG39HZta4BmfurfDGFHJBVXV"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "com_mailto": {
            "links": {
                "d4abcb178788ff8697df4ad713ed3d8cb40a82dd": {
                    "link": "https://www.ifitnessbook.com/lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto?print=1&tmpl=component",
                    "expiry": 1778014560
                }
            }
        }
    }
}

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

Χρήση Μνήμης

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

Καταγράφηκαν 71 ερωτήματα 102.75 ms

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

12 διπλότυπα: #33 #34 #39 #40 #46 #47 #52 #53 #58 #59 #63 #64

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

SELECT `data`

  FROM `plzh7_session`

  WHERE `session_id` = X'6663643764643062303062313834343461373333346430383033383039383638'

Επεξήγηση

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

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

#	Καλών	Αρχείο και αριθμός σειράς
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Το ίδιο όπως κλήθηκε στην παρακάτω σειρά.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:56

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

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

SELECT `session_id`

  FROM `plzh7_session`

  WHERE `session_id` = X'6663643764643062303062313834343461373333346430383033383039383638' 
  LIMIT 1

Επεξήγηση

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

Προφίλ

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

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

#	Καλών	Αρχείο και αριθμός σειράς
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:56

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

Χρόνος επερώτησης:2.78 ms Μετά την τελευταία επερώτηση:0.07 ms Μνήμη με επερώτηση: 0.004 MB Μνήμη πριν την επερώτηση: 1.049 MB

INSERT INTO `plzh7_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6663643764643062303062313834343461373333346430383033383039383638', 1, 1778014559, 0, '', 0)

Επεξήγηση

Δεν είναι δυνατό το EXPLAIN στην επερώτηση:INSERT INTO `plzh7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6663643764643062303062313834343461373333346430383033383039383638', 1, 1778014559, 0, '', 0)

Προφίλ

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 for update	0.04 ms
Update	0.18 ms
End of update loop	0.03 ms
Query end	0.01 ms
Commit	2.20 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:56

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

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

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

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

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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.63 ms Μετά την τελευταία επερώτηση:20.17 ms Μνήμη με επερώτηση: 0.022 MB Μνήμη πριν την επερώτηση: 1.636 MB Σειρές που επιστράφηκαν:0

SELECT `value`

  FROM `plzh7_admintools_storage`

  WHERE `key` = 'cparams'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Προφίλ

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

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

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

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

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

SELECT *

  FROM `plzh7_admintools_wafexceptions`

  WHERE NOT(`option` LIKE 'com_%')

Επεξήγηση

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

Προφίλ

Status	Duration
Starting	0.06 ms
checking permissions	0.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.05 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.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

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

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

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

SELECT `source`,`keepurlparams`

  FROM `plzh7_admintools_redirects`

  WHERE ((`dest` = 'lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto') OR (`dest` = 'lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto?print=1&tmpl=component') OR ('lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto?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.13 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.05 ms
Statistics	0.04 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.06 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

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

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

SELECT id 
  FROM plzh7_k2_items 
  WHERE alias = 'lionei-sti-gymnastiki-prin-apo-ti-premiera-foto'

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_items	ALL	NULL	ΔΕ ΧΡΗΣΙΜΟΠΟΙΗΘΗΚΕ ΚΑΝΕΝΑ ΚΛΕΙΔΙ ΕΥΡΕΤΗΡΙΟΥ	NULL	NULL	13372	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.02 ms
table lock	0.02 ms
init	0.05 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	40.43 ms
End of update loop	0.03 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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.85 ms Μετά την τελευταία επερώτηση:2.56 ms Μνήμη με επερώτηση: 0.006 MB Μνήμη πριν την επερώτηση: 2.795 MB

UPDATE `plzh7_extensions`

  SET `params` = '{\"mediaversion\":\"21bb8b7e5163df890ad80daa31b9734a\"}'

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

Επεξήγηση

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

Προφίλ

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.09 ms
Updating	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.27 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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.64 ms Μετά την τελευταία επερώτηση:12.04 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 2.986 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.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.02 ms
Statistics	0.09 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.17 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.16 ms Μετά την τελευταία επερώτηση:8.50 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.178 MB Σειρές που επιστράφηκαν:76

SELECT id 
  FROM plzh7_k2_categories 
  WHERE published=1 
  AND trash=0 
  AND access IN(1,1,5)

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	plzh7_k2_categories	range	category,published,access,trash	category	8	NULL	66	Using index condition

Προφίλ

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.69 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/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.42 ms Μετά την τελευταία επερώτηση:0.09 ms Μνήμη με επερώτηση: 0.039 MB Μνήμη πριν την επερώτηση: 3.185 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_items 
  WHERE id=5082 
  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.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.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.09 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: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 για να έχετε συνδέσμους για αρχεία]

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

SHOW FULL COLUMNS 
  FROM `plzh7_k2_categories`

Επεξήγηση

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

Προφίλ

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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.42 ms Μετά την τελευταία επερώτηση:1.15 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.300 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '27'

Επεξήγηση

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.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 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
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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.39 ms Μετά την τελευταία επερώτηση:2.87 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.377 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.04 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.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 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.60 ms Μετά την τελευταία επερώτηση:0.52 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.398 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 = 5082 
  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.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.09 ms
Preparing	0.04 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.12 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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.33 ms Μετά την τελευταία επερώτηση:1.39 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.413 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM plzh7_k2_rating 
  WHERE itemID = 5082

Επεξήγηση

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.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	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: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.42 ms Μετά την τελευταία επερώτηση:0.84 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.431 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=5082 
  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.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.07 ms
Preparing	0.04 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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.94 ms Μετά την τελευταία επερώτηση:2.66 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.450 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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.41 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.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: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.63 ms Μετά την τελευταία επερώτηση:0.05 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.459 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.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.05 ms
Optimizing	0.03 ms
Statistics	0.12 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.06 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: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 για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:2.55 ms Μετά την τελευταία επερώτηση:3.89 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.487 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 (27,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.25 ms
checking permissions	0.02 ms
Opening tables	0.07 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.13 ms
Optimizing	0.09 ms
Statistics	0.27 ms
Preparing	0.11 ms
Creating tmp table	0.12 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.91 ms
Creating sort index	0.07 ms
Removing tmp table	0.16 ms
Creating sort index	0.02 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.03 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

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

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

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

Χρόνος επερώτησης:2.20 ms Μετά την τελευταία επερώτηση:1.90 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.587 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 (27,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.24 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.11 ms
Optimizing	0.08 ms
Statistics	0.22 ms
Preparing	0.09 ms
Creating tmp table	0.10 ms
Sorting result	0.03 ms
Executing	0.01 ms
Sending data	0.79 ms
Creating sort index	0.06 ms
Removing tmp table	0.14 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.03 ms
Reset for next command	0.02 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php: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.52 ms Μετά την τελευταία επερώτηση:0.74 ms Μνήμη με επερώτηση: 0.033 MB Μνήμη πριν την επερώτηση: 3.604 MB Σειρές που επιστράφηκαν:36

SHOW FULL COLUMNS 
  FROM `plzh7_k2_items`

Επεξήγηση

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

Προφίλ

Status	Duration
Starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
checking permissions	0.01 ms
Opening tables	0.50 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.02 ms
Statistics	0.02 ms
Preparing	0.03 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.25 ms
closing tables	0.01 ms
checking permissions	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
Removing tmp table	0.16 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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.54 ms Μετά την τελευταία επερώτηση:0.11 ms Μνήμη με επερώτηση: 0.007 MB Μνήμη πριν την επερώτηση: 3.650 MB

UPDATE plzh7_k2_items

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

  WHERE `id` = '5082'

Επεξήγηση

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

Προφίλ

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init for update	0.07 ms
Updating	0.16 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.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/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.59 ms Μετά την τελευταία επερώτηση:0.12 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 3.655 MB Σειρές που επιστράφηκαν:0

SELECT * 
  FROM plzh7_k2_comments 
  WHERE itemID=5082 
  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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.06 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

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

Χρόνος επερώτησης:2.43 ms Μετά την τελευταία επερώτηση:1.02 ms Μνήμη με επερώτηση: 0.038 MB Μνήμη πριν την επερώτηση: 3.663 MB Σειρές που επιστράφηκαν:317

SELECT DISTINCT itemID 
  FROM plzh7_k2_tags_xref 
  WHERE tagID IN (498,5005,5224) 
  AND itemID!=5082

Επεξήγηση

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	290	Using index condition; Using where; Using temporary

Προφίλ

Status	Duration
Starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.03 ms
Statistics	0.15 ms
Preparing	0.04 ms
Creating tmp table	0.05 ms
Executing	0.01 ms
Sending data	1.80 ms
Removing tmp table	0.02 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.02 ms

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

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

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

Χρόνος επερώτησης:11.37 ms Μετά την τελευταία επερώτηση:0.12 ms Μνήμη με επερώτηση: 0.073 MB Μνήμη πριν την επερώτηση: 3.705 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-05-05 20:56:00' )
				
  AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2026-05-05 20:56:00' )  
  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 (307,384,469,688,705,711,751,781,843,1007,1034,1054,1195,1222,1261,1400,1440,1515,1516,1607,1643,1661,1703,1845,1849,1859,1993,2010,1663,2156,2255,2265,2400,2401,2447,2496,2500,2499,2236,2625,2697,2709,2720,2211,999,2806,2807,2836,2850,2875,2935,2980,2982,2995,3049,1642,993,3094,3112,3116,3147,3327,3380,3385,3381,3405,3410,3412,3413,3419,3420,3421,3435,3432,3467,3477,3479,3485,3504,3511,3515,3526,815,1001,3382,3614,3616,3617,3677,3687,3695,3705,3709,3714,3718,3721,3769,3799,3801,3820,3885,3886,3887,3903,3914,3942,3946,3965,3971,3974,3566,4003,4060,4087,4101,4183,4246,4253,4338,4368,4443,4450,4468,4486,4492,4528,4562,4588,4632,4651,4677,4689,4690,4714,4749,4670,4805,4877,4950,4999,5018,5042,5092,5135,5152,5158,5181,5199,5210,5213,5272,5276,5309,5373,5408,5418,5440,5480,5515,5567,5591,5610,5611,5678,5712,5816,5826,5827,5843,5894,5936,6019,6040,6097,6124,6176,6184,6207,6280,6277,6281,6310,6324,6330,6357,6581,6592,6638,6654,6653,6658,6663,6668,6679,6697,6699,6711,6714,6715,6741,6743,6821,6852,7032,7180,7283,7287,7302,7392,7430,7440,7452,7517,7557,7563,7674,7678,7744,7789,7790,7804,7808,7822,7870,7873,7879,7937,7956,7977,7995,8023,8027,8028,8040,8044,8078,8080,8087,8088,8095,8178,8199,8223,8224,8267,8319,8327,8332,8384,8390,8414,8450,8481,8515,8547,8573,8597,8625,8634,8640,8641,8658,8708,8725,8753,8754,8764,8796,8852,8893,8911,8914,8934,8974,9008,9022,9072,9089,9090,9106,9127,9163,9221,9268,9370,9444,9496,9581,9594,9618,9642,9655,9661,9691,9758,9761,9765,9773,9804,9820,9870,9906,9948,9986,9995,10046,10067,10110,10142,10171,10191,10197,10202,10227,10296,10300,4775)
				
  ORDER BY i.created DESC 
  LIMIT 0, 6

Επεξήγηση

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	i	index	PRIMARY,item,catid	created	5	NULL	326	Using where
1	SIMPLE	c	eq_ref	PRIMARY,category,published,access,trash	PRIMARY	4	ifitness_ifitnew.i.catid	1	Using index condition; Using where

Προφίλ

Status	Duration
Starting	0.37 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.13 ms
Optimizing	0.08 ms
Statistics	0.45 ms
Preparing	0.42 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	9.73 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.02 ms
Updating status	0.01 ms
Reset for next command	0.00 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.25 ms Μετά την τελευταία επερώτηση:0.17 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.773 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '175'

Επεξήγηση

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.04 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.02 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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 Μετά την τελευταία επερώτηση:4.98 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 3.858 MB Σειρές που επιστράφηκαν:17

SHOW FULL COLUMNS 
  FROM `plzh7_users`

Επεξήγηση

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

Προφίλ

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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.26 ms Μετά την τελευταία επερώτηση:0.17 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.890 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.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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.24 ms Μετά την τελευταία επερώτηση:1.20 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.903 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.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.22 ms Μετά την τελευταία επερώτηση:1.31 ms Μνήμη με επερώτηση: 0.025 MB Μνήμη πριν την επερώτηση: 3.921 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #34 #39 #40 #46 #47 #52 #53 #58 #59 #63 #64

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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 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.16 ms Μετά την τελευταία επερώτηση:0.30 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.931 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #39 #40 #46 #47 #52 #53 #58 #59 #63 #64

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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.18 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.940 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=8319 
  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.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.86 ms Μετά την τελευταία επερώτηση:1.04 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 3.928 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 (175,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.05 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.09 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.28 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.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.80 ms Μετά την τελευταία επερώτηση:0.66 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 3.940 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 (175,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.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.27 ms
Creating sort index	0.02 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.22 ms Μετά την τελευταία επερώτηση:0.31 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 3.951 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.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 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.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.19 ms Μετά την τελευταία επερώτηση:2.90 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.031 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #40 #46 #47 #52 #53 #58 #59 #63 #64

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.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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.16 ms Μετά την τελευταία επερώτηση:0.31 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.039 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #46 #47 #52 #53 #58 #59 #63 #64

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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 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.17 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.047 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=10197 
  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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.00 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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.77 ms Μετά την τελευταία επερώτηση:0.65 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.035 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.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.00 ms
init	0.04 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.03 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.27 ms
Creating sort index	0.02 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.63 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.047 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.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.05 ms
Optimizing	0.03 ms
Statistics	0.09 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.34 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.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.22 ms Μετά την τελευταία επερώτηση:0.29 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.058 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '160'

Επεξήγηση

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.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.73 ms Μετά την τελευταία επερώτηση:0.20 ms Μνήμη με επερώτηση: 0.030 MB Μνήμη πριν την επερώτηση: 4.085 MB Σειρές που επιστράφηκαν:76

SELECT id, name,  parent	
  FROM plzh7_k2_categories 
  WHERE published=1  
  AND trash=0 
  AND access IN(1,1,5) 
  ORDER BY parent

Επεξήγηση

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.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.47 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1245
17	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:314
16	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
15	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/models/item.php:76
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.25 ms Μετά την τελευταία επερώτηση:3.41 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.188 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #47 #52 #53 #58 #59 #63 #64

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.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.03 ms
Starting cleanup	0.00 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.20 ms Μετά την τελευταία επερώτηση:0.30 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.196 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #52 #53 #58 #59 #63 #64

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.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.20 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.205 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=9948 
  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.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.94 ms Μετά την τελευταία επερώτηση:0.65 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.192 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 (160,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.04 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.10 ms
Preparing	0.04 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.32 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.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.96 ms Μετά την τελευταία επερώτηση:0.68 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.204 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 (160,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.04 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.09 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.02 ms
Executing	0.02 ms
Sending data	0.32 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.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.24 ms Μετά την τελευταία επερώτηση:0.30 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.215 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '38'

Επεξήγηση

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.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.22 ms Μετά την τελευταία επερώτηση:2.83 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.295 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #47 #53 #58 #59 #63 #64

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.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.18 ms Μετά την τελευταία επερώτηση:0.30 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.303 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #47 #52 #58 #59 #63 #64

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.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
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.19 ms Μετά την τελευταία επερώτηση:0.04 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.312 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=9370 
  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.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.01 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.00 ms
Query end	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.88 ms Μετά την τελευταία επερώτηση:0.66 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.300 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 (38,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.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.32 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.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.87 ms Μετά την τελευταία επερώτηση:0.67 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.312 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 (38,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.04 ms
Optimizing	0.03 ms
Statistics	0.08 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.30 ms
Creating sort index	0.02 ms
Removing tmp table	0.06 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 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.22 ms Μετά την τελευταία επερώτηση:0.29 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.323 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_categories 
  WHERE id = '184'

Επεξήγηση

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

Προφίλ

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.00 ms
Query end	0.00 ms
closing tables	0.00 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 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.47 ms Μετά την τελευταία επερώτηση:20.46 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.397 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #47 #52 #53 #59 #63 #64

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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.29 ms Μετά την τελευταία επερώτηση:0.42 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.405 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #47 #52 #53 #58 #63 #64

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.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.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.28 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.414 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=7879 
  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.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.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.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 για να έχετε συνδέσμους για αρχεία]

Χρόνος επερώτησης:1.90 ms Μετά την τελευταία επερώτηση:1.27 ms Μνήμη με επερώτηση: 0.026 MB Μνήμη πριν την επερώτηση: 4.401 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.19 ms
checking permissions	0.02 ms
Opening tables	0.08 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.18 ms
Preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.63 ms
Creating sort index	0.05 ms
Removing tmp table	0.11 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.87 ms Μετά την τελευταία επερώτηση:1.37 ms Μνήμη με επερώτηση: 0.027 MB Μνήμη πριν την επερώτηση: 4.413 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.19 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.09 ms
Optimizing	0.07 ms
Statistics	0.17 ms
Preparing	0.07 ms
Creating tmp table	0.07 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.61 ms
Creating sort index	0.05 ms
Removing tmp table	0.11 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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.46 ms Μετά την τελευταία επερώτηση:5.53 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.487 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #47 #52 #53 #58 #59 #64

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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.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.34 ms Μετά την τελευταία επερώτηση:0.43 ms Μνήμη με επερώτηση: 0.024 MB Μνήμη πριν την επερώτηση: 4.495 MB Σειρές που επιστράφηκαν:0

Διπλότυπες επερωτήσεις: #33 #34 #39 #40 #46 #47 #52 #53 #58 #59 #63

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.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.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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.41 ms Μετά την τελευταία επερώτηση:0.06 ms Μνήμη με επερώτηση: 0.029 MB Μνήμη πριν την επερώτηση: 4.513 MB Σειρές που επιστράφηκαν:1

SELECT COUNT(*) 
  FROM plzh7_k2_comments 
  WHERE itemID=8753 
  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.06 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.02 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 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

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

#	Καλών	Αρχείο και αριθμός σειράς
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.79 ms Μετά την τελευταία επερώτηση:0.99 ms Μνήμη με επερώτηση: 0.023 MB Μνήμη πριν την επερώτηση: 4.469 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_items 
  WHERE id != 5082 
  AND catid=27 
  AND ordering > 217 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-05-05 20:56:00' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-05 20:56:00' )  
  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	8288	Using where

Προφίλ

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

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

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

Χρόνος επερώτησης:2.74 ms Μετά την τελευταία επερώτηση:1.62 ms Μνήμη με επερώτηση: 0.273 MB Μνήμη πριν την επερώτηση: 4.487 MB Σειρές που επιστράφηκαν:1

SELECT * 
  FROM plzh7_k2_items 
  WHERE id != 5082 
  AND catid=27 
  AND ordering < 217 
  AND published=1 
  AND ( publish_up = '0000-00-00 00:00:00' OR publish_up <= '2026-05-05 20:56:00' ) 
  AND ( publish_down = '0000-00-00 00:00:00' OR publish_down >= '2026-05-05 20:56:00' )  
  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	5072	Using where

Προφίλ

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

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

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

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

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

SHOW TABLES

Επεξήγηση

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

Προφίλ

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

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

#	Καλών	Αρχείο και αριθμός σειράς
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
11	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
10	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/mobilemenuck/helpers/helper.php:173
9	Mobilemenuck\Helper::searchTable()	JROOT/plugins/system/mobilemenuck/helpers/helper.php:161
8	Mobilemenuck\Helper::checkIsProVersion()	JROOT/plugins/system/mobilemenuck/mobilemenuck.php:374
7	PlgSystemMobilemenuck->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

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

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

SELECT *
 
  FROM plzh7_jmap_metainfo
 
  WHERE `linkurl` = 'https://www.ifitnessbook.com/lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto?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.07 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.01 ms
init	0.05 ms
Optimizing	0.04 ms
Statistics	0.11 ms
Preparing	0.05 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.02 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:514
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

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

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

SELECT *
 
  FROM plzh7_jmap_canonicals
 
  WHERE `linkurl` = 'https://www.ifitnessbook.com/lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto?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.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.03 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

#	Καλών	Αρχείο και αριθμός σειράς
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:593
12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:59

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

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

SELECT *
 
  FROM plzh7_jmap_headings
 
  WHERE `linkurl` = 'https://www.ifitnessbook.com/lifestyle/gossip/lionei-sti-gymnastiki-prin-apo-ti-premiera-foto?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.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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

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

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

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

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

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

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

7 × SELECT COUNT(*) 
  FROM plzh7_k2_comments

7 × 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 id, name,  parent 
  FROM plzh7_k2_categories

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 `session_id` 
  FROM `plzh7_session`

```
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 id, rules 
  FROM `plzh7_viewlevels

1 × SELECT *  
  FROM plzh7_jmap_headings

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

1 × INSERT INTO `plzh7_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'6663643764643062303062313834343461373333346430383033383039383638', 1, 1778014559, 0, '', 0

1 × UPDATE `plzh7_extensions` 
  SET `params` = '{\"mediaversion\":\"21bb8b7e5163df890ad80daa31b9734a\"}'

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
```

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

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

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

Πώς να συνδυάσεις γυμναστική με νηστεία

Πως να κάνετε γυμναστική ακόμα και στην πισίνα του ξενοδοχείου (vid)

Πώς να φτιάξεις σώμα για παραλία σε λιγότερο από μήνα

Οι μύες που γυμνάζονται στο κολύμπι (video)

Πώς θα μετατρέπεις κάθε τροφή σε καύσιμο

Τι πρέπει να κάνεις μετά τη γυμναστική για να δεις άμεσα αποτελέσματα στο σώμα σου

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

Συνεδρία

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

Χρόνος

Μνήμη

Χρήση Μνήμης

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

Καταγράφηκαν 71 ερωτήματα 102.75 ms

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

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

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

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