{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1783247922,
                "last": 1783247922,
                "now": 1783247922
            },
            "client": {
                "forwarded": "216.73.216.197"
            },
            "token": "wy81vY5khw02x90BTfopPwRU9IjzML6s"
        },
        "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
        }
    }
}

Tempo

Memoria

40 query eseguite 19.07 ms

1. Tempo della query: 0.24 ms Memoria query: 0.022 MB memoria prima della query: 0.974 MB Righe restituite: 0

   SELECT `data`
   
     FROM `pcl_session`
   
     WHERE `session_id` = X'35676f74366d356330656772623133693936726f656f6c663431'

   Explain

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

   Profilo

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Chiamata uguale alla linea sottostante.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Tempo della query: 0.22 ms Dopo l'ultima query: 0.84 ms Memoria query: 0.020 MB memoria prima della query: 0.985 MB Righe restituite: 0

   SELECT `session_id`
   
     FROM `pcl_session`
   
     WHERE `session_id` = X'35676f74366d356330656772623133693936726f656f6c663431' 
     LIMIT 1

   Explain

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

   Profilo

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

3. Tempo della query: 2.45 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.003 MB memoria prima della query: 0.990 MB

   INSERT INTO `pcl_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'35676f74366d356330656772623133693936726f656f6c663431', 1, 1783247922, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `pcl_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'35676f74366d356330656772623133693936726f656f6c663431', 1, 1783247922, 0, '', 0)

   Profilo

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.01 ms
   Update	0.04 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	2.25 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	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:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Tempo della query: 0.29 ms Dopo l'ultima query: 2.26 ms Memoria query: 0.020 MB memoria prima della query: 1.126 MB Righe restituite: 9

   SELECT id, rules
   
     FROM `pcl_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

5. Tempo della query: 0.28 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.020 MB memoria prima della query: 1.137 MB Righe restituite: 2

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

   Explain

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

   Profilo

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Unlocking tables	0.01 ms
   Preparing	0.02 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

6. Tempo della query: 0.40 ms Dopo l'ultima query: 6.37 ms Memoria query: 0.020 MB memoria prima della query: 1.669 MB Righe restituite: 1

   SELECT `manifest_cache`
   
     FROM `pcl_extensions`
   
     WHERE `name` ='files_joomla'

   Explain

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

   Profilo

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.18 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
   9	JDatabaseDriver->loadAssoc()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2371
   8	plgSystemCleantalkantispam->getCmsVersion()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:137
   7	plgSystemCleantalkantispam->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tempo della query: 0.29 ms Dopo l'ultima query: 25.79 ms Memoria query: 0.022 MB memoria prima della query: 2.515 MB Righe restituite: 1
   Query duplicate: #8

   SELECT template
   
     FROM pcl_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	Extra
   1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using where

   Profilo

   Status	Duration
   Starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tempo della query: 0.23 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.022 MB memoria prima della query: 2.521 MB Righe restituite: 1
   Query duplicate: #7

   SELECT template
   
     FROM pcl_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	Extra
   1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using where

   Profilo

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.02 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tempo della query: 0.24 ms Dopo l'ultima query: 3.46 ms Memoria query: 0.020 MB memoria prima della query: 2.895 MB Righe restituite: 2

   SELECT extension, file, type
   
     FROM pcl_rokcommon_configs
   
     ORDER BY priority

   Explain

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

   Profilo

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.03 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.01 ms

   Call Stack

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

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

   ---

10. Tempo della query: 0.30 ms Dopo l'ultima query: 15.54 ms Memoria query: 0.022 MB memoria prima della query: 3.279 MB Righe restituite: 43

    SELECT * 
      FROM pcl_acysms_config

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.03 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acysms/classes/cpanel.php:17
    11	ACYSMScpanelClass->load()	JROOT/administrator/components/com_acysms/helpers/helper.php:265
    10	ACYSMS::config()	JROOT/administrator/components/com_acysms/helpers/helper.php:751
    9	include_once JROOT/administrator/components/com_acysms/helpers/helper.php	JROOT/plugins/system/acysmsusercreation/acysmsusercreation.php:25
    8	plgSystemAcysmsUserCreation->init()	JROOT/plugins/system/acysmsusercreation/acysmsusercreation.php:18
    7	plgSystemAcysmsUserCreation->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tempo della query: 0.34 ms Dopo l'ultima query: 3.26 ms Memoria query: 0.007 MB memoria prima della query: 3.327 MB

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

    Explain

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

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.07 ms
    Updating	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    17	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    16	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    15	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    14	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    13	Joomla\CMS\Factory::getDocument()	JROOT/components/com_joomsport/models/models.php:71
    12	JSPRO_Models->__construct()	JROOT/components/com_joomsport/models/default/match.php:25
    11	matchJSModel->__construct()	JROOT/plugins/acysms/answerjoomsport/answerjoomsport.php:220
    10	plgAcysmsAnswerJoomsport->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    9	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    8	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/plugins/system/acysmsverifnumber/acysmsverifnumber.php:25
    7	plgSystemAcySMSVerifNumber->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tempo della query: 0.25 ms Dopo l'ultima query: 3.52 ms Memoria query: 0.020 MB memoria prima della query: 3.367 MB Righe restituite: 1

    SELECT count(1)
    
      FROM `pcl_session`
    
      WHERE `session_id` ='' 
      AND client_id = 1 
      AND guest = 0

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:53
    8	plgSystemARKtypography->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tempo della query: 0.57 ms Dopo l'ultima query: 1.89 ms Memoria query: 0.022 MB memoria prima della query: 3.387 MB Righe restituite: 18

    SHOW FULL COLUMNS 
      FROM `pcl_extensions`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.17 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    checking permissions	0.06 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.06 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 0.26 ms Dopo l'ultima query: 0.80 ms Memoria query: 0.020 MB memoria prima della query: 3.417 MB Righe restituite: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:46
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tempo della query: 0.25 ms Dopo l'ultima query: 0.13 ms Memoria query: 0.020 MB memoria prima della query: 3.423 MB Righe restituite: 1
    Query duplicate: #17

    SELECT *
    
      FROM pcl_extensions
    
      WHERE `extension_id` ='10032'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tempo della query: 0.24 ms Dopo l'ultima query: 0.12 ms Memoria query: 0.020 MB memoria prima della query: 3.427 MB Righe restituite: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:69
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tempo della query: 0.24 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.021 MB memoria prima della query: 3.433 MB Righe restituite: 1
    Query duplicate: #15

    SELECT *
    
      FROM pcl_extensions
    
      WHERE `extension_id` ='10032'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tempo della query: 0.29 ms Dopo l'ultima query: 33.86 ms Memoria query: 0.023 MB memoria prima della query: 3.605 MB Righe restituite: 1

    SELECT extension_id AS id, element AS"option", params, enabled
    
      FROM pcl_extensions
    
      WHERE `type` ='component' 
      AND `element` = 'com_advancedmodules'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
    15	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
    14	RokSprocket_Addon_AdvancedModuleManager->__construct()	Chiamata uguale alla linea sottostante.
    13	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
    12	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
    11	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
    10	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
    9	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tempo della query: 0.81 ms Dopo l'ultima query: 17.12 ms Memoria query: 0.024 MB memoria prima della query: 4.072 MB Righe restituite: 64

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `pcl_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_acysms','com_admin','com_advancedmodules','com_ajax','com_akeeba','com_arkeditor','com_associations','com_banners','com_blankcomponent','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_conventions','com_cpanel','com_fields','com_finder','com_fpss','com_fsj_main','com_fsj_transman','com_googlesearch_cse','com_igallery','com_installer','com_itemrating','com_itpgooglesearch','com_jchoptimize','com_jcomments','com_jdownloads','com_jfbconnect','com_joomlaupdate','com_joomsport','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mightysites','com_miniorange_oauth','com_modules','com_obrss','com_offlajn_installer','com_plotalot','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_roksprocket','com_rsform','com_search','com_sigpro','com_smartslider3','com_tags','com_templates','com_universal_ajax_live_search','com_users','com_weblinks','com_wrapper')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_assets	range	idx_asset_name	idx_asset_name	202	NULL	66	Using index condition

    Profilo

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.01 ms
    Statistics	0.13 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.37 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    15	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    14	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    13	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    12	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    11	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:30
    10	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/advancedmodules.php:95
    9	PlgSystemAdvancedModules->handleOnAfterRoute()	JROOT/libraries/regularlabs/src/SystemPlugin.php:191
    8	RegularLabs\Library\SystemPlugin->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tempo della query: 0.80 ms Dopo l'ultima query: 0.86 ms Memoria query: 0.028 MB memoria prima della query: 4.162 MB Righe restituite: 325
    Query duplicate: #39

    SHOW TABLES

    Explain

    EXPLAIN non possibile sulla query: SHOW TABLES

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.47 ms
    Executing	0.01 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    9	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:244
    8	plgSystemjdownloads->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tempo della query: 0.26 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.036 MB memoria prima della query: 4.168 MB Righe restituite: 1

    SELECT params
    
      FROM `pcl_extensions`
    
      WHERE `element` ='com_arkeditor' 
      AND `type` = 'component'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/arktypography/arktypography.php:127
    8	plgSystemARKtypography->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tempo della query: 0.26 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.020 MB memoria prima della query: 4.277 MB Righe restituite: 1

    SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type` 
      FROM `pcl_obrss` 
      WHERE `published` = 1 
      AND `feeded` = 1 
      ORDER BY `ordering`

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/obrss/obrss.php:40
    8	plgSystemobrss->onAfterRoute()	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:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tempo della query: 1.17 ms Dopo l'ultima query: 15.66 ms Memoria query: 0.260 MB memoria prima della query: 4.895 MB Righe restituite: 61

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM pcl_modules AS m
    
      LEFT JOIN pcl_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN pcl_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.access IN (1,1,5,7) 
      AND m.client_id = 0
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	range	published,newsfeeds	published	5	NULL	76	Using index condition; Using where; Using filesort
    1	SIMPLE	am	eq_ref	PRIMARY	PRIMARY	4	giocaacalcio_it.m.id	1	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	giocaacalcio_it.m.module,const	1	Using index condition; Using where

    Profilo

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.06 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.71 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:278
    19	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:60
    18	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	JROOT/libraries/joomla/event/dispatcher.php:165
    17	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    16	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:366
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(528) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:686
    12	T3Template->checkSpotlight()	JROOT/templates/ts_dailytimes/tpls/blocks/topbar.php:13
    11	include JROOT/templates/ts_dailytimes/tpls/blocks/topbar.php	JROOT/plugins/system/t3/includes/core/template.php:200
    10	T3Template->loadBlock()	JROOT/templates/ts_dailytimes/tpls/default.php:32
    9	include JROOT/templates/ts_dailytimes/tpls/default.php	JROOT/plugins/system/t3/includes/core/template.php:226
    8	T3Template->loadLayout()	JROOT/templates/ts_dailytimes/index.php:35
    7	require JROOT/templates/ts_dailytimes/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 0.62 ms Dopo l'ultima query: 38.15 ms Memoria query: 0.021 MB memoria prima della query: 5.786 MB Righe restituite: 1

    SELECT extension_id, name 
      FROM pcl_extensions 
      WHERE type ='plugin' 
      AND folder = 'search' 
      AND enabled =1 
      AND access IN (1,1,5,7) 
      ORDER BY ordering

    Explain

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

    Profilo

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.31 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1811
    12	JDatabaseDriver->loadRowList()	JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php:196
    11	include JROOT/modules/mod_universal_ajaxlivesearch/mod_universal_ajaxlivesearch.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tempo della query: 0.26 ms Dopo l'ultima query: 5.83 ms Memoria query: 0.023 MB memoria prima della query: 5.798 MB Righe restituite: 1
    Query duplicate: #26  #29  #30  #34  #35

    SELECT `extension_id`
    
      FROM `pcl_extensions`
    
      WHERE `element` ='cleantalkantispam' 
      AND `folder` = 'system'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:19
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:191
    15	Cleantalk\Common\Cron->checkTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2229
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tempo della query: 0.21 ms Dopo l'ultima query: 0.06 ms Memoria query: 0.023 MB memoria prima della query: 5.805 MB Righe restituite: 1
    Query duplicate: #25  #29  #30  #34  #35

    SELECT `extension_id`
    
      FROM `pcl_extensions`
    
      WHERE `element` ='cleantalkantispam' 
      AND `folder` = 'system'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:21
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:191
    15	Cleantalk\Common\Cron->checkTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2229
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tempo della query: 0.21 ms Dopo l'ultima query: 0.18 ms Memoria query: 0.024 MB memoria prima della query: 5.818 MB Righe restituite: 1
    Query duplicate: #31  #36

    SELECT *
    
      FROM pcl_extensions
    
      WHERE `extension_id` ='10986'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    17	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:23
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:191
    15	Cleantalk\Common\Cron->checkTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2229
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tempo della query: 1.96 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.008 MB memoria prima della query: 5.844 MB

    UPDATE `pcl_extensions` 
      SET `package_id`='0',`name`='plg_system_cleantalkantispam_name',`type`='plugin',`element`='cleantalkantispam',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"plg_system_cleantalkantispam_name\",\"type\":\"plugin\",\"creationDate\":\"24.07.2019\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"2.3\",\"description\":\"PLG_SYSTEM_CLEANTALKANTISPAM_DESCRIPTION\",\"
      group\":\"\",\"filename\":\"cleantalkantispam\"}',`params`='{\"apikey\":\"6utahe8yhe8y\",\"form_protection\":[\"check_register\",\"check_contact_forms\",\"check_search\"],\"comments_and_messages\":[\"jcomments_check_comments\"],\"cookies\":[\"set_cookies\"],\"url_exclusions\":\"\",\"fields_exclusions\":\"\",\"roles_exclusions\":\"administrator,super users\",\"work_url\":\"https:\\/\\/moderate4.cleantalk.org\",\"server_ttl\":4,\"server_changed\":1783247873,\"ct_key_is_ok\":1,\"acc_status_last_check\":1783246808,\"show_notice\":0,\"renew\":0,\"trial\":0,\"user_token\":\"pUul0WqgkxRkDsWgWhqX11KCtqWPXoI6\",\"spam_count\":216257,\"moderate_ip\":0,\"moderate\":1,\"show_review\":1,\"service_id\":1133539,\"license_trial\":0,\"account_name_ob\":\"fabiobe******@about-sport.it\",\"valid\":1,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"ip_license\":0,\"cleantalk_cron\":{\"last_start\":1783247923,\"tasks\":{\"sfw_update\":{\"handler\":\"apbct_sfw_update\",\"next_call\":1783293141,\"period\":86400,\"params\":[],\"processing\":false,\"last_call\":0},\"sfw_send_logs\":{\"handler\":\"apbct_sfw_send_logs\",\"next_call\":1783246799,\"period\":3600,\"params\":[],\"processing\":true,\"last_call\":1783247923}}},\"js_keys\":{\"1469489267\":1783206741},\"firewall_updating_id\":\"389907757fba7e9bd2b7c55ca848b238\",\"firewall_updating_last_start\":1783206740,\"firewall_update_percent\":0,\"remote_calls\":{\"close_renew_banner\":{\"last_call\":0,\"cooldown\":10},\"sfw_update\":{\"last_call\":1783206740,\"cooldown\":10},\"sfw_send_logs\":{\"last_call\":0,\"cooldown\":10},\"sfw_update__write_base\":{\"last_call\":1783206754,\"cooldown\":0}},\"connection_reports\":{\"success\":46186,\"negative\":10,\"negative_report\":null},\"sfw_last_check\":1782990502}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='1',`state`='0' 
      WHERE `extension_id` = '10986'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `pcl_extensions` SET `package_id`='0',`name`='plg_system_cleantalkantispam_name',`type`='plugin',`element`='cleantalkantispam',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"plg_system_cleantalkantispam_name\",\"type\":\"plugin\",\"creationDate\":\"24.07.2019\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"2.3\",\"description\":\"PLG_SYSTEM_CLEANTALKANTISPAM_DESCRIPTION\",\"group\":\"\",\"filename\":\"cleantalkantispam\"}',`params`='{\"apikey\":\"6utahe8yhe8y\",\"form_protection\":[\"check_register\",\"check_contact_forms\",\"check_search\"],\"comments_and_messages\":[\"jcomments_check_comments\"],\"cookies\":[\"set_cookies\"],\"url_exclusions\":\"\",\"fields_exclusions\":\"\",\"roles_exclusions\":\"administrator,super users\",\"work_url\":\"https:\\/\\/moderate4.cleantalk.org\",\"server_ttl\":4,\"server_changed\":1783247873,\"ct_key_is_ok\":1,\"acc_status_last_check\":1783246808,\"show_notice\":0,\"renew\":0,\"trial\":0,\"user_token\":\"pUul0WqgkxRkDsWgWhqX11KCtqWPXoI6\",\"spam_count\":216257,\"moderate_ip\":0,\"moderate\":1,\"show_review\":1,\"service_id\":1133539,\"license_trial\":0,\"account_name_ob\":\"fabiobe******@about-sport.it\",\"valid\":1,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"ip_license\":0,\"cleantalk_cron\":{\"last_start\":1783247923,\"tasks\":{\"sfw_update\":{\"handler\":\"apbct_sfw_update\",\"next_call\":1783293141,\"period\":86400,\"params\":[],\"processing\":false,\"last_call\":0},\"sfw_send_logs\":{\"handler\":\"apbct_sfw_send_logs\",\"next_call\":1783246799,\"period\":3600,\"params\":[],\"processing\":true,\"last_call\":1783247923}}},\"js_keys\":{\"1469489267\":1783206741},\"firewall_updating_id\":\"389907757fba7e9bd2b7c55ca848b238\",\"firewall_updating_last_start\":1783206740,\"firewall_update_percent\":0,\"remote_calls\":{\"close_renew_banner\":{\"last_call\":0,\"cooldown\":10},\"sfw_update\":{\"last_call\":1783206740,\"cooldown\":10},\"sfw_send_logs\":{\"last_call\":0,\"cooldown\":10},\"sfw_update__write_base\":{\"last_call\":1783206754,\"cooldown\":0}},\"connection_reports\":{\"success\":46186,\"negative\":10,\"negative_report\":null},\"sfw_last_check\":1782990502}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='1',`state`='0' WHERE `extension_id` = '10986'

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	1.67 ms
    Query end	0.02 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    18	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    17	Joomla\CMS\Table\Table->store()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:27
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:191
    15	Cleantalk\Common\Cron->checkTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2229
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tempo della query: 0.32 ms Dopo l'ultima query: 0.43 ms Memoria query: 0.023 MB memoria prima della query: 5.831 MB Righe restituite: 1
    Query duplicate: #25  #26  #30  #34  #35

    SELECT `extension_id`
    
      FROM `pcl_extensions`
    
      WHERE `element` ='cleantalkantispam' 
      AND `folder` = 'system'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:86
    16	Cleantalk\ApbctJoomla\Cron->setCronLastStart()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:209
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tempo della query: 0.23 ms Dopo l'ultima query: 0.03 ms Memoria query: 0.023 MB memoria prima della query: 5.838 MB Righe restituite: 1
    Query duplicate: #25  #26  #29  #34  #35

    SELECT `extension_id`
    
      FROM `pcl_extensions`
    
      WHERE `element` ='cleantalkantispam' 
      AND `folder` = 'system'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:88
    16	Cleantalk\ApbctJoomla\Cron->setCronLastStart()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:209
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tempo della query: 0.21 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.024 MB memoria prima della query: 5.851 MB Righe restituite: 1
    Query duplicate: #27  #36

    SELECT *
    
      FROM pcl_extensions
    
      WHERE `extension_id` ='10986'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    17	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:90
    16	Cleantalk\ApbctJoomla\Cron->setCronLastStart()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:209
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tempo della query: 0.92 ms Dopo l'ultima query: 0.32 ms Memoria query: 0.008 MB memoria prima della query: 5.879 MB

    UPDATE `pcl_extensions` 
      SET `package_id`='0',`name`='plg_system_cleantalkantispam_name',`type`='plugin',`element`='cleantalkantispam',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"plg_system_cleantalkantispam_name\",\"type\":\"plugin\",\"creationDate\":\"24.07.2019\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"2.3\",\"description\":\"PLG_SYSTEM_CLEANTALKANTISPAM_DESCRIPTION\",\"
      group\":\"\",\"filename\":\"cleantalkantispam\"}',`params`='{\"apikey\":\"6utahe8yhe8y\",\"form_protection\":[\"check_register\",\"check_contact_forms\",\"check_search\"],\"comments_and_messages\":[\"jcomments_check_comments\"],\"cookies\":[\"set_cookies\"],\"url_exclusions\":\"\",\"fields_exclusions\":\"\",\"roles_exclusions\":\"administrator,super users\",\"work_url\":\"https:\\/\\/moderate4.cleantalk.org\",\"server_ttl\":4,\"server_changed\":1783247873,\"ct_key_is_ok\":1,\"acc_status_last_check\":1783246808,\"show_notice\":0,\"renew\":0,\"trial\":0,\"user_token\":\"pUul0WqgkxRkDsWgWhqX11KCtqWPXoI6\",\"spam_count\":216257,\"moderate_ip\":0,\"moderate\":1,\"show_review\":1,\"service_id\":1133539,\"license_trial\":0,\"account_name_ob\":\"fabiobe******@about-sport.it\",\"valid\":1,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"ip_license\":0,\"cleantalk_cron\":{\"last_start\":1783247923,\"tasks\":{\"sfw_update\":{\"handler\":\"apbct_sfw_update\",\"next_call\":1783293141,\"period\":86400,\"params\":[],\"processing\":false,\"last_call\":0},\"sfw_send_logs\":{\"handler\":\"apbct_sfw_send_logs\",\"next_call\":1783246799,\"period\":3600,\"params\":[],\"processing\":false,\"last_call\":0}}},\"js_keys\":{\"1469489267\":1783206741},\"firewall_updating_id\":\"389907757fba7e9bd2b7c55ca848b238\",\"firewall_updating_last_start\":1783206740,\"firewall_update_percent\":0,\"remote_calls\":{\"close_renew_banner\":{\"last_call\":0,\"cooldown\":10},\"sfw_update\":{\"last_call\":1783206740,\"cooldown\":10},\"sfw_send_logs\":{\"last_call\":0,\"cooldown\":10},\"sfw_update__write_base\":{\"last_call\":1783206754,\"cooldown\":0}},\"connection_reports\":{\"success\":46186,\"negative\":10,\"negative_report\":null},\"sfw_last_check\":1782990502}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='1',`state`='0' 
      WHERE `extension_id` = '10986'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `pcl_extensions` SET `package_id`='0',`name`='plg_system_cleantalkantispam_name',`type`='plugin',`element`='cleantalkantispam',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"plg_system_cleantalkantispam_name\",\"type\":\"plugin\",\"creationDate\":\"24.07.2019\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"2.3\",\"description\":\"PLG_SYSTEM_CLEANTALKANTISPAM_DESCRIPTION\",\"group\":\"\",\"filename\":\"cleantalkantispam\"}',`params`='{\"apikey\":\"6utahe8yhe8y\",\"form_protection\":[\"check_register\",\"check_contact_forms\",\"check_search\"],\"comments_and_messages\":[\"jcomments_check_comments\"],\"cookies\":[\"set_cookies\"],\"url_exclusions\":\"\",\"fields_exclusions\":\"\",\"roles_exclusions\":\"administrator,super users\",\"work_url\":\"https:\\/\\/moderate4.cleantalk.org\",\"server_ttl\":4,\"server_changed\":1783247873,\"ct_key_is_ok\":1,\"acc_status_last_check\":1783246808,\"show_notice\":0,\"renew\":0,\"trial\":0,\"user_token\":\"pUul0WqgkxRkDsWgWhqX11KCtqWPXoI6\",\"spam_count\":216257,\"moderate_ip\":0,\"moderate\":1,\"show_review\":1,\"service_id\":1133539,\"license_trial\":0,\"account_name_ob\":\"fabiobe******@about-sport.it\",\"valid\":1,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"ip_license\":0,\"cleantalk_cron\":{\"last_start\":1783247923,\"tasks\":{\"sfw_update\":{\"handler\":\"apbct_sfw_update\",\"next_call\":1783293141,\"period\":86400,\"params\":[],\"processing\":false,\"last_call\":0},\"sfw_send_logs\":{\"handler\":\"apbct_sfw_send_logs\",\"next_call\":1783246799,\"period\":3600,\"params\":[],\"processing\":false,\"last_call\":0}}},\"js_keys\":{\"1469489267\":1783206741},\"firewall_updating_id\":\"389907757fba7e9bd2b7c55ca848b238\",\"firewall_updating_last_start\":1783206740,\"firewall_update_percent\":0,\"remote_calls\":{\"close_renew_banner\":{\"last_call\":0,\"cooldown\":10},\"sfw_update\":{\"last_call\":1783206740,\"cooldown\":10},\"sfw_send_logs\":{\"last_call\":0,\"cooldown\":10},\"sfw_update__write_base\":{\"last_call\":1783206754,\"cooldown\":0}},\"connection_reports\":{\"success\":46186,\"negative\":10,\"negative_report\":null},\"sfw_last_check\":1782990502}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='1',`state`='0' WHERE `extension_id` = '10986'

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.66 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    18	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    17	Joomla\CMS\Table\Table->store()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:94
    16	Cleantalk\ApbctJoomla\Cron->setCronLastStart()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:209
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tempo della query: 0.26 ms Dopo l'ultima query: 0.79 ms Memoria query: 0.025 MB memoria prima della query: 5.876 MB Righe restituite: 0

    SELECT * 
      FROM pcl_cleantalk_sfw_logs;

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    20	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/DB.php:75
    19	Cleantalk\ApbctJoomla\DB->fetch_all()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Firewall/Firewall.php:327
    18	Cleantalk\Common\Firewall\Firewall->sendLogs()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2274
    17	plgSystemCleantalkantispam::apbct_sfw_send_logs()	Chiamata uguale alla linea sottostante.
    16	call_user_func_array()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:221
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tempo della query: 0.27 ms Dopo l'ultima query: 0.08 ms Memoria query: 0.023 MB memoria prima della query: 5.875 MB Righe restituite: 1
    Query duplicate: #25  #26  #29  #30  #35

    SELECT `extension_id`
    
      FROM `pcl_extensions`
    
      WHERE `element` ='cleantalkantispam' 
      AND `folder` = 'system'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:19
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:251
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tempo della query: 0.24 ms Dopo l'ultima query: 0.04 ms Memoria query: 0.023 MB memoria prima della query: 5.883 MB Righe restituite: 1
    Query duplicate: #25  #26  #29  #30  #34

    SELECT `extension_id`
    
      FROM `pcl_extensions`
    
      WHERE `element` ='cleantalkantispam' 
      AND `folder` = 'system'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	element_clientid,element_folder_clientid	element_folder_clientid	804	const,const	1	Using where; Using index

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:21
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:251
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tempo della query: 0.24 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.024 MB memoria prima della query: 5.895 MB Righe restituite: 1
    Query duplicate: #27  #31

    SELECT *
    
      FROM pcl_extensions
    
      WHERE `extension_id` ='10986'

    Explain

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

    Profilo

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    17	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:23
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:251
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Tempo della query: 0.93 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.008 MB memoria prima della query: 5.922 MB

    UPDATE `pcl_extensions` 
      SET `package_id`='0',`name`='plg_system_cleantalkantispam_name',`type`='plugin',`element`='cleantalkantispam',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"plg_system_cleantalkantispam_name\",\"type\":\"plugin\",\"creationDate\":\"24.07.2019\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"2.3\",\"description\":\"PLG_SYSTEM_CLEANTALKANTISPAM_DESCRIPTION\",\"
      group\":\"\",\"filename\":\"cleantalkantispam\"}',`params`='{\"apikey\":\"6utahe8yhe8y\",\"form_protection\":[\"check_register\",\"check_contact_forms\",\"check_search\"],\"comments_and_messages\":[\"jcomments_check_comments\"],\"cookies\":[\"set_cookies\"],\"url_exclusions\":\"\",\"fields_exclusions\":\"\",\"roles_exclusions\":\"administrator,super users\",\"work_url\":\"https:\\/\\/moderate4.cleantalk.org\",\"server_ttl\":4,\"server_changed\":1783247873,\"ct_key_is_ok\":1,\"acc_status_last_check\":1783246808,\"show_notice\":0,\"renew\":0,\"trial\":0,\"user_token\":\"pUul0WqgkxRkDsWgWhqX11KCtqWPXoI6\",\"spam_count\":216257,\"moderate_ip\":0,\"moderate\":1,\"show_review\":1,\"service_id\":1133539,\"license_trial\":0,\"account_name_ob\":\"fabiobe******@about-sport.it\",\"valid\":1,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"ip_license\":0,\"cleantalk_cron\":{\"last_start\":1783247923,\"tasks\":{\"sfw_update\":{\"handler\":\"apbct_sfw_update\",\"next_call\":1783293141,\"period\":86400,\"params\":[],\"processing\":false,\"last_call\":0},\"sfw_send_logs\":{\"handler\":\"apbct_sfw_send_logs\",\"next_call\":1783251523,\"period\":3600,\"params\":[],\"processing\":true,\"last_call\":1783247923}}},\"js_keys\":{\"1469489267\":1783206741},\"firewall_updating_id\":\"389907757fba7e9bd2b7c55ca848b238\",\"firewall_updating_last_start\":1783206740,\"firewall_update_percent\":0,\"remote_calls\":{\"close_renew_banner\":{\"last_call\":0,\"cooldown\":10},\"sfw_update\":{\"last_call\":1783206740,\"cooldown\":10},\"sfw_send_logs\":{\"last_call\":0,\"cooldown\":10},\"sfw_update__write_base\":{\"last_call\":1783206754,\"cooldown\":0}},\"connection_reports\":{\"success\":46186,\"negative\":10,\"negative_report\":null},\"sfw_last_check\":1782990502}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='1',`state`='0' 
      WHERE `extension_id` = '10986'

    Explain

    EXPLAIN non possibile sulla query: UPDATE `pcl_extensions` SET `package_id`='0',`name`='plg_system_cleantalkantispam_name',`type`='plugin',`element`='cleantalkantispam',`folder`='system',`client_id`='0',`enabled`='1',`access`='1',`protected`='0',`manifest_cache`='{\"name\":\"plg_system_cleantalkantispam_name\",\"type\":\"plugin\",\"creationDate\":\"24.07.2019\",\"author\":\"CleanTalk team\",\"copyright\":\"(C) CleanTalk\",\"authorEmail\":\"[email protected]\",\"authorUrl\":\"cleantalk.org\",\"version\":\"2.3\",\"description\":\"PLG_SYSTEM_CLEANTALKANTISPAM_DESCRIPTION\",\"group\":\"\",\"filename\":\"cleantalkantispam\"}',`params`='{\"apikey\":\"6utahe8yhe8y\",\"form_protection\":[\"check_register\",\"check_contact_forms\",\"check_search\"],\"comments_and_messages\":[\"jcomments_check_comments\"],\"cookies\":[\"set_cookies\"],\"url_exclusions\":\"\",\"fields_exclusions\":\"\",\"roles_exclusions\":\"administrator,super users\",\"work_url\":\"https:\\/\\/moderate4.cleantalk.org\",\"server_ttl\":4,\"server_changed\":1783247873,\"ct_key_is_ok\":1,\"acc_status_last_check\":1783246808,\"show_notice\":0,\"renew\":0,\"trial\":0,\"user_token\":\"pUul0WqgkxRkDsWgWhqX11KCtqWPXoI6\",\"spam_count\":216257,\"moderate_ip\":0,\"moderate\":1,\"show_review\":1,\"service_id\":1133539,\"license_trial\":0,\"account_name_ob\":\"fabiobe******@about-sport.it\",\"valid\":1,\"auto_update_app\":0,\"show_auto_update_notice\":0,\"ip_license\":0,\"cleantalk_cron\":{\"last_start\":1783247923,\"tasks\":{\"sfw_update\":{\"handler\":\"apbct_sfw_update\",\"next_call\":1783293141,\"period\":86400,\"params\":[],\"processing\":false,\"last_call\":0},\"sfw_send_logs\":{\"handler\":\"apbct_sfw_send_logs\",\"next_call\":1783251523,\"period\":3600,\"params\":[],\"processing\":true,\"last_call\":1783247923}}},\"js_keys\":{\"1469489267\":1783206741},\"firewall_updating_id\":\"389907757fba7e9bd2b7c55ca848b238\",\"firewall_updating_last_start\":1783206740,\"firewall_update_percent\":0,\"remote_calls\":{\"close_renew_banner\":{\"last_call\":0,\"cooldown\":10},\"sfw_update\":{\"last_call\":1783206740,\"cooldown\":10},\"sfw_send_logs\":{\"last_call\":0,\"cooldown\":10},\"sfw_update__write_base\":{\"last_call\":1783206754,\"cooldown\":0}},\"connection_reports\":{\"success\":46186,\"negative\":10,\"negative_report\":null},\"sfw_last_check\":1782990502}',`custom_data`='',`system_data`='',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`ordering`='1',`state`='0' WHERE `extension_id` = '10986'

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init for update	0.02 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.67 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    18	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    17	Joomla\CMS\Table\Table->store()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/ApbctJoomla/Cron.php:27
    16	Cleantalk\ApbctJoomla\Cron->saveTasks()	JROOT/plugins/system/cleantalkantispam/lib/Cleantalk/Common/Cron.php:251
    15	Cleantalk\Common\Cron->runTasks()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2238
    14	plgSystemCleantalkantispam->apbct_run_cron()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:2220
    13	plgSystemCleantalkantispam->sfw_check()	JROOT/plugins/system/cleantalkantispam/cleantalkantispam.php:582
    12	plgSystemCleantalkantispam->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Tempo della query: 0.52 ms Dopo l'ultima query: 2.41 ms Memoria query: 0.023 MB memoria prima della query: 6.138 MB Righe restituite: 65

    SELECT name, element AS `option`
    
      FROM pcl_extensions
    
      WHERE type ='component' 
      AND enabled = 1
    
      ORDER BY name ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	pcl_extensions	ref	extension	extension	82	const	68	Using index condition; Using where; Using filesort

    Profilo

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.17 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_menus/models/menutypes.php:90
    14	MenusModelMenutypes->getTypeOptions()	JROOT/plugins/system/betterpreview/src/Component/Link.php:35
    13	RegularLabs\Plugin\System\BetterPreview\Component\Link->__construct()	JROOT/plugins/system/betterpreview/src/Component.php:29
    12	RegularLabs\Plugin\System\BetterPreview\Component::getClass()	JROOT/plugins/system/betterpreview/src/Helper.php:135
    11	RegularLabs\Plugin\System\BetterPreview\Helper->getClass()	JROOT/plugins/system/betterpreview/src/Helper.php:109
    10	RegularLabs\Plugin\System\BetterPreview\Helper->onAfterRender()	Chiamata uguale alla linea sottostante.
    9	call_user_func_array()	JROOT/plugins/system/betterpreview/src/Plugin.php:97
    8	RegularLabs\Plugin\System\BetterPreview\Plugin->run()	JROOT/plugins/system/betterpreview/betterpreview.php:58
    7	PlgSystemBetterPreview->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Tempo della query: 0.66 ms Dopo l'ultima query: 102.48 ms Memoria query: 0.028 MB memoria prima della query: 6.283 MB Righe restituite: 325
    Query duplicate: #20

    SHOW TABLES

    Explain

    EXPLAIN non possibile sulla query: SHOW TABLES

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Filling schema table	0.01 ms
    checking permissions	0.32 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Removing tmp table	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    9	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/database/driver/mysqli.php:505
    8	JDatabaseDriverMysqli->getTableList()	JROOT/plugins/system/jdownloads/jdownloads.php:140
    7	plgSystemjdownloads->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Tempo della query: 0.32 ms Dopo l'ultima query: 4.18 ms Memoria query: 0.024 MB memoria prima della query: 6.533 MB Righe restituite: 181

    SELECT * 
      FROM pcl_acymailing_config

    Explain

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

    Profilo

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.01 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    10	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:461
    9	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1185
    8	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:139
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---