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

46 query eseguite 429.74 ms

1. Tempo della query: 6.37 ms Memoria query: 0.021 MB memoria prima della query: 1.616 MB Righe restituite: 0

   SELECT `data`
   
     FROM `kfsn9_session`
   
     WHERE `session_id` = 'dopdraq01n7k7d2h29su7mppt2'

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:765
   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:351
   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: 6.81 ms Dopo l'ultima query: 5.68 ms Memoria query: 0.013 MB memoria prima della query: 1.673 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `kfsn9_session`
   
     WHERE `session_id` = 'dopdraq01n7k7d2h29su7mppt2' 
     LIMIT 1

   Explain

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

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   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:767
   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:351
   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: 6.91 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.010 MB memoria prima della query: 1.689 MB

   INSERT INTO `kfsn9_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('dopdraq01n7k7d2h29su7mppt2', 1, 1734857251, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `kfsn9_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('dopdraq01n7k7d2h29su7mppt2', 1, 1734857251, 0, '', 0)

   Profilo

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.09 ms
   Waiting for query cache lock	0.03 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.06 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.01 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:767
   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:351
   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: 21.91 ms Dopo l'ultima query: 10.38 ms Memoria query: 0.029 MB memoria prima della query: 1.763 MB Righe restituite: 39

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kfsn9_extensions	ref	extension	extension	82	const	39	100.00	Using index condition; Using where

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   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:203
   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: 8.46 ms Dopo l'ultima query: 17.78 ms Memoria query: 0.015 MB memoria prima della query: 1.871 MB Righe restituite: 5

   SELECT id, rules
   
     FROM `kfsn9_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 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.01 ms
   executing	0.00 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   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: 8.69 ms Dopo l'ultima query: 0.97 ms Memoria query: 0.016 MB memoria prima della query: 1.896 MB Righe restituite: 1

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.05 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.07 ms
   preparing	0.03 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.03 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
   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: 12.47 ms Dopo l'ultima query: 3.54 ms Memoria query: 0.020 MB memoria prima della query: 1.935 MB Righe restituite: 105

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kfsn9_extensions	ref	extension	extension	82	const	134	100.00	Using index condition; Using where; Using filesort

   Profilo

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

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
   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:359
   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:203
   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: 7.00 ms Dopo l'ultima query: 122.69 ms Memoria query: 0.019 MB memoria prima della query: 2.669 MB Righe restituite: 1
   Query duplicate: #9

   SELECT template
   
     FROM kfsn9_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Explain

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

   Profilo

   Status	Duration
   starting	0.04 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.01 ms
   executing	0.01 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.02 ms
   freeing items	0.05 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:632
   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:203
   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: 7.42 ms Dopo l'ultima query: 0.65 ms Memoria query: 0.021 MB memoria prima della query: 2.688 MB Righe restituite: 1
   Query duplicate: #8

   SELECT template
   
     FROM kfsn9_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Explain

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

   Profilo

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	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
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   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:632
   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:203
   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: 7.32 ms Dopo l'ultima query: 18.31 ms Memoria query: 0.015 MB memoria prima della query: 2.751 MB Righe restituite: 2

    SELECT extension, file, type
    
      FROM kfsn9_rokcommon_configs
    
      ORDER BY priority

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	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
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    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:632
    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:203
    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: 6.89 ms Dopo l'ultima query: 66.71 ms Memoria query: 0.018 MB memoria prima della query: 2.936 MB Righe restituite: 2

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

    Explain

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

    Profilo

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

    Call Stack

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

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

    ---

12. Tempo della query: 6.89 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.015 MB memoria prima della query: 2.958 MB Righe restituite: 4

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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:283
    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:632
    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:203
    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: 6.52 ms Dopo l'ultima query: 63.29 ms Memoria query: 0.028 MB memoria prima della query: 3.159 MB Righe restituite: 1

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

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    21	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    20	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Chiamata uguale alla linea sottostante.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    17	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    16	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    15	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
    11	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
    10	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
    9	plgSystemHelix->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 6.17 ms Dopo l'ultima query: 0.64 ms Memoria query: 0.022 MB memoria prima della query: 3.168 MB

    UPDATE `kfsn9_extensions`
    
      SET `params` = '{\"mediaversion\":\"4e432bba50b73aec0af2437f2453acce\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profilo

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.10 ms
    updating	0.07 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.02 ms
    query end	0.07 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    16	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    15	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    14	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    13	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    12	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/helix/core/helix.php:50
    11	Helix::getDocument()	JROOT/plugins/system/helix/core/helix.php:36
    10	Helix::getInstance()	JROOT/plugins/system/helix/helix.php:21
    9	plgSystemHelix->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 29.95 ms Dopo l'ultima query: 57.45 ms Memoria query: 0.041 MB memoria prima della query: 3.298 MB Righe restituite: 32

    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 kfsn9_menu AS m
    
      LEFT JOIN kfsn9_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	40	100.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.m.component_id	1	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    24	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Chiamata uguale alla linea sottostante.
    23	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    22	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    21	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    20	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    19	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    18	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:382
    17	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    16	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:434
    15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    9	plgSystemHelix->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 12.15 ms Dopo l'ultima query: 6.47 ms Memoria query: 0.023 MB memoria prima della query: 3.505 MB Righe restituite: 4

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	ALL	idx_template	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	100.00	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Sql941215_1.s.template,const	1	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    15	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helix/core/helix.php:65
    14	Helix::themeName()	JROOT/plugins/system/helix/core/helix.php:114
    13	Helix::themePath()	JROOT/plugins/system/helix/core/helix.php:302
    12	Helix::_Import()	JROOT/plugins/system/helix/core/helix.php:290
    11	Helix::Import()	JROOT/plugins/system/helix/core/helix.php:1592
    10	Helix::loadHelixOverwrite()	JROOT/plugins/system/helix/helix.php:22
    9	plgSystemHelix->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 8.83 ms Dopo l'ultima query: 85.15 ms Memoria query: 0.024 MB memoria prima della query: 4.028 MB Righe restituite: 18

    SHOW FULL COLUMNS 
      FROM `kfsn9_extensions`

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:46
    9	plgSystemRokSprocket->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 6.89 ms Dopo l'ultima query: 5.67 ms Memoria query: 0.016 MB memoria prima della query: 4.100 MB Righe restituite: 1

    SELECT `extension_id`
    
      FROM `kfsn9_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:50
    9	plgSystemRokSprocket->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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.59 ms Dopo l'ultima query: 1.21 ms Memoria query: 0.020 MB memoria prima della query: 4.118 MB Righe restituite: 1
    Query duplicate: #21

    SELECT *
    
      FROM kfsn9_extensions
    
      WHERE `extension_id` = '10026'

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:55
    9	plgSystemRokSprocket->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 6.78 ms Dopo l'ultima query: 1.12 ms Memoria query: 0.016 MB memoria prima della query: 4.132 MB Righe restituite: 1

    SELECT `extension_id`
    
      FROM `kfsn9_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:73
    9	plgSystemRokSprocket->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 7.06 ms Dopo l'ultima query: 0.82 ms Memoria query: 0.020 MB memoria prima della query: 4.149 MB Righe restituite: 1
    Query duplicate: #19

    SELECT *
    
      FROM kfsn9_extensions
    
      WHERE `extension_id` = '10026'

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:77
    9	plgSystemRokSprocket->onAfterInitialise()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:633
    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:203
    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: 8.74 ms Dopo l'ultima query: 874.14 ms Memoria query: 0.020 MB memoria prima della query: 5.076 MB Righe restituite: 39

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `kfsn9_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_joomlaupdate','com_k2','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_roksprocket','com_search','com_tags','com_templates','com_uniterevolution2','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_assets	ALL	idx_asset_name	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	243	16.46	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    11	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    10	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    9	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    8	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    7	Joomla\CMS\User\User->authorise()	JROOT/components/com_k2/k2.php:16
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 5.73 ms Dopo l'ultima query: 23.17 ms Memoria query: 0.020 MB memoria prima della query: 5.333 MB Righe restituite: 29

    SELECT id 
      FROM kfsn9_k2_categories 
      WHERE published=1 
      AND trash=0 
      AND access IN(1,1)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_k2_categories	range	category,published,access,trash	category	8	NULL	29	100.00	Using where; Using index

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    13	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/helpers/permissions.php:261
    12	K2HelperPermissions::canAddItem()	JROOT/components/com_k2/views/itemlist/view.html.php:29
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.83 ms Dopo l'ultima query: 3.15 ms Memoria query: 0.027 MB memoria prima della query: 5.402 MB Righe restituite: 14

    SHOW FULL COLUMNS 
      FROM `kfsn9_k2_categories`

    Explain

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

    Profilo

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.53 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.06 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.03 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.00 ms
    removing tmp table	0.43 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    15	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    14	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_k2/tables/k2category.php:34
    13	TableK2Category->__construct()	JROOT/libraries/src/Table/Table.php:312
    12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_k2/views/itemlist/view.html.php:41
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.16 ms Dopo l'ultima query: 1.01 ms Memoria query: 0.023 MB memoria prima della query: 5.450 MB Righe restituite: 1

    SELECT * 
      FROM kfsn9_k2_categories 
      WHERE id = '4'

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    13	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_k2/tables/k2category.php:65
    12	TableK2Category->load()	JROOT/components/com_k2/views/itemlist/view.html.php:42
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 8.26 ms Dopo l'ultima query: 9.38 ms Memoria query: 0.023 MB memoria prima della query: 5.530 MB Righe restituite: 27

    SELECT id, name,  parent	
      FROM kfsn9_k2_categories 
      WHERE published=1  
      AND trash=0 
      AND access IN(1,1) 
      AND language IN('it-IT', '*') 
      ORDER BY parent

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_k2_categories	ref	category,published,access,trash,language	category	2	const	29	100.00	Using index condition; Using where; Using filesort

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:1239
    14	K2ModelItemlist->getCategoriesTree()	JROOT/components/com_k2/helpers/route.php:321
    13	K2HelperRoute::_findItem()	JROOT/components/com_k2/helpers/route.php:58
    12	K2HelperRoute::getCategoryRoute()	JROOT/components/com_k2/views/itemlist/view.html.php:122
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 8.48 ms Dopo l'ultima query: 58.39 ms Memoria query: 0.033 MB memoria prima della query: 5.743 MB Righe restituite: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM kfsn9_fields AS a
    
      LEFT JOIN `kfsn9_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN kfsn9_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN kfsn9_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN kfsn9_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN kfsn9_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'com_k2.category' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	Sql941215_1.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.group_id	1	100.00	Using where

    Profilo

    Status	Duration
    starting	0.16 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.05 ms
    init	0.08 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.17 ms
    preparing	0.05 ms
    Creating tmp table	0.11 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.61 ms
    Creating sort index	0.03 ms
    end	0.00 ms
    removing tmp table	0.24 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    18	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    17	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    16	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    15	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    12	JEventDispatcher->trigger()	JROOT/components/com_k2/views/itemlist/view.html.php:138
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.71 ms Dopo l'ultima query: 8.19 ms Memoria query: 0.023 MB memoria prima della query: 5.853 MB Righe restituite: 1

    SELECT * 
      FROM kfsn9_k2_categories 
      WHERE parent=4 
      AND published=1 
      AND trash=0 
      AND access IN(1,1)  
      AND language IN('it-IT', '*') 
      ORDER BY  id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_k2_categories	ref	category,parent,published,access,trash,language	parent	5	const	2	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:748
    12	K2ModelItemlist->getCategoryFirstChildren()	JROOT/components/com_k2/views/itemlist/view.html.php:173
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.06 ms Dopo l'ultima query: 4.90 ms Memoria query: 0.021 MB memoria prima della query: 5.920 MB Righe restituite: 1

    SELECT id
    						
      FROM kfsn9_k2_categories 
    						
      WHERE parent IN (4) 
    						
      AND id NOT IN (4) 
    								
      AND published=1 
    								
      AND trash=0 
      AND access IN(1,1) 
      AND language IN('it-IT', '*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_k2_categories	range	PRIMARY,category,parent,published,access,trash,language	parent	9	NULL	3	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:642
    13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:122
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:376
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 5.79 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.020 MB memoria prima della query: 5.940 MB Righe restituite: 0

    SELECT id
    						
      FROM kfsn9_k2_categories 
    						
      WHERE parent IN (38) 
    						
      AND id NOT IN (38) 
    								
      AND published=1 
    								
      AND trash=0 
      AND access IN(1,1) 
      AND language IN('it-IT', '*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_k2_categories	range	PRIMARY,category,parent,published,access,trash,language	parent	9	NULL	2	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    14	JDatabaseDriver->loadColumn()	JROOT/components/com_k2/models/itemlist.php:642
    13	K2ModelItemlist->getCategoryTree()	JROOT/components/com_k2/models/itemlist.php:122
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:376
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 26.75 ms Dopo l'ultima query: 0.63 ms Memoria query: 0.029 MB memoria prima della query: 5.960 MB Righe restituite: 3

    SELECT i.*, c.name as categoryname,c.id as categoryid, c.alias as categoryalias, c.params as categoryparams 
      FROM kfsn9_k2_items as i RIGHT JOIN kfsn9_k2_categories AS c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1) 
      AND c.trash = 0 
      AND c.language IN ('it-IT','*') 
    						
      AND i.language IN ('it-IT','*') 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-12-22 08:47:33' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-12-22 08:47:33' ) 
      AND c.id IN (4,38) 
      ORDER BY i.id DESC 
      LIMIT 16, 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	range	PRIMARY,category,published,access,trash,language	PRIMARY	4	NULL	2	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	i	ref	item,catid,language	catid	4	Sql941215_1.c.id	9	100.00	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.08 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.06 ms
    System lock	0.00 ms
    optimizing	0.02 ms
    statistics	0.19 ms
    preparing	0.03 ms
    Creating tmp table	0.09 ms
    Sorting result	0.00 ms
    executing	0.00 ms
    Sending data	1.03 ms
    Creating sort index	0.29 ms
    end	0.00 ms
    removing tmp table	0.87 ms
    end	0.01 ms
    query end	0.00 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/itemlist.php:357
    12	K2ModelItemlist->getData()	JROOT/components/com_k2/views/itemlist/view.html.php:376
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.26 ms Dopo l'ultima query: 4.84 ms Memoria query: 0.019 MB memoria prima della query: 6.037 MB Righe restituite: 1

    SELECT COUNT(*) 
      FROM kfsn9_k2_items as i RIGHT JOIN kfsn9_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published = 1 
      AND i.access IN(1,1) 
      AND i.trash = 0 
      AND c.published = 1 
      AND c.access IN(1,1) 
      AND c.trash = 0 
      AND c.language IN ('it-IT','*') 
    						
      AND i.language IN ('it-IT','*') 
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-12-22 08:47:33' ) 
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-12-22 08:47:33' ) 
      AND c.id IN (4,38)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	range	PRIMARY,category,published,access,trash,language	PRIMARY	4	NULL	2	100.00	Using where
    1	SIMPLE	i	ref	item,catid,language	catid	4	Sql941215_1.c.id	9	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    13	JDatabaseDriver->loadResult()	JROOT/components/com_k2/models/itemlist.php:592
    12	K2ModelItemlist->getTotal()	JROOT/components/com_k2/views/itemlist/view.html.php:385
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.63 ms Dopo l'ultima query: 18.44 ms Memoria query: 0.024 MB memoria prima della query: 6.162 MB Righe restituite: 0

    SELECT tag.*
    		
      FROM kfsn9_k2_tags AS tag
    		JOIN kfsn9_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
    		
      WHERE tag.published=1
    		
      AND xref.itemID = 28 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	Sql941215_1.xref.tagID	1	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 8.74 ms Dopo l'ultima query: 30.26 ms Memoria query: 0.037 MB memoria prima della query: 6.212 MB Righe restituite: 16

    SHOW FULL COLUMNS 
      FROM `kfsn9_users`

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:41
    22	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
    21	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
    20	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:877
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:247
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 6.60 ms Dopo l'ultima query: 1.14 ms Memoria query: 0.032 MB memoria prima della query: 6.282 MB Righe restituite: 1

    SELECT *
    
      FROM `kfsn9_users`
    
      WHERE `id` = 518

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
    21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:87
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:247
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.80 ms Dopo l'ultima query: 10.09 ms Memoria query: 0.028 MB memoria prima della query: 7.046 MB Righe restituite: 1

    SELECT `g`.`id`,`g`.`title`
    
      FROM `kfsn9_usergroups` AS g
    
      INNER JOIN `kfsn9_user_usergroup_map` AS m 
      ON m.group_id = g.id
    
      WHERE `m`.`user_id` = 518

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.m.group_id	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
    21	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:112
    20	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:880
    19	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
    18	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
    17	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
    16	Joomla\CMS\Factory::getUser()	JROOT/components/com_k2/models/item.php:247
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 7.13 ms Dopo l'ultima query: 4.81 ms Memoria query: 0.025 MB memoria prima della query: 7.069 MB Righe restituite: 1

    SELECT id, gender, description, image, url, `
      group`, plugins 
      FROM kfsn9_k2_users 
      WHERE userID=518

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_k2_users	ref	userID	userID	4	const	1	100.00	NULL

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    17	JDatabaseDriver->loadObject()	JROOT/components/com_k2/models/item.php:1811
    16	K2ModelItem->getUserProfile()	JROOT/components/com_k2/models/item.php:250
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 10.29 ms Dopo l'ultima query: 49.30 ms Memoria query: 0.035 MB memoria prima della query: 7.183 MB Righe restituite: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM kfsn9_fields AS a
    
      LEFT JOIN `kfsn9_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN kfsn9_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN kfsn9_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN kfsn9_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN kfsn9_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `kfsn9_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_k2.itemlist' 
      AND (fc.category_id IS NULL OR fc.category_id IN (4,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','it-IT')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	Sql941215_1.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	Sql941215_1.a.id	1	100.00	Using where; Using index; Distinct

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    20	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    19	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    17	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    16	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
    15	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    13	JEventDispatcher->trigger()	JROOT/components/com_k2/models/item.php:714
    12	K2ModelItem->execPlugins()	JROOT/components/com_k2/views/itemlist/view.html.php:444
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 6.46 ms Dopo l'ultima query: 7.87 ms Memoria query: 0.024 MB memoria prima della query: 7.324 MB Righe restituite: 0

    SELECT tag.*
    		
      FROM kfsn9_k2_tags AS tag
    		JOIN kfsn9_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
    		
      WHERE tag.published=1
    		
      AND xref.itemID = 27 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	Sql941215_1.xref.tagID	1	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 6.08 ms Dopo l'ultima query: 24.77 ms Memoria query: 0.024 MB memoria prima della query: 7.479 MB Righe restituite: 0

    SELECT tag.*
    		
      FROM kfsn9_k2_tags AS tag
    		JOIN kfsn9_k2_tags_xref AS xref 
      ON tag.id = xref.tagID
    		
      WHERE tag.published=1
    		
      AND xref.itemID = 26 
      ORDER BY xref.id ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	xref	ref	tagID,itemID	itemID	4	const	1	100.00	Using where
    1	SIMPLE	tag	eq_ref	PRIMARY,published	PRIMARY	4	Sql941215_1.xref.tagID	1	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/components/com_k2/models/item.php:1353
    16	K2ModelItem->getItemTags()	JROOT/components/com_k2/models/item.php:109
    15	K2ModelItem->prepareItem()	Chiamata uguale alla linea sottostante.
    14	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    13	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Cache/Controller/CallbackController.php:45
    12	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/components/com_k2/views/itemlist/view.html.php:435
    11	K2ViewItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    10	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_k2/controllers/controller.php:20
    9	K2Controller->display()	JROOT/components/com_k2/controllers/itemlist.php:49
    8	K2ControllerItemlist->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_k2/k2.php:63
    6	require_once JROOT/components/com_k2/k2.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:203
    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: 6.46 ms Dopo l'ultima query: 144.20 ms Memoria query: 0.015 MB memoria prima della query: 7.502 MB Righe restituite: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kfsn9_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	41	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
    9	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
    8	PlgSystemLanguageFilter->onAfterDispatch()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:203
    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: 29.01 ms Dopo l'ultima query: 435.14 ms Memoria query: 0.028 MB memoria prima della query: 7.925 MB Righe restituite: 33

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM kfsn9_modules AS m
    
      LEFT JOIN kfsn9_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN kfsn9_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 <= '2024-12-22 08:47:33') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 08:47:33') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 180 OR mm.menuid <= 0) 
      AND m.language IN ('it-IT','*')
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix/core/helix.php:735
    11	Helix::countModules()	JROOT/plugins/system/helix/core/helix.php:351
    10	Helix::showRow()	JROOT/plugins/system/helix/core/helix.php:448
    9	Helix::generatelayout()	JROOT/plugins/system/helix/core/helix.php:713
    8	Helix::layout()	JROOT/templates/ts_barrister/index.php:43
    7	require JROOT/templates/ts_barrister/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1037
    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:209
    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: 9.71 ms Dopo l'ultima query: 80.24 ms Memoria query: 0.036 MB memoria prima della query: 8.147 MB Righe restituite: 0

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM kfsn9_fields AS a
    
      LEFT JOIN `kfsn9_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN kfsn9_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN kfsn9_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN kfsn9_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN kfsn9_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `kfsn9_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_custom.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (4,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1) 
      AND a.language in ('*','it-IT')
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context,idx_language	idx_state	1	const	1	100.00	Using where; Using temporary; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	Sql941215_1.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql941215_1.a.group_id	1	100.00	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	Sql941215_1.a.id	1	100.00	Using where; Using index; Distinct

    Profilo

    Status	Duration
    starting	0.25 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    init	0.15 ms
    System lock	0.01 ms
    optimizing	0.04 ms
    statistics	0.22 ms
    preparing	0.06 ms
    Creating tmp table	0.16 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	1.01 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    removing tmp table	0.58 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    18	PlgSystemFields->onContentPrepare()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	Chiamata uguale alla linea sottostante.
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    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:209
    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: 11.05 ms Dopo l'ultima query: 26.26 ms Memoria query: 0.021 MB memoria prima della query: 8.263 MB Righe restituite: 198

    SELECT i.id 
      FROM kfsn9_k2_items as i 
      LEFT JOIN kfsn9_k2_categories c 
      ON c.id = i.catid 
      WHERE i.published=1  
      AND ( i.publish_up = '0000-00-00 00:00:00' OR i.publish_up <= '2024-12-22 08:47:33' )  
      AND ( i.publish_down = '0000-00-00 00:00:00' OR i.publish_down >= '2024-12-22 08:47:33' ) 
      AND i.trash=0  
      AND i.access IN(1,1)  
      AND c.published=1  
      AND c.trash=0  
      AND c.access IN(1,1)  
      AND c.language IN ('it-IT', '*') 
      AND i.language IN ('it-IT', '*')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	ref	PRIMARY,category,published,access,trash,language	category	2	const	29	100.00	Using index condition; Using where
    1	SIMPLE	i	ref	item,catid,language	catid	4	Sql941215_1.c.id	9	100.00	Using index condition; Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
    12	JDatabaseDriver->loadColumn()	JROOT/modules/mod_k2_tools/helper.php:320
    11	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:103
    10	include JROOT/modules/mod_k2_tools/mod_k2_tools.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    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:209
    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]

    ---

45. Tempo della query: 8.10 ms Dopo l'ultima query: 1.78 ms Memoria query: 0.020 MB memoria prima della query: 8.316 MB Righe restituite: 51

    SELECT tag.name, tag.id
            
      FROM kfsn9_k2_tags as tag
            
      LEFT JOIN kfsn9_k2_tags_xref AS xref 
      ON xref.tagID = tag.id 
            
      WHERE xref.itemID IN (1,2,3,4,16,17,18,19,20,21,22,23,100,101,102,103,97,98,99,113,119,120,121,129,130,142,143,144,175,177,178,180,181,182,183,188,189,190,191,193,194,195,37,38,39,40,41,43,44,45,46,47,48,49,50,52,54,55,56,57,58,85,86,87,88,89,91,94,95,107,108,109,110,112,114,117,118,122,123,124,125,126,127,128,135,139,146,147,148,149,150,151,152,153,154,155,156,157,158,159,160,161,162,163,164,165,166,167,168,169,170,171,172,173,174,176,179,184,186,187,192,196,197,198,199,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228,229,230,231,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,257,258,259,261,262,263,264,265,26,27,28,29,30,31,32,33,34,42,53,90,96,134,145,238,239,240,256,36,111) 
            
      AND tag.published = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	tag	ALL	PRIMARY,published	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	61	75.41	Using where
    1	SIMPLE	xref	ref	tagID,itemID	tagID	4	Sql941215_1.tag.id	1	100.00	Using where

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    12	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_k2_tools/helper.php:333
    11	modK2ToolsHelper::tagCloud()	JROOT/modules/mod_k2_tools/mod_k2_tools.php:103
    10	include JROOT/modules/mod_k2_tools/mod_k2_tools.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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1051
    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:209
    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]

    ---

46. Tempo della query: 5.86 ms Dopo l'ultima query: 193.29 ms Memoria query: 0.023 MB memoria prima della query: 8.561 MB Righe restituite: 90

    SELECT * 
      FROM kfsn9_acymailing_config

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:481
    14	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:438
    12	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:822
    11	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:22
    10	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    9	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    8	plgSystemRegacymailing->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1057
    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:209
    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]

    ---