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

36 query eseguite 53.16 ms

1. Tempo della query: 0.75 ms

   SELECT `data`
   
     FROM `fsp_session`
   
     WHERE `session_id` = X'6163306164646630623064313637373231626432613636626566333735653066'

   Explain

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

   Profilo

   Status	Duration
   starting	0.11 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   init	0.03 ms
   optimizing	0.02 ms
   statistics	0.08 ms
   preparing	0.01 ms
   executing	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.09 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   16	JDatabaseDriverMysql->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:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.57 ms Dopo l'ultima query: 3.01 ms

   SELECT `session_id`
   
     FROM `fsp_session`
   
     WHERE `session_id` = X'6163306164646630623064313637373231626432613636626566333735653066' 
     LIMIT 1

   Explain

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

   Profilo

   Status	Duration
   starting	0.05 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.02 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   preparing	0.01 ms
   executing	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.06 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   9	JDatabaseDriverMysql->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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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: 1.69 ms Dopo l'ultima query: 0.23 ms

   INSERT INTO `fsp_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6163306164646630623064313637373231626432613636626566333735653066', 1, 1618737383, 0, '', 0)

   Explain

   EXPLAIN non possibile sulla query: INSERT INTO `fsp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6163306164646630623064313637373231626432613636626566333735653066', 1, 1618737383, 0, '', 0)

   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
   update	0.19 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.01 ms
   query end	1.00 ms
   closing tables	0.03 ms
   Unlocking tables	0.04 ms
   freeing items	0.01 ms
   updating status	0.13 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   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.83 ms Dopo l'ultima query: 14.42 ms

   SELECT id, rules
   
     FROM `fsp_viewlevels`

   Explain

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

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.09 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.04 ms
   executing	0.02 ms
   Sending data	0.12 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.10 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   10	JDatabaseDriverMysql->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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Tempo della query: 0.80 ms Dopo l'ultima query: 0.34 ms

   SELECT b.id
   
     FROM fsp_usergroups AS a
   
     LEFT JOIN fsp_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	index	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	8	NULL	11	Using where; Using index

   Profilo

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.14 ms
   preparing	0.01 ms
   Unlocking tables	0.03 ms
   executing	0.01 ms
   Sending data	0.08 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.05 ms
   freeing items	0.02 ms
   updating status	0.08 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   11	JDatabaseDriverMysql->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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Tempo della query: 0.76 ms Dopo l'ultima query: 39.25 ms

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

   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.14 ms
   checking permissions	0.01 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.04 ms
   optimizing	0.03 ms
   statistics	0.09 ms
   preparing	0.01 ms
   executing	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.01 ms
   updating status	0.09 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:831
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Tempo della query: 0.53 ms Dopo l'ultima query: 2.62 ms

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

   Explain

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

   Profilo

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.05 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.02 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.09 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Tempo della query: 1.42 ms Dopo l'ultima query: 41.48 ms

   SHOW VARIABLES LIKE "collation_database"

   Explain

   EXPLAIN non possibile sulla query: SHOW VARIABLES LIKE "collation_database"

   Profilo

   Status	Duration
   starting	0.10 ms
   Opening tables	0.07 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.02 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.02 ms
   preparing	0.03 ms
   executing	0.01 ms
   Filling schema table	0.73 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   removing tmp table	0.02 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   freeing items	0.02 ms
   updating status	0.11 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
   13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:342
   12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
   11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
   10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
   9	plgSystemAdmintools->onAfterInitialise()	Chiamata uguale alla linea sottostante.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Tempo della query: 0.77 ms Dopo l'ultima query: 0.51 ms

   SELECT `source`,`keepurlparams`
   
     FROM `fsp_admintools_redirects`
   
     WHERE ((`dest` = 'aree/usa-tag.html') OR (`dest` = 'aree/usa-tag.html') OR ('aree/usa-tag.html' LIKE `dest`)) 
     AND `published` = '1'
   
     ORDER BY `ordering` DESC 
     LIMIT 1

   Explain

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

   Profilo

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   init	0.04 ms
   optimizing	0.03 ms
   statistics	0.03 ms
   preparing	0.02 ms
   Sorting result	0.02 ms
   executing	0.02 ms
   Sending data	0.01 ms
   Creating sort index	0.12 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.02 ms
   freeing items	0.01 ms
   updating status	0.09 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File e numero di linea
   13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1773
   12	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
   11	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
   10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
   9	plgSystemAdmintools->onAfterInitialise()	Chiamata uguale alla linea sottostante.
   8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Tempo della query: 1.77 ms Dopo l'ultima query: 35.93 ms

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

    Explain

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

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.14 ms
    updating	0.13 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	0.84 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/oziojquery/oziojquery.php:57
    9	plgSystemOziojquery->onAfterRoute()	Chiamata uguale alla linea sottostante.
    8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Tempo della query: 2.70 ms Dopo l'ultima query: 32.52 ms

    SELECT *
    
      FROM `fsp_content_types`

    Explain

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

    Profilo

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	1.86 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.02 ms
    optimizing	0.03 ms
    statistics	0.02 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.26 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
    18	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Helper/TagsHelper.php:794
    17	Joomla\CMS\Helper\TagsHelper::getTypes()	JROOT/libraries/src/Helper/TagsHelper.php:628
    16	Joomla\CMS\Helper\TagsHelper->getTagItemsQuery()	JROOT/components/com_tags/models/tag.php:149
    15	TagsModelTag->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    14	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
    12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Tempo della query: 8.30 ms Dopo l'ultima query: 0.43 ms

    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM fsp_contentitem_tag_map AS m
    
      INNER JOIN fsp_ucm_content AS c 
      ON m.type_alias = c.core_type_alias 
      AND m.core_content_id = c.core_content_id 
      AND c.core_state IN (1) 
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2021-04-18 09:16:23')  
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2021-04-18 09:16:23')
    
      INNER JOIN fsp_content_types AS ct 
      ON ct.type_alias = m.type_alias
    
      LEFT JOIN fsp_categories AS tc 
      ON tc.id = c.core_catid
    
      LEFT JOIN fsp_users AS ua 
      ON ua.id = c.core_created_user_id
    
      WHERE m.tag_id IN (4) 
      AND (c.core_catid = 0 OR tc.published = 1) 
      AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_dpcalendar.event','com_dpcalendar.category','com_dpcalendar.event','com_dpcalendar.category') 
      AND c.core_access IN (0,1,5)
    
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
    
      ORDER BY MAX(`c`.`core_publish_up`) DESC 
      LIMIT 20

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	172	Using where; Using temporary; Using filesort
    1	SIMPLE	ct	ref	idx_alias	idx_alias	402	uy5h4chs_fsit.m.type_alias	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	uy5h4chs_fsit.m.core_content_id	1	Using where
    1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	uy5h4chs_fsit.c.core_catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	uy5h4chs_fsit.c.core_created_user_id	1	Using where

    Profilo

    Status	Duration
    starting	0.21 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.55 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.14 ms
    optimizing	0.05 ms
    statistics	0.18 ms
    preparing	0.07 ms
    Creating tmp table	0.17 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	6.01 ms
    Creating sort index	0.41 ms
    removing tmp table	0.06 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.10 ms
    freeing items	0.04 ms
    updating status	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_tags/models/tag.php:86
    12	TagsModelTag->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:93
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Tempo della query: 1.87 ms Dopo l'ultima query: 12.10 ms

    SHOW FULL COLUMNS 
      FROM `fsp_tags`

    Explain

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

    Profilo

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.25 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
    Opening tables	0.70 ms
    After opening tables	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.05 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.10 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_tags/tables/tag.php:29
    14	TagsTableTag->__construct()	JROOT/libraries/src/Table/Table.php:312
    13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_tags/models/tag.php:279
    12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Tempo della query: 0.63 ms Dopo l'ultima query: 4.65 ms
    Query duplicate: #17

    SELECT *
    
      FROM fsp_tags
    
      WHERE `id` = '4'

    Explain

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

    Profilo

    Status	Duration
    starting	0.05 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.02 ms
    statistics	0.11 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    13	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:288
    12	TagsModelTag->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:94
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Tempo della query: 7.13 ms Dopo l'ultima query: 2.92 ms

    SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count, MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title, MAX(c.core_params) AS core_params,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
      CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
      CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email
    
      FROM fsp_contentitem_tag_map AS m
    
      INNER JOIN fsp_ucm_content AS c 
      ON m.type_alias = c.core_type_alias 
      AND m.core_content_id = c.core_content_id 
      AND c.core_state IN (1) 
      AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2021-04-18 09:16:23')  
      AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2021-04-18 09:16:23')
    
      INNER JOIN fsp_content_types AS ct 
      ON ct.type_alias = m.type_alias
    
      LEFT JOIN fsp_categories AS tc 
      ON tc.id = c.core_catid
    
      LEFT JOIN fsp_users AS ua 
      ON ua.id = c.core_created_user_id
    
      WHERE m.tag_id IN (4) 
      AND (c.core_catid = 0 OR tc.published = 1) 
      AND m.type_alias IN ('com_content.article','com_weblinks.weblink','com_contact.contact','com_newsfeeds.newsfeed','com_users.user','com_content.category','com_contact.category','com_newsfeeds.category','com_weblinks.category','com_tags.tag','com_banners.banner','com_banners.category','com_banners.client','com_users.note','com_users.category','com_dpcalendar.event','com_dpcalendar.category','com_dpcalendar.event','com_dpcalendar.category') 
      AND c.core_access IN (0,1,5)
    
      GROUP BY m.type_alias, m.content_item_id, m.core_content_id, core_modified_time, core_created_time, core_created_by_alias, author, author_email
    
      ORDER BY MAX(`c`.`core_publish_up`) DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_tag_type,idx_core_content_id	idx_tag_type	4	const	172	Using where; Using temporary; Using filesort
    1	SIMPLE	ct	ref	idx_alias	idx_alias	402	uy5h4chs_fsit.m.type_alias	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	uy5h4chs_fsit.m.core_content_id	1	Using where
    1	SIMPLE	tc	eq_ref	PRIMARY	PRIMARY	4	uy5h4chs_fsit.c.core_catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	uy5h4chs_fsit.c.core_created_user_id	1	Using where

    Profilo

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.10 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.12 ms
    optimizing	0.05 ms
    statistics	0.13 ms
    preparing	0.05 ms
    Creating tmp table	0.06 ms
    Sorting result	0.02 ms
    executing	0.00 ms
    Sending data	4.58 ms
    Creating sort index	1.41 ms
    removing tmp table	0.06 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.05 ms
    freeing items	0.02 ms
    updating status	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_tags/views/tag/view.html.php:97
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Tempo della query: 1.82 ms Dopo l'ultima query: 42.69 ms

    UPDATE fsp_tags
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '4'

    Explain

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

    Profilo

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.08 ms
    updating	0.14 ms
    end	0.01 ms
    Waiting for query cache lock	0.01 ms
    end	0.01 ms
    query end	0.89 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Table/Table.php:1245
    12	Joomla\CMS\Table\Table->hit()	JROOT/components/com_tags/models/tag.php:343
    11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:239
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Tempo della query: 0.64 ms Dopo l'ultima query: 0.30 ms
    Query duplicate: #14

    SELECT *
    
      FROM fsp_tags
    
      WHERE `id` = '4'

    Explain

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

    Profilo

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

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    12	Joomla\CMS\Table\Table->load()	JROOT/components/com_tags/models/tag.php:346
    11	TagsModelTag->hit()	JROOT/components/com_tags/views/tag/view.html.php:239
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Tempo della query: 1.45 ms Dopo l'ultima query: 35.97 ms

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `fsp_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oziogallery3','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_slideshowck','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

    Explain

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

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.08 ms
    optimizing	0.02 ms
    statistics	0.20 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.47 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.10 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    20	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    19	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    18	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    17	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    16	Joomla\CMS\User\User->authorise()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:20
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Tempo della query: 1.22 ms Dopo l'ultima query: 3.83 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 85
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	8	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.10 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.18 ms
    end	0.03 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Tempo della query: 0.92 ms Dopo l'ultima query: 3.45 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 205
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	109	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 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.04 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.20 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.09 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Tempo della query: 0.80 ms Dopo l'ultima query: 0.74 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 81
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	7	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 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.04 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    Sorting result	0.03 ms
    executing	0.00 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Tempo della query: 0.70 ms Dopo l'ultima query: 1.48 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 45
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	6	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Tempo della query: 0.79 ms Dopo l'ultima query: 1.34 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 41
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	17	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 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.04 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    Sorting result	0.01 ms
    executing	0.02 ms
    Sending data	0.12 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Tempo della query: 0.93 ms Dopo l'ultima query: 0.94 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 80
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	109	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.20 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Tempo della query: 0.87 ms Dopo l'ultima query: 1.48 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 37
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	109	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.12 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.22 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Tempo della query: 0.83 ms Dopo l'ultima query: 0.94 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 35
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	109	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.10 ms
    preparing	0.01 ms
    Unlocking tables	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.03 ms
    Creating sort index	0.18 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    29	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    27	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    26	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    25	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    24	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    23	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    22	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    21	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    20	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_tags/views/tag/tmpl/default_items.php:79
    15	include JROOT/components/com_tags/views/tag/tmpl/default_items.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_tags/views/tag/tmpl/default.php:50
    13	include JROOT/components/com_tags/views/tag/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
    12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_tags/views/tag/view.html.php:243
    10	TagsViewTag->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_tags/controller.php:52
    8	TagsController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_tags/tags.php:15
    6	require_once JROOT/components/com_tags/tags.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Tempo della query: 0.85 ms Dopo l'ultima query: 3.84 ms

    SHOW FULL COLUMNS 
      FROM `fsp_template_styles`

    Explain

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

    Profilo

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    closing tables	0.01 ms
    Opening tables	0.24 ms
    After opening tables	0.01 ms
    System lock	0.00 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.04 ms
    After opening tables	0.01 ms
    checking permissions	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    closing tables	0.02 ms
    executing	0.01 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.07 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    freeing items	0.01 ms
    updating status	0.08 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    10	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
    8	plgSystemHelix3->onAfterDispatch()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Tempo della query: 0.49 ms Dopo l'ultima query: 0.28 ms

    SELECT *
    
      FROM fsp_template_styles
    
      WHERE `id` = '12'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fsp_template_styles	const	PRIMARY	PRIMARY	4	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.02 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.06 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/helix3/helix3.php:38
    8	plgSystemHelix3->onAfterDispatch()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Tempo della query: 3.81 ms Dopo l'ultima query: 188.86 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM fsp_modules AS m
    
      LEFT JOIN fsp_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN fsp_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-04-18 09:16:23') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-04-18 09:16:23') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 580 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

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

    Profilo

    Status	Duration
    starting	0.20 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.12 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.07 ms
    optimizing	0.08 ms
    statistics	0.15 ms
    preparing	0.08 ms
    Sorting result	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	2.56 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.06 ms
    freeing items	0.02 ms
    updating status	0.12 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	Chiamata uguale alla linea sottostante.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    14	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    13	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    12	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    11	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/helix3/core/helix3.php:512
    10	Helix3::countModules()	JROOT/plugins/system/helix3/core/helix3.php:459
    9	Helix3::rowColumns()	JROOT/plugins/system/helix3/core/helix3.php:268
    8	Helix3::generatelayout()	JROOT/templates/jl_finance_free/index.php:192
    7	require JROOT/templates/jl_finance_free/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Tempo della query: 0.86 ms Dopo l'ultima query: 1170.70 ms

    SELECT `link`
    
      FROM `fsp_menu`
    
      WHERE `published`=1 
      AND `id`='650'

    Explain

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

    Profilo

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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.08 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.14 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/modules/mod_bt_login/helper.php:55
    11	modbt_loginHelper::getReturnURL()	JROOT/modules/mod_bt_login/mod_bt_login.php:107
    10	include JROOT/modules/mod_bt_login/mod_bt_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Tempo della query: 1.55 ms Dopo l'ultima query: 23.94 ms

    SELECT * 
      FROM fsp_acymailing_config

    Explain

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

    Profilo

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.04 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.02 ms
    executing	0.02 ms
    Sending data	0.19 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.67 ms
    freeing items	0.01 ms
    updating status	0.10 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:450
    15	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    14	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
    13	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:789
    12	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
    11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:13
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Tempo della query: 0.84 ms Dopo l'ultima query: 9.18 ms

    SELECT * 
      FROM fsp_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fsp_acymailing_list	ALL	typeorderingindex,typeuseridindex	NON È POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	3	Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.10 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.11 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/compat/joomla.php:450
    12	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
    11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:105
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Tempo della query: 0.61 ms Dopo l'ultima query: 0.31 ms

    SELECT a.id,a.alias,a.catid, c.alias as catalias 
      FROM fsp_content as a  
      LEFT JOIN fsp_categories AS c 
      ON c.id = a.catid 
      WHERE a.id = 682 
      LIMIT 1

    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	c	const	PRIMARY	PRIMARY	4	const	1

    Profilo

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.07 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.08 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File e numero di linea
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_acymailing/compat/joomla.php:457
    11	acymailing_loadObject()	JROOT/modules/mod_acymailing/mod_acymailing.php:248
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Tempo della query: 0.92 ms Dopo l'ultima query: 43.06 ms

    SELECT `alias`
    
      FROM `fsp_contact_details`
    
      WHERE id = '2'

    Explain

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

    Profilo

    Status	Duration
    starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.09 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.02 ms
    statistics	0.14 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    executing	0.01 ms
    Sending data	0.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.04 ms
    freeing items	0.01 ms
    updating status	0.11 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_contact/router.php:121
    18	ContactRouter->getContactSegment()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Tempo della query: 0.96 ms Dopo l'ultima query: 0.90 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_contact' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 12
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	cat_idx	207	NULL	4	Using index condition; Using where; Using filesort

    Profilo

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    init	0.05 ms
    optimizing	0.05 ms
    statistics	0.15 ms
    preparing	0.01 ms
    Unlocking tables	0.03 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.02 ms
    Creating sort index	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.03 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_contact/router.php:68
    18	ContactRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Tempo della query: 0.80 ms Dopo l'ultima query: 1.29 ms

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `fsp_categories` AS `s`
    
      INNER JOIN `fsp_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 112
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	4	Using index condition; Using where

    Profilo

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    Table lock	0.01 ms
    init	0.04 ms
    optimizing	0.03 ms
    statistics	0.15 ms
    preparing	0.01 ms
    Unlocking tables	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.11 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.07 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File e numero di linea
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    20	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    19	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    18	ContentRouter->getCategorySegment()	Chiamata uguale alla linea sottostante.
    17	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    16	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    15	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    14	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    13	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    10	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    9	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
    8	PlgSystemSef->onAfterRender()	Chiamata uguale alla linea sottostante.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1050
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---