{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1741921098,
                "last": 1741921098,
                "now": 1741921098
            },
            "token": "w96YvhLlIVi7AP1CLyn0miKaCFpeXix1"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "d65f0415f23c251742b59762d11484cbb55017c6",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            },
            "com_installer": {
                "message": "",
                "extension_message": ""
            }
        },
        "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

28 query eseguite 92.38 ms

1. Tempo della query: 1.22 ms

   SELECT `data`
   
     FROM `knfcx_session`
   
     WHERE `session_id` = '6vi1n0i9eu1nksmehku5ag68a4'

   Explain

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

   Profilo

   Error
   MySql have_profiling = off

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.41 ms Dopo l'ultima query: 15.86 ms

   SELECT `session_id`
   
     FROM `knfcx_session`
   
     WHERE `session_id` = '6vi1n0i9eu1nksmehku5ag68a4' 
     LIMIT 1

   Explain

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

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysql->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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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: 2.66 ms Dopo l'ultima query: 0.29 ms

   INSERT INTO `knfcx_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('6vi1n0i9eu1nksmehku5ag68a4', 1, 1741921098, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `knfcx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6vi1n0i9eu1nksmehku5ag68a4', 1, 1741921098, 0, '', 0)

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.46 ms Dopo l'ultima query: 84.92 ms

   SELECT id, rules
   
     FROM `knfcx_viewlevels`

   Explain

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

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysql->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:321
   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:196
   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.45 ms Dopo l'ultima query: 0.26 ms

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

   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 index

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysql->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:321
   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:196
   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.56 ms Dopo l'ultima query: 789.12 ms

   SELECT `lastupdate`
   
     FROM `knfcx_ak_storage`
   
     WHERE `tag` = 'akeebaupdatecheck_lastrun'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	knfcx_ak_storage	system	PRIMARY	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   10	JDatabaseDriver->loadResult()	JROOT/plugins/system/akeebaupdatecheck/akeebaupdatecheck.php:81
   9	plgSystemAkeebaupdatecheck->onAfterInitialise()	Chiamata uguale alla linea sottostante.
   8	call_user_func_array()	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:626
   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:196
   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: 0.60 ms Dopo l'ultima query: 189.48 ms

   UPDATE `knfcx_extensions`
   
     SET `params` = '{\"mediaversion\":\"56ac0aab4366e86e28c529c07e484caf\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN non possibile sulla query: UPDATE `knfcx_extensions` SET `params` = '{\"mediaversion\":\"56ac0aab4366e86e28c529c07e484caf\"}' WHERE `type` = 'library' AND `element` = 'joomla'

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysql->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:1129
   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:196
   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: 2.05 ms Dopo l'ultima query: 252.06 ms

   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 knfcx_fields AS a
   
     LEFT JOIN `knfcx_languages` AS l 
     ON l.lang_code = a.language
   
     LEFT JOIN knfcx_users AS uc 
     ON uc.id=a.checked_out
   
     LEFT JOIN knfcx_viewlevels AS ag 
     ON ag.id = a.access
   
     LEFT JOIN knfcx_users AS ua 
     ON ua.id = a.created_user_id
   
     LEFT JOIN knfcx_fields_groups AS g 
     ON g.id = a.group_id
   
     WHERE a.context = 'com_mailto.mailto' 
     AND a.access IN (1,1) 
     AND (a.group_id = 0 OR g.access IN (1,1)) 
     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 temporary; Using filesort
   1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	21	ef8434abb_c7a322.a.language	1
   1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	ef8434abb_c7a322.a.checked_out	1
   1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	ef8434abb_c7a322.a.access	1
   1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	ef8434abb_c7a322.a.created_user_id	1
   1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	ef8434abb_c7a322.a.group_id	1	Using where

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   25	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
   24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
   23	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
   22	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
   21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
   20	FieldsHelper::getFields()	JROOT/administrator/components/com_fields/helpers/fields.php:285
   19	FieldsHelper::prepareForm()	JROOT/plugins/system/fields/fields.php:298
   18	PlgSystemFields->onContentPrepareForm()	Chiamata uguale alla linea sottostante.
   17	call_user_func_array()	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/libraries/src/MVC/Model/FormModel.php:242
   13	Joomla\CMS\MVC\Model\FormModel->loadForm()	JROOT/components/com_mailto/models/mailto.php:35
   12	MailtoModelMailto->getForm()	JROOT/libraries/src/MVC/View/HtmlView.php:425
   11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_mailto/views/mailto/view.html.php:30
   10	MailtoViewMailto->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
   9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_mailto/controller.php:29
   8	MailtoController->mailto()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
   7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_mailto/mailto.php:16
   6	require_once JROOT/components/com_mailto/mailto.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:196
   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.64 ms Dopo l'ultima query: 137.90 ms

   SELECT params 
     FROM knfcx_extensions AS e 
     WHERE e.element='com_widgetkit'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using where

   Profilo

   Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:278
   14	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
   13	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
   12	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
   11	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
   10	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
   9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
   8	plgSystemWidgetkit_System->onAfterDispatch()	Chiamata uguale alla linea sottostante.
   7	call_user_func_array()	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:196
   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.52 ms Dopo l'ultima query: 6.18 ms

    SELECT id,template 
      FROM knfcx_template_styles 
      WHERE client_id=0 
      AND home=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	knfcx_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	5	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/helpers/system.php:78
    10	SystemWidgetkitHelper->init()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
    9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
    8	plgSystemWidgetkit_System->onAfterDispatch()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:196
    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]

    ---

11. Tempo della query: 5.71 ms Dopo l'ultima query: 217.89 ms

    SELECT language,id
    
      FROM `knfcx_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	knfcx_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	42	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    8	PlgSystemLanguageFilter->onAfterDispatch()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:196
    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]

    ---

12. Tempo della query: 6.24 ms Dopo l'ultima query: 127.26 ms

    LOCK TABLES `knfcx_extensions` WRITE

    Explain

    EXPLAIN non possibile sulla query: LOCK TABLES `knfcx_extensions` WRITE

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:548
    9	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:78
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

13. Tempo della query: 1.41 ms Dopo l'ultima query: 0.27 ms

    UPDATE `knfcx_extensions`
    
      SET `params` = '{\"lastrun\":1741921100}'
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'system' 
      AND `element` = 'updatenotification'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `knfcx_extensions` SET `params` = '{\"lastrun\":1741921100}' WHERE `type` = 'plugin' AND `folder` = 'system' AND `element` = 'updatenotification'

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    9	JDatabaseDriverMysql->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:89
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

14. Tempo della query: 0.51 ms Dopo l'ultima query: 2.69 ms

    UNLOCK TABLES

    Explain

    EXPLAIN non possibile sulla query: UNLOCK TABLES

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:923
    9	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:103
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

15. Tempo della query: 1.62 ms Dopo l'ultima query: 10.69 ms

    SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query
    
      FROM `knfcx_update_sites` AS `a`
    
      INNER JOIN knfcx_update_sites_extensions AS b 
      ON a.update_site_id = b.update_site_id
    
      WHERE a.enabled = 1 
      AND b.extension_id IN (700)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	index	PRIMARY	PRIMARY	8	NULL	18	Using where; Using index; Using temporary
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	ef8434abb_c7a322.b.update_site_id	1	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
    11	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Updater/Updater.php:240
    10	Joomla\CMS\Updater\Updater->getUpdateSites()	JROOT/libraries/src/Updater/Updater.php:127
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

16. Tempo della query: 34.57 ms Dopo l'ultima query: 0.23 ms

    SELECT DISTINCT update_site_id
    
      FROM knfcx_updates
    
      WHERE `update_site_id` IN (
    SELECT update_site_id
    
      FROM knfcx_update_sites
    
      WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1741899500')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	knfcx_updates	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	15692	Using where; Using temporary
    2	DEPENDENT SUBQUERY	knfcx_update_sites	unique_subquery	PRIMARY	PRIMARY	4	func	1	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Updater/Updater.php:411
    10	Joomla\CMS\Updater\Updater->getSitesWithUpdates()	JROOT/libraries/src/Updater/Updater.php:140
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

17. Tempo della query: 0.52 ms Dopo l'ultima query: 10.64 ms

    SELECT `name`
    
      FROM `knfcx_update_sites`
    
      WHERE `update_site_id` = '10'

    Explain

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

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/libraries/src/Updater/UpdateAdapter.php:195
    13	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName()	JROOT/libraries/src/Updater/UpdateAdapter.php:222
    12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
    11	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

18. Tempo della query: 0.49 ms Dopo l'ultima query: 0.18 ms

    UPDATE `knfcx_update_sites`
    
      SET `enabled` = '0'
    
      WHERE `update_site_id` = '10'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `knfcx_update_sites` SET `enabled` = '0' WHERE `update_site_id` = '10'

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
    13	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:245
    12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
    11	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

19. Tempo della query: 0.64 ms Dopo l'ultima query: 85.82 ms

    UPDATE `knfcx_update_sites`
    
      SET `enabled` = '1'
    
      WHERE `update_site_id` = '10'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `knfcx_update_sites` SET `enabled` = '1' WHERE `update_site_id` = '10'

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
    13	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:265
    12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
    11	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

20. Tempo della query: 1.55 ms Dopo l'ultima query: 3.40 ms

    SHOW FULL COLUMNS 
      FROM `knfcx_updates`

    Explain

    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `knfcx_updates`

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    16	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Update.php:32
    15	Joomla\CMS\Table\Update->__construct()	JROOT/libraries/src/Table/Table.php:312
    14	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126
    13	Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement()	Chiamata uguale alla linea sottostante.
    12	xml_parse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243
    11	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

21. Tempo della query: 1.37 ms Dopo l'ultima query: 17.60 ms

    SHOW FULL COLUMNS 
      FROM `knfcx_extensions`

    Explain

    EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `knfcx_extensions`

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    15	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    14	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    13	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    12	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
    11	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Updater.php:322
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

22. Tempo della query: 14.41 ms Dopo l'ultima query: 0.49 ms

    SELECT `update_id`
    
      FROM `knfcx_updates`
    
      WHERE element = 'joomla' 
      AND type = 'file' 
      AND client_id = '0' 
      AND folder = ''

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	knfcx_updates	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	15692	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Update.php:114
    11	Joomla\CMS\Table\Update->find()	JROOT/libraries/src/Updater/Updater.php:332
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

23. Tempo della query: 0.73 ms Dopo l'ultima query: 0.35 ms

    SELECT `extension_id`
    
      FROM `knfcx_extensions`
    
      WHERE element = 'joomla' 
      AND type = 'file' 
      AND client_id = '0' 
      AND folder = ''

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	knfcx_extensions	ref	element_clientid,element_folder_clientid,extension	extension	667	const,const,const,const	1	Using where

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    11	Joomla\CMS\Table\Extension->find()	JROOT/libraries/src/Updater/Updater.php:342
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

24. Tempo della query: 0.46 ms Dopo l'ultima query: 0.29 ms

    SELECT *
    
      FROM knfcx_updates
    
      WHERE `update_id` = '101'

    Explain

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

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    11	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:367
    10	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

25. Tempo della query: 3.93 ms Dopo l'ultima query: 0.37 ms

    INSERT INTO `knfcx_updates`
    (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
      VALUES 
    ('10','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')

    Explain

    EXPLAIN non possibile sulla query: INSERT INTO `knfcx_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('10','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','','')

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1421
    11	JDatabaseDriver->insertObject()	JROOT/libraries/src/Table/Table.php:805
    10	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Updater/Updater.php:169
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

26. Tempo della query: 0.83 ms Dopo l'ultima query: 0.31 ms

    UPDATE `knfcx_update_sites`
    
      SET `last_check_timestamp` = '1741921100'
    
      WHERE `update_site_id` = '10'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `knfcx_update_sites` SET `last_check_timestamp` = '1741921100' WHERE `update_site_id` = '10'

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Updater/Updater.php:440
    10	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT/libraries/src/Updater/Updater.php:174
    9	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

27. Tempo della query: 6.19 ms Dopo l'ultima query: 6.17 ms

    SELECT u.*,`e`.`manifest_cache`
    
      FROM `knfcx_updates` AS `u`
    
      LEFT JOIN `knfcx_extensions` AS `e` 
      ON `e`.`extension_id` = `u`.`extension_id`
    
      WHERE `u`.`extension_id` != '0' 
      AND `u`.`extension_id` = '700'
    
      ORDER BY `u`.`name` asc 
      LIMIT 20

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	u	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	15692	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	ef8434abb_c7a322.u.extension_id	1

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    11	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_installer/models/update.php:217
    10	InstallerModelUpdate->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    9	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/plugins/system/updatenotification/updatenotification.php:136
    8	PlgSystemUpdatenotification->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

28. Tempo della query: 1.63 ms Dopo l'ultima query: 29.51 ms

    SELECT * 
      FROM knfcx_acymailing_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	knfcx_acymailing_config	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	93

    Profilo

    Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
    14	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
    12	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
    11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
    10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    8	plgSystemRegacymailing->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	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:1050
    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:202
    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]

    ---

28 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 1 × SELECT `update_id` 
     FROM `knfcx_updates`

2. 1 × SELECT `name` 
     FROM `knfcx_update_sites`

3. 1 × SELECT DISTINCT update_site_id 
     FROM knfcx_updates

4. 1 × SELECT `extension_id` 
     FROM `knfcx_extensions`

5. 1 × SELECT * 
     FROM knfcx_updates

6. 1 × SELECT * 
     FROM knfcx_acymailing_confi

7. 1 × SELECT u.*,`e`.`manifest_cache` 
     FROM `knfcx_updates` AS `u` 
     LEFT JOIN `knfcx_extensions` AS `e` 
     ON `e`.`extension_id` = `u`.`extension_id`

8. 1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
     FROM `knfcx_update_sites` AS `a` 
     INNER JOIN knfcx_update_sites_extensions AS b 
     ON a.update_site_id = b.update_site_id

9. 1 × SELECT language,id 
     FROM `knfcx_menu`

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

11. 1 × SELECT id, rules 
      FROM `knfcx_viewlevels

12. 1 × SELECT `session_id` 
      FROM `knfcx_session`

13. 1 × SELECT `lastupdate` 
      FROM `knfcx_ak_storage`

14. 1 × 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 knfcx_fields AS a 
      LEFT JOIN `knfcx_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN knfcx_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN knfcx_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN knfcx_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN knfcx_fields_groups AS g 
      ON g.id = a.group_id

15. 1 × SELECT id,template 
      FROM knfcx_template_styles

16. 1 × SELECT params 
      FROM knfcx_extensions AS e

17. 1 × SELECT `data` 
      FROM `knfcx_session`

ALTRE tabelle:

1. 1 × SHOW FULL COLUMNS 
     FROM `knfcx_updates

2. 1 × SHOW FULL COLUMNS 
     FROM `knfcx_extensions

3. 1 × INSERT INTO `knfcx_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
     VALUES  ('10','Joomla','','joomla','file','','0','3.10.12','','https://update.joomla.org/core/extension.xml','',''

4. 1 × UPDATE `knfcx_update_sites` 
     SET `last_check_timestamp` = '1741921100'

5. 1 × UPDATE `knfcx_update_sites` 
     SET `enabled` = '1'

6. 1 × UPDATE `knfcx_update_sites` 
     SET `enabled` = '0'

7. 1 × UPDATE `knfcx_extensions` 
     SET `params` = '{\"mediaversion\":\"56ac0aab4366e86e28c529c07e484caf\"}'

8. 1 × LOCK TABLES `knfcx_extensions` WRIT

9. 1 × UPDATE `knfcx_extensions` 
     SET `params` = '{\"lastrun\":1741921100}'

10. 1 × UNLOCK TABLE

11. 1 × INSERT INTO `knfcx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
      VALUES  ('6vi1n0i9eu1nksmehku5ag68a4', 1, 1741921098, 0, '', 0