Console Debug Joomla!

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1652788282,
                "last": 1652788282,
                "now": 1652788282
            },
            "token": "SsK0v648Gh283At5l7sFWBlJ5zfxCXsA"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "it-IT"
        }
    }
}

Tempo

Memoria

10 query eseguite 18.59 ms

1. Tempo della query: 0.28 ms Memoria query: 0.025 MB memoria prima della query: 1.389 MB Righe restituite: 0

   SELECT `data`
   
     FROM `o6mbh_session`
   
     WHERE `session_id` = 'n0rd7jk3vj8j5h87k7psg97rlr'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	o6mbh_session	const	PRIMARY	PRIMARY	766	const	1

   Profilo

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	0.02 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
   Waiting for query cache lock	0.02 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.03 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
   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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:831
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

2. Tempo della query: 0.18 ms Dopo l'ultima query: 1.11 ms Memoria query: 0.021 MB memoria prima della query: 1.466 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `o6mbh_session`
   
     WHERE `session_id` = 'n0rd7jk3vj8j5h87k7psg97rlr' 
     LIMIT 1

   Explain

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

   Profilo

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Init	0.00 ms
   Checking query cache for query	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
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
   7	JDatabaseDriver->loadResult()	JROOT/libraries/src/Application/CMSApplication.php:178
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

3. Tempo della query: 7.86 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.003 MB memoria prima della query: 1.471 MB

   INSERT INTO `o6mbh_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('n0rd7jk3vj8j5h87k7psg97rlr', 1, '1652788282', 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `o6mbh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('n0rd7jk3vj8j5h87k7psg97rlr', 1, '1652788282', 0, '', 0)

   Profilo

   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 for update	0.01 ms
   Update	0.05 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	7.67 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	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

   Call Stack

   #	Caller	File e numero di linea
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Application/CMSApplication.php:218
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:833
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:133
   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:415
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

4. Tempo della query: 0.38 ms Dopo l'ultima query: 13.10 ms Memoria query: 0.023 MB memoria prima della query: 1.615 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `o6mbh_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	o6mbh_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

   Profilo

   Status	Duration
   Starting	0.03 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	0.03 ms
   Checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.00 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.02 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.07 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.01 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1496
   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:310
   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:606
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

5. Tempo della query: 0.31 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.022 MB memoria prima della query: 1.627 MB Righe restituite: 2

   SELECT b.id
   
     FROM o6mbh_usergroups AS a
   
     LEFT JOIN o6mbh_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 9

   Explain

   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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	9	Using where; Using index

   Profilo

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	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.00 ms
   Waiting for query cache lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Unlocking tables	0.00 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1540
   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:310
   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:606
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

6. Tempo della query: 0.28 ms Dopo l'ultima query: 22.95 ms Memoria query: 0.028 MB memoria prima della query: 2.304 MB Righe restituite: 71

   SELECT *
   
     FROM o6mbh_rsticketspro_configuration

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	o6mbh_rsticketspro_configuration	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	71

   Profilo

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	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
   Waiting for query cache lock	0.01 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsticketspro/helpers/config.php:52
   11	RSTicketsProConfig->load()	JROOT/administrator/components/com_rsticketspro/helpers/config.php:19
   10	RSTicketsProConfig->__construct()	JROOT/administrator/components/com_rsticketspro/helpers/config.php:102
   9	RSTicketsProConfig::getInstance()	JROOT/plugins/system/rsticketspro/rsticketspro.php:50
   8	plgSystemRSTicketsPro->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:686
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

7. Tempo della query: 7.44 ms Dopo l'ultima query: 16.16 ms Memoria query: 0.005 MB memoria prima della query: 2.920 MB

   UPDATE `o6mbh_extensions`
   
     SET `params` = '{\"mediaversion\":\"52a2488c23fb2148dcec3e7838606335\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN non possibile sulla query: UPDATE `o6mbh_extensions` SET `params` = '{\"mediaversion\":\"52a2488c23fb2148dcec3e7838606335\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profilo

   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.00 ms
   Init for update	0.12 ms
   Updating	0.08 ms
   End of update loop	0.01 ms
   Waiting for query cache lock	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	7.06 ms
   Closing tables	0.01 ms
   Unlocking tables	0.01 ms
   Closing tables	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

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
   9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
   8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
   7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
   6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
   5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1116
   4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

8. Tempo della query: 0.62 ms Dopo l'ultima query: 17.54 ms Memoria query: 0.039 MB memoria prima della query: 3.202 MB Righe restituite: 0

   SELECT 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
   
     FROM o6mbh_fields AS a
   
     LEFT JOIN `o6mbh_languages` AS l 
     ON l.lang_code = a.language
   
     LEFT JOIN o6mbh_users AS uc 
     ON uc.id=a.checked_out
   
     LEFT JOIN o6mbh_viewlevels AS ag 
     ON ag.id = a.access
   
     LEFT JOIN o6mbh_users AS ua 
     ON ua.id = a.created_user_id
   
     LEFT JOIN o6mbh_fields_groups AS g 
     ON g.id = a.group_id
   
     WHERE a.context = 'com_users.reset_request' 
     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

   Explain

   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 filesort
   1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	biasinet_site.a.language	1	Using where
   1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	biasinet_site.a.checked_out	1
   1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	biasinet_site.a.access	1	Using where
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	biasinet_site.a.created_user_id	1	Using where
   1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	biasinet_site.a.group_id	1	Using where

   Profilo

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	0.10 ms
   Checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   Waiting for query cache lock	0.03 ms
   Init	0.05 ms
   Optimizing	0.03 ms
   Statistics	0.11 ms
   Preparing	0.04 ms
   Sorting result	0.01 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.00 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.00 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:327
   21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
   19	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
   18	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:236
   17	PlgSystemFields->onContentPrepareForm()	JROOT/libraries/joomla/event/event.php:70
   16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   15	JEventDispatcher->trigger()	JROOT/libraries/src/MVC/Model/FormModel.php:321
   14	Joomla\CMS\MVC\Model\FormModel->preprocessForm()	JROOT/components/com_users/models/reset.php:110
   13	UsersModelReset->preprocessForm()	JROOT/libraries/src/MVC/Model/FormModel.php:242
   12	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_users/models/reset.php:35
   11	UsersModelReset->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:423
   10	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_users/views/reset/view.html.php:55
   9	UsersViewReset->display()	JROOT/components/com_users/controller.php:133
   8	UsersController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_users/users.php:15
   6	require_once JROOT/components/com_users/users.php	JROOT/libraries/src/Component/ComponentHelper.php:381
   5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:356
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

9. Tempo della query: 0.40 ms Dopo l'ultima query: 22.52 ms Memoria query: 0.023 MB memoria prima della query: 3.488 MB Righe restituite: 1

   SELECT language,id
   
     FROM `o6mbh_menu`
   
     WHERE home = 1 
     AND published = 1 
     AND client_id = 0

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	o6mbh_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	9	Using where

   Profilo

   Status	Duration
   Starting	0.01 ms
   Waiting for query cache lock	0.01 ms
   Init	0.00 ms
   Checking query cache for query	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
   Waiting for query cache lock	0.01 ms
   Init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.06 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.09 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.02 ms
   Waiting for query cache lock	0.00 ms
   Updating status	0.00 ms
   Storing result in query cache	0.01 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
   7	PlgSystemLanguageFilter->onAfterDispatch()	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/SiteApplication.php:199
   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:267
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

   [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

   ---

10. Tempo della query: 0.84 ms Dopo l'ultima query: 3.14 ms Memoria query: 0.028 MB memoria prima della query: 3.546 MB Righe restituite: 10

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM o6mbh_modules AS m
    
      LEFT JOIN o6mbh_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN o6mbh_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2022-05-17 11:51:22') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2022-05-17 11:51:22') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 103 OR mm.menuid <= 0) 
      AND m.language IN ('it-IT','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	18	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	biasinet_site.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	biasinet_site.m.module,const	1	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.01 ms
    Waiting for query cache lock	0.01 ms
    Init	0.00 ms
    Checking query cache for query	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
    Waiting for query cache lock	0.02 ms
    Init	0.04 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.04 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.32 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.00 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.01 ms
    Waiting for query cache lock	0.00 ms
    Updating status	0.00 ms
    Storing result in query cache	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    14	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:433
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:363
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/studioetro/index.php:18
    7	require JROOT/templates/studioetro/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1103
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:273
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Aggiungi la direttiva xdebug.file_link_format al tuo file php.ini per avere i link ai file]

    ---

10 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 1 × SELECT `data` 
     FROM `o6mbh_session`

2. 1 × SELECT `session_id` 
     FROM `o6mbh_session`

3. 1 × SELECT id, rules 
     FROM `o6mbh_viewlevels

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

5. 1 × SELECT * 
     FROM o6mbh_rsticketspro_configuratio

6. 1 × SELECT 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 
     FROM o6mbh_fields AS a 
     LEFT JOIN `o6mbh_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN o6mbh_users AS uc 
     ON uc.id=a.checked_out 
     LEFT JOIN o6mbh_viewlevels AS ag 
     ON ag.id = a.access 
     LEFT JOIN o6mbh_users AS ua 
     ON ua.id = a.created_user_id 
     LEFT JOIN o6mbh_fields_groups AS g 
     ON g.id = a.group_id

7. 1 × SELECT language,id 
     FROM `o6mbh_menu`

8. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM o6mbh_modules AS m 
     LEFT JOIN o6mbh_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN o6mbh_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

ALTRE tabelle:

1. 1 × INSERT INTO `o6mbh_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('n0rd7jk3vj8j5h87k7psg97rlr', 1, '1652788282', 0, '', 0

2. 1 × UPDATE `o6mbh_extensions` 
     SET `params` = '{\"mediaversion\":\"52a2488c23fb2148dcec3e7838606335\"}'