{
    "__default": {
        "session": {
            "counter": 5,
            "timer": {
                "start": 1784048947,
                "last": 1784048950,
                "now": 1784048950
            },
            "token": "GKLx9wTDIyaoRQcoN4o6jmcJZjqTCImM"
        },
        "registry": {
            "com_content": {
                "category": {
                    "list": {
                        "55:744": {
                            "limit": 100
                        }
                    }
                }
            },
            "com_mymaplocations": {
                "locations": {
                    "filter": {
                        "radius": "-1",
                        "category": "0",
                        "component": "com_mymaplocations"
                    },
                    "ordercol": "distance"
                }
            },
            "global": {
                "list": {
                    "limit": 0
                }
            }
        },
        "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

20 query eseguite 18.02 ms

1. Tempo della query: 0.46 ms Memoria query: 0.021 MB memoria prima della query: 3.545 MB Righe restituite: 1

   SELECT `data`
   
     FROM `zgs39_session`
   
     WHERE `session_id` = X'716838616a676f6e6773756f6a6131747570376f766665353366'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zgs39_session	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profilo

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.05 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->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:661
   9	Joomla\CMS\Session\Session->_start()	JROOT\libraries\src\Session\Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT\libraries\src\Session\Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT\libraries\src\Session\Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT\libraries\src\Application\CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT\libraries\src\Application\SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT\libraries\src\Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT\index.php:46

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

   ---

2. Tempo della query: 0.67 ms Dopo l'ultima query: 4.41 ms Memoria query: 0.038 MB memoria prima della query: 3.790 MB Righe restituite: 38

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `zgs39_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zgs39_extensions	ref	extension	extension	62	const	42	100.00	Using index condition; Using where

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.07 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.28 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Chiamata uguale alla linea sottostante.
   9	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Component\ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT\libraries\src\Component\ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT\libraries\src\Component\ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT\libraries\src\Application\SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

3. Tempo della query: 0.29 ms Dopo l'ultima query: 3.21 ms Memoria query: 0.020 MB memoria prima della query: 3.957 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `zgs39_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.03 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.05 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT\libraries\src\Access\Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT\libraries\src\User\User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT\libraries\src\Plugin\PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

4. Tempo della query: 0.21 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.020 MB memoria prima della query: 3.966 MB Righe restituite: 1

   SELECT b.id
   
     FROM zgs39_usergroups AS a
   
     LEFT JOIN zgs39_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	filtered	Extra
   1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1550
   10	JDatabaseDriver->loadColumn()	JROOT\libraries\src\Access\Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT\libraries\src\Access\Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT\libraries\src\User\User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT\libraries\src\Plugin\PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

5. Tempo della query: 0.74 ms Dopo l'ultima query: 0.87 ms Memoria query: 0.028 MB memoria prima della query: 4.026 MB Righe restituite: 101

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM zgs39_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1,1)
   
     ORDER BY ordering

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zgs39_extensions	ref	extension	extension	62	const	126	100.00	Using index condition; Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.00 ms
   Creating sort index	0.48 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Chiamata uguale alla linea sottostante.
   8	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Plugin\PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT\libraries\src\Plugin\PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT\libraries\src\Plugin\PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT\libraries\src\Application\SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

6. Tempo della query: 0.41 ms Dopo l'ultima query: 24.43 ms Memoria query: 0.021 MB memoria prima della query: 5.943 MB Righe restituite: 0

   SELECT `value`
   
     FROM `zgs39_admintools_storage`
   
     WHERE `key` = 'cparams'

   Explain

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

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.05 ms
   cleaning up	0.07 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT\administrator\components\com_admintools\Helper\Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT\administrator\components\com_admintools\Helper\Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT\administrator\components\com_admintools\Helper\Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT\plugins\system\admintools\admintools\main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT\plugins\system\admintools\admintools\main.php:892
   8	plgSystemAdmintools->initialize()	JROOT\plugins\system\admintools\admintools\main.php:84
   7	plgSystemAdmintools->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

7. Tempo della query: 0.53 ms Dopo l'ultima query: 2.19 ms Memoria query: 0.021 MB memoria prima della query: 6.051 MB Righe restituite: 2

   SELECT *
   
     FROM zgs39_languages
   
     WHERE published=1
   
     ORDER BY ordering ASC

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zgs39_languages	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	2	100.00	Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.02 ms
   Sorting result	0.00 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.14 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.06 ms

   Call Stack

   #	Caller	File e numero di linea
   13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
   12	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:150
   11	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT\plugins\system\admintools\admintools\main.php:700
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT\plugins\system\admintools\admintools\main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT\plugins\system\admintools\admintools\main.php:901
   8	plgSystemAdmintools->initialize()	JROOT\plugins\system\admintools\admintools\main.php:84
   7	plgSystemAdmintools->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

8. Tempo della query: 0.20 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.020 MB memoria prima della query: 6.058 MB Righe restituite: 0

   SELECT *
   
     FROM `zgs39_admintools_wafexceptions`
   
     WHERE NOT(`option` LIKE 'com_%')

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT\plugins\system\admintools\admintools\main.php:729
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT\plugins\system\admintools\admintools\main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT\plugins\system\admintools\admintools\main.php:901
   8	plgSystemAdmintools->initialize()	JROOT\plugins\system\admintools\admintools\main.php:84
   7	plgSystemAdmintools->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

9. Tempo della query: 0.39 ms Dopo l'ultima query: 10.43 ms Memoria query: 0.020 MB memoria prima della query: 6.710 MB Righe restituite: 4

   SELECT `element`,`name`,`client_id`,`extension_id`
   
     FROM `zgs39_extensions`
   
     WHERE `type` = 'language' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	zgs39_extensions	ref	extension	extension	62	const	4	100.00	Using index condition; Using where

   Profilo

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaning up	0.10 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:209
   8	Joomla\CMS\Language\LanguageHelper::getInstalledLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:110
   7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\src\Plugin\PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT\libraries\src\Plugin\PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT\libraries\src\Application\CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

   ---

10. Tempo della query: 0.37 ms Dopo l'ultima query: 10.36 ms Memoria query: 0.020 MB memoria prima della query: 6.973 MB Righe restituite: 0

    SELECT `source`,`keepurlparams`
    
      FROM `zgs39_admintools_redirects`
    
      WHERE ((`dest` = 'index.php/biglietti-e-abbonamenti/rivendite-autorizzate') OR (`dest` = 'index.php/biglietti-e-abbonamenti/rivendite-autorizzate') OR ('index.php/biglietti-e-abbonamenti/rivendite-autorizzate' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	zgs39_admintools_redirects	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.07 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.11 ms

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1773
    11	JDatabaseDriver->loadRow()	JROOT\plugins\system\admintools\feature\urlredir.php:91
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT\plugins\system\admintools\admintools\main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT\plugins\system\admintools\admintools\main.php:144
    8	plgSystemAdmintools->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

11. Tempo della query: 3.04 ms Dopo l'ultima query: 3.85 ms Memoria query: 0.468 MB memoria prima della query: 7.206 MB Righe restituite: 336

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM zgs39_menu AS m
    
      LEFT JOIN zgs39_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	406	91.87	Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	stpbrindisi_new.m.component_id	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.07 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	2.70 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    23	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Menu\SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
    20	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Menu\SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT\libraries\src\Menu\AbstractMenu.php:78
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:142
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:417
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Router\SiteRouter.php:65
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT\libraries\src\Router\Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:533
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\plugins\system\languagefilter\languagefilter.php:145
    8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT\libraries\joomla\event\event.php:70
    7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

12. Tempo della query: 0.38 ms Dopo l'ultima query: 12.31 ms Memoria query: 0.021 MB memoria prima della query: 8.854 MB Righe restituite: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `zgs39_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	zgs39_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using index condition

    Profilo

    Status	Duration
    starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
    12	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
    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:1137
    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:225
    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.44 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.004 MB memoria prima della query: 8.844 MB

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	zgs39_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.03 ms
    updating	0.05 ms
    end	0.00 ms
    query end	1.22 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	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:1137
    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:225
    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.42 ms Dopo l'ultima query: 2.07 ms Memoria query: 0.034 MB memoria prima della query: 9.069 MB Righe restituite: 2

    SELECT id, home, template, s.params
    
      FROM zgs39_template_styles as s
    
      LEFT JOIN zgs39_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	4	100.00	NULL
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	stpbrindisi_new.s.template,const	1	100.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.17 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    6	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\Application\SiteApplication.php:168
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

15. Tempo della query: 0.58 ms Dopo l'ultima query: 270.51 ms Memoria query: 0.022 MB memoria prima della query: 10.783 MB Righe restituite: 3

    SELECT a.id, a.title, a.level, a.language
    
      FROM zgs39_categories AS a
    
      WHERE a.parent_id > 0 
      AND extension = 'com_mymaplocations' 
      AND a.access IN (1,1) 
      AND a.published IN (1) 
      AND a.language IN ('*','it-IT') 
      AND a.access IN ('1','1')
    
      ORDER BY a.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	range	cat_idx,idx_access,idx_language	cat_idx	157	NULL	3	100.00	Using index condition; Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.09 ms
    preparing	0.02 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.11 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.09 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\html\category.php:115
    14	JHtmlCategory::options()	Chiamata uguale alla linea sottostante.
    13	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\components\com_mymaplocations\views\locations\view.html.php:231
    10	MyMaplocationsViewlocations->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_mymaplocations\controller.php:26
    8	MyMaplocationsController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_mymaplocations\mymaplocations.php:21
    6	require_once JROOT\components\com_mymaplocations\mymaplocations.php	JROOT\libraries\src\Component\ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

16. Tempo della query: 0.56 ms Dopo l'ultima query: 1.90 ms Memoria query: 0.026 MB memoria prima della query: 10.900 MB Righe restituite: 38

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `zgs39_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_admintools','com_ajax','com_associations','com_attachments','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_htprotect','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_multicats','com_mymaplocations','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_visforms','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	zgs39_assets	range	idx_asset_name	idx_asset_name	152	NULL	39	100.00	Using index condition

    Profilo

    Status	Duration
    starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.25 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.00 ms
    freeing items	0.04 ms
    cleaning up	0.12 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT\components\com_mymaplocations\helpers\mymaplocations.php:4833
    14	MyMaplocationsHelper::getAllowAdd()	JROOT\components\com_mymaplocations\views\locations\tmpl\default.php:20
    13	include JROOT\components\com_mymaplocations\views\locations\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_mymaplocations\views\locations\view.html.php:324
    10	MyMaplocationsViewlocations->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_mymaplocations\controller.php:26
    8	MyMaplocationsController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_mymaplocations\mymaplocations.php:21
    6	require_once JROOT\components\com_mymaplocations\mymaplocations.php	JROOT\libraries\src\Component\ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

17. Tempo della query: 4.98 ms Dopo l'ultima query: 7.09 ms Memoria query: 0.024 MB memoria prima della query: 11.204 MB Righe restituite: 0

    SELECT DISTINCT m.tag_id,`t`.*
    
      FROM `zgs39_contentitem_tag_map` AS m 
    
      INNER JOIN `zgs39_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_mymaplocations.location' 
      AND `t`.`published` = 1 
      AND t.access IN (1,1) 
      AND `language` IN ('it-IT', '*')
    
      ORDER BY t.title

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access,idx_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	62.50	Using where; Using temporary; Using filesort
    1	SIMPLE	m	ref	idx_tag_type	idx_tag_type	4	stpbrindisi_new.t.id	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    Creating tmp table	0.18 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	3.79 ms
    Creating sort index	0.08 ms
    end	0.00 ms
    removing tmp table	0.42 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT\components\com_mymaplocations\helpers\mymaplocations.php:2725
    18	MyMaplocationsHelper::getTag()	JROOT\components\com_mymaplocations\views\locations\tmpl\default_tag.php:12
    17	include JROOT\components\com_mymaplocations\views\locations\tmpl\default_tag.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
    16	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\components\com_mymaplocations\views\locations\tmpl\default_bootstrapform.php:346
    15	include JROOT\components\com_mymaplocations\views\locations\tmpl\default_bootstrapform.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\components\com_mymaplocations\views\locations\tmpl\default.php:68
    13	include JROOT\components\com_mymaplocations\views\locations\tmpl\default.php	JROOT\libraries\src\MVC\View\HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT\libraries\src\MVC\View\HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT\components\com_mymaplocations\views\locations\view.html.php:324
    10	MyMaplocationsViewlocations->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_mymaplocations\controller.php:26
    8	MyMaplocationsController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_mymaplocations\mymaplocations.php:21
    6	require_once JROOT\components\com_mymaplocations\mymaplocations.php	JROOT\libraries\src\Component\ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

18. Tempo della query: 0.72 ms Dopo l'ultima query: 24.37 ms Memoria query: 0.020 MB memoria prima della query: 11.205 MB Righe restituite: 3

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	zgs39_menu	ALL	idx_client_id_parent_id_alias_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	406	92.12	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.30 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    9	JDatabaseDriver->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:225
    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: 1.03 ms Dopo l'ultima query: 26.99 ms Memoria query: 0.025 MB memoria prima della query: 12.981 MB Righe restituite: 17

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM zgs39_modules AS m
    
      LEFT JOIN zgs39_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN zgs39_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 <= '2026-07-14 17:09:11') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-14 17:09:11') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 266 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	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds,idx_language	published	1	const	56	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	stpbrindisi_new.m.module,const	1	100.00	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	stpbrindisi_new.m.id	3	100.00	Using where; Using index

    Profilo

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.04 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.46 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.08 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    17	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:441
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:371
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:601
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\plugins\system\helix3\core\helix3.php:542
    10	Helix3::countModules()	JROOT\plugins\system\helix3\core\helix3.php:500
    9	Helix3::rowColumns()	JROOT\plugins\system\helix3\core\helix3.php:316
    8	Helix3::generatelayout()	JROOT\templates\shaper_helix3\index.php:178
    7	require JROOT\templates\shaper_helix3\index.php	JROOT\libraries\src\Document\HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT\libraries\src\Application\CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

20. Tempo della query: 0.60 ms Dopo l'ultima query: 34.21 ms Memoria query: 0.021 MB memoria prima della query: 13.384 MB Righe restituite: 2

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `zgs39_menu` AS `c`
    
      INNER JOIN `zgs39_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `zgs39_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `zgs39_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 266

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	a	const	PRIMARY,idx_key	PRIMARY	156	const,const	1	100.00	NULL
    1	SIMPLE	a2	ref	idx_key	idx_key	96	const	2	100.00	Using index
    1	SIMPLE	c2	eq_ref	PRIMARY	PRIMARY	4	stpbrindisi_new.a2.id	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.10 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\Associations.php:115
    13	Joomla\CMS\Language\Associations::getAssociations()	JROOT\administrator\components\com_menus\helpers\menus.php:321
    12	MenusHelper::getAssociations()	JROOT\modules\mod_languages\helper.php:58
    11	ModLanguagesHelper::getList()	JROOT\modules\mod_languages\mod_languages.php:17
    10	include JROOT\modules\mod_languages\mod_languages.php	JROOT\libraries\src\Helper\ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT\index.php:49

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

    ---

19 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
     FROM `zgs39_extensions`

2. 1 × SELECT `data`
    
     FROM `zgs39_session`

3. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
     FROM zgs39_modules AS m
    
     LEFT JOIN zgs39_modules_menu AS mm 
     ON mm.moduleid = m.id
    
     LEFT JOIN zgs39_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

4. 1 × SELECT language,id
    
     FROM `zgs39_menu`

5. 1 × SELECT DISTINCT m.tag_id,`t`.*
    
     FROM `zgs39_contentitem_tag_map` AS m 
    
     INNER JOIN `zgs39_tags` AS t  
     ON `m`.`tag_id` = `t`.`id`

6. 1 × SELECT `id`,`name`,`rules`,`parent_id`
    
     FROM `zgs39_assets`

7. 1 × SELECT a.id, a.title, a.level, a.language
    
     FROM zgs39_categories AS a

8. 1 × SELECT id, home, template, s.params
    
     FROM zgs39_template_styles as s
    
     LEFT JOIN zgs39_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

9. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
     FROM zgs39_menu AS m
    
     LEFT JOIN zgs39_extensions AS e 
     ON m.component_id = e.extension_id

10. 1 × SELECT `source`,`keepurlparams`
     
      FROM `zgs39_admintools_redirects`

11. 1 × SELECT `element`,`name`,`client_id`,`extension_id`
     
      FROM `zgs39_extensions`

12. 1 × SELECT *
     
      FROM `zgs39_admintools_wafexceptions`

13. 1 × SELECT *
     
      FROM zgs39_languages

14. 1 × SELECT `value`
     
      FROM `zgs39_admintools_storage`

15. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
     
      FROM zgs39_extensions

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

17. 1 × SELECT id, rules
     
      FROM `zgs39_viewlevels

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

ALTRE tabelle:

1. 1 × UPDATE `zgs39_extensions`
    
     SET `params` = '{\"mediaversion\":\"d80163b41c53f3b1ec2adb680aeafc69\"}'