HomeContatti

Judo Club Prato Milano

Associazione sportiva dilettantistica

Indirizzo

Viale Sarca,29 (ang. Via Pianell)
Milano
MI
20125
Italia

Informazioni sul contatto

026434474
3472428252
http://www.jcpmilano.it

CHI SIAMO

L'A.S.D. JUDO CLUB PRATO MILANO è una Associazione Sportiva Dilettantistica senza scopo di lucro che, attraverso la promozione e lo studio delle arti marziali, ha come obiettivo la crescita psicofisica della persona nella sua interezza.

CONTATTI

Palestra scuola "FALCONE-BORSELLINO" Viale Sarca,29(ang.Via Pianell) 20159 Milano
3472428252
3286367478
rosario.maffei@gmail.com
judoclubmilano@tiscali.it

ORARI APERTURA

Martedì e Venerdì
16:30pm-21:00pm

Console Debug Joomla!

Sessione

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1540299294,
                "last": 1540299294,
                "now": 1540299294
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Informazioni profilo

Tempo

Memoria

Tempo: 8.90 ms / 8.90 ms Memoria: 0.185 MB / 0.40 MB Application: afterLoad

Tempo: 53.42 ms / 62.32 ms Memoria: 2.320 MB / 2.72 MB Application: afterInitialise

Tempo: 15.77 ms / 78.10 ms Memoria: 0.322 MB / 3.04 MB Application: afterRoute

Tempo: 0.62 ms / 78.71 ms Memoria: 0.028 MB / 3.07 MB Application: beforeRenderComponent com_contact

Tempo: 35.03 ms / 113.74 ms Memoria: 0.335 MB / 3.40 MB Application: Start JAccess::getAssetRules Old (1)

Tempo: 0.93 ms / 114.68 ms Memoria: 0.039 MB / 3.44 MB Application: Finish JAccess::getAssetRules Old (1)

Tempo: 0.06 ms / 114.74 ms Memoria: 0.000 MB / 3.44 MB Application: Start JAccess::preload(components)

Tempo: 4.48 ms / 119.22 ms Memoria: 0.303 MB / 3.74 MB Application: Finish JAccess::preload(components)

Tempo: 93.51 ms / 212.73 ms Memoria: 0.824 MB / 4.56 MB Application: afterRenderComponent com_contact

Tempo: 11.18 ms / 223.91 ms Memoria: 0.281 MB / 4.85 MB Application: afterDispatch

Tempo: 9.85 ms / 233.76 ms Memoria: 0.340 MB / 5.19 MB Application: beforeRenderModule mod_social_icon (Social Icon)

Tempo: 1.12 ms / 234.89 ms Memoria: 0.028 MB / 5.21 MB Application: afterRenderModule mod_social_icon (Social Icon)

Tempo: 0.81 ms / 235.69 ms Memoria: 0.000 MB / 5.20 MB Application: beforeRenderModule mod_custom (Logo)

Tempo: 1.96 ms / 237.65 ms Memoria: 0.015 MB / 5.21 MB Application: afterRenderModule mod_custom (Logo)

Tempo: 0.61 ms / 238.27 ms Memoria: 0.000 MB / 5.21 MB Application: beforeRenderModule mod_menu (Main Menu)

Tempo: 3.84 ms / 242.11 ms Memoria: 0.072 MB / 5.28 MB Application: afterRenderModule mod_menu (Main Menu)

Tempo: 4.88 ms / 246.98 ms Memoria: 0.111 MB / 5.39 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Tempo: 1.51 ms / 248.49 ms Memoria: 0.020 MB / 5.41 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Tempo: 0.89 ms / 249.38 ms Memoria: 0.000 MB / 5.41 MB Application: beforeRenderModule mod_custom (CHI SIAMO)

Tempo: 1.04 ms / 250.42 ms Memoria: 0.008 MB / 5.41 MB Application: afterRenderModule mod_custom (CHI SIAMO)

Tempo: 0.11 ms / 250.53 ms Memoria: 0.005 MB / 5.42 MB Application: beforeRenderModule mod_contactus (CONTATTI)

Tempo: 0.83 ms / 251.36 ms Memoria: 0.022 MB / 5.44 MB Application: afterRenderModule mod_contactus (CONTATTI)

Tempo: 0.10 ms / 251.46 ms Memoria: 0.000 MB / 5.44 MB Application: beforeRenderModule mod_schedule (ORARI APERTURA)

Tempo: 0.74 ms / 252.20 ms Memoria: 0.017 MB / 5.45 MB Application: afterRenderModule mod_schedule (ORARI APERTURA)

Tempo: 1.54 ms / 253.74 ms Memoria: 0.000 MB / 5.45 MB Application: beforeRenderModule mod_custom (Powered)

Tempo: 0.40 ms / 254.14 ms Memoria: 0.008 MB / 5.46 MB Application: afterRenderModule mod_custom (Powered)

Tempo: 43.10 ms / 297.24 ms Memoria: 0.047 MB / 5.50 MB Application: afterRender

Query totali del database: 36.59 ms

Utilizzo memoria

Query Database

32 query eseguite 36.59 ms

Trovati 5 duplicati!

2 duplicati: #8 #9

3 duplicati: #23 #26 #27

Tempo della query: 0.48 ms Memoria query: 0.018 MB memoria prima della query: 0.896 MB Righe restituite: 0

SELECT `data`

  FROM `a9san_session`

  WHERE `session_id` = '1814ad7ah4f2nt0ue9npr7qru7'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a9san_session	const	PRIMARY	PRIMARY	602	const	1

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
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:408
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.39 ms Dopo l'ultima query: 1.19 ms Memoria query: 0.012 MB memoria prima della query: 0.961 MB Righe restituite: 0

SELECT `session_id`

  FROM `a9san_session`

  WHERE `session_id` = '1814ad7ah4f2nt0ue9npr7qru7' 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.03 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
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:408
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.89 ms Dopo l'ultima query: 0.22 ms Memoria query: 0.009 MB memoria prima della query: 0.975 MB

INSERT INTO `a9san_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('1814ad7ah4f2nt0ue9npr7qru7', 0, 1, '1540299294', 0, '')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `a9san_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('1814ad7ah4f2nt0ue9npr7qru7', 0, 1, '1540299294', 0, '')

Profilo

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

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
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:408
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.92 ms Dopo l'ultima query: 0.96 ms Memoria query: 0.022 MB memoria prima della query: 1.033 MB Righe restituite: 38

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

  FROM `a9san_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a9san_extensions	ref	extension	extension	62	const	38	Using index condition

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.23 ms Dopo l'ultima query: 0.91 ms Memoria query: 0.015 MB memoria prima della query: 1.107 MB Righe restituite: 1

SELECT b.id

  FROM a9san_usergroups AS a

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

  WHERE a.id = 1

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.34 ms Dopo l'ultima query: 0.27 ms Memoria query: 0.014 MB memoria prima della query: 1.127 MB Righe restituite: 3

SELECT id, rules

  FROM `a9san_viewlevels`

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.16 ms Dopo l'ultima query: 0.21 ms Memoria query: 0.014 MB memoria prima della query: 1.144 MB Righe restituite: 59

SELECT folder AS type, element AS name, params

  FROM a9san_extensions

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

  ORDER BY ordering

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.39 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
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:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.26 ms Dopo l'ultima query: 13.50 ms Memoria query: 0.019 MB memoria prima della query: 1.779 MB Righe restituite: 1

Query duplicate: #9

SELECT template

  FROM a9san_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	10	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:99
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:57
7	plgSystemRokCommon->__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:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.21 ms Dopo l'ultima query: 0.16 ms Memoria query: 0.020 MB memoria prima della query: 1.798 MB Righe restituite: 1

Query duplicate: #8

SELECT template

  FROM a9san_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_home	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	10	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:99
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:57
7	plgSystemRokCommon->__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:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.24 ms Dopo l'ultima query: 3.93 ms Memoria query: 0.015 MB memoria prima della query: 1.999 MB Righe restituite: 2

SELECT extension, file, type

  FROM a9san_rokcommon_configs

  ORDER BY priority

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:130
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:78
7	plgSystemRokCommon->__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:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.77 ms Dopo l'ultima query: 3.36 ms Memoria query: 0.031 MB memoria prima della query: 2.123 MB Righe restituite: 18

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

  LEFT JOIN a9san_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	85	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	rsxtgpgl_jcp.m.component_id	1	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sorting result	0.84 ms
Sending data	0.20 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.19 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
17	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
16	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
15	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
14	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
13	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
12	JApplicationSite->getMenu()	JROOT/libraries/cms/application/site.php:438
11	JApplicationSite->getTemplate()	JROOT/libraries/bdshortcode/shortcodes/shortcodes.php:203
10	include_once JROOT/libraries/bdshortcode/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
9	JLoader::import()	JROOT/libraries/loader.php:682
8	jimport()	JROOT/plugins/system/bdshortcodes/bdshortcodes.php:20
7	require_once JROOT/plugins/system/bdshortcodes/bdshortcodes.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.65 ms Dopo l'ultima query: 1.31 ms Memoria query: 0.018 MB memoria prima della query: 2.323 MB Righe restituite: 7

SELECT id, home, template, s.params

  FROM a9san_template_styles as s

  LEFT JOIN a9san_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	10	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	rsxtgpgl_jcp.s.template,const	1	Using index condition; Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
11	JApplicationSite->getTemplate()	JROOT/libraries/bdshortcode/shortcodes/shortcodes.php:203
10	include_once JROOT/libraries/bdshortcode/shortcodes/shortcodes.php	JROOT/libraries/loader.php:219
9	JLoader::import()	JROOT/libraries/loader.php:682
8	jimport()	JROOT/plugins/system/bdshortcodes/bdshortcodes.php:20
7	require_once JROOT/plugins/system/bdshortcodes/bdshortcodes.php	JROOT/libraries/cms/plugin/helper.php:230
6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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: 1.32 ms Memoria query: 0.022 MB memoria prima della query: 2.375 MB Righe restituite: 1

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

  FROM `a9san_extensions`

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

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	Same as call in the line below.
15	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
14	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
13	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
12	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
11	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/bdshortcodes/bdshortcodes.php:30
7	plgSystemBDShortcodes->__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:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.06 ms Dopo l'ultima query: 0.29 ms Memoria query: 0.016 MB memoria prima della query: 2.380 MB

UPDATE `a9san_extensions`

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

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

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
12	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
11	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
10	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
9	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
8	JFactory::getDocument()	JROOT/plugins/system/bdshortcodes/bdshortcodes.php:30
7	plgSystemBDShortcodes->__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:669
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.27 ms Dopo l'ultima query: 15.72 ms Memoria query: 0.022 MB memoria prima della query: 2.937 MB Righe restituite: 2

SELECT *

  FROM a9san_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
13	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
12	JApplicationSite->getParams()	JROOT/components/com_k2/helpers/utilities.php:315
11	K2HelperUtilities::getParams()	JROOT/administrator/components/com_k2/helpers/html.php:56
10	K2HelperHTML::loadjQuery()	JROOT/plugins/system/k2/k2.php:55
9	plgSystemK2->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.76 ms Dopo l'ultima query: 2.55 ms Memoria query: 0.022 MB memoria prima della query: 3.035 MB Righe restituite: 8

SELECT * 
  FROM a9san_rokcandy 
  WHERE published=1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a9san_rokcandy	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	8	Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	2.47 ms
init	0.01 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
14	RokCandyHelper::getUserMacros()	Same as call in the line below.
13	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/joomla/cache/controller/callback.php:40
11	JCacheControllerCallback->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
10	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
9	plgSystemRokCandy->onAfterRoute()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
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.20 ms Dopo l'ultima query: 33.57 ms Memoria query: 0.032 MB memoria prima della query: 3.325 MB Righe restituite: 8

SHOW FULL COLUMNS 
  FROM `a9san_assets`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
18	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.26 ms Dopo l'ultima query: 1.00 ms Memoria query: 0.026 MB memoria prima della query: 3.386 MB Righe restituite: 1

SELECT *

  FROM a9san_assets

  WHERE `id` = '1'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
18	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
17	JTable->load()	JROOT/libraries/joomla/access/access.php:697
16	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.23 ms Dopo l'ultima query: 0.25 ms Memoria query: 0.022 MB memoria prima della query: 3.406 MB Righe restituite: 1

SELECT a.rules

  FROM a9san_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
15	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.66 ms Dopo l'ultima query: 0.78 ms Memoria query: 0.025 MB memoria prima della query: 3.441 MB Righe restituite: 37

SELECT element

  FROM a9san_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.01 ms
After opening tables	0.02 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
18	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.31 ms Dopo l'ultima query: 0.33 ms Memoria query: 0.026 MB memoria prima della query: 3.473 MB Righe restituite: 36

SELECT a.name, a.rules

  FROM a9san_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_pbbooking','com_plugins','com_postinstall','com_redirect','com_rokcandy','com_rokecwid','com_search','com_tags','com_templates','com_uniterevolution','com_weblinks','com_widgetkit','com_wrapper') OR a.name = 'root.1')

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
18	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
17	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
16	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
15	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
14	JUser->authorise()	JROOT/components/com_contact/models/contact.php:67
13	ContactModelContact->populateState()	JROOT/libraries/legacy/model/legacy.php:435
12	JModelLegacy->getState()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:71
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 11.73 ms Dopo l'ultima query: 3.43 ms Memoria query: 0.031 MB memoria prima della query: 3.742 MB Righe restituite: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias

  FROM a9san_contact_details AS a

  LEFT JOIN a9san_categories AS c 
  on c.id = a.catid

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

  WHERE a.id = 1 
  AND (a.published = 1 OR a.published =2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-10-23 12:54:55') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-10-23 12:54:55')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows
1	SIMPLE	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.73 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.07 ms
optimizing	0.03 ms
statistics	10.18 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.04 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_contact/models/contact.php:194
12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 1.38 ms Memoria query: 0.026 MB memoria prima della query: 3.802 MB Righe restituite: 0

Query duplicate: #26 #27

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

  FROM `a9san_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.02 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
13	JHelperTags->getItemTags()	JROOT/components/com_contact/models/contact.php:218
12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 20.14 ms Memoria query: 0.032 MB memoria prima della query: 3.918 MB Righe restituite: 15

SHOW FULL COLUMNS 
  FROM `a9san_users`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
21	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
20	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
19	JTable->__construct()	JROOT/libraries/joomla/table/user.php:39
18	JTableUser->__construct()	JROOT/libraries/joomla/table/table.php:308
17	JTable::getInstance()	JROOT/administrator/components/com_users/models/user.php:57
16	UsersModelUser->getTable()	JROOT/libraries/legacy/model/admin.php:886
15	JModelAdmin->getItem()	JROOT/administrator/components/com_users/models/user.php:73
14	UsersModelUser->getItem()	JROOT/components/com_contact/models/contact.php:364
13	ContactModelContact->buildContactExtendedData()	JROOT/components/com_contact/models/contact.php:254
12	ContactModelContact->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_contact/views/contact/view.html.php:72
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.66 ms Dopo l'ultima query: 28.37 ms Memoria query: 0.031 MB memoria prima della query: 4.165 MB Righe restituite: 1

SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email

  FROM `a9san_contact_details` AS a

  LEFT JOIN a9san_categories AS c 
  ON c.id = a.catid

  LEFT JOIN a9san_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN a9san_users AS uam 
  ON uam.id = a.modified_by

  WHERE a.access IN (1,1) 
  AND a.catid = 4 
  AND c.access IN (1,1) 
  AND a.published = 1

  ORDER BY a.name asc

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.32 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.03 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.41 ms
preparing	0.05 ms
executing	0.01 ms
Sorting result	0.06 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.03 ms
Waiting for query cache lock	0.01 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:310
13	JModelLegacy->_getList()	JROOT/libraries/legacy/model/list.php:183
12	JModelList->getItems()	JROOT/components/com_contact/models/category.php:91
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.36 ms Memoria query: 0.025 MB memoria prima della query: 4.209 MB Righe restituite: 0

Query duplicate: #23 #27

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

  FROM `a9san_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
12	JHelperTags->getItemTags()	JROOT/components/com_contact/models/category.php:104
11	ContactModelCategory->getItems()	JROOT/components/com_contact/views/contact/view.html.php:90
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.30 ms Dopo l'ultima query: 1.84 ms Memoria query: 0.024 MB memoria prima della query: 4.239 MB Righe restituite: 0

Query duplicate: #23 #26

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

  FROM `a9san_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_contact.contact' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.01 ms
init	0.00 ms
checking query cache for query	0.01 ms
checking privileges on cached	0.00 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
sending cached result to clien	0.02 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_contact/views/contact/view.html.php:278
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.73 ms Dopo l'ultima query: 3.83 ms Memoria query: 0.029 MB memoria prima della query: 4.278 MB Righe restituite: 43

SHOW FULL COLUMNS 
  FROM `a9san_contact_details`

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
14	JTable->__construct()	JROOT/administrator/components/com_contact/tables/contact.php:38
13	ContactTableContact->__construct()	JROOT/libraries/joomla/table/table.php:308
12	JTable::getInstance()	JROOT/components/com_contact/models/contact.php:591
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:298
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.59 ms Dopo l'ultima query: 1.74 ms Memoria query: 0.030 MB memoria prima della query: 4.425 MB Righe restituite: 1

SELECT *

  FROM a9san_contact_details

  WHERE `id` = '1'

Explain

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

Profilo

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
12	JTable->load()	JROOT/components/com_contact/models/contact.php:592
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:298
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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.18 ms Dopo l'ultima query: 0.30 ms Memoria query: 0.016 MB memoria prima della query: 4.440 MB

UPDATE a9san_contact_details

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

  WHERE `id` = '1'

Explain

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

Profilo

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.00 ms
After opening tables	0.01 ms
init	0.04 ms
updating	0.09 ms
end	0.01 ms
Waiting for query cache lock	0.01 ms
end	0.17 ms
query end	0.62 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
12	JTable->hit()	JROOT/components/com_contact/models/contact.php:593
11	ContactModelContact->hit()	JROOT/components/com_contact/views/contact/view.html.php:298
10	ContactViewContact->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_contact/controller.php:42
8	ContactController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_contact/contact.php:15
6	require_once JROOT/components/com_contact/contact.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
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:261
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: 16.64 ms Memoria query: 0.021 MB memoria prima della query: 4.598 MB Righe restituite: 1

SELECT params 
  FROM a9san_extensions AS e 
  WHERE e.element='com_widgetkit'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	302	const	1	Using index condition

Profilo

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
15	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_widgetkit/helpers/system.php:254
14	SystemWidgetkitHelper->_getParams()	JROOT/administrator/components/com_widgetkit/helpers/system.php:54
13	SystemWidgetkitHelper->__construct()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:129
12	Widgetkit->loadHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:76
11	Widgetkit->getHelper()	JROOT/administrator/components/com_widgetkit/classes/widgetkit.php:137
10	Widgetkit->offsetGet()	JROOT/administrator/components/com_widgetkit/widgetkit.php:17
9	require_once JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/plugins/system/widgetkit_system/widgetkit_system.php:20
8	plgSystemWidgetkit_System->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
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:261
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.65 ms Dopo l'ultima query: 12.35 ms Memoria query: 0.027 MB memoria prima della query: 4.959 MB Righe restituite: 13

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

  FROM a9san_modules AS m

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

  LEFT JOIN a9san_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 <= '2018-10-23 12:54:55') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-10-23 12:54:55') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 106 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profilo

Status	Duration
starting	0.02 ms
Waiting for query cache lock	0.00 ms
init	0.00 ms
checking query cache for query	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
After opening tables	0.01 ms
Waiting for query cache lock	0.00 ms
After opening tables	0.04 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Sorting result	0.25 ms
Sending data	0.46 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
Waiting for query cache lock	0.00 ms
updating status	0.06 ms
Waiting for query cache lock	0.00 ms
updating status	0.00 ms
storing result in query cache	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT/libraries/joomla/cache/controller/callback.php:152
16	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
15	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
14	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
13	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
12	JDocumentHtml->countModules()	JROOT/templates/bd_beauty/warp/systems/joomla/helpers/modules.php:49
11	ModulesWarpHelper->count()	JROOT/templates/bd_beauty/layouts/template.config.php:87
10	include JROOT/templates/bd_beauty/layouts/template.config.php	JROOT/templates/bd_beauty/layouts/template.php:14
9	include JROOT/templates/bd_beauty/layouts/template.php	JROOT/templates/bd_beauty/warp/helpers/template.php:49
8	TemplateWarpHelper->render()	JROOT/templates/bd_beauty/index.php:19
7	require JROOT/templates/bd_beauty/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
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]

28 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

3 × SELECT `m`.`tag_id`,`t`.* 
  FROM `a9san_contentitem_tag_map` AS m  
  INNER JOIN `a9san_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

2 × SELECT template 
  FROM a9san_template_styles as s

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias 
  FROM a9san_contact_details AS a 
  LEFT JOIN a9san_categories AS c 
  on c.id = a.catid 
  LEFT JOIN a9san_categories as parent 
  ON parent.id = c.parent_id

1 × SELECT element 
  FROM a9san_extensions

1 × SELECT a.rules 
  FROM a9san_assets AS a

1 × SELECT a.name, a.rules 
  FROM a9san_assets AS a

1 × SELECT a.*, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM `a9san_contact_details` AS a 
  LEFT JOIN a9san_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN a9san_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN a9san_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM a9san_modules AS m 
  LEFT JOIN a9san_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN a9san_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT params 
  FROM a9san_extensions AS e

1 × SELECT * 
  FROM a9san_contact_details

```
1 × SELECT * 
  FROM a9san_assets
```
```
1 × SELECT * 
  FROM a9san_languages
```

1 × SELECT id, rules 
  FROM `a9san_viewlevels

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

1 × SELECT `session_id` 
  FROM `a9san_session`

1 × SELECT folder AS type, element AS name, params 
  FROM a9san_extensions

1 × SELECT extension, file, type 
  FROM a9san_rokcommon_configs

1 × SELECT `data` 
  FROM `a9san_session`

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

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 a9san_menu AS m 
  LEFT JOIN a9san_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM a9san_rokcandy
```

ALTRE tabelle:

1 × SHOW FULL COLUMNS 
  FROM `a9san_contact_details

1 × UPDATE a9san_contact_details 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `a9san_users

1 × SHOW FULL COLUMNS 
  FROM `a9san_assets

1 × UPDATE `a9san_extensions` 
  SET `params` = '{\"mediaversion\":\"bdbc179bb249cc753f2c2a71c4b48394\"}'

1 × INSERT INTO `a9san_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('1814ad7ah4f2nt0ue9npr7qru7', 0, 1, '1540299294', 0, ''