{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1785273208,
                "last": 1785273208,
                "now": 1785273208
            },
            "token": "u06w9YEGjvGzKaHkNUOUNNHyGYpicimg"
        },
        "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

44 query eseguite 46.77 ms

1. Tempo della query: 0.79 ms Memoria query: 0.023 MB memoria prima della query: 1.041 MB Righe restituite: 0

   SELECT `data`
   
     FROM `gzx6k_session`
   
     WHERE `session_id` = X'3266303837313330333532356665653761383039373936393332313933343133'

   Explain

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

   Profilo

   Status	Duration
   starting	0.22 ms
   Executing hook on transaction	0.03 ms
   starting	0.05 ms
   checking permissions	0.04 ms
   Opening tables	0.06 ms
   init	0.02 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.07 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.02 ms
   closing tables	0.03 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.98 ms Dopo l'ultima query: 2.19 ms Memoria query: 0.020 MB memoria prima della query: 1.055 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `gzx6k_session`
   
     WHERE `session_id` = X'3266303837313330333532356665653761383039373936393332313933343133' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	gzx6k_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profilo

   Status	Duration
   starting	0.11 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.02 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Tempo della query: 4.89 ms Dopo l'ultima query: 0.07 ms Memoria query: 0.004 MB memoria prima della query: 1.060 MB

   INSERT INTO `gzx6k_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3266303837313330333532356665653761383039373936393332313933343133', 1, 1785273208, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `gzx6k_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3266303837313330333532356665653761383039373936393332313933343133', 1, 1785273208, 0, '', 0)

   Profilo

   Status	Duration
   starting	0.21 ms
   Executing hook on transaction	0.01 ms
   starting	0.03 ms
   checking permissions	0.03 ms
   Opening tables	0.06 ms
   init	0.02 ms
   System lock	0.02 ms
   update	0.12 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	4.17 ms
   closing tables	0.05 ms
   freeing items	1.03 ms
   cleaning up	0.08 ms

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Tempo della query: 1.04 ms Dopo l'ultima query: 3.85 ms Memoria query: 0.024 MB memoria prima della query: 1.092 MB Righe restituite: 39

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	gzx6k_extensions	NULL	ref	extension	extension	82	const	40	1.00	Using where

   Profilo

   Status	Duration
   starting	0.26 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.15 ms
   preparing	0.05 ms
   executing	0.21 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 ms
   freeing items	0.04 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]

   ---

5. Tempo della query: 0.37 ms Dopo l'ultima query: 2.89 ms Memoria query: 0.021 MB memoria prima della query: 1.123 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `gzx6k_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.08 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 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]

   ---

6. Tempo della query: 0.42 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.021 MB memoria prima della query: 1.135 MB Righe restituite: 1

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	1	100.00	Using where; Using index

   Profilo

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.09 ms
   preparing	0.03 ms
   executing	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.02 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]

   ---

7. Tempo della query: 0.78 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.030 MB memoria prima della query: 1.156 MB Righe restituite: 102

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM gzx6k_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	gzx6k_extensions	NULL	ref	extension	extension	82	const	122	0.41	Using where; Using filesort

   Profilo

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.03 ms
   executing	0.43 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 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]

   ---

8. Tempo della query: 0.72 ms Dopo l'ultima query: 13.95 ms Memoria query: 0.021 MB memoria prima della query: 1.570 MB Righe restituite: 2

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.17 ms
   Executing hook on transaction	0.02 ms
   starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.14 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.03 ms
   executing	0.08 ms
   end	0.02 ms
   query end	0.01 ms
   waiting for handler commit	0.01 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/joomla/database/driver.php:1701
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
   8	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/languagefilter/languagefilter.php:96
   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]

   ---

9. Tempo della query: 0.43 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.021 MB memoria prima della query: 1.579 MB Righe restituite: 4

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	gzx6k_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using where

   Profilo

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.01 ms
   starting	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.05 ms
   statistics	0.04 ms
   preparing	0.03 ms
   executing	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   waiting for handler commit	0.01 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/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.44 ms Dopo l'ultima query: 4.43 ms Memoria query: 0.021 MB memoria prima della query: 1.626 MB Righe restituite: 1
    Query duplicate: #21  #22

    SELECT `template`
    
      FROM `gzx6k_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:242
    9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:47
    8	plgSystemHelix3->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: 0.47 ms Dopo l'ultima query: 26.07 ms Memoria query: 0.025 MB memoria prima della query: 1.819 MB Righe restituite: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

    Profilo

    Status	Duration
    starting	0.10 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:23
    16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:240
    15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
    14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Chiamata uguale alla linea sottostante.
    13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
    12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
    11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:91
    10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:6
    9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:9
    8	plgSystemWidgetkit->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.75 ms Dopo l'ultima query: 5.53 ms Memoria query: 0.054 MB memoria prima della query: 1.864 MB Righe restituite: 31

    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 gzx6k_menu AS m
    
      LEFT JOIN gzx6k_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	116	6.90	Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	uaestwbm_dbo2.m.component_id	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.04 ms
    executing	0.30 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 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]

    ---

13. Tempo della query: 0.87 ms Dopo l'ultima query: 24.84 ms Memoria query: 0.038 MB memoria prima della query: 2.187 MB Righe restituite: 4

    SELECT id, home, template, s.params
    
      FROM gzx6k_template_styles as s
    
      LEFT JOIN gzx6k_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	uaestwbm_dbo2.e.element	1	66.67	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.26 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.12 ms
    preparing	0.04 ms
    executing	0.11 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    12	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/administrator/components/com_widgetkit/widgetkit.php:43
    11	plgSystemWidgetkit->{closure}()	Chiamata uguale alla linea sottostante.
    10	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:113
    9	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:132
    8	YOOtheme\Framework\Application->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/plugins/joomla/src/JoomlaPlugin.php:141
    7	YOOtheme\Framework\Joomla\JoomlaPlugin->init()	JROOT/libraries/joomla/event/dispatcher.php:165
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 0.64 ms Dopo l'ultima query: 7.45 ms Memoria query: 0.022 MB memoria prima della query: 2.268 MB Righe restituite: 1

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.07 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 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]

    ---

15. Tempo della query: 5.37 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.005 MB memoria prima della query: 2.258 MB

    UPDATE `gzx6k_extensions`
    
      SET `params` = '{\"mediaversion\":\"6862e8d6606ed033d5c82065df26e7dd\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `gzx6k_extensions` SET `params` = '{\"mediaversion\":\"6862e8d6606ed033d5c82065df26e7dd\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.06 ms
    updating	0.08 ms
    end	0.02 ms
    query end	0.03 ms
    waiting for handler commit	4.83 ms
    closing tables	0.11 ms
    freeing items	0.04 ms
    cleaning up	0.02 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]

    ---

16. Tempo della query: 0.99 ms Dopo l'ultima query: 26.84 ms Memoria query: 0.027 MB memoria prima della query: 2.453 MB Righe restituite: 39

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `gzx6k_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_icagenda','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_widgetkit','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_assets	NULL	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	206	19.42	Using where

    Profilo

    Status	Duration
    starting	0.19 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.31 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    12	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
    11	SppagebuilderModelPage->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_sppagebuilder/models/page.php:175
    9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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: 2.65 ms Dopo l'ultima query: 3.11 ms Memoria query: 0.028 MB memoria prima della query: 2.514 MB Righe restituite: 25

    SHOW FULL COLUMNS 
      FROM `gzx6k_sppagebuilder`

    Explain

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

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.07 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.80 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.05 ms
    Creating tmp table	0.08 ms
    executing	0.11 ms
    checking permissions	0.13 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.02 ms
    freeing items	0.06 ms
    cleaning up	0.05 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    12	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
    11	SppagebuilderTablePage->__construct()	JROOT/libraries/src/Table/Table.php:328
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
    9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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.54 ms Dopo l'ultima query: 2.07 ms Memoria query: 0.069 MB memoria prima della query: 2.553 MB Righe restituite: 1

    SELECT *
    
      FROM gzx6k_sppagebuilder
    
      WHERE `id` = '15'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_sppagebuilder	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.02 ms
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.08 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    10	Joomla\CMS\Table\Table->load()	JROOT/components/com_sppagebuilder/models/page.php:177
    9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

19. Tempo della query: 6.81 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.005 MB memoria prima della query: 2.583 MB

    UPDATE gzx6k_sppagebuilder
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '15'

    Explain

    EXPLAIN non possibile sulla query: UPDATE gzx6k_sppagebuilder SET `hits` = (`hits` + 1) WHERE `id` = '15'

    Profilo

    Status	Duration
    starting	0.27 ms
    Executing hook on transaction	0.03 ms
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.05 ms
    updating	0.12 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	5.86 ms
    closing tables	0.19 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
    10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
    9	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/controller.php:65
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

20. Tempo della query: 0.90 ms Dopo l'ultima query: 2.60 ms Memoria query: 0.070 MB memoria prima della query: 2.574 MB Righe restituite: 1

    SELECT a.*,l.title AS language_title,ua.name AS author_name
    
      FROM gzx6k_sppagebuilder as a
    
      LEFT JOIN `gzx6k_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN gzx6k_users AS ua 
      ON ua.id = a.created_by
    
      WHERE a.id = 15 
      AND a.published = 1 
      AND a.language in ('it-IT','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
    1	SIMPLE	l	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL
    1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    Opening tables	0.10 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.09 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.03 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
    12	SppagebuilderModelPage->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

21. Tempo della query: 0.59 ms Dopo l'ultima query: 3.08 ms Memoria query: 0.025 MB memoria prima della query: 2.688 MB Righe restituite: 1
    Query duplicate: #10  #22

    SELECT `template`
    
      FROM `gzx6k_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

    Profilo

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:643
    16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
    15	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:739
    14	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:14
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

22. Tempo della query: 0.79 ms Dopo l'ultima query: 37.53 ms Memoria query: 0.025 MB memoria prima della query: 2.943 MB Righe restituite: 1
    Query duplicate: #10  #21

    SELECT `template`
    
      FROM `gzx6k_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	4	16.67	Using where

    Profilo

    Status	Duration
    starting	0.23 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.03 ms
    executing	0.06 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
    16	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

23. Tempo della query: 0.75 ms Dopo l'ultima query: 13.46 ms Memoria query: 0.025 MB memoria prima della query: 3.074 MB Righe restituite: 0

    SELECT DISTINCT a.id, a.title, a.level, a.published, a.lft, a.parent_id
    
      FROM (
    SELECT id,title,level,published,parent_id,lft,rgt
    
      FROM gzx6k_tags
    
      WHERE `published` = '1') AS a
    
      LEFT JOIN `gzx6k_tags` AS b 
      ON a.lft > b.lft 
      AND a.rgt < b.rgt
    
      WHERE `a`.`level` != '0'
    
      ORDER BY a.lft ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_tags	NULL	ref	tag_idx	tag_idx	1	const	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	b	NULL	ALL	idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Range checked for each record (index map: 0x10); Distinct

    Profilo

    Status	Duration
    starting	0.16 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.07 ms
    Creating tmp table	0.05 ms
    executing	0.08 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:194
    17	SpPgaeBuilderBase::getArticleTags()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:163
    16	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

24. Tempo della query: 0.66 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.025 MB memoria prima della query: 3.081 MB Righe restituite: 0
    Query duplicate: #25  #26

    SELECT a.enabled
    
      FROM `gzx6k_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	241	10.00	Using where

    Profilo

    Status	Duration
    starting	0.13 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.21 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:172
    16	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

25. Tempo della query: 0.43 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.025 MB memoria prima della query: 3.096 MB Righe restituite: 0
    Query duplicate: #24  #26

    SELECT a.enabled
    
      FROM `gzx6k_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	241	10.00	Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.02 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.12 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles/admin.php:279
    16	require_once JROOT/components/com_sppagebuilder/addons/articles/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

26. Tempo della query: 0.45 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.025 MB memoria prima della query: 3.131 MB Righe restituite: 0
    Query duplicate: #24  #25

    SELECT a.enabled
    
      FROM `gzx6k_extensions` AS `a`
    
      WHERE `a`.`name` = 'com_k2'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	241	10.00	Using where

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.12 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:545
    17	SpPgaeBuilderBase::k2CatList()	JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php:138
    16	require_once JROOT/components/com_sppagebuilder/addons/articles_scroller/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

27. Tempo della query: 0.45 ms Dopo l'ultima query: 16.51 ms Memoria query: 0.025 MB memoria prima della query: 3.821 MB Righe restituite: 0

    SELECT a.enabled
    
      FROM `gzx6k_extensions` AS `a`
    
      WHERE (`a`.`element` = 'com_acymailing' OR `a`.`element` = 'com_acym')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	range	element_clientid,element_folder_clientid	element_clientid	402	NULL	2	100.00	Using index condition

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:470
    17	SpPgaeBuilderBase::acymailingList()	JROOT/components/com_sppagebuilder/addons/optin_form/admin.php:163
    16	require_once JROOT/components/com_sppagebuilder/addons/optin_form/admin.php	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:68
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:199
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

28. Tempo della query: 0.57 ms Dopo l'ultima query: 23.22 ms Memoria query: 0.025 MB memoria prima della query: 4.261 MB Righe restituite: 1

    SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
    
      FROM gzx6k_modules AS m
    
      WHERE m.published = 1 
      AND m.id = 119 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-28 21:13:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-28 21:13:28') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND m.language IN ('it-IT','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published,idx_language	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.12 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
    17	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

29. Tempo della query: 0.48 ms Dopo l'ultima query: 4.83 ms Memoria query: 0.026 MB memoria prima della query: 4.349 MB Righe restituite: 0

    SELECT next AS tNext, dates AS tDates, startdate AS tStartdate, enddate AS tEnddate,
    						weekdays AS tWeekdays, id AS tId, state AS tState, access AS tAccess
    
      FROM gzx6k_icagenda_events AS e
    
      WHERE e.state = 1 
      AND e.next < '2026-07-28 21:13:28' 
      AND e.next > (DATE(NOW() - INTERVAL 2 MONTH))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	idx_state	idx_state	1	const	2	25.00	Using where

    Profilo

    Status	Duration
    starting	0.09 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.05 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:1172
    19	icagendaEventsData::getNext()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:131
    18	include JROOT/modules/mod_iccalendar/mod_iccalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

30. Tempo della query: 0.33 ms Dopo l'ultima query: 0.66 ms Memoria query: 0.026 MB memoria prima della query: 4.359 MB Righe restituite: 2

    SELECT id AS nbevt
    
      FROM `gzx6k_icagenda_events` AS e
    
      WHERE e.state = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	e	NULL	ref	idx_state	idx_state	1	const	2	100.00	NULL

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    20	JDatabaseDriver->loadResult()	JROOT/modules/mod_iccalendar/helper.php:119
    19	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:175
    18	include JROOT/modules/mod_iccalendar/mod_iccalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

31. Tempo della query: 0.65 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.026 MB memoria prima della query: 4.371 MB Righe restituite: 0
    Query duplicate: #37

    SELECT m.title, m.published, m.id, m.params, m.language
    
      FROM gzx6k_menu AS m
    
      WHERE (m.link = 'index.php?option=com_icagenda&view=list') 
      AND (m.published = 1) 
      AND m.language in ('it-IT','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	116	0.86	Using where

    Profilo

    Status	Duration
    starting	0.06 ms
    Executing hook on transaction	0.02 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.22 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56
    20	icagendaMenus::iClistMenuItemsInfo()	JROOT/modules/mod_iccalendar/helper.php:154
    19	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:175
    18	include JROOT/modules/mod_iccalendar/mod_iccalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

32. Tempo della query: 1.73 ms Dopo l'ultima query: 0.48 ms Memoria query: 0.026 MB memoria prima della query: 4.391 MB Righe restituite: 0

    SELECT e.*,
    				e.place as place_name,
    				c.title as cat_title,
    				c.alias as cat_alias,
    				c.color as cat_color,
    				c.ordering as cat_order
    			,feat.count AS features,r.count AS reg_people, r.date AS reg_date
    
      FROM `gzx6k_icagenda_events` AS e
    
      LEFT JOIN `gzx6k_icagenda_category` AS c 
      ON `c`.`id` = `e`.`catid`
    
      LEFT JOIN (
    SELECT fx.event_id, COUNT(*) AS count
    
      FROM `gzx6k_icagenda_feature_xref` AS fx
    
      INNER JOIN `gzx6k_icagenda_feature` AS f 
      ON fx.feature_id=f.id 
      AND f.state=1 
      AND f.icon<>'-1'
    
      GROUP BY fx.event_id) AS feat 
      ON e.id=feat.event_id
    
      LEFT JOIN (
    SELECT r.eventid, sum(r.people) AS count, r.date AS date
    
      FROM `gzx6k_icagenda_registration` AS r
    
      WHERE r.state > 0
    
      GROUP BY r.eventid) AS r 
      ON e.id=r.eventid
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.approval = 0 
      AND e.next >= '2026-06-01' 
      AND e.access IN (1, 1) 
      AND e.language IN ('it-IT','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	c	NULL	system	PRIMARY,idx_state	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
    1	PRIMARY	e	NULL	ref	idx_state,idx_approval,idx_language,idx_catid	idx_state	1	const	2	25.00	Using where
    1	PRIMARY	<derived2>	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
    1	PRIMARY	<derived3>	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	Using where; Using join buffer (hash join)
    3	DERIVED	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table
    2	DERIVED	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

    Status	Duration
    starting	0.39 ms
    Executing hook on transaction	0.02 ms
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.01 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    executing	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.02 ms
    statistics	0.10 ms
    preparing	0.47 ms
    executing	0.07 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_iccalendar/helper.php:272
    19	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:175
    18	include JROOT/modules/mod_iccalendar/mod_iccalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

33. Tempo della query: 0.27 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.028 MB memoria prima della query: 4.409 MB Righe restituite: 0

    SELECT r.date AS date, r.period AS period, r.eventid AS eventid, r.people AS people
    
      FROM gzx6k_icagenda_registration AS r
    
      WHERE r.state = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	NULL	no matching row in const table

    Profilo

    Status	Duration
    starting	0.05 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    executing	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:1567
    20	icagendaEventsData::registeredList()	JROOT/modules/mod_iccalendar/helper.php:274
    19	modiCcalendarHelper->getStamp()	JROOT/modules/mod_iccalendar/mod_iccalendar.php:175
    18	include JROOT/modules/mod_iccalendar/mod_iccalendar.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

34. Tempo della query: 0.68 ms Dopo l'ultima query: 33.07 ms Memoria query: 0.025 MB memoria prima della query: 4.438 MB Righe restituite: 1

    SELECT m.id, m.title, m.module, m.position, m.ordering, m.content, m.showtitle, m.params
    
      FROM gzx6k_modules AS m
    
      WHERE m.published = 1 
      AND m.id = 120 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-07-28 21:13:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-28 21:13:28') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND m.language IN ('it-IT','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published,idx_language	PRIMARY	4	const	1	100.00	NULL

    Profilo

    Status	Duration
    starting	0.24 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/components/com_sppagebuilder/addons/module/site.php:99
    17	SppagebuilderAddonModule::getModules()	JROOT/components/com_sppagebuilder/addons/module/site.php:28
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

35. Tempo della query: 1.04 ms Dopo l'ultima query: 12.20 ms Memoria query: 0.029 MB memoria prima della query: 4.571 MB Righe restituite: 2
    Query duplicate: #38

    SELECT e.*
    
      FROM gzx6k_icagenda_events AS e
    
      LEFT JOIN gzx6k_icagenda_category AS c 
      ON c.id = e.catid
    
      LEFT JOIN gzx6k_icagenda_customfields_data AS cfd 
      ON cfd.parent_id = e.id
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.catid IN (1) 
      AND  TRUE  
      AND e.language IN ('it-IT','*') 
      AND e.access IN (1, 1) 
      AND e.approval <> 1
    
      GROUP BY e.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	system	PRIMARY,idx_state	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
    1	SIMPLE	cfd	NULL	system	idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	e	NULL	ref	PRIMARY,idx_state,idx_approval,idx_language,idx_catid	idx_state	1	const	2	28.12	Using where

    Profilo

    Status	Duration
    starting	0.31 ms
    Executing hook on transaction	0.02 ms
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.11 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.13 ms
    preparing	0.04 ms
    executing	0.08 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:259
    24	icagendaEventsData::getAllDates()	JROOT/components/com_icagenda/models/events.php:261
    23	iCagendaModelEvents->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:140
    22	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_icagenda/models/events.php:301
    20	iCagendaModelEvents->getItems()	JROOT/modules/mod_ic_event_list/helper.php:117
    19	modiCEventListHelper::getList()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:187
    18	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

36. Tempo della query: 0.01 ms Dopo l'ultima query: 1.92 ms Memoria query: 0.011 MB memoria prima della query: 4.579 MB
    Explain

    EXPLAIN non possibile sulla query:

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.01 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.09 ms
    executing	0.17 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    21	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_icagenda/models/events.php:301
    20	iCagendaModelEvents->getItems()	JROOT/modules/mod_ic_event_list/helper.php:117
    19	modiCEventListHelper::getList()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:187
    18	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

37. Tempo della query: 0.68 ms Dopo l'ultima query: 0.90 ms Memoria query: 0.026 MB memoria prima della query: 4.591 MB Righe restituite: 0
    Query duplicate: #31

    SELECT m.title, m.published, m.id, m.params, m.language
    
      FROM gzx6k_menu AS m
    
      WHERE (m.link = 'index.php?option=com_icagenda&view=list') 
      AND (m.published = 1) 
      AND m.language in ('it-IT','*')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	idx_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	116	0.86	Using where

    Profilo

    Status	Duration
    starting	0.07 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.08 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.05 ms
    executing	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/menus/menus.php:56
    19	icagendaMenus::iClistMenuItemsInfo()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:192
    18	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

38. Tempo della query: 0.63 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.028 MB memoria prima della query: 4.605 MB Righe restituite: 2
    Query duplicate: #35

    SELECT e.*
    
      FROM gzx6k_icagenda_events AS e
    
      LEFT JOIN gzx6k_icagenda_category AS c 
      ON c.id = e.catid
    
      LEFT JOIN gzx6k_icagenda_customfields_data AS cfd 
      ON cfd.parent_id = e.id
    
      WHERE c.state = 1 
      AND e.state = 1 
      AND e.catid IN (1) 
      AND  TRUE  
      AND e.language IN ('it-IT','*') 
      AND e.access IN (1, 1) 
      AND e.approval <> 1
    
      GROUP BY e.id

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	system	PRIMARY,idx_state	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	100.00	NULL
    1	SIMPLE	cfd	NULL	system	idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	0.00	const row not found
    1	SIMPLE	e	NULL	ref	PRIMARY,idx_state,idx_approval,idx_language,idx_catid	idx_state	1	const	2	28.12	Using where

    Profilo

    Status	Duration
    starting	0.17 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    init	0.01 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.23 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_icagenda/utilities/events/data.php:259
    19	icagendaEventsData::getAllDates()	JROOT/modules/mod_ic_event_list/mod_ic_event_list.php:275
    18	include JROOT/modules/mod_ic_event_list/mod_ic_event_list.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    17	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/components/com_sppagebuilder/addons/module/site.php:48
    16	SppagebuilderAddonModule->render()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:440
    15	AddonParser::getAddonHtmlView()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:292
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:95
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

39. Tempo della query: 0.83 ms Dopo l'ultima query: 30.15 ms Memoria query: 0.027 MB memoria prima della query: 4.593 MB Righe restituite: 25

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `gzx6k_assets`
    
      WHERE `name` LIKE 'com_sppagebuilder.%' OR `name` = 'com_sppagebuilder' OR `parent_id` = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_assets	NULL	ALL	idx_asset_name,idx_parent_id	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	206	24.00	Using where

    Profilo

    Status	Duration
    starting	0.04 ms
    Executing hook on transaction	0.01 ms
    starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.26 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 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/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:97
    13	include JROOT/components/com_sppagebuilder/views/page/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_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_sppagebuilder/controller.php:68
    8	SppagebuilderController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:24
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.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]

    ---

40. Tempo della query: 0.61 ms Dopo l'ultima query: 0.36 ms Memoria query: 0.021 MB memoria prima della query: 4.467 MB Righe restituite: 3

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	81	1.00	Using where

    Profilo

    Status	Duration
    starting	0.26 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.05 ms
    executing	0.50 ms
    end	0.03 ms
    query end	0.01 ms
    waiting for handler commit	0.02 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    cleaning up	0.02 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]

    ---

41. Tempo della query: 1.41 ms Dopo l'ultima query: 29.97 ms Memoria query: 0.026 MB memoria prima della query: 4.637 MB Righe restituite: 11

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM gzx6k_modules AS m
    
      LEFT JOIN gzx6k_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN gzx6k_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-28 21:13:28') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-07-28 21:13:28') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 559 OR mm.menuid <= 0) 
      AND m.language IN ('it-IT','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	ALL	PRIMARY,published,newsfeeds,idx_language	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	50	2.00	Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	uaestwbm_dbo2.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	uaestwbm_dbo2.m.id	1	40.00	Using where; Using index

    Profilo

    Status	Duration
    starting	0.23 ms
    Executing hook on transaction	0.03 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    init	0.02 ms
    System lock	0.02 ms
    optimizing	0.03 ms
    statistics	0.14 ms
    preparing	0.03 ms
    executing	0.04 ms
    end	0.02 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    cleaning up	0.01 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:140
    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]

    ---

42. Tempo della query: 0.86 ms Dopo l'ultima query: 39.26 ms Memoria query: 0.023 MB memoria prima della query: 4.727 MB Righe restituite: 2

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `gzx6k_menu` AS `c`
    
      INNER JOIN `gzx6k_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `gzx6k_associations` AS `a2` 
      ON `a`.`key` = `a2`.`key`
    
      INNER JOIN `gzx6k_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 559

    Explain

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

    Profilo

    Status	Duration
    starting	0.15 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 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]

    ---

43. Tempo della query: 0.55 ms Dopo l'ultima query: 21.18 ms Memoria query: 0.021 MB memoria prima della query: 4.872 MB Righe restituite: 1

    SELECT manifest_cache
    
      FROM gzx6k_extensions
    
      WHERE type='component' 
      AND element='com_baforms'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    Executing hook on transaction	0.02 ms
    starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    waiting for handler commit	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:668
    10	baformsHelper::aboutUs()	JROOT/components/com_baforms/helpers/baforms.php:566
    9	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:56
    8	plgSystemBaforms->setForms()	JROOT/plugins/system/baforms/baforms.php:35
    7	plgSystemBaforms->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Tempo della query: 0.50 ms Dopo l'ultima query: 0.50 ms Memoria query: 0.021 MB memoria prima della query: 4.879 MB Righe restituite: 1

    SELECT `key`
    
      FROM gzx6k_baforms_api
    
      WHERE service = 'balbooa_activation'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	gzx6k_baforms_api	NULL	ALL	NULL	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	25	10.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:653
    10	baformsHelper::checkFormsActivation()	JROOT/components/com_baforms/helpers/baforms.php:567
    9	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:56
    8	plgSystemBaforms->setForms()	JROOT/plugins/system/baforms/baforms.php:35
    7	plgSystemBaforms->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---