Questo sito utilizza i cookies. Utilizzando il nostro sito web l'utente dichiara di accettare e acconsentire all’ utilizzo dei cookies in conformità con i termini di uso dei cookies espressi nell'informativa.

**Allegati:**
Verbale consiglio C R del 04032017.doc	[ ]	??ATTACH_S_KB??

Calendario eventi

<< **febbraio** 2019 >>
**	**	**	**	**	**	**
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28

Link utili

**Oggi**243

**Ieri**471

**Questa Settimana**243

**Questo Mese**7807

**Totale**645682

Informazione Visitatore

**IP:** 34.228.143.13
**Browser:** unknown
**Versione Browser:** unknown
**Sistema Operativo:** unknown

Chi è Online

**Online**

****Lunedì**, 18 **Febbraio** 2019 13:03**

Accesso riservato

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1550495036,
                "last": 1550495036,
                "now": 1550495036
            },
            "token": "n8HEvzudAZKPNNtPPvXf9kAn6YTGIsFz"
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cDovL3d3dy5wdWdsaWFicmlkZ2UuaXQvaW5kZXgucGhwL2l0L2NoaS1zaWFtby9pLXZlcmJhbGk%2F"
            }
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "it-IT"
        }
    }
}

Informazioni profilo

Tempo

Memoria

**Tempo**: 27.94 ms / 27.94 ms **Memoria**: 0.468 MB / 0.58 MB Application: afterLoad

**Tempo**: 703.80 ms / 731.74 ms **Memoria**: 5.433 MB / 6.02 MB Application: afterInitialise

**Tempo**: 28.78 ms / 760.52 ms **Memoria**: 0.420 MB / 6.44 MB Application: afterRoute

**Tempo**: 5.93 ms / 766.45 ms **Memoria**: 0.033 MB / 6.47 MB Application: beforeRenderComponent com_content

**Tempo**: 12.56 ms / 779.00 ms **Memoria**: 0.315 MB / 6.78 MB Application: Before JAccess::preloadComponents (all components)

**Tempo**: 1.20 ms / 780.20 ms **Memoria**: 0.069 MB / 6.85 MB Application: After JAccess::preloadComponents (all components)

**Tempo**: 0.07 ms / 780.27 ms **Memoria**: 0.000 MB / 6.85 MB Application: Before JAccess::getAssetRules (id:8 name:com_content)

**Tempo**: 1.35 ms / 781.63 ms **Memoria**: 0.028 MB / 6.88 MB Application: After JAccess::getAssetRules (id:8 name:com_content)

**Tempo**: 96.92 ms / 878.55 ms **Memoria**: 2.117 MB / 9.00 MB Application: Before JAccess::preloadPermissions (com_content)

**Tempo**: 3.14 ms / 881.70 ms **Memoria**: 0.212 MB / 9.21 MB Application: After JAccess::preloadPermissions (com_content)

**Tempo**: 0.10 ms / 881.79 ms **Memoria**: 0.000 MB / 9.20 MB Application: Before JAccess::getAssetRules (id:87 name:com_content.article.12)

**Tempo**: 0.16 ms / 881.95 ms **Memoria**: 0.008 MB / 9.21 MB Application: After JAccess::getAssetRules (id:87 name:com_content.article.12)

**Tempo**: 5.83 ms / 887.78 ms **Memoria**: 0.078 MB / 9.29 MB Application: Before JAccess::getAssetRules (id:99 name:com_attachments)

**Tempo**: 0.15 ms / 887.93 ms **Memoria**: 0.008 MB / 9.29 MB Application: After JAccess::getAssetRules (id:99 name:com_attachments)

**Tempo**: 0.11 ms / 888.05 ms **Memoria**: 0.001 MB / 9.29 MB Application: Before JAccess::getAssetRules (id:1 name:root.1)

**Tempo**: 0.11 ms / 888.15 ms **Memoria**: 0.007 MB / 9.30 MB Application: After JAccess::getAssetRules (id:1 name:root.1)

**Tempo**: 50.86 ms / 939.01 ms **Memoria**: 0.845 MB / 10.15 MB Application: afterRenderComponent com_content

**Tempo**: 17.61 ms / 956.62 ms **Memoria**: 0.320 MB / 10.47 MB Application: afterDispatch

**Tempo**: 18.24 ms / 974.86 ms **Memoria**: 0.211 MB / 10.68 MB Application: beforeRenderModule mod_menu (Bridge )

**Tempo**: 7.81 ms / 982.67 ms **Memoria**: 0.056 MB / 10.73 MB Application: afterRenderModule mod_menu (Bridge )

**Tempo**: 0.81 ms / 983.48 ms **Memoria**: 0.000 MB / 10.72 MB Application: beforeRenderModule mod_jem_cal (Calendario eventi)

**Tempo**: 21.49 ms / 1004.97 ms **Memoria**: 0.559 MB / 11.28 MB Application: afterRenderModule mod_jem_cal (Calendario eventi)

**Tempo**: 1.52 ms / 1006.49 ms **Memoria**: 0.016 MB / 11.30 MB Application: beforeRenderModule mod_menu (Menu 2)

**Tempo**: 8.58 ms / 1015.07 ms **Memoria**: 0.046 MB / 11.34 MB Application: afterRenderModule mod_menu (Menu 2)

**Tempo**: 1.99 ms / 1017.06 ms **Memoria**: 0.019 MB / 11.36 MB Application: beforeRenderModule mod_menu (Link utili)

**Tempo**: 8.14 ms / 1025.20 ms **Memoria**: 0.023 MB / 11.39 MB Application: afterRenderModule mod_menu (Link utili)

**Tempo**: 0.95 ms / 1026.15 ms **Memoria**: 0.000 MB / 11.38 MB Application: beforeRenderModule mod_coalawebtraffic (CoalaWeb Traffic)

**Tempo**: 14.47 ms / 1040.63 ms **Memoria**: 0.261 MB / 11.64 MB Application: afterRenderModule mod_coalawebtraffic (CoalaWeb Traffic)

**Tempo**: 0.09 ms / 1040.72 ms **Memoria**: 0.000 MB / 11.62 MB Application: beforeRenderModule mod_login (Accesso riservato)

**Tempo**: 11.35 ms / 1052.07 ms **Memoria**: 0.126 MB / 11.75 MB Application: afterRenderModule mod_login (Accesso riservato)

**Tempo**: 1.67 ms / 1053.75 ms **Memoria**: 0.030 MB / 11.78 MB Application: beforeRenderModule mod_menu (Menu Principale)

**Tempo**: 33.64 ms / 1087.38 ms **Memoria**: 0.159 MB / 11.94 MB Application: afterRenderModule mod_menu (Menu Principale)

**Tempo**: 39.06 ms / 1126.44 ms **Memoria**: 0.177 MB / 12.11 MB Application: afterRender

**Query totali del database: 483.52 ms**

Utilizzo memoria

Query Database

60 query eseguite 483.52 ms

Trovati 11 duplicati!

**4 duplicati**: #19 #20 #21 #22

**2 duplicati**: #27 #60

**2 duplicati**: #37 #38

**3 duplicati**: #47 #48 #49

**Tempo della query: 0.77 ms**

SELECT `data`

  FROM `pb_session`

  WHERE `session_id` = 'emhirn81tqhb35tee900rn7506'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_session	const	PRIMARY	PRIMARY	766	const	1

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
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:82
10	JSessionHandlerJoomla->start()	JROOT\libraries\joomla\session\session.php:648
9	JSession->_start()	JROOT\libraries\joomla\session\session.php:608
8	JSession->start()	JROOT\libraries\joomla\session\session.php:486
7	JSession->get()	JROOT\libraries\joomla\session\session.php:443
6	JSession->isNew()	JROOT\libraries\cms\application\cms.php:829
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

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

**Tempo della query: 0.59 ms** **Dopo l'ultima query: 2.31 ms**

SELECT `session_id`

  FROM `pb_session`

  WHERE `session_id` = 'emhirn81tqhb35tee900rn7506' 
  LIMIT 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
8	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
7	JDatabaseDriver->loadResult()	JROOT\libraries\cms\application\cms.php:176
6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:831
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

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

**Tempo della query: 1.29 ms** **Dopo l'ultima query: 0.24 ms**

INSERT INTO `pb_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('emhirn81tqhb35tee900rn7506', 1, '1550495036', 0, '', 0)

**Explain**

**EXPLAIN non possibile sulla query: INSERT INTO `pb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('emhirn81tqhb35tee900rn7506', 1, '1550495036', 0, '', 0)**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
7	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\application\cms.php:216
6	JApplicationCms->checkSession()	JROOT\libraries\cms\application\cms.php:831
5	JApplicationCms->loadSession()	JROOT\libraries\cms\application\cms.php:131
4	JApplicationCms->__construct()	JROOT\libraries\cms\application\site.php:63
3	JApplicationSite->__construct()	JROOT\libraries\cms\application\cms.php:413
2	JApplicationCms::getInstance()	JROOT\libraries\joomla\factory.php:125
1	JFactory::getApplication()	JROOT\index.php:46

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

**Tempo della query: 1.27 ms** **Dopo l'ultima query: 10.30 ms**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pb_extensions`

  WHERE `type` = 'component'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_extensions	ref	extension	extension	82	const	37	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\component\helper.php:447
9	JComponentHelper::{closure}()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
7	JCacheControllerCallback->get()	JROOT\libraries\cms\component\helper.php:455
6	JComponentHelper::load()	JROOT\libraries\cms\component\helper.php:43
5	JComponentHelper::getComponent()	JROOT\libraries\cms\component\helper.php:111
4	JComponentHelper::getParams()	JROOT\libraries\cms\application\site.php:593
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.44 ms** **Dopo l'ultima query: 6.22 ms**

SELECT id, rules

  FROM `pb_viewlevels`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_viewlevels	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1486
9	JDatabaseDriver->loadAssocList()	JROOT\libraries\joomla\access\access.php:1061
8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:293
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:603
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.49 ms** **Dopo l'ultima query: 0.26 ms**

SELECT b.id

  FROM pb_usergroups AS a

  LEFT JOIN pb_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT\libraries\joomla\access\access.php:978
9	JAccess::getGroupsByUser()	JROOT\libraries\joomla\access\access.php:1093
8	JAccess::getAuthorisedViewLevels()	JROOT\libraries\joomla\user\user.php:453
7	JUser->getAuthorisedViewLevels()	JROOT\libraries\cms\plugin\helper.php:293
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:603
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 2.20 ms** **Dopo l'ultima query: 4.74 ms**

SELECT `folder` AS `type`,`element` AS `name`,`params`

  FROM pb_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_extensions	ref	extension	extension	82	const	114	Using where; Using filesort

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\plugin\helper.php:311
9	JPluginHelper::{closure}()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
7	JCacheControllerCallback->get()	JROOT\libraries\cms\plugin\helper.php:316
6	JPluginHelper::load()	JROOT\libraries\cms\plugin\helper.php:86
5	JPluginHelper::getPlugin()	JROOT\libraries\cms\plugin\helper.php:128
4	JPluginHelper::isEnabled()	JROOT\libraries\cms\application\site.php:603
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.94 ms** **Dopo l'ultima query: 101.30 ms**

SELECT *

  FROM pb_languages

  WHERE published=1

  ORDER BY ordering ASC

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:148
8	JLanguageHelper::getLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:98
7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\cms\plugin\helper.php:255
6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:170
5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:683
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.69 ms** **Dopo l'ultima query: 1.90 ms**

SELECT `element`,`name`,`client_id`,`extension_id`

  FROM `pb_extensions`

  WHERE `type` = 'language' 
  AND `state` = 0 
  AND `enabled` = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_extensions	ref	extension	extension	82	const	4	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
10	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
9	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\language\helper.php:207
8	JLanguageHelper::getInstalledLanguages()	JROOT\plugins\system\languagefilter\languagefilter.php:109
7	PlgSystemLanguageFilter->__construct()	JROOT\libraries\cms\plugin\helper.php:255
6	JPluginHelper::import()	JROOT\libraries\cms\plugin\helper.php:170
5	JPluginHelper::importPlugin()	JROOT\libraries\cms\application\cms.php:683
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.49 ms** **Dopo l'ultima query: 21.69 ms**

SELECT ip

  FROM `pb_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT\plugins\system\cwtrafficcount\cwtrafficcount.php:106
9	plgSystemCwtrafficCount->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.38 ms** **Dopo l'ultima query: 0.20 ms**

SELECT botname

  FROM `pb_cwtraffic_knownips`

  WHERE state = 1 
  AND count = 0

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1530
10	JDatabaseDriver->loadColumn()	JROOT\plugins\system\cwtrafficcount\cwtrafficcount.php:126
9	plgSystemCwtrafficCount->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 434.15 ms** **Dopo l'ultima query: 0.23 ms**

SELECT count(*)

  FROM `pb_cwtraffic`

  WHERE ip = '34.228.143.13' 
  AND tm + '3600'>'1550495037'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic	index	NULL	unique_tm_ip	156	NULL	645682	Using where; Using index

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT\plugins\system\cwtrafficcount\cwtrafficcount.php:163
9	plgSystemCwtrafficCount->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.83 ms** **Dopo l'ultima query: 0.51 ms**

SELECT count(*)

  FROM `pb_cwtraffic_whoisonline`

  WHERE ip = '585404173'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic_whoisonline	const	ip	ip	8	const	1	Using index

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
10	JDatabaseDriver->loadResult()	JROOT\plugins\system\cwtrafficonline\cwtrafficonline.php:75
9	plgSystemCwtrafficOnline->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.73 ms** **Dopo l'ultima query: 0.32 ms**

UPDATE `pb_cwtraffic_whoisonline`

  SET dt = NOW()

  WHERE ip = '585404173'

**Explain**

**EXPLAIN non possibile sulla query: UPDATE `pb_cwtraffic_whoisonline` SET dt = NOW() WHERE ip = '585404173'**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\database.php:33
10	JDatabase->query()	JROOT\plugins\system\cwtrafficonline\cwtrafficonline.php:114
9	plgSystemCwtrafficOnline->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.57 ms** **Dopo l'ultima query: 0.28 ms**

DELETE 

  FROM `pb_cwtraffic_whoisonline`

  WHERE dt < SUBTIME(NOW(),'0 0:10:0')

**Explain**

**EXPLAIN non possibile sulla query: DELETE FROM `pb_cwtraffic_whoisonline` WHERE dt < SUBTIME(NOW(),'0 0:10:0')**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\database.php:33
10	JDatabase->query()	JROOT\plugins\system\cwtrafficonline\cwtrafficonline.php:120
9	plgSystemCwtrafficOnline->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.72 ms** **Dopo l'ultima query: 2.37 ms**

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `pb_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT\libraries\cms\library\helper.php:166
18	JLibraryHelper::{closure}()	*Chiamata uguale alla linea sottostante.*
17	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
16	JCacheControllerCallback->get()	JROOT\libraries\cms\library\helper.php:174
15	JLibraryHelper::loadLibrary()	JROOT\libraries\cms\library\helper.php:42
14	JLibraryHelper::getLibrary()	JROOT\libraries\cms\library\helper.php:89
13	JLibraryHelper::getParams()	JROOT\libraries\cms\version\version.php:270
12	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:760
11	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
10	JFactory::getDocument()	JROOT\plugins\system\fmalertcookies\fmalertcookies.php:35
9	plgSystemFmAlertCookies->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.12 ms** **Dopo l'ultima query: 0.96 ms**

UPDATE `pb_extensions`

  SET `params` = '{\"mediaversion\":\"d6fef95e33fde0092a08dede53c6b10c\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT\libraries\cms\library\helper.php:116
14	JLibraryHelper::saveParams()	JROOT\libraries\cms\version\version.php:321
13	JVersion->setMediaVersion()	JROOT\libraries\cms\version\version.php:280
12	JVersion->getMediaVersion()	JROOT\libraries\joomla\factory.php:760
11	JFactory::createDocument()	JROOT\libraries\joomla\factory.php:216
10	JFactory::getDocument()	JROOT\plugins\system\fmalertcookies\fmalertcookies.php:35
9	plgSystemFmAlertCookies->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.76 ms** **Dopo l'ultima query: 9.53 ms**

SELECT * 
  FROM pb_extensions 
  WHERE element='mailster' 
  AND folder='system'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
12	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_mailster\mailster\app\PluginUtils.php:219
11	MstPluginUtils::getPlugin()	JROOT\plugins\system\mailster\mailster.php:56
10	plgSystemMailster->initMailPlugin()	JROOT\plugins\system\mailster\mailster.php:77
9	plgSystemMailster->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.81 ms** **Dopo l'ultima query: 22.83 ms**

**Query duplicate**: #20 #21 #22

SELECT extension_id AS "id", element AS "option", params, enabled

  FROM pb_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
17	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_mailster\mailster\app\Application.php:48
16	MstApplication::getComponent()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:44
15	MstConfiguration::getComponentParams()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:144
14	MstConfiguration::getLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:230
13	MstLog::getCurrentLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:214
12	MstLog::loggingLevelSufficient()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:52
11	MstLog::log()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:147
10	MstLog::debug()	JROOT\plugins\system\mailster\mailster.php:96
9	plgSystemMailster->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.50 ms** **Dopo l'ultima query: 3.02 ms**

**Query duplicate**: #19 #21 #22

SELECT extension_id AS "id", element AS "option", params, enabled

  FROM pb_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
19	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_mailster\mailster\app\Application.php:48
17	MstApplication::getComponent()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:44
16	MstConfiguration::getComponentParams()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:144
15	MstConfiguration::getLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:230
14	MstLog::getCurrentLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:214
13	MstLog::loggingLevelSufficient()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:52
12	MstLog::log()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:147
11	MstLog::debug()	JROOT\plugins\system\mailster\mailster.php:254
10	plgSystemMailster->isMailRetrievingRequired()	JROOT\plugins\system\mailster\mailster.php:97
9	plgSystemMailster->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.46 ms** **Dopo l'ultima query: 2.97 ms**

**Query duplicate**: #19 #20 #22

SELECT extension_id AS "id", element AS "option", params, enabled

  FROM pb_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
19	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
18	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_mailster\mailster\app\Application.php:48
17	MstApplication::getComponent()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:44
16	MstConfiguration::getComponentParams()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:144
15	MstConfiguration::getLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:230
14	MstLog::getCurrentLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:214
13	MstLog::loggingLevelSufficient()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:52
12	MstLog::log()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:147
11	MstLog::debug()	JROOT\plugins\system\mailster\mailster.php:266
10	plgSystemMailster->isMailSendingRequired()	JROOT\plugins\system\mailster\mailster.php:119
9	plgSystemMailster->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.49 ms** **Dopo l'ultima query: 4.37 ms**

**Query duplicate**: #19 #20 #21

SELECT extension_id AS "id", element AS "option", params, enabled

  FROM pb_extensions

  WHERE `type` = 'component' 
  AND `element` = 'com_mailster'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
20	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
19	JDatabaseDriver->loadObject()	JROOT\administrator\components\com_mailster\mailster\app\Application.php:48
18	MstApplication::getComponent()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:44
17	MstConfiguration::getComponentParams()	JROOT\administrator\components\com_mailster\mailster\conf\Configuration.php:144
16	MstConfiguration::getLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:230
15	MstLog::getCurrentLoggingLevel()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:214
14	MstLog::loggingLevelSufficient()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:52
13	MstLog::log()	JROOT\administrator\components\com_mailster\mailster\app\Log.php:147
12	MstLog::debug()	JROOT\plugins\system\mailster\mailster.php:278
11	plgSystemMailster->isMaintenanceRequired()	JROOT\plugins\system\mailster\mailster.php:161
10	plgSystemMailster->handleMaintenance()	JROOT\plugins\system\mailster\mailster.php:142
9	plgSystemMailster->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.92 ms** **Dopo l'ultima query: 8.55 ms**

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 pb_menu AS m

  LEFT JOIN pb_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	46	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.m.component_id	1

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
24	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\menu\site.php:88
22	JMenuSite->{closure}()	*Chiamata uguale alla linea sottostante.*
21	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
20	JCacheControllerCallback->get()	JROOT\libraries\cms\menu\site.php:96
19	JMenuSite->load()	JROOT\libraries\cms\menu\menu.php:74
18	JMenu->__construct()	JROOT\libraries\cms\menu\site.php:57
17	JMenuSite->__construct()	JROOT\libraries\cms\menu\menu.php:129
16	JMenu::getInstance()	JROOT\libraries\cms\application\cms.php:444
15	JApplicationCms->getMenu()	JROOT\libraries\cms\application\site.php:272
14	JApplicationSite->getMenu()	JROOT\libraries\cms\router\site.php:59
13	JRouterSite->__construct()	JROOT\libraries\cms\router\router.php:198
12	JRouter::getInstance()	JROOT\libraries\cms\application\cms.php:549
11	JApplicationCms::getRouter()	JROOT\libraries\cms\application\site.php:402
10	JApplicationSite::getRouter()	JROOT\plugins\system\languagefilter\languagefilter.php:130
9	PlgSystemLanguageFilter->onAfterInitialise()	*Chiamata uguale alla linea sottostante.*
8	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
7	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
5	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:684
4	JApplicationCms->initialiseApp()	JROOT\libraries\cms\application\site.php:685
3	JApplicationSite->initialiseApp()	JROOT\libraries\cms\application\site.php:209
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.01 ms** **Dopo l'ultima query: 37.37 ms**

SELECT id, home, template, s.params

  FROM pb_template_styles as s

  LEFT JOIN pb_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 E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	Sql835257_1.s.template,const	1	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
6	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
5	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\application\site.php:485
4	JApplicationSite->getTemplate()	JROOT\libraries\cms\application\site.php:165
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.60 ms** **Dopo l'ultima query: 14.76 ms**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `pb_assets`

  WHERE `name` IN ('com_acymailing','com_admin','com_ajax','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jem','com_joomlaupdate','com_languages','com_login','com_mailster','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper') OR `parent_id` = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_assets	ALL	idx_asset_name,idx_parent_id	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	226	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\access\access.php:427
16	JAccess::preloadComponents()	JROOT\libraries\joomla\access\access.php:211
15	JAccess::preload()	JROOT\libraries\joomla\access\access.php:529
14	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:181
13	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
12	JUser->authorise()	JROOT\components\com_content\models\article.php:55
11	ContentModelArticle->populateState()	JROOT\libraries\legacy\model\legacy.php:434
10	JModelLegacy->getState()	JROOT\components\com_content\models\article.php:248
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.36 ms** **Dopo l'ultima query: 3.27 ms**

SHOW FULL COLUMNS 
  FROM `pb_content`

**Explain**

**EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `pb_content`**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:244
13	JTable->getFields()	JROOT\libraries\joomla\table\table.php:163
12	JTable->__construct()	JROOT\libraries\legacy\table\content.php:33
11	JTableContent->__construct()	JROOT\libraries\joomla\table\table.php:311
10	JTable::getInstance()	JROOT\components\com_content\models\article.php:250
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.78 ms** **Dopo l'ultima query: 7.24 ms**

**Query duplicate**: #60

SELECT *

  FROM pb_content

  WHERE `id` = '12'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1445
11	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:729
10	JTable->load()	JROOT\components\com_content\models\article.php:251
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.80 ms** **Dopo l'ultima query: 0.38 ms**

UPDATE pb_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '12'

**Explain**

**EXPLAIN non possibile sulla query: UPDATE pb_content SET `hits` = (`hits` + 1) WHERE `id` = '12'**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\table\table.php:1240
10	JTable->hit()	JROOT\components\com_content\models\article.php:252
9	ContentModelArticle->hit()	JROOT\components\com_content\controller.php:109
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.37 ms** **Dopo l'ultima query: 8.82 ms**

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM pb_content AS a

  INNER JOIN pb_categories AS c 
  on c.id = a.catid

  LEFT JOIN pb_users AS u 
  on u.id = a.created_by

  LEFT JOIN pb_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN pb_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 12 
  AND c.published > 0 
  AND a.language in ('it-IT','*') 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-02-18 13:03:57') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-02-18 13:03:57') 
  AND (a.state = 1 OR a.state =2)

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid,idx_language	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
15	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1642
14	JDatabaseDriver->loadObject()	JROOT\components\com_content\models\article.php:148
13	ContentModelArticle->getItem()	JROOT\libraries\legacy\view\legacy.php:422
12	JViewLegacy->get()	JROOT\components\com_content\views\article\view.html.php:42
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.04 ms** **Dopo l'ultima query: 7.59 ms**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM pb_categories as c

  LEFT JOIN pb_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('it-IT','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=2

  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,idx_language	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
24	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
23	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:304
22	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
21	JCategories->get()	JROOT\components\com_content\router.php:72
20	ContentRouter->getCategorySegment()	*Chiamata uguale alla linea sottostante.*
19	call_user_func_array()	JROOT\libraries\cms\component\router\view.php:117
18	JComponentRouterView->getPath()	JROOT\libraries\cms\component\router\rules\menu.php:82
17	JComponentRouterRulesMenu->preprocess()	JROOT\libraries\cms\component\router\view.php:219
16	JComponentRouterView->preprocess()	JROOT\libraries\cms\router\site.php:660
15	JRouterSite->processBuildRules()	JROOT\libraries\cms\router\router.php:267
14	JRouter->build()	JROOT\libraries\cms\router\site.php:149
13	JRouterSite->build()	JROOT\libraries\joomla\application\route.php:62
12	JRoute::_()	JROOT\components\com_content\views\article\view.html.php:71
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.87 ms** **Dopo l'ultima query: 0.97 ms**

SELECT `m`.`tag_id`,`t`.*

  FROM `pb_contentitem_tag_map` AS m 

  INNER JOIN `pb_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 12 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
13	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\helper\tags.php:450
12	JHelperTags->getItemTags()	JROOT\components\com_content\views\article\view.html.php:180
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.67 ms** **Dopo l'ultima query: 32.52 ms**

SELECT 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

  FROM pb_fields AS a

  LEFT JOIN `pb_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN pb_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN pb_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN pb_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN pb_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `pb_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 (2,0)) 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  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 filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	Sql835257_1.a.language	1
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.a.access	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.a.created_user_id	1
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	Sql835257_1.a.id	1	Using where; Using index

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
21	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\model\legacy.php:307
19	JModelLegacy->_getList()	JROOT\administrator\components\com_fields\models\fields.php:326
18	FieldsModelFields->_getList()	JROOT\libraries\legacy\model\list.php:186
17	JModelList->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:134
16	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:378
15	PlgSystemFields->onContentPrepare()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:190
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.62 ms** **Dopo l'ultima query: 27.73 ms**

SELECT created_by, catid

  FROM pb_content

  WHERE id = 12

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
17	JDatabaseDriver->loadObjectList()	JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:811
16	AttachmentsPlugin_Com_Content->attachmentsHiddenForParent()	JROOT\plugins\content\attachments\attachments.php:296
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.97 ms** **Dopo l'ultima query: 1.82 ms**

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `pb_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	pb_assets	ALL	idx_asset_name,idx_parent_id	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	226	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
25	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
24	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\access\access.php:357
23	JAccess::preloadPermissions()	JROOT\libraries\joomla\access\access.php:224
22	JAccess::preload()	JROOT\libraries\joomla\access\access.php:538
21	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:181
20	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
19	JUser->authorise()	JROOT\administrator\components\com_attachments\permissions.php:125
18	AttachmentsPermissions::userMayEditArticle()	JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:886
17	AttachmentsPlugin_Com_Content->userMayAddAttachment()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:862
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.21 ms** **Dopo l'ultima query: 7.57 ms**

SELECT a.*, u.name as creator_name

  FROM pb_attachments AS a

  LEFT JOIN pb_users AS u 
  ON u.id = a.created_by

  WHERE a.parent_id=12 
  AND a.state = 1 
  AND a.parent_type='com_content' 
  AND a.parent_entity='article' 
  AND a.access IN (1,5)

  ORDER BY filename

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	54	Using where; Using filesort
1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.a.created_by	1

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
21	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT\components\com_attachments\models\attachments.php:436
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT\components\com_attachments\models\attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT\components\com_attachments\controllers\attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.31 ms** **Dopo l'ultima query: 3.44 ms**

SHOW FULL COLUMNS 
  FROM `pb_assets`

**Explain**

**EXPLAIN non possibile sulla query: SHOW FULL COLUMNS FROM `pb_assets`**

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
31	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
30	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:440
29	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\joomla\table\table.php:244
28	JTable->getFields()	JROOT\libraries\joomla\table\table.php:163
27	JTable->__construct()	JROOT\libraries\joomla\table\asset.php:60
26	JTableAsset->__construct()	JROOT\libraries\joomla\table\table.php:311
25	JTable::getInstance()	JROOT\libraries\joomla\access\access.php:781
24	JAccess::getAssetId()	JROOT\libraries\joomla\access\access.php:542
23	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:181
22	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
21	JUser->authorise()	JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:1008
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT\components\com_attachments\models\attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT\components\com_attachments\models\attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT\components\com_attachments\controllers\attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.69 ms** **Dopo l'ultima query: 0.40 ms**

**Query duplicate**: #38

SELECT *

  FROM pb_assets

  WHERE `name` = 'edit'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
27	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:729
25	JTable->load()	JROOT\libraries\joomla\access\access.php:782
24	JAccess::getAssetId()	JROOT\libraries\joomla\access\access.php:542
23	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:181
22	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
21	JUser->authorise()	JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:1008
20	AttachmentsPlugin_Com_Content->userMayDeleteAttachment()	JROOT\components\com_attachments\models\attachments.php:462
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT\components\com_attachments\models\attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT\components\com_attachments\controllers\attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.41 ms** **Dopo l'ultima query: 1.18 ms**

**Query duplicate**: #37

SELECT *

  FROM pb_assets

  WHERE `name` = 'edit'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
27	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1445
26	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:729
25	JTable->load()	JROOT\libraries\joomla\access\access.php:782
24	JAccess::getAssetId()	JROOT\libraries\joomla\access\access.php:542
23	JAccess::getAssetRules()	JROOT\libraries\joomla\access\access.php:181
22	JAccess::check()	JROOT\libraries\joomla\user\user.php:393
21	JUser->authorise()	JROOT\plugins\attachments\attachments_for_content\attachments_for_content.php:915
20	AttachmentsPlugin_Com_Content->userMayEditAttachment()	JROOT\components\com_attachments\models\attachments.php:463
19	AttachmentsModelAttachments->getAttachmentsList()	JROOT\components\com_attachments\models\attachments.php:514
18	AttachmentsModelAttachments->someVisible()	JROOT\components\com_attachments\controllers\attachments.php:98
17	AttachmentsControllerAttachments->displayString()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.63 ms** **Dopo l'ultima query: 10.12 ms**

SELECT id

  FROM pb_content

  WHERE id=12 
  LIMIT 1

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
23	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
22	JDatabaseDriver->loadResult()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:648
21	AttachmentsPlugin->parentExists()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:344
20	AttachmentsPlugin->getTitle()	JROOT\components\com_attachments\models\attachments.php:254
19	AttachmentsModelAttachments->getParentTitle()	JROOT\components\com_attachments\views\attachments\view.html.php:152
18	AttachmentsViewAttachments->display()	JROOT\components\com_attachments\controllers\attachments.php:132
17	AttachmentsControllerAttachments->displayString()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.95 ms** **Dopo l'ultima query: 0.24 ms**

SELECT title

  FROM pb_content

  WHERE id=12

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
22	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
21	JDatabaseDriver->loadResult()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:359
20	AttachmentsPlugin->getTitle()	JROOT\components\com_attachments\models\attachments.php:254
19	AttachmentsModelAttachments->getParentTitle()	JROOT\components\com_attachments\views\attachments\view.html.php:152
18	AttachmentsViewAttachments->display()	JROOT\components\com_attachments\controllers\attachments.php:132
17	AttachmentsControllerAttachments->displayString()	JROOT\plugins\attachments\attachments_plugin_framework\attachments_plugin.php:911
16	AttachmentsPlugin->insertAttachmentsList()	JROOT\plugins\content\attachments\attachments.php:302
15	plgContentAttachments->onContentBeforeDisplay()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
13	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT\components\com_content\views\article\view.html.php:196
11	ContentViewArticle->display()	JROOT\libraries\joomla\cache\controller\view.php:98
10	JCacheControllerView->get()	JROOT\libraries\legacy\controller\legacy.php:662
9	JControllerLegacy->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\legacy\controller\legacy.php:709
7	JControllerLegacy->execute()	JROOT\components\com_content\content.php:39
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\cms\component\helper.php:389
5	JComponentHelper::executeComponent()	JROOT\libraries\cms\component\helper.php:364
4	JComponentHelper::renderComponent()	JROOT\libraries\cms\application\site.php:191
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.55 ms** **Dopo l'ultima query: 30.36 ms**

SELECT language,id

  FROM `pb_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_menu	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	47	Using where

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\multilang.php:106
9	JLanguageMultilang::getSiteHomePages()	JROOT\plugins\system\languagefilter\languagefilter.php:718
8	PlgSystemLanguageFilter->onAfterDispatch()	*Chiamata uguale alla linea sottostante.*
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.61 ms** **Dopo l'ultima query: 0.39 ms**

SELECT `alias`

  FROM `pb_content`

  WHERE id = '12'

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
19	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT\components\com_content\router.php:125
17	ContentRouter->getArticleSegment()	*Chiamata uguale alla linea sottostante.*
16	call_user_func_array()	JROOT\libraries\cms\component\router\view.php:117
15	JComponentRouterView->getPath()	JROOT\libraries\cms\component\router\rules\menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT\libraries\cms\component\router\view.php:219
13	JComponentRouterView->preprocess()	JROOT\libraries\cms\router\site.php:660
12	JRouterSite->processBuildRules()	JROOT\libraries\cms\router\router.php:267
11	JRouter->build()	JROOT\libraries\cms\router\site.php:149
10	JRouterSite->build()	JROOT\libraries\joomla\application\route.php:62
9	JRoute::_()	JROOT\plugins\system\languagefilter\languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	*Chiamata uguale alla linea sottostante.*
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.13 ms** **Dopo l'ultima query: 0.33 ms**

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
			c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
			c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
			c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM pb_categories as c

  LEFT JOIN pb_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('it-IT','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id=12

  ORDER BY c.lft

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
21	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\categories\categories.php:304
19	JCategories->_load()	JROOT\libraries\legacy\categories\categories.php:184
18	JCategories->get()	JROOT\components\com_content\router.php:72
17	ContentRouter->getCategorySegment()	*Chiamata uguale alla linea sottostante.*
16	call_user_func_array()	JROOT\libraries\cms\component\router\view.php:121
15	JComponentRouterView->getPath()	JROOT\libraries\cms\component\router\rules\menu.php:82
14	JComponentRouterRulesMenu->preprocess()	JROOT\libraries\cms\component\router\view.php:219
13	JComponentRouterView->preprocess()	JROOT\libraries\cms\router\site.php:660
12	JRouterSite->processBuildRules()	JROOT\libraries\cms\router\router.php:267
11	JRouter->build()	JROOT\libraries\cms\router\site.php:149
10	JRouterSite->build()	JROOT\libraries\joomla\application\route.php:62
9	JRoute::_()	JROOT\plugins\system\languagefilter\languagefilter.php:729
8	PlgSystemLanguageFilter->onAfterDispatch()	*Chiamata uguale alla linea sottostante.*
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.82 ms** **Dopo l'ultima query: 2.89 ms**

SELECT `c2`.`language`,`c2`.`id`

  FROM `pb_menu` AS `c`

  INNER JOIN `pb_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `pb_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `pb_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 109

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
12	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
11	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\associations.php:101
10	JLanguageAssociations::getAssociations()	JROOT\administrator\components\com_menus\helpers\menus.php:314
9	MenusHelper::getAssociations()	JROOT\plugins\system\languagefilter\languagefilter.php:735
8	PlgSystemLanguageFilter->onAfterDispatch()	*Chiamata uguale alla linea sottostante.*
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.04 ms** **Dopo l'ultima query: 3.11 ms**

SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`

  FROM `pb_content` AS `c`

  INNER JOIN `pb_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'

  INNER JOIN `pb_associations` AS `a2` 
  ON a.key = a2.key

  INNER JOIN `pb_content` AS `c2` 
  ON a2.id = c2.`id`

  INNER JOIN `pb_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'

  WHERE c.id = 12

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT\libraries\cms\language\associations.php:101
11	JLanguageAssociations::getAssociations()	JROOT\components\com_content\helpers\association.php:43
10	ContentHelperAssociation::getAssociations()	*Chiamata uguale alla linea sottostante.*
9	call_user_func()	JROOT\plugins\system\languagefilter\languagefilter.php:750
8	PlgSystemLanguageFilter->onAfterDispatch()	*Chiamata uguale alla linea sottostante.*
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\site.php:196
3	JApplicationSite->dispatch()	JROOT\libraries\cms\application\site.php:230
2	JApplicationSite->doExecute()	JROOT\libraries\cms\application\cms.php:265
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 1.95 ms** **Dopo l'ultima query: 14.96 ms**

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM pb_modules AS m

  LEFT JOIN pb_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN pb_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 <= '2019-02-18 13:03:57') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-02-18 13:03:57') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 109 OR mm.menuid <= 0) 
  AND m.language IN ('it-IT','*')

  ORDER BY m.position, m.ordering

**Explain**

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

**Profilo**

**Nessun SHOW PROFILE (forse perchè ci sono meno di 100 query)**

**Call Stack**

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
15	JDatabaseDriver->loadObjectList()	*Chiamata uguale alla linea sottostante.*
14	call_user_func_array()	JROOT\libraries\joomla\cache\controller\callback.php:169
13	JCacheControllerCallback->get()	JROOT\libraries\cms\module\helper.php:424
12	JModuleHelper::getModuleList()	JROOT\libraries\cms\module\helper.php:360
11	JModuleHelper::load()	JROOT\libraries\cms\module\helper.php:84
10	JModuleHelper::getModules()	JROOT\libraries\joomla\document\html.php:576
9	JDocumentHtml->countModules()	JROOT\templates\pugliabridge\library\Artx\Page.php:43
8	ArtxPage->containsModules()	JROOT\templates\pugliabridge\index.php:72
7	require JROOT\templates\pugliabridge\index.php	JROOT\libraries\joomla\document\html.php:653
6	JDocumentHtml->_loadTemplate()	JROOT\libraries\joomla\document\html.php:715
5	JDocumentHtml->_fetchTemplate()	JROOT\libraries\joomla\document\html.php:530
4	JDocumentHtml->parse()	JROOT\libraries\cms\application\cms.php:1102
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.47 ms** **Dopo l'ultima query: 31.10 ms**

**Query duplicate**: #48 #49

SELECT globalattribs

  FROM pb_jem_settings

  WHERE id = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_jem_settings	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

**Profilo**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
14	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
13	JDatabaseDriver->loadResult()	JROOT\components\com_jem\helpers\helper.php:67
12	JemHelper::globalattribs()	JROOT\modules\mod_jem_cal\helper.php:36
11	modjemcalqhelper::getdays()	JROOT\modules\mod_jem_cal\mod_jem_cal.php:122
10	include JROOT\modules\mod_jem_cal\mod_jem_cal.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.44 ms** **Dopo l'ultima query: 0.42 ms**

**Query duplicate**: #47 #49

SELECT globalattribs

  FROM pb_jem_settings

  WHERE id = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_jem_settings	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
17	JDatabaseDriver->loadResult()	JROOT\components\com_jem\helpers\helper.php:67
16	JemHelper::globalattribs()	JROOT\components\com_jem\models\eventslist.php:223
15	JemModelEventslist->getListQuery()	JROOT\libraries\legacy\model\list.php:132
14	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:186
13	JModelList->getItems()	JROOT\components\com_jem\models\eventslist.php:487
12	JemModelEventslist->getItems()	JROOT\modules\mod_jem_cal\helper.php:88
11	modjemcalqhelper::getdays()	JROOT\modules\mod_jem_cal\mod_jem_cal.php:122
10	include JROOT\modules\mod_jem_cal\mod_jem_cal.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.41 ms** **Dopo l'ultima query: 0.41 ms**

**Query duplicate**: #47 #48

SELECT globalattribs

  FROM pb_jem_settings

  WHERE id = 1

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_jem_settings	system	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
19	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
18	JDatabaseDriver->loadResult()	JROOT\components\com_jem\helpers\helper.php:67
17	JemHelper::globalattribs()	JROOT\components\com_jem\models\eventslist.php:571
16	JemModelEventslist->getCategories()	JROOT\components\com_jem\models\eventslist.php:377
15	JemModelEventslist->getListQuery()	JROOT\libraries\legacy\model\list.php:132
14	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:186
13	JModelList->getItems()	JROOT\components\com_jem\models\eventslist.php:487
12	JemModelEventslist->getItems()	JROOT\modules\mod_jem_cal\helper.php:88
11	modjemcalqhelper::getdays()	JROOT\modules\mod_jem_cal\mod_jem_cal.php:122
10	include JROOT\modules\mod_jem_cal\mod_jem_cal.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.46 ms** **Dopo l'ultima query: 0.31 ms**

SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi

  FROM pb_jem_categories as c

  LEFT JOIN pb_jem_cats_event_relations AS rel 
  ON rel.catid = c.id

  LEFT JOIN pb_jem_events AS a 
  ON a.id = rel.itemid

  WHERE c.published = 1 
  AND (c.access IN (1,1,5))

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where; Using temporary
1	SIMPLE	rel	ref	category event relation,catid	category event relation	4	Sql835257_1.c.id	1	Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.rel.itemid	1	Using index

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
18	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1530
17	JDatabaseDriver->loadColumn()	JROOT\components\com_jem\models\eventslist.php:691
16	JemModelEventslist->getCategories()	JROOT\components\com_jem\models\eventslist.php:377
15	JemModelEventslist->getListQuery()	JROOT\libraries\legacy\model\list.php:132
14	JModelList->_getListQuery()	JROOT\libraries\legacy\model\list.php:186
13	JModelList->getItems()	JROOT\components\com_jem\models\eventslist.php:487
12	JemModelEventslist->getItems()	JROOT\modules\mod_jem_cal\helper.php:88
11	modjemcalqhelper::getdays()	JROOT\modules\mod_jem_cal\mod_jem_cal.php:122
10	include JROOT\modules\mod_jem_cal\mod_jem_cal.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.90 ms** **Dopo l'ultima query: 0.31 ms**

SELECT a.access,a.alias,a.attribs,a.author_ip,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,l.alias AS l_alias,l.author_ip AS l_authorip,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug

  FROM pb_jem_events as a

  LEFT JOIN pb_jem_venues AS l 
  ON l.id = a.locid

  LEFT JOIN pb_jem_countries AS ct 
  ON ct.iso2 = l.country

  LEFT JOIN pb_jem_cats_event_relations AS rel 
  ON rel.itemid = a.id

  LEFT JOIN pb_jem_categories AS c 
  ON c.id = rel.catid

  WHERE a.access IN (1,1,5) 
  AND a.published = 1 
  AND a.dates IS NOT NULL 
  AND c.id  IN (1,5)

  GROUP BY a.id

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	index	PRIMARY	PRIMARY	4	NULL	5	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	rel	ref	category event relation,catid,itemid	category event relation	4	Sql835257_1.c.id	1	Using where; Using index
1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.rel.itemid	1	Using where
1	SIMPLE	l	eq_ref	PRIMARY	PRIMARY	4	Sql835257_1.a.locid	1
1	SIMPLE	ct	ref	iso2	iso2	8	Sql835257_1.l.country	1

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.05 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.03 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
16	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\legacy\model\legacy.php:307
14	JModelLegacy->_getList()	JROOT\libraries\legacy\model\list.php:186
13	JModelList->getItems()	JROOT\components\com_jem\models\eventslist.php:487
12	JemModelEventslist->getItems()	JROOT\modules\mod_jem_cal\helper.php:88
11	modjemcalqhelper::getdays()	JROOT\modules\mod_jem_cal\mod_jem_cal.php:122
10	include JROOT\modules\mod_jem_cal\mod_jem_cal.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.51 ms** **Dopo l'ultima query: 30.51 ms**

SELECT TCOUNT

  FROM `pb_cwtraffic_total`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic_total	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:80
11	mod_coalawebtrafficHelper->read()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:69
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.38 ms** **Dopo l'ultima query: 0.20 ms**

SELECT count(*)

  FROM `pb_cwtraffic`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Select tables optimized away

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:87
11	mod_coalawebtrafficHelper->read()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:69
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.39 ms** **Dopo l'ultima query: 0.21 ms**

SELECT count(*)

  FROM `pb_cwtraffic`

  WHERE tm > '1550448000'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	97	Using where; Using index

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:97
11	mod_coalawebtrafficHelper->read()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:69
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.37 ms** **Dopo l'ultima query: 0.22 ms**

SELECT count(*)

  FROM `pb_cwtraffic`

  WHERE tm > '1550361600' 
  AND tm < '1550448000'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	170	Using where; Using index

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:106
11	mod_coalawebtrafficHelper->read()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:69
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.39 ms** **Dopo l'ultima query: 0.22 ms**

SELECT count(*)

  FROM `pb_cwtraffic`

  WHERE tm >= '1550448000'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	97	Using where; Using index

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.00 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.01 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:114
11	mod_coalawebtrafficHelper->read()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:69
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.36 ms** **Dopo l'ultima query: 0.21 ms**

SELECT count(*)

  FROM `pb_cwtraffic`

  WHERE tm >= '1548979200'

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pb_cwtraffic	range	unique_tm_ip	unique_tm_ip	4	NULL	4251	Using where; Using index

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.00 ms
sending cached result to clien	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:122
11	mod_coalawebtrafficHelper->read()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:69
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.52 ms** **Dopo l'ultima query: 0.73 ms**

SELECT count(*)

  FROM `pb_cwtraffic_whoisonline`

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	NULL	Select tables optimized away

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
System lock	0.01 ms
Waiting for query cache lock	0.01 ms
Waiting on query cache mutex	0.04 ms
init	0.01 ms
optimizing	0.00 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1720
12	JDatabaseDriver->loadResult()	JROOT\modules\mod_coalawebtraffic\helper.php:137
11	mod_coalawebtrafficHelper::getRealCount()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:124
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.99 ms** **Dopo l'ultima query: 0.23 ms**

SELECT a.country_code, a.country_name, COUNT(1) as num

  FROM `pb_cwtraffic_whoisonline` AS `a`

  WHERE `a`.`country_code` IS NOT NULL 

  GROUP BY a.country_code, a.country_name

  ORDER BY `num` DESC  
  LIMIT 5

**Explain**

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	countrycode	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using where; Using temporary; Using filesort

**Profilo**

Status	Duration
starting	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.04 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.00 ms
Copying to tmp table	0.29 ms
Sorting result	0.01 ms
Sending data	0.01 ms
end	0.00 ms
removing tmp table	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.06 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.00 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
13	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1681
12	JDatabaseDriver->loadObjectList()	JROOT\modules\mod_coalawebtraffic\helper.php:153
11	mod_coalawebtrafficHelper::getCountries()	JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php:125
10	include JROOT\modules\mod_coalawebtraffic\mod_coalawebtraffic.php	JROOT\libraries\cms\module\helper.php:198
9	JModuleHelper::renderModule()	JROOT\libraries\joomla\document\renderer\html\module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT\libraries\joomla\document\renderer\html\modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT\libraries\joomla\document\html.php:486
6	JDocumentHtml->getBuffer()	JROOT\libraries\joomla\document\html.php:777
5	JDocumentHtml->_renderTemplate()	JROOT\libraries\joomla\document\html.php:552
4	JDocumentHtml->render()	JROOT\libraries\cms\application\cms.php:1116
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

**Tempo della query: 0.91 ms** **Dopo l'ultima query: 83.33 ms**

**Query duplicate**: #27

SELECT *

  FROM pb_content

  WHERE `id` = '12'

**Explain**

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

**Profilo**

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
System lock	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
init	0.04 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.02 ms
freeing items	0.01 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.04 ms
freeing items	0.02 ms
Waiting for query cache lock	0.00 ms
Waiting on query cache mutex	0.00 ms
freeing items	0.00 ms
storing result in query cache	0.02 ms
logging slow query	0.00 ms
cleaning up	0.00 ms

**Call Stack**

#	Caller	File e numero di linea
11	JDatabaseDriverMysql->execute()	JROOT\libraries\joomla\database\driver.php:1445
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\table\table.php:729
9	JTable->load()	JROOT\plugins\content\facebooklikeandshare\facebooklikeandshare.php:374
8	plgContentfacebooklikeandshare->onAfterRender()	*Chiamata uguale alla linea sottostante.*
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\joomla\application\base.php:106
4	JApplicationBase->triggerEvent()	JROOT\libraries\cms\application\cms.php:1122
3	JApplicationCms->render()	JROOT\libraries\cms\application\site.php:777
2	JApplicationSite->render()	JROOT\libraries\cms\application\cms.php:271
1	JApplicationCms->execute()	JROOT\index.php:49

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

46 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

**5 × SELECT count(*)
 
  FROM `pb_cwtraffic`**

**4 × SELECT extension_id AS "id", element AS "option", params, enabled
 
  FROM pb_extensions**

**3 × SELECT globalattribs
 
  FROM pb_jem_settings**

**2 × SELECT `id`,`name`,`rules`,`parent_id`
 
  FROM `pb_assets`**

```
**2 × SELECT *
 
  FROM pb_assets**
```
```
**2 × SELECT *
 
  FROM pb_content**
```

**2 × 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 pb_categories as c
 
  LEFT JOIN pb_categories AS s 
  ON (s.lft < c.lft 
  AND s.rgt > c.rgt 
  AND c.language in ('it-IT','*')) OR (s.lft >= c.lft 
  AND s.rgt <= c.rgt)**

**2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
 
  FROM `pb_extensions`**

**1 × SELECT `c2`.`language`,`c2`.`id`
 
  FROM `pb_menu` AS `c`
 
  INNER JOIN `pb_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'
 
  INNER JOIN `pb_associations` AS `a2` 
  ON a.key = a2.key
 
  INNER JOIN `pb_menu` AS `c2` 
  ON a2.id = c2.`id`**

**1 × SELECT `c2`.`language`,CONCAT_WS(':', `c2`.`id`, `c2`.`alias`) AS `id`,CONCAT_WS(':', ca.id, ca.alias) AS `catid`
 
  FROM `pb_content` AS `c`
 
  INNER JOIN `pb_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_content.item'
 
  INNER JOIN `pb_associations` AS `a2` 
  ON a.key = a2.key
 
  INNER JOIN `pb_content` AS `c2` 
  ON a2.id = c2.`id`
 
  INNER JOIN `pb_categories` AS `ca` 
  ON `c2`.`catid` = ca.id 
  AND ca.extension = 'com_content'**

**1 × SELECT `alias`
 
  FROM `pb_content`**

**1 × SELECT title
 
  FROM pb_content**

```
**1 × SELECT id
 
  FROM pb_content**
```

**1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 
  FROM pb_modules AS m
 
  LEFT JOIN pb_modules_menu AS mm 
  ON mm.moduleid = m.id
 
  LEFT JOIN pb_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id**

**1 × SELECT language,id
 
  FROM `pb_menu`**

**1 × SELECT `session_id`
 
  FROM `pb_session`**

**1 × SELECT count(*)
 
  FROM `pb_cwtraffic_whoisonline**

**1 × SELECT a.country_code, a.country_name, COUNT(1) as num
 
  FROM `pb_cwtraffic_whoisonline` AS `a`**

**1 × SELECT count(*)
 
  FROM `pb_cwtraffic**

**1 × SELECT TCOUNT
 
  FROM `pb_cwtraffic_total**

**1 × SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
 
  FROM pb_jem_categories as c
 
  LEFT JOIN pb_jem_cats_event_relations AS rel 
  ON rel.catid = c.id
 
  LEFT JOIN pb_jem_events AS a 
  ON a.id = rel.itemid**

**1 × SELECT a.access,a.alias,a.attribs,a.author_ip,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,l.alias AS l_alias,l.author_ip AS l_authorip,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description,l.meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.ordering,l.postalCode,l.publish_up,l.publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
 
  FROM pb_jem_events as a
 
  LEFT JOIN pb_jem_venues AS l 
  ON l.id = a.locid
 
  LEFT JOIN pb_jem_countries AS ct 
  ON ct.iso2 = l.country
 
  LEFT JOIN pb_jem_cats_event_relations AS rel 
  ON rel.itemid = a.id
 
  LEFT JOIN pb_jem_categories AS c 
  ON c.id = rel.catid**

**1 × SELECT a.*, u.name as creator_name
 
  FROM pb_attachments AS a
 
  LEFT JOIN pb_users AS u 
  ON u.id = a.created_by**

**1 × SELECT created_by, catid
 
  FROM pb_content**

**1 × SELECT * 
  FROM pb_extensions**

**1 × SELECT `folder` AS `type`,`element` AS `name`,`params`
 
  FROM pb_extensions**

**1 × SELECT count(*)
 
  FROM `pb_cwtraffic_whoisonline`**

**1 × SELECT *
 
  FROM pb_languages**

**1 × SELECT ip
 
  FROM `pb_cwtraffic_knownips`**

**1 × SELECT botname
 
  FROM `pb_cwtraffic_knownips`**

**1 × 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 pb_menu AS m
 
  LEFT JOIN pb_extensions AS e 
  ON m.component_id = e.extension_id**

**1 × SELECT id, home, template, s.params
 
  FROM pb_template_styles as s
 
  LEFT JOIN pb_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id**

**1 × SELECT `m`.`tag_id`,`t`.*
 
  FROM `pb_contentitem_tag_map` AS m 
 
  INNER JOIN `pb_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`**

**1 × SELECT 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
 
  FROM pb_fields AS a
 
  LEFT JOIN `pb_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN pb_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN pb_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN pb_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN pb_fields_groups AS g 
  ON g.id = a.group_id
 
  LEFT JOIN `pb_fields_categories` AS fc 
  ON fc.field_id = a.id**

**1 × SELECT `data`
 
  FROM `pb_session`**

**1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count
 
  FROM pb_content AS a
 
  INNER JOIN pb_categories AS c 
  on c.id = a.catid
 
  LEFT JOIN pb_users AS u 
  on u.id = a.created_by
 
  LEFT JOIN pb_categories as parent 
  ON parent.id = c.parent_id
 
  LEFT JOIN pb_content_rating AS v 
  ON a.id = v.content_id**

**1 × SELECT b.id
 
  FROM pb_usergroups AS a
 
  LEFT JOIN pb_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt**

**1 × SELECT id, rules
 
  FROM `pb_viewlevels**

**1 × SELECT `element`,`name`,`client_id`,`extension_id`
 
  FROM `pb_extensions`**

ALTRE tabelle:

**1 × UPDATE pb_content
 
  SET `hits` = (`hits` + 1)**

**1 × SHOW FULL COLUMNS 
  FROM `pb_assets**

**1 × SHOW FULL COLUMNS 
  FROM `pb_content**

**1 × UPDATE `pb_extensions`
 
  SET `params` = '{\"mediaversion\":\"d6fef95e33fde0092a08dede53c6b10c\"}'**

**1 × UPDATE `pb_cwtraffic_whoisonline`
 
  SET dt = NOW()**

**1 × DELETE 
 
  FROM `pb_cwtraffic_whoisonline`**

**1 × INSERT INTO `pb_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 ('emhirn81tqhb35tee900rn7506', 1, '1550495036', 0, '', 0**

**Caricato** : JROOT/language/it-IT/it-IT.ini
**Caricato** : JROOT/language/it-IT/it-IT.lib_joomla.ini
**Caricato** : JROOT\administrator/language/en-GB/en-GB.plg_system_cwtrafficcount.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_cwtrafficcount.ini
**Caricato** : JROOT\administrator/language/en-GB/en-GB.com_coalawebtraffic.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.com_coalawebtraffic.ini
**Caricato** : JROOT\administrator/language/en-GB/en-GB.plg_system_cwtrafficclean.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_cwtrafficclean.ini
**Caricato** : JROOT\administrator/language/en-GB/en-GB.plg_system_cwtrafficonline.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_cwtrafficonline.ini
**Caricato** : JROOT\administrator/language/en-GB/en-GB.plg_system_cwgears.ini
**Non caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_cwgears.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_fields.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_logout.ini
**Non caricato** : JROOT\administrator/language/it-IT/it-IT.com_mailster.ini
**Non caricato** : JROOT/language/it-IT/it-IT.tpl_pugliabridge.ini
**Non caricato** : JROOT\templates/pugliabridge/language/it-IT/it-IT.tpl_pugliabridge.ini
**Caricato** : JROOT/language/it-IT/it-IT.com_content.ini
**Non caricato** : JROOT\administrator/language/it-IT/it-IT.plg_content_attachments.ini
**Caricato** : JROOT\plugins/content/attachments/language/it-IT/it-IT.plg_content_attachments.ini
**Caricato** : JROOT\plugins\content\attachments/language/it-IT/it-IT.plg_content_attachments.ini
**Caricato** : JROOT/plugins/content/attachments/language/it-IT/it-IT.plg_content_attachments.ini
**Caricato** : JROOT\plugins\attachments\attachments_plugin_framework/language/it-IT/it-IT.plg_attachments_attachments_plugin_framework.ini
**Non caricato** : JROOT\administrator/language/it-IT/it-IT.plg_attachments_attachments_for_content.ini
**Caricato** : JROOT\plugins/attachments/attachments_for_content/language/it-IT/it-IT.plg_attachments_attachments_for_content.ini
**Caricato** : JROOT/language/it-IT/it-IT.mod_menu.ini
**Non caricato** : JROOT/language/it-IT/it-IT.mod_jem_cal.ini
**Caricato** : JROOT/modules/mod_jem_cal/language/it-IT/it-IT.mod_jem_cal.ini
**Caricato** : JROOT/language/it-IT/it-IT.mod_coalawebtraffic.ini
**Caricato** : JROOT/language/it-IT/it-IT.mod_login.ini
**Caricato** : JROOT\administrator/language/it-IT/it-IT.plg_system_debug.ini

Stringhe non tradotte


# JROOT\libraries\legacy\view\legacy.php

ATTACH_S_KB="S KB"

# JROOT\libraries\cms\module\helper.php

MOD_CWTRAFFIC_HORTEXT="CWTRAFFIC HORTEXT"

Calendario eventi

Link utili

Informazione Visitatore

Chi è Online

Accesso riservato

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

60 query eseguite 483.52 ms

Trovati 11 duplicati!

46 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

Messaggi di log

3 messaggi registrati

Errori nei file di lingua da analizzare

File lingua caricati

Stringhe non tradotte

Calendario eventi

Link utili

**Informazione Visitatore**

**Chi è Online**

Accesso riservato

**Console Debug Joomla!**

**Sessione**

**Informazioni profilo**

**Tempo**

**Memoria**

**Utilizzo memoria**

**Query Database**

**60 query eseguite** 483.52 ms

**Trovati 11 duplicati!**

**46 tipi di query eseguite, ordinate per Occurrences**

**Tabelle SELECT:**

**ALTRE tabelle:**

**Messaggi di log**

**3 messaggi registrati**

**Errori nei file di lingua da analizzare**

**File lingua caricati**

**Stringhe non tradotte**

Informazione Visitatore

Chi è Online

Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

60 query eseguite 483.52 ms

Trovati 11 duplicati!

46 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

Messaggi di log

3 messaggi registrati

Errori nei file di lingua da analizzare

File lingua caricati

Stringhe non tradotte