{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1745539440,
                "last": 1745539440,
                "now": 1745539440
            },
            "token": "huCn7ZaCJ1vXQaOb5gM64P6l2hDOoD23"
        },
        "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

9 query eseguite 10.56 ms

1. Tempo della query: 0.99 ms Memoria query: 0.007 MB memoria prima della query: 2.679 MB

   UPDATE `l3yfr_extensions`
   
     SET `params` = '{\"mediaversion\":\"b23b7db41c324c4070335b127e89c65a\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   EXPLAIN non possibile sulla query: UPDATE `l3yfr_extensions` SET `params` = '{\"mediaversion\":\"b23b7db41c324c4070335b127e89c65a\"}' 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
   11	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   10	JFalangDatabase->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:1119
   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]

   ---

2. Tempo della query: 1.39 ms Dopo l'ultima query: 18.62 ms Memoria query: 0.025 MB memoria prima della query: 2.885 MB Righe restituite: 1

   SELECT language,id
   
     FROM `l3yfr_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	l3yfr_menu	ALL	idx_client_id_parent_id_alias_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	54	Using where

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   11	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   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: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]

   ---

3. Tempo della query: 1.00 ms Dopo l'ultima query: 1.77 ms Memoria query: 0.030 MB memoria prima della query: 2.903 MB Righe restituite: 10

   SELECT joomlatablename,tablepkID 
     FROM `l3yfr_falang_tableinfo`

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:144
   13	FalangManager->_loadPrimaryKeyData()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:57
   12	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
   11	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
   10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   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: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]

   ---

4. Tempo della query: 1.11 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.033 MB memoria prima della query: 2.916 MB Righe restituite: 3

   SELECT * 
     FROM l3yfr_languages 
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	l3yfr_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using filesort

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:319
   13	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
   12	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
   11	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
   10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   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: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: 2.01 ms Dopo l'ultima query: 0.62 ms Memoria query: 0.035 MB memoria prima della query: 2.939 MB Righe restituite: 14

   SHOW FULL COLUMNS 
     FROM `l3yfr_languages`

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   20	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   19	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   18	JFalangDatabase->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
   17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_falang/tables/JFLanguage.php:54
   14	TableJFLanguage->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:325
   13	FalangManager->getLanguages()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:63
   12	FalangManager->__construct()	JROOT/administrator/components/com_falang/classes/FalangManager.class.php:85
   11	FalangManager::getInstance()	JROOT/components/com_falang/helpers/falang.class.php:35
   10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   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: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: 1.28 ms Dopo l'ultima query: 2.11 ms Memoria query: 0.028 MB memoria prima della query: 2.986 MB Righe restituite: 0

   SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value 
   
     FROM l3yfr_falang_content AS falang_content
   
     WHERE falang_content.language_id=2
   	
     AND falang_content.published=1
      
     AND falang_content.reference_id IN(101)
      
     AND falang_content.reference_table='menu'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	falang_content	ref|filter	idxFalang1,falangContent,falangContentLanguage,reference_id,language_id,reference_table	reference_id|language_id	4|4	const	1 (0%)	Using where; Using rowid filter

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   15	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   14	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   13	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:277
   12	JFalangDatabase->loadObjectList()	JROOT/components/com_falang/helpers/falang.class.php:235
   11	Falang::translateListWithIDs()	JROOT/components/com_falang/helpers/falang.class.php:108
   10	Falang::translateList()	JROOT/plugins/system/falangdriver/falang_database.php:334
   9	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
   8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
   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: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: 1.15 ms Dopo l'ultima query: 2.89 ms Memoria query: 0.026 MB memoria prima della query: 3.071 MB Righe restituite: 0

   SELECT `c2`.`language`,`c2`.`id`
   
     FROM `l3yfr_menu` AS `c`
   
     INNER JOIN `l3yfr_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item'
   
     INNER JOIN `l3yfr_associations` AS `a2` 
     ON `a`.`key` = `a2`.`key`
   
     INNER JOIN `l3yfr_menu` AS `c2` 
     ON a2.id = c2.`id`
   
     WHERE c.id = 101

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   13	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   12	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   10	JFalangDatabase->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
   9	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
   8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:768
   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: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: 1.64 ms Dopo l'ultima query: 41.16 ms Memoria query: 0.045 MB memoria prima della query: 3.345 MB Righe restituite: 140

   SELECT * 
     FROM l3yfr_acymailing_config

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/falangdriver/falang_database.php:105
   16	JFalangDatabase->execute()	JROOT/libraries/joomla/database/driver.php:1695
   15	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/falangdriver/falang_database.php:282
   14	JFalangDatabase->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:464
   13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
   12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
   11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
   10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
   9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
   8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
   7	plgSystemRegacymailing->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: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]

   ---

8 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 1 × SELECT language,id 
     FROM `l3yfr_menu`

2. 1 × SELECT joomlatablename,tablepkID 
     FROM `l3yfr_falang_tableinfo

3. 1 × SELECT * 
     FROM l3yfr_languages

4. 1 × SELECT falang_content.reference_field, falang_content.value, falang_content.reference_id, falang_content.original_value  
     FROM l3yfr_falang_content AS falang_content

5. 1 × SELECT `c2`.`language`,`c2`.`id` 
     FROM `l3yfr_menu` AS `c` 
     INNER JOIN `l3yfr_associations` AS `a` 
     ON a.id = c.`id` 
     AND a.context='com_menus.item' 
     INNER JOIN `l3yfr_associations` AS `a2` 
     ON `a`.`key` = `a2`.`key` 
     INNER JOIN `l3yfr_menu` AS `c2` 
     ON a2.id = c2.`id`

6. 1 × SELECT * 
     FROM l3yfr_acymailing_confi

ALTRE tabelle:

1. 1 × UPDATE `l3yfr_extensions` 
     SET `params` = '{\"mediaversion\":\"b23b7db41c324c4070335b127e89c65a\"}'

2. 1 × SHOW FULL COLUMNS 
     FROM `l3yfr_languages