{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1610910333,
                "last": 1610910333,
                "now": 1610910333
            },
            "client": {
                "forwarded": "18.234.247.75"
            },
            "token": "pC0CBKbC20du3wKPE9KRPRTKZ1JVVtRz"
        },
        "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**

**49 query eseguite** 157.24 ms

1. **Tempo della query: 1.10 ms** **Memoria query: 0.027 MB memoria prima della query: 1.180 MB** **Righe restituite: 0**

   SELECT `data`
   
     FROM `htlw1_session`
   
     WHERE `session_id` = 'toqh12g9jcdf8o8gk13bh7k2j2'

   **Explain**

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

   **Profilo**

   Status	Duration
   starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.18 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.02 ms
   optimizing	0.02 ms
   statistics	0.17 ms
   preparing	0.06 ms
   executing	0.05 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.05 ms
   freeing items	0.02 ms
   updating status	0.10 ms
   cleaning up	0.02 ms

   **Call Stack**

   #	**Caller**	**File e numero di linea**
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	**Chiamata uguale alla linea sottostante.**
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php: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:53

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

   ---

2. **Tempo della query: 0.80 ms** **Dopo l'ultima query: 3.13 ms** **Memoria query: 0.023 MB memoria prima della query: 1.261 MB** **Righe restituite: 0**

   SELECT `session_id`
   
     FROM `htlw1_session`
   
     WHERE `session_id` = 'toqh12g9jcdf8o8gk13bh7k2j2' 
     LIMIT 1

   **Explain**

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

   **Profilo**

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

   **Call Stack**

   #	**Caller**	**File e numero di linea**
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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:53

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

   ---

3. **Tempo della query: 1.28 ms** **Dopo l'ultima query: 0.44 ms** **Memoria query: 0.005 MB memoria prima della query: 1.268 MB**

   INSERT INTO `htlw1_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('toqh12g9jcdf8o8gk13bh7k2j2', 1, 1610910333, 0, '', 0)

   **Explain**

   **EXPLAIN non possibile sulla query: INSERT INTO `htlw1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('toqh12g9jcdf8o8gk13bh7k2j2', 1, 1610910333, 0, '', 0)**

   **Profilo**

   Status	Duration
   starting	0.10 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.01 ms
   init	0.04 ms
   update	0.21 ms
   Waiting for query cache lock	0.02 ms
   update	0.02 ms
   end	0.02 ms
   query end	0.50 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.08 ms
   cleaning up	0.02 ms

   **Call Stack**

   #	**Caller**	**File e numero di linea**
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php: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:53

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

   ---

4. **Tempo della query: 2.23 ms** **Dopo l'ultima query: 4.64 ms** **Memoria query: 0.032 MB memoria prima della query: 1.304 MB** **Righe restituite: 39**

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

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	htlw1_extensions	ref	extension	extension	62	const	39	Using index condition; Using where

   **Profilo**

   Status	Duration
   starting	0.12 ms
   checking permissions	0.02 ms
   Opening tables	0.28 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   Table lock	0.01 ms
   After table lock	0.02 ms
   init	0.06 ms
   optimizing	0.05 ms
   statistics	0.20 ms
   preparing	0.07 ms
   executing	0.02 ms
   Sending data	0.73 ms
   end	0.02 ms
   query end	0.04 ms
   closing tables	0.05 ms
   freeing items	0.02 ms
   updating status	0.09 ms
   cleaning up	0.02 ms

   **Call Stack**

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

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

   ---

5. **Tempo della query: 0.93 ms** **Dopo l'ultima query: 3.67 ms** **Memoria query: 0.024 MB memoria prima della query: 1.339 MB** **Righe restituite: 3**

   SELECT id, rules
   
     FROM `htlw1_viewlevels`

   **Explain**

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

   **Profilo**

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

   **Call Stack**

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

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

   ---

6. **Tempo della query: 1.24 ms** **Dopo l'ultima query: 0.36 ms** **Memoria query: 0.024 MB memoria prima della query: 1.352 MB** **Righe restituite: 1**

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

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	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	8	Using where; Using index

   **Profilo**

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

   **Call Stack**

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

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

   ---

7. **Tempo della query: 3.45 ms** **Dopo l'ultima query: 0.77 ms** **Memoria query: 0.037 MB memoria prima della query: 1.376 MB** **Righe restituite: 72**

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

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	htlw1_extensions	ref	extension	extension	62	const	111	Using index condition; Using where; **Using filesort**

   **Profilo**

   Status	Duration
   starting	0.12 ms
   checking permissions	0.02 ms
   Opening tables	0.03 ms
   After opening tables	0.02 ms
   System lock	0.02 ms
   Table lock	0.01 ms
   After table lock	0.02 ms
   init	0.06 ms
   optimizing	0.05 ms
   statistics	0.10 ms
   preparing	0.10 ms
   executing	0.02 ms
   Sorting result	1.25 ms
   Sending data	1.17 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   updating status	0.07 ms
   cleaning up	0.02 ms

   **Call Stack**

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

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

   ---

8. **Tempo della query: 1.17 ms** **Dopo l'ultima query: 69.58 ms** **Memoria query: 0.024 MB memoria prima della query: 1.790 MB** **Righe restituite: 1**

   SELECT count(*)
   
     FROM `htlw1_cwgears_schedule`

   **Explain**

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	htlw1_cwgears_schedule	index	NULL	PRIMARY	4	NULL	1	Using index

   **Profilo**

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

   **Call Stack**

   #	**Caller**	**File e numero di linea**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

   ---

9. **Tempo della query: 0.65 ms** **Dopo l'ultima query: 0.26 ms** **Memoria query: 0.024 MB memoria prima della query: 1.798 MB** **Righe restituite: 1**

   SELECT count(*)
   
     FROM `htlw1_cwgears_schedule`
   
     WHERE time + '86400'<'1610910333'

   **Explain**

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

   **Profilo**

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

   **Call Stack**

   #	**Caller**	**File e numero di linea**
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:139
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
   5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

   ---

10. **Tempo della query: 5.40 ms** **Dopo l'ultima query: 5.71 ms** **Memoria query: 0.106 MB memoria prima della query: 1.900 MB** **Righe restituite: 69**

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

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	89	Using index condition; Using where; **Using filesort**
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.m.component_id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.20 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.29 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    After table lock	0.02 ms
    init	0.11 ms
    optimizing	0.06 ms
    statistics	0.14 ms
    preparing	0.08 ms
    executing	0.02 ms
    Sorting result	1.35 ms
    Sending data	2.66 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.04 ms
    freeing items	0.03 ms
    updating status	0.07 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	**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/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
    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:56

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

    ---

11. **Tempo della query: 1.04 ms** **Dopo l'ultima query: 21.76 ms** **Memoria query: 0.030 MB memoria prima della query: 2.343 MB** **Righe restituite: 1**

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

    **Explain**

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

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	**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/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

12. **Tempo della query: 1.41 ms** **Dopo l'ultima query: 0.58 ms** **Memoria query: 0.009 MB memoria prima della query: 2.339 MB**

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

    **Explain**

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

    **Profilo**

    Status	Duration
    starting	0.10 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.17 ms
    Updating	0.18 ms
    end	0.02 ms
    Waiting for query cache lock	0.01 ms
    end	0.03 ms
    query end	0.53 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.07 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:195
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

13. **Tempo della query: 0.76 ms** **Dopo l'ultima query: 2.44 ms** **Memoria query: 0.024 MB memoria prima della query: 2.365 MB** **Righe restituite: 1**

    SELECT count(*)
    
      FROM `htlw1_extensions`
    
      WHERE `element` = 'cwgears' 
      AND `extension_id` = ''

    **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.08 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.02 ms
    init	0.05 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    preparing	0.02 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.07 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:1003
    9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:202
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

14. **Tempo della query: 1.16 ms** **Dopo l'ultima query: 1.06 ms** **Memoria query: 0.026 MB memoria prima della query: 2.388 MB** **Righe restituite: 1**

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

    **Explain**

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

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
    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:56

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

    ---

15. **Tempo della query: 1.45 ms** **Dopo l'ultima query: 1.04 ms** **Memoria query: 0.023 MB memoria prima della query: 2.402 MB** **Righe restituite: 5**

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

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	8	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	c2_ebgh.s.template,const	1	Using index condition; Using where

    **Profilo**

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

    **Call Stack**

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

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

    ---

16. **Tempo della query: 2.83 ms** **Dopo l'ultima query: 14.91 ms** **Memoria query: 0.036 MB memoria prima della query: 2.564 MB** **Righe restituite: 39**

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `htlw1_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_coalawebsociallinks','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_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	htlw1_assets	range	idx_asset_name	idx_asset_name	152	NULL	40	Using index condition

    **Profilo**

    Status	Duration
    starting	0.20 ms
    checking permissions	0.02 ms
    Opening tables	0.23 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.02 ms
    init	0.18 ms
    optimizing	0.05 ms
    statistics	0.31 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	1.26 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    updating status	0.09 ms
    cleaning up	0.03 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

17. **Tempo della query: 14.35 ms** **Dopo l'ultima query: 0.83 ms** **Memoria query: 0.622 MB memoria prima della query: 2.622 MB** **Righe restituite: 2608**

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

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	htlw1_assets	ALL	idx_asset_name,idx_parent_id	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	2696	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
    18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
    13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

18. **Tempo della query: 13.49 ms** **Dopo l'ultima query: 25.48 ms** **Memoria query: 0.041 MB memoria prima della query: 4.825 MB** **Righe restituite: 3**

    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,(
    SELECT COUNT(i.`id`)
    
      FROM `htlw1_content` AS `i`
    
      WHERE i.`catid` = c.id 
      AND i.state = 1) AS numitems
    
      FROM `htlw1_categories` AS `s`
    
      INNER JOIN `htlw1_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.published = 1 
      AND s.id = 38
    
      ORDER BY c.lft

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	**Using filesort**
    1	PRIMARY	c	ALL	cat_idx,idx_left_right	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	55	Using where
    2	DEPENDENT SUBQUERY	i	ref	idx_state,idx_catid	idx_catid	4	c2_ebgh.c.id	74	Using index condition; Using where

    **Profilo**

    Status	Duration
    starting	0.46 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Opening tables	0.94 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.21 ms
    optimizing	0.11 ms
    statistics	0.36 ms
    preparing	0.08 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.06 ms
    executing	0.02 ms
    Sorting result	0.32 ms
    Sending data	0.29 ms
    executing	0.03 ms
    Sending data	0.13 ms
    executing	0.02 ms
    Sending data	0.08 ms
    executing	0.02 ms
    Sending data	9.44 ms
    end	0.05 ms
    query end	0.02 ms
    closing tables	0.04 ms
    freeing items	0.02 ms
    removing tmp table	0.03 ms
    freeing items	0.06 ms
    updating status	0.11 ms
    cleaning up	0.03 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
    13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

19. **Tempo della query: 19.38 ms** **Dopo l'ultima query: 4.18 ms** **Memoria query: 0.442 MB memoria prima della query: 4.871 MB** **Righe restituite: 10**

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM htlw1_content AS a
    
      LEFT JOIN htlw1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN htlw1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN htlw1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN htlw1_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 38 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 19:05:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 19:05:33')
    
      ORDER BY    
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created   
      LIMIT 20, 10

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	**Using filesort**
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	427	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.63 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.02 ms
    Opening tables	0.52 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.36 ms
    optimizing	0.17 ms
    statistics	0.40 ms
    preparing	0.15 ms
    executing	0.02 ms
    Sorting result	11.50 ms
    Sending data	5.00 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.07 ms
    updating status	0.05 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

20. **Tempo della query: 1.96 ms** **Dopo l'ultima query: 3.90 ms** **Memoria query: 0.039 MB memoria prima della query: 5.388 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2581 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.20 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.52 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.11 ms
    optimizing	0.08 ms
    statistics	0.23 ms
    preparing	0.09 ms
    executing	0.02 ms
    Sending data	0.15 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

21. **Tempo della query: 1.24 ms** **Dopo l'ultima query: 0.88 ms** **Memoria query: 0.039 MB memoria prima della query: 5.415 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2575 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

22. **Tempo della query: 1.16 ms** **Dopo l'ultima query: 0.91 ms** **Memoria query: 0.039 MB memoria prima della query: 5.441 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2565 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 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
    After table lock	0.02 ms
    init	0.09 ms
    optimizing	0.07 ms
    statistics	0.13 ms
    preparing	0.06 ms
    executing	0.02 ms
    Sending data	0.12 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

23. **Tempo della query: 1.16 ms** **Dopo l'ultima query: 0.72 ms** **Memoria query: 0.039 MB memoria prima della query: 5.467 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2552 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

24. **Tempo della query: 1.07 ms** **Dopo l'ultima query: 0.69 ms** **Memoria query: 0.039 MB memoria prima della query: 5.494 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2541 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

25. **Tempo della query: 1.27 ms** **Dopo l'ultima query: 0.65 ms** **Memoria query: 0.039 MB memoria prima della query: 5.520 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2532 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.17 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.10 ms
    optimizing	0.07 ms
    statistics	0.15 ms
    preparing	0.09 ms
    executing	0.02 ms
    Sending data	0.13 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

26. **Tempo della query: 1.11 ms** **Dopo l'ultima query: 0.69 ms** **Memoria query: 0.039 MB memoria prima della query: 5.547 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2528 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

27. **Tempo della query: 1.18 ms** **Dopo l'ultima query: 0.64 ms** **Memoria query: 0.039 MB memoria prima della query: 5.573 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2527 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

28. **Tempo della query: 1.11 ms** **Dopo l'ultima query: 0.66 ms** **Memoria query: 0.039 MB memoria prima della query: 5.599 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2524 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 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
    After table lock	0.02 ms
    init	0.09 ms
    optimizing	0.06 ms
    statistics	0.13 ms
    preparing	0.06 ms
    executing	0.02 ms
    Sending data	0.12 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

29. **Tempo della query: 1.12 ms** **Dopo l'ultima query: 0.68 ms** **Memoria query: 0.039 MB memoria prima della query: 5.626 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2522 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

30. **Tempo della query: 12.28 ms** **Dopo l'ultima query: 2.04 ms** **Memoria query: 0.029 MB memoria prima della query: 5.648 MB** **Righe restituite: 1**

    SELECT COUNT(*)
    
      FROM htlw1_content AS a
    
      LEFT JOIN htlw1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN htlw1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN htlw1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN htlw1_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 38 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 19:05:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 19:05:33')

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	427	Using where

    **Profilo**

    Status	Duration
    starting	0.25 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.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.12 ms
    optimizing	0.11 ms
    statistics	0.31 ms
    preparing	0.09 ms
    executing	0.02 ms
    Sending data	10.69 ms
    end	0.04 ms
    query end	0.03 ms
    closing tables	0.06 ms
    freeing items	0.04 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
    16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
    15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
    14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
    13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

31. **Tempo della query: 1.43 ms** **Dopo l'ultima query: 1.01 ms** **Memoria query: 0.037 MB memoria prima della query: 5.658 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.category' 
      AND `m`.`content_item_id` = 38 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
    11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

32. **Tempo della query: 2.34 ms** **Dopo l'ultima query: 7.66 ms** **Memoria query: 0.043 MB memoria prima della query: 5.769 MB** **Righe restituite: 3**

    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 `htlw1_categories` AS `s`
    
      INNER JOIN `htlw1_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) 
      AND c.published = 1 
      AND s.id = 38
    
      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	**Using filesort**
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	55	Using where

    **Profilo**

    Status	Duration
    starting	0.37 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.05 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.01 ms
    After table lock	0.02 ms
    init	0.17 ms
    optimizing	0.15 ms
    statistics	0.36 ms
    preparing	0.08 ms
    executing	0.02 ms
    Sorting result	0.31 ms
    Sending data	0.30 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    19	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    18	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_fields/models/fields.php:203
    17	FieldsModelFields->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
    16	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

33. **Tempo della query: 4.13 ms** **Dopo l'ultima query: 0.81 ms** **Memoria query: 0.042 MB memoria prima della query: 5.801 MB** **Righe restituite: 0**

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM htlw1_fields AS a
    
      LEFT JOIN `htlw1_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN htlw1_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN htlw1_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN htlw1_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `htlw1_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.article' 
      AND (fc.category_id IS NULL OR fc.category_id IN (38,0,69)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; **Using filesort**
    1	SIMPLE	l	ALL	NULL	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where; Using index; Distinct

    **Profilo**

    Status	Duration
    starting	0.34 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.02 ms
    Opening tables	0.71 ms
    After opening tables	0.03 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.18 ms
    optimizing	0.13 ms
    statistics	0.48 ms
    preparing	0.16 ms
    executing	0.02 ms
    Creating tmp table	0.93 ms
    Copying to tmp table	0.12 ms
    Sorting result	0.05 ms
    Sending data	0.12 ms
    end	0.02 ms
    removing tmp table	0.24 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.07 ms
    freeing items	0.04 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

34. **Tempo della query: 3.64 ms** **Dopo l'ultima query: 60.73 ms** **Memoria query: 0.045 MB memoria prima della query: 5.980 MB** **Righe restituite: 0**

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM htlw1_fields AS a
    
      LEFT JOIN `htlw1_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN htlw1_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN htlw1_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN htlw1_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `htlw1_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.categories' 
      AND (fc.category_id IS NULL OR fc.category_id IN (38,0,69)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; **Using filesort**
    1	SIMPLE	l	ALL	NULL	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where; Using index; Distinct

    **Profilo**

    Status	Duration
    starting	0.41 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.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.23 ms
    optimizing	0.14 ms
    statistics	0.40 ms
    preparing	0.17 ms
    executing	0.02 ms
    Creating tmp table	0.91 ms
    Copying to tmp table	0.12 ms
    Sorting result	0.05 ms
    Sending data	0.16 ms
    end	0.02 ms
    removing tmp table	0.26 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    updating status	0.11 ms
    cleaning up	0.03 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    24	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    23	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    22	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    21	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    20	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/layouts/joomla/content/category_default.php:25
    17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
    16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
    15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/templates/beez_20/html/com_content/category/default.php:20
    14	include JROOT/templates/beez_20/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

35. **Tempo della query: 3.17 ms** **Dopo l'ultima query: 3.84 ms** **Memoria query: 0.047 MB memoria prima della query: 6.009 MB** **Righe restituite: 0**

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM htlw1_fields AS a
    
      LEFT JOIN `htlw1_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN htlw1_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN htlw1_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN htlw1_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `htlw1_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'com_content.category.title' 
      AND (fc.category_id IS NULL OR fc.category_id IN (38,0,69)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; **Using filesort**
    1	SIMPLE	l	ALL	NULL	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where; Using index; Distinct

    **Profilo**

    Status	Duration
    starting	0.37 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.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.17 ms
    optimizing	0.12 ms
    statistics	0.34 ms
    preparing	0.16 ms
    executing	0.02 ms
    Creating tmp table	0.78 ms
    Copying to tmp table	0.11 ms
    Sorting result	0.06 ms
    Sending data	0.12 ms
    end	0.02 ms
    removing tmp table	0.22 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.04 ms
    freeing items	0.04 ms
    updating status	0.09 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    29	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    28	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    27	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    26	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    25	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    24	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    23	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    22	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    21	JHtmlContent::prepare()	**Chiamata uguale alla linea sottostante.**
    20	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    19	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    18	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/layouts/joomla/content/category_default.php:57
    17	include JROOT/layouts/joomla/content/category_default.php	JROOT/libraries/src/Layout/FileLayout.php:125
    16	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
    15	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/templates/beez_20/html/com_content/category/default.php:20
    14	include JROOT/templates/beez_20/html/com_content/category/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:697
    13	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
    12	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/libraries/src/MVC/View/CategoryView.php:245
    11	Joomla\CMS\MVC\View\CategoryView->display()	JROOT/components/com_content/views/category/view.html.php:250
    10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.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:56

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

    ---

36. **Tempo della query: 2.31 ms** **Dopo l'ultima query: 37.51 ms** **Memoria query: 0.054 MB memoria prima della query: 6.128 MB** **Righe restituite: 41**

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM htlw1_modules AS m
    
      LEFT JOIN htlw1_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN htlw1_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-01-17 19:05:33') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-17 19:05:33') 
      AND m.access IN (1,1) 
      AND m.client_id = 0 
      AND (mm.menuid = 59 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	43	Using index condition; Using where; **Using filesort**
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	303	c2_ebgh.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	c2_ebgh.m.id	6	Using where; Using index

    **Profilo**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.22 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.04 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    preparing	0.05 ms
    executing	0.01 ms
    Sorting result	0.40 ms
    Sending data	1.01 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    14	JDatabaseDriver->loadObjectList()	**Chiamata uguale alla linea sottostante.**
    13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
    11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
    10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
    8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/beez_20/index.php:15
    7	require JROOT/templates/beez_20/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

37. **Tempo della query: 1.43 ms** **Dopo l'ultima query: 19.48 ms** **Memoria query: 0.042 MB memoria prima della query: 6.326 MB** **Righe restituite: 0**

    SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note
    
      FROM htlw1_fields AS a
    
      LEFT JOIN `htlw1_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN htlw1_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN htlw1_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN htlw1_fields_groups AS g 
      ON g.id = a.group_id
    
      LEFT JOIN `htlw1_fields_categories` AS fc 
      ON fc.field_id = a.id
    
      WHERE a.context = 'mod_custom.content' 
      AND (fc.category_id IS NULL OR fc.category_id IN (38,0)) 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; **Using filesort**
    1	SIMPLE	l	ALL	NULL	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.checked_out	1
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.access	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_user_id	1	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.group_id	1	Using where
    1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where; Using index; Distinct

    **Profilo**

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.07 ms
    optimizing	0.05 ms
    statistics	0.14 ms
    preparing	0.06 ms
    executing	0.01 ms
    Creating tmp table	0.39 ms
    Copying to tmp table	0.05 ms
    Sorting result	0.02 ms
    Sending data	0.04 ms
    end	0.01 ms
    removing tmp table	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.01 ms
    updating status	0.03 ms
    cleaning up	0.01 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    21	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
    20	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
    18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
    17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    14	JHtmlContent::prepare()	**Chiamata uguale alla linea sottostante.**
    13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
    10	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

38. **Tempo della query: 24.23 ms** **Dopo l'ultima query: 7.91 ms** **Memoria query: 0.042 MB memoria prima della query: 6.375 MB** **Righe restituite: 3**

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM htlw1_content AS a
    
      LEFT JOIN htlw1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN htlw1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN htlw1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN htlw1_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid IN (15,17,18,69,66,65,64,63,62,59,42,41,40,39,38,37,36,35,34,70,71,50,72,47,75) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 19:05:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 19:05:33')
    
      ORDER BY a.hits DESC 
      LIMIT 3

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_state	1	const	2544	Using where; **Using filesort**
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	c2_ebgh.a.catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.c.parent_id	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.19 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.11 ms
    optimizing	0.05 ms
    statistics	0.23 ms
    preparing	0.04 ms
    executing	0.01 ms
    Sorting result	22.63 ms
    Sending data	0.48 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.02 ms
    cleaning up	0.01 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/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_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_popular/helper.php:77
    11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

39. **Tempo della query: 1.01 ms** **Dopo l'ultima query: 2.09 ms** **Memoria query: 0.045 MB memoria prima della query: 6.480 MB** **Righe restituite: 3**

    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 `htlw1_categories` AS `s`
    
      INNER JOIN `htlw1_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) 
      AND c.published = 1 
      AND s.id = 39
    
      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	**Using filesort**
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	55	Using where

    **Profilo**

    Status	Duration
    starting	0.15 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
    After table lock	0.02 ms
    init	0.07 ms
    optimizing	0.04 ms
    statistics	0.15 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sorting result	0.10 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    updating status	0.04 ms
    cleaning up	0.01 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	**Chiamata uguale alla linea sottostante.**
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_popular/helper.php:89
    11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

40. **Tempo della query: 1.09 ms** **Dopo l'ultima query: 1.68 ms** **Memoria query: 0.045 MB memoria prima della query: 6.504 MB** **Righe restituite: 3**

    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 `htlw1_categories` AS `s`
    
      INNER JOIN `htlw1_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) 
      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	**Using filesort**
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	55	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    21	ContentRouter->getCategorySegment()	**Chiamata uguale alla linea sottostante.**
    20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    12	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_popular/helper.php:89
    11	ModArticlesPopularHelper::getList()	JROOT/modules/mod_articles_popular/mod_articles_popular.php:15
    10	include JROOT/modules/mod_articles_popular/mod_articles_popular.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

41. **Tempo della query: 2.64 ms** **Dopo l'ultima query: 9.70 ms** **Memoria query: 0.041 MB memoria prima della query: 6.481 MB** **Righe restituite: 2**

    SELECT a.urls, a.images, a.fulltext, a.id, a.title, a.alias, a.introtext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, a.modified, a.modified_by,a.publish_up, a.publish_down, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.featured, LENGTH(a.fulltext) AS readmore,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM htlw1_content AS a
    
      LEFT JOIN htlw1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN htlw1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN htlw1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN htlw1_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.featured = 1 
      AND a.id IN (2655,2656) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 19:05:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 19:05:33')
    
      ORDER BY a.created asc 
      LIMIT 3

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	range	PRIMARY,idx_access,idx_state,idx_catid,idx_featured_catid	PRIMARY	4	NULL	2	Using index condition; Using where; **Using filesort**
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_by	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	c2_ebgh.a.catid	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.c.parent_id	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.44 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.02 ms
    Opening tables	0.06 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.27 ms
    optimizing	0.13 ms
    statistics	0.33 ms
    preparing	0.19 ms
    executing	0.02 ms
    Sorting result	0.15 ms
    Sending data	0.40 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    updating status	0.10 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:169
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

42. **Tempo della query: 1.19 ms** **Dopo l'ultima query: 0.95 ms** **Memoria query: 0.038 MB memoria prima della query: 6.542 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2656 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:169
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

43. **Tempo della query: 1.15 ms** **Dopo l'ultima query: 0.76 ms** **Memoria query: 0.038 MB memoria prima della query: 6.567 MB** **Righe restituite: 0**

    SELECT `m`.`tag_id`,`t`.*
    
      FROM `htlw1_contentitem_tag_map` AS m 
    
      INNER JOIN `htlw1_tags` AS t  
      ON `m`.`tag_id` = `t`.`id`
    
      WHERE `m`.`type_alias` = 'com_content.article' 
      AND `m`.`content_item_id` = 2655 
      AND `t`.`published` = 1 
      AND t.access IN (1,1)

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ALL	idx_tag_type	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	1	Using where
    1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	c2_ebgh.m.tag_id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.12 ms
    checking permissions	0.02 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.02 ms
    After table lock	0.02 ms
    init	0.09 ms
    optimizing	0.06 ms
    statistics	0.13 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sending data	0.12 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
    14	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
    13	ContentModelArticles->getItems()	JROOT/modules/mod_bt_contentslider/classes/content.php:169
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

44. **Tempo della query: 1.90 ms** **Dopo l'ultima query: 0.76 ms** **Memoria query: 0.046 MB memoria prima della query: 6.580 MB** **Righe restituite: 3**

    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 `htlw1_categories` AS `s`
    
      INNER JOIN `htlw1_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) 
      AND c.published = 1 
      AND s.id = 34
    
      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	**Using filesort**
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	55	Using where

    **Profilo**

    Status	Duration
    starting	0.30 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.02 ms
    init	0.13 ms
    optimizing	0.09 ms
    statistics	0.24 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sorting result	0.27 ms
    Sending data	0.27 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    22	ContentRouter->getCategorySegment()	**Chiamata uguale alla linea sottostante.**
    21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_bt_contentslider/classes/content.php:207
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

45. **Tempo della query: 1.86 ms** **Dopo l'ultima query: 2.85 ms** **Memoria query: 0.046 MB memoria prima della query: 6.609 MB** **Righe restituite: 3**

    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 `htlw1_categories` AS `s`
    
      INNER JOIN `htlw1_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) 
      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	**Using filesort**
    1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	**NON È POSSIBILE UTILIZZARE ALCUN INDICE**	NULL	NULL	55	Using where

    **Profilo**

    Status	Duration
    starting	0.26 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.04 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.15 ms
    optimizing	0.09 ms
    statistics	0.23 ms
    preparing	0.06 ms
    executing	0.01 ms
    Sorting result	0.26 ms
    Sending data	0.23 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.05 ms
    updating status	0.08 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    23	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
    22	ContentRouter->getCategorySegment()	**Chiamata uguale alla linea sottostante.**
    21	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
    20	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
    19	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
    18	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
    17	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:131
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:80
    13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_bt_contentslider/classes/content.php:207
    12	BtContentDataSource->getList()	JROOT/modules/mod_bt_contentslider/helpers/helper.php:69
    11	modBtContentSliderHelper::getList()	JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php:21
    10	include JROOT/modules/mod_bt_contentslider/mod_bt_contentslider.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

46. **Tempo della query: 2.51 ms** **Dopo l'ultima query: 58.42 ms** **Memoria query: 0.040 MB memoria prima della query: 6.785 MB** **Righe restituite: 0**

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM htlw1_content AS a
    
      LEFT JOIN htlw1_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN htlw1_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN htlw1_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN htlw1_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN htlw1_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1) 
      AND c.access IN (1,1) 
      AND c.published = 1 
      AND a.state = 1 
      AND a.catid = 3 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-17 19:05:33') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-17 19:05:33')
    
      ORDER BY a.publish_up DESC 
      LIMIT 5

    **Explain**

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1	**Using filesort**
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	c2_ebgh.a.id	1	Using where

    **Profilo**

    Status	Duration
    starting	0.61 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.02 ms
    Opening tables	0.07 ms
    After opening tables	0.02 ms
    System lock	0.02 ms
    Table lock	0.02 ms
    After table lock	0.02 ms
    init	0.30 ms
    optimizing	0.17 ms
    statistics	0.33 ms
    preparing	0.12 ms
    executing	0.02 ms
    Sorting result	0.06 ms
    Sending data	0.16 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.04 ms
    updating status	0.12 ms
    cleaning up	0.02 ms

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
    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_content/models/articles.php:576
    12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
    11	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
    10	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

47. **Tempo della query: 1.16 ms** **Dopo l'ultima query: 93.12 ms** **Memoria query: 0.027 MB memoria prima della query: 7.222 MB** **Righe restituite: 0**

    SELECT uikit
    
      FROM `htlw1_cwgears`
    
      WHERE url = 'https://www.ebgh.it/aree-tematiche/endoscopia.html?start=20'

    **Explain**

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

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:418
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

48. **Tempo della query: 0.56 ms** **Dopo l'ultima query: 0.38 ms** **Memoria query: 0.027 MB memoria prima della query: 7.232 MB** **Righe restituite: 0**

    SELECT uikit_plus
    
      FROM `htlw1_cwgears`
    
      WHERE url = 'https://www.ebgh.it/aree-tematiche/endoscopia.html?start=20'

    **Explain**

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

    **Profilo**

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    After opening tables	0.04 ms
    System lock	0.01 ms
    Table lock	0.01 ms
    After table lock	0.01 ms
    init	0.03 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.04 ms
    end	0.02 ms
    query end	0.02 ms
    closing 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**
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:427
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---

49. **Tempo della query: 0.69 ms** **Dopo l'ultima query: 4.99 ms** **Memoria query: 0.024 MB memoria prima della query: 7.302 MB** **Righe restituite: 0**

    SELECT facebook_js
    
      FROM `htlw1_cwgears`
    
      WHERE url = 'https://www.ebgh.it/aree-tematiche/endoscopia.html?start=20'

    **Explain**

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

    **Profilo**

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

    **Call Stack**

    #	**Caller**	**File e numero di linea**
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:67
    8	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwfacebookjs/cwfacebookjs.php:201
    7	plgSystemCwfacebookjs->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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:56

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

    ---