Console Debug Joomla!

Sessione

Informazioni profilo

Tempo

Memoria

Tempo: 0.0 ms / 0.0 ms Memoria: 0.323 MB / 0.32 MB Application: afterLoad

Tempo: 16.4 ms / 16.4 ms Memoria: 1.467 MB / 1.79 MB Application: afterInitialise

Tempo: 12.6 ms / 29.0 ms Memoria: 0.770 MB / 2.56 MB Application: afterRoute

Tempo: 21.7 ms / 50.7 ms Memoria: 1.382 MB / 3.94 MB Application: afterDispatch

Tempo: 3.9 ms / 54.6 ms Memoria: 0.237 MB / 4.18 MB Application: beforeRenderModule mod_menu (Footer menu)

Tempo: 1.6 ms / 56.3 ms Memoria: 0.034 MB / 4.21 MB Application: afterRenderModule mod_menu (Footer menu)

Tempo: 0.1 ms / 56.3 ms Memoria: 0.000 MB / 4.21 MB Application: beforeRenderModule mod_zensocial (Pulsanti social network)

Tempo: 1.0 ms / 57.4 ms Memoria: 0.030 MB / 4.24 MB Application: afterRenderModule mod_zensocial (Pulsanti social network)

Tempo: 0.1 ms / 57.5 ms Memoria: 0.000 MB / 4.22 MB Application: beforeRenderModule mod_custom (Hai bisogno di contattarci?)

Tempo: 1.0 ms / 58.5 ms Memoria: 0.009 MB / 4.23 MB Application: afterRenderModule mod_custom (Hai bisogno di contattarci?)

Tempo: 0.1 ms / 58.5 ms Memoria: 0.000 MB / 4.23 MB Application: beforeRenderModule mod_custom (Informazioni)

Tempo: 0.1 ms / 58.7 ms Memoria: 0.007 MB / 4.24 MB Application: afterRenderModule mod_custom (Informazioni)

Tempo: 0.1 ms / 58.7 ms Memoria: 0.000 MB / 4.24 MB Application: beforeRenderModule mod_custom (Acquisto)

Tempo: 0.6 ms / 59.4 ms Memoria: 0.035 MB / 4.27 MB Application: afterRenderModule mod_custom (Acquisto)

Tempo: 0.1 ms / 59.5 ms Memoria: 0.001 MB / 4.27 MB Application: beforeRenderModule mod_jbmaps (Mappa contatto)

Tempo: 0.2 ms / 59.7 ms Memoria: 0.017 MB / 4.29 MB Application: afterRenderModule mod_jbmaps (Mappa contatto)

Tempo: 0.1 ms / 59.8 ms Memoria: 0.000 MB / 4.28 MB Application: beforeRenderModule mod_hikashop_cart (Carrello)

Tempo: 17.8 ms / 77.6 ms Memoria: 1.894 MB / 6.17 MB Application: afterRenderModule mod_hikashop_cart (Carrello)

Tempo: 0.1 ms / 77.7 ms Memoria: 0.000 MB / 6.17 MB Application: beforeRenderModule mod_menu (Topmenu)

Tempo: 0.7 ms / 78.4 ms Memoria: 0.016 MB / 6.18 MB Application: afterRenderModule mod_menu (Topmenu)

Tempo: 40.7 ms / 119.1 ms Memoria: 0.783 MB / 6.97 MB Application: afterRender

Query totali del database: 21.4 ms

Utilizzo memoria

Query Database

45 query eseguite 21.4 ms

Trovati 3 duplicati!

3 duplicati: #22 #28 #29

Tempo della query: 0.19 ms Memoria query: 0.015 MB memoria prima della query: 0.735 MB Righe restituite: 0

SELECT `data`

  FROM `fh40d_session`

  WHERE `session_id` = 'p8bashifmjp9cv1ja6h6k6vd26'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:46

JROOT/libraries/joomla/session/session.php:658

JROOT/libraries/joomla/session/session.php:596

JROOT/libraries/cms/application/cms.php:662

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:322

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

[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.27 ms Memoria query: 0.007 MB memoria prima della query: 0.781 MB

DELETE 

  FROM `fh40d_session`

  WHERE `time` < '1532149947'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	DELETE	fh40d_session	NULL	range	time	time	45	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:679

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:322

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Tempo della query: 0.17 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.012 MB memoria prima della query: 0.792 MB Righe restituite: 0

SELECT `session_id`

  FROM `fh40d_session`

  WHERE `session_id` = 'p8bashifmjp9cv1ja6h6k6vd26' 
  LIMIT 0, 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100.00	Using index

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:175

JROOT/libraries/cms/application/cms.php:688

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:322

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Tempo della query: 2.00 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.009 MB memoria prima della query: 0.804 MB

INSERT INTO `fh40d_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('p8bashifmjp9cv1ja6h6k6vd26', 0, '1532150847')

Explain

EXPLAIN non possibile sulla query: INSERT INTO `fh40d_session` (`session_id`, `client_id`, `time`) VALUES ('p8bashifmjp9cv1ja6h6k6vd26', 0, '1532150847')

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
update	0.1 ms
end	0.0 ms
query end	1.8 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/cms.php:207

JROOT/libraries/cms/application/cms.php:688

JROOT/libraries/cms/application/cms.php:131

JROOT/libraries/cms/application/site.php:63

JROOT/libraries/cms/application/cms.php:322

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:37

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

Tempo della query: 0.29 ms Dopo l'ultima query: 0.42 ms Memoria query: 0.014 MB memoria prima della query: 0.880 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:557

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.22 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.014 MB memoria prima della query: 0.897 MB Righe restituite: 2

SELECT b.id

  FROM fh40d_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:336

JROOT/libraries/joomla/access/access.php:405

JROOT/libraries/joomla/user/user.php:428

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:562

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.15 ms Dopo l'ultima query: 0.10 ms Memoria query: 0.013 MB memoria prima della query: 0.916 MB Righe restituite: 5

SELECT id, rules

  FROM `fh40d_viewlevels`

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:422

JROOT/libraries/joomla/user/user.php:428

JROOT/libraries/cms/plugin/helper.php:298

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:562

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.67 ms Dopo l'ultima query: 0.14 ms Memoria query: 0.015 MB memoria prima della query: 0.935 MB Righe restituite: 84

SELECT folder AS type, element AS name, params

  FROM fh40d_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	extension	extension	62	const	192	3.33	Using index condition; Using where; Using filesort

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.4 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/plugin/helper.php:312

JROOT/libraries/cms/plugin/helper.php:165

JROOT/libraries/cms/application/site.php:562

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.41 ms Memoria query: 0.014 MB memoria prima della query: 1.038 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/application/site.php:615

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.20 ms Dopo l'ultima query: 2.03 ms Memoria query: 0.013 MB memoria prima della query: 1.333 MB Righe restituite: 1

SELECT `enabled`

  FROM `fh40d_extensions`

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/backuponupdate/backuponupdate.php:50

JROOT/libraries/cms/plugin/helper.php:232

JROOT/libraries/cms/plugin/helper.php:172

JROOT/libraries/cms/application/cms.php:576

JROOT/libraries/cms/application/site.php:636

JROOT/libraries/cms/application/site.php:196

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.85 ms Memoria query: 0.026 MB memoria prima della query: 1.842 MB Righe restituite: 19

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

  LEFT JOIN fh40d_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	41	3.33	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	addart_db.m.component_id	1	100.00	Using where

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/menu/site.php:47

JROOT/libraries/cms/menu/menu.php:64

JROOT/libraries/cms/menu/menu.php:118

JROOT/libraries/cms/application/cms.php:347

JROOT/libraries/cms/application/site.php:266

JROOT/libraries/cms/router/site.php:218

JROOT/libraries/cms/router/router.php:408

JROOT/libraries/cms/router/router.php:192

JROOT/libraries/cms/router/site.php:90

JROOT/libraries/cms/application/cms.php:1012

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 1.21 ms Memoria query: 0.024 MB memoria prima della query: 2.095 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/library/helper.php:156

JROOT/libraries/cms/library/helper.php:47

JROOT/libraries/cms/library/helper.php:90

JROOT/libraries/cms/version/version.php:179

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/jbtype/jbtype.php:29

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1021

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 1.98 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.017 MB memoria prima della query: 2.102 MB

UPDATE `fh40d_extensions`

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	fh40d_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	1.8 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/library/helper.php:119

JROOT/libraries/cms/version/version.php:230

JROOT/libraries/cms/version/version.php:189

JROOT/libraries/joomla/factory.php:734

JROOT/libraries/joomla/factory.php:215

JROOT/plugins/system/jbtype/jbtype.php:29

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1021

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.019 MB memoria prima della query: 2.184 MB Righe restituite: 5

SELECT id, home, template, s.params

  FROM fh40d_template_styles as s

  LEFT JOIN fh40d_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	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	7	14.29	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	addart_db.s.template,const	1	4.77	Using index condition; Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/application/site.php:473

JROOT/plugins/system/t3/includes/core/t3.php:310

JROOT/plugins/system/t3/t3.php:81

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1021

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 5.88 ms Memoria query: 0.021 MB memoria prima della query: 2.462 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/plugins/system/nnframework/helpers/parameters.php:95

JROOT/plugins/system/rereplacer/rereplacer.php:79

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1021

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 0.96 ms Memoria query: 0.027 MB memoria prima della query: 2.540 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_contact/router.php:37

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:63

JROOT/plugins/system/sef/sef.php:49

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:1021

JROOT/libraries/cms/application/site.php:736

JROOT/libraries/cms/application/site.php:218

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 0.48 ms Memoria query: 0.013 MB memoria prima della query: 2.585 MB Righe restituite: 1

SELECT *

  FROM fh40d_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/language/helper.php:166

JROOT/libraries/cms/application/site.php:323

JROOT/libraries/cms/application/site.php:122

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.19 ms Dopo l'ultima query: 2.66 ms Memoria query: 0.022 MB memoria prima della query: 2.846 MB Righe restituite: 1

SELECT a.rules

  FROM fh40d_assets AS a

  WHERE (a.id = 1)

  GROUP BY a.id, a.rules, a.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/user/user.php:364

JROOT/components/com_contact/models/contact.php:54

JROOT/libraries/legacy/model/legacy.php:415

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:42

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.23 ms Memoria query: 0.023 MB memoria prima della query: 2.877 MB Righe restituite: 2

SELECT b.rules

  FROM fh40d_assets AS a

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

  WHERE (a.name = 'com_contact')

  GROUP BY b.id, b.rules, b.lft

  ORDER BY b.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	idx_asset_name	idx_asset_name	152	const	1	100.00	Using temporary; Using filesort
1	SIMPLE	b	NULL	range	idx_lft_rgt	idx_lft_rgt	4	NULL	8	100.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Creating tmp table	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/access/access.php:250

JROOT/libraries/joomla/access/access.php:110

JROOT/libraries/joomla/user/user.php:373

JROOT/components/com_contact/models/contact.php:54

JROOT/libraries/legacy/model/legacy.php:415

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:42

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.53 ms Dopo l'ultima query: 0.24 ms Memoria query: 0.031 MB memoria prima della query: 2.909 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 fh40d_contact_details AS a

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

  LEFT JOIN fh40d_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-07-21 05:27:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-21 05:27:27')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_state	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.1 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contact/models/contact.php:171

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:43

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 0.42 ms Memoria query: 0.026 MB memoria prima della query: 2.989 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/libraries/cms/helper/tags.php:389

JROOT/components/com_contact/models/contact.php:195

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:43

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.13 ms Memoria query: 0.026 MB memoria prima della query: 2.996 MB Righe restituite: 0

Query duplicate: #28 #29

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

  FROM `fh40d_contentitem_tag_map` AS m 

  INNER JOIN `fh40d_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,5)

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_contact/models/contact.php:195

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:43

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 0.17 ms Memoria query: 0.030 MB memoria prima della query: 3.017 MB Righe restituite: 1

SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug

  FROM fh40d_contact_details AS a

  INNER JOIN fh40d_categories AS cc 
  on cc.id = a.catid

  WHERE a.id = 1 
  AND a.published IN (1,2) 
  AND cc.published IN (1,2) 
  AND a.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	cc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contact/models/contact.php:292

JROOT/components/com_contact/models/contact.php:230

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:43

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.19 ms Memoria query: 0.021 MB memoria prima della query: 3.050 MB Righe restituite: 0

SELECT a.id,a.title,a.state,a.access,a.created, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug

  FROM fh40d_content as a

  LEFT JOIN fh40d_categories as c 
  on a.catid=c.id

  WHERE a.created_by = 0 
  AND a.access IN (1,1,5) 
  AND a.state IN (1,2) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-07-21 05:27:27') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-07-21 05:27:27')

  ORDER BY a.state DESC, a.created DESC 
  LIMIT 0, 10

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_createdby	idx_createdby	4	const	1	16.00	Using index condition; Using where; Using filesort
1	SIMPLE	c	NULL	eq_ref	PRIMARY	PRIMARY	4	addart_db.a.catid	1	100.00	Using where

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/components/com_contact/models/contact.php:360

JROOT/components/com_contact/models/contact.php:230

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:43

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.49 ms Memoria query: 0.032 MB memoria prima della query: 3.212 MB Righe restituite: 16

SHOW FULL COLUMNS 
  FROM `fh40d_users`

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:229

JROOT/libraries/joomla/table/table.php:150

JROOT/libraries/joomla/table/user.php:38

JROOT/libraries/joomla/table/table.php:294

JROOT/administrator/components/com_users/models/user.php:52

JROOT/libraries/legacy/model/admin.php:832

JROOT/administrator/components/com_users/models/user.php:68

JROOT/components/com_contact/models/contact.php:366

JROOT/components/com_contact/models/contact.php:230

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:394

JROOT/components/com_contact/views/contact/view.html.php:43

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 3.07 ms Memoria query: 0.022 MB memoria prima della query: 3.396 MB Righe restituite: 1

SELECT COUNT(*)

  FROM `fh40d_contact_details` AS a

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

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

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	addart_db.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	addart_db.a.modified_by	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.3 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/model/legacy.php:327

JROOT/libraries/legacy/model/list.php:292

JROOT/libraries/legacy/model/list.php:326

JROOT/libraries/legacy/model/list.php:187

JROOT/components/com_contact/models/category.php:87

JROOT/components/com_contact/views/contact/view.html.php:61

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.40 ms Dopo l'ultima query: 0.09 ms Memoria query: 0.030 MB memoria prima della query: 3.409 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 `fh40d_contact_details` AS a

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

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

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

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

  ORDER BY a.name asc

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_state	1	const	1	100.00	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	addart_db.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	addart_db.a.modified_by	1	100.00	Using where; Using index

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/legacy/model/legacy.php:301

JROOT/libraries/legacy/model/list.php:187

JROOT/components/com_contact/models/category.php:87

JROOT/components/com_contact/views/contact/view.html.php:61

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.24 ms Memoria query: 0.025 MB memoria prima della query: 3.452 MB Righe restituite: 0

Query duplicate: #22 #29

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

  FROM `fh40d_contentitem_tag_map` AS m 

  INNER JOIN `fh40d_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,5)

Explain

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

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_contact/models/category.php:100

JROOT/components/com_contact/views/contact/view.html.php:61

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 0.25 ms Memoria query: 0.024 MB memoria prima della query: 3.476 MB Righe restituite: 0

Query duplicate: #22 #28

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

  FROM `fh40d_contentitem_tag_map` AS m 

  INNER JOIN `fh40d_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,5)

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/helper/tags.php:409

JROOT/components/com_contact/views/contact/view.html.php:215

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 0.15 ms Memoria query: 0.029 MB memoria prima della query: 3.512 MB Righe restituite: 43

SHOW FULL COLUMNS 
  FROM `fh40d_contact_details`

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Opening tables	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:229

JROOT/libraries/joomla/table/table.php:150

JROOT/administrator/components/com_contact/tables/contact.php:27

JROOT/libraries/joomla/table/table.php:294

JROOT/components/com_contact/models/contact.php:408

JROOT/components/com_contact/views/contact/view.html.php:234

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 0.22 ms Dopo l'ultima query: 0.54 ms Memoria query: 0.029 MB memoria prima della query: 3.658 MB Righe restituite: 1

SELECT *

  FROM fh40d_contact_details

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_contact_details	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:705

JROOT/components/com_contact/models/contact.php:409

JROOT/components/com_contact/views/contact/view.html.php:234

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

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

Tempo della query: 1.93 ms Dopo l'ultima query: 0.17 ms Memoria query: 0.016 MB memoria prima della query: 3.672 MB

UPDATE fh40d_contact_details

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

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	fh40d_contact_details	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.0 ms
end	0.0 ms
query end	1.8 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/table/table.php:1215

JROOT/components/com_contact/models/contact.php:410

JROOT/components/com_contact/views/contact/view.html.php:234

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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.39 ms Memoria query: 0.026 MB memoria prima della query: 3.740 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	10.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/plugins/system/t3/base/html/com_contact/contact/default.php:12

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:661

JROOT/plugins/system/t3/includes/joomla30/viewlegacy.php:207

JROOT/components/com_contact/views/contact/view.html.php:237

JROOT/libraries/legacy/controller/legacy.php:685

JROOT/components/com_contact/controller.php:41

JROOT/libraries/legacy/controller/legacy.php:722

JROOT/components/com_contact/contact.php:15

JROOT/libraries/cms/component/helper.php:352

JROOT/libraries/cms/component/helper.php:332

JROOT/libraries/cms/application/site.php:178

JROOT/libraries/cms/application/site.php:224

JROOT/libraries/cms/application/cms.php:245

JROOT/index.php:40

[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: 5.95 ms Memoria query: 0.033 MB memoria prima della query: 4.091 MB Righe restituite: 21

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

  FROM fh40d_modules AS m

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

  LEFT JOIN fh40d_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-07-21 05:27:27') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-07-21 05:27:27') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 134 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	29	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	addart_db.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	addart_db.m.id	2	40.00	Using where; Using index

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.4 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:430

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:373

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:89

JROOT/libraries/joomla/document/html/html.php:502

JROOT/plugins/system/t3/includes/core/template.php:656

JROOT/templates/newlifestyle/tpls/blocks/top.php:9

JROOT/plugins/system/t3/includes/core/template.php:195

JROOT/templates/newlifestyle/tpls/default.php:24

JROOT/plugins/system/t3/includes/core/template.php:219

JROOT/templates/newlifestyle/index.php:34

JROOT/libraries/joomla/document/html/html.php:570

JROOT/libraries/joomla/document/html/html.php:628

JROOT/libraries/joomla/document/html/html.php:452

JROOT/libraries/cms/application/cms.php:968

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Tempo della query: 0.28 ms Dopo l'ultima query: 6.14 ms Memoria query: 0.029 MB memoria prima della query: 4.266 MB Righe restituite: 0

SELECT r.*

  FROM fh40d_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'articles')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	25.00	Using where; Using filesort

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/rereplacer/helper.php:937

JROOT/plugins/system/rereplacer/helper.php:58

JROOT/plugins/system/rereplacer/rereplacer.php:93

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/cms/html/content.php:43

JROOT/libraries/cms/html/html.php:238

JROOT/libraries/cms/html/html.php:140

JROOT/modules/mod_custom/mod_custom.php:15

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:982

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Tempo della query: 0.40 ms Dopo l'ultima query: 12.28 ms Memoria query: 0.029 MB memoria prima della query: 5.313 MB Righe restituite: 281

SELECT * 
  FROM fh40d_hikashop_config

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_hikashop_config	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	281	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_hikashop/classes/config.php:16

JROOT/administrator/components/com_hikashop/helpers/helper.php:1005

JROOT/administrator/components/com_hikashop/helpers/helper.php:3491

JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:13

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:982

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[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: 1.61 ms Memoria query: 0.025 MB memoria prima della query: 5.740 MB Righe restituite: 0

SELECT a.* 
  FROM fh40d_hikashop_cart AS a 
  WHERE (a.session_id = 'p8bashifmjp9cv1ja6h6k6vd26') 
  AND a.cart_type = 'cart' 
  ORDER BY a.cart_modified DESC 
  LIMIT 1

Explain

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

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_hikashop/classes/cart.php:70

JROOT/administrator/components/com_hikashop/classes/cart.php:20

JROOT/administrator/components/com_hikashop/classes/cart.php:95

JROOT/components/com_hikashop/views/product/view.html.php:2036

JROOT/components/com_hikashop/views/product/view.html.php:37

JROOT/administrator/components/com_hikashop/helpers/helper.php:770

JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:61

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:982

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Tempo della query: 0.32 ms Dopo l'ultima query: 0.28 ms Memoria query: 0.022 MB memoria prima della query: 5.823 MB Righe restituite: 2

SELECT currency_id 
  FROM fh40d_hikashop_currency 
  WHERE currency_published=1 OR currency_id = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_hikashop_currency	NULL	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	181	10.50	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_hikashop/classes/currency.php:434

JROOT/administrator/components/com_hikashop/classes/cart.php:1165

JROOT/components/com_hikashop/views/product/view.html.php:2037

JROOT/components/com_hikashop/views/product/view.html.php:37

JROOT/administrator/components/com_hikashop/helpers/helper.php:770

JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:61

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:982

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[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: 1.20 ms Memoria query: 0.022 MB memoria prima della query: 5.909 MB Righe restituite: 2

SELECT a.id 
  FROM fh40d_menu AS a 
  INNER JOIN `fh40d_menu_types` as b 
  on a.menutype = b.menutype 
  WHERE a.type='component' 
  AND a.published=1 
  AND b.title IS NOT NULL 
  AND a.client_id=0 
  AND a.link LIKE 'index.php?option=com_hikashop&view=%'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_client_id_parent_id_alias_language	1	const	21	1.22	Using where
1	SIMPLE	b	NULL	eq_ref	idx_menutype	idx_menutype	74	addart_db.a.menutype	1	83.33	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_hikashop/classes/menus.php:186

JROOT/components/com_hikashop/views/product/view.html.php:2105

JROOT/components/com_hikashop/views/product/view.html.php:2092

JROOT/components/com_hikashop/views/product/view.html.php:37

JROOT/administrator/components/com_hikashop/helpers/helper.php:770

JROOT/modules/mod_hikashop_cart/mod_hikashop_cart.php:61

JROOT/plugins/system/t3/includes/joomla30/modulehelper.php:195

JROOT/libraries/joomla/document/html/renderer/module.php:105

JROOT/libraries/joomla/document/html/renderer/modules.php:46

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:982

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[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: 2.83 ms Memoria query: 0.027 MB memoria prima della query: 6.233 MB Righe restituite: 1

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

  FROM fh40d_extensions

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/cache/controller/callback.php:158

JROOT/libraries/cms/component/helper.php:396

JROOT/libraries/cms/component/helper.php:43

JROOT/libraries/cms/component/helper.php:91

JROOT/components/com_content/router.php:37

JROOT/libraries/cms/router/site.php:463

JROOT/libraries/cms/router/site.php:426

JROOT/libraries/cms/router/router.php:231

JROOT/libraries/cms/router/site.php:106

JROOT/libraries/joomla/application/route.php:63

JROOT/plugins/system/t3/includes/menu/megamenu.php:162

JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84

JROOT/libraries/joomla/document/html/html.php:408

JROOT/libraries/joomla/document/html/html.php:690

JROOT/libraries/joomla/document/html/html.php:471

JROOT/libraries/cms/application/cms.php:982

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Tempo della query: 0.29 ms Dopo l'ultima query: 26.73 ms Memoria query: 0.019 MB memoria prima della query: 6.359 MB Righe restituite: 0

SELECT r.*

  FROM fh40d_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'component')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	25.00	Using where; Using filesort

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/rereplacer/helper.php:937

JROOT/plugins/system/rereplacer/helper.php:196

JROOT/plugins/system/rereplacer/helper.php:181

JROOT/plugins/system/rereplacer/rereplacer.php:109

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Tempo della query: 0.22 ms Dopo l'ultima query: 0.11 ms Memoria query: 0.019 MB memoria prima della query: 6.375 MB Righe restituite: 2

SELECT r.*

  FROM fh40d_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'body')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	25.00	Using where; Using filesort

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/rereplacer/helper.php:937

JROOT/plugins/system/rereplacer/helper.php:223

JROOT/plugins/system/rereplacer/helper.php:181

JROOT/plugins/system/rereplacer/rereplacer.php:109

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[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: 1.36 ms Memoria query: 0.019 MB memoria prima della query: 6.439 MB Righe restituite: 0

SELECT r.*

  FROM fh40d_rereplacer AS r

  WHERE r.published = 1 
  AND (r.area = 'everywhere')

  ORDER BY r.ordering, r.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	r	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	4	25.00	Using where; Using filesort

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.0 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/plugins/system/rereplacer/helper.php:937

JROOT/plugins/system/rereplacer/helper.php:255

JROOT/plugins/system/rereplacer/helper.php:181

JROOT/plugins/system/rereplacer/rereplacer.php:109

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

[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: 8.10 ms Memoria query: 0.020 MB memoria prima della query: 6.748 MB Righe restituite: 145

SELECT * 
  FROM fh40d_acymailing_config

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	fh40d_acymailing_config	NULL	ALL	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	145	100.00	NULL

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.1 ms
init	0.0 ms
System lock	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/administrator/components/com_acymailing/classes/cpanel.php:17

JROOT/administrator/components/com_acymailing/helpers/helper.php:473

JROOT/administrator/components/com_acymailing/helpers/helper.php:1183

JROOT/plugins/system/regacymailing/regacymailing.php:139

JROOT/libraries/joomla/event/event.php:71

JROOT/libraries/joomla/event/dispatcher.php:162

JROOT/libraries/joomla/application/base.php:106

JROOT/libraries/cms/application/cms.php:988

JROOT/libraries/cms/application/site.php:718

JROOT/libraries/cms/application/cms.php:251

JROOT/index.php:40

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

Tempo della query: 2.29 ms Dopo l'ultima query: 2.94 ms Memoria query: 0.003 MB memoria prima della query: 6.973 MB

UPDATE `fh40d_session`

  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1532150847;s:18:\"session.timer.last\";i:1532150847;s:17:\"session.timer.now\";i:1532150847;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:7:\"cart_id\";i:0;s:7:\"zone_id\";s:3:\"105\";s:7:\"user_id\";i:0;}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"b75c98dd52f523a0c137cfd374baa18a\";}'
	, `time` = '1532150847'

  WHERE `session_id` = 'p8bashifmjp9cv1ja6h6k6vd26'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	fh40d_session	NULL	range	PRIMARY	PRIMARY	602	const	1	100.00	Using where

Profilo

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.0 ms
updating	0.1 ms
end	0.0 ms
query end	2.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/joomla/session/storage/database.php:85

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

33 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

8 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM fh40d_extensions

4 × SELECT r.* 
  FROM fh40d_rereplacer AS r

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

1 × SELECT * 
  FROM fh40d_contact_details

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 `fh40d_contact_details` AS a 
  LEFT JOIN fh40d_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN fh40d_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN fh40d_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT a.id,a.title,a.state,a.access,a.created, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug, 
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug 
  FROM fh40d_content as a 
  LEFT JOIN fh40d_categories as c 
  on a.catid=c.id

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

1 × SELECT COUNT(*) 
  FROM `fh40d_contact_details` AS a 
  LEFT JOIN fh40d_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN fh40d_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN fh40d_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT * 
  FROM fh40d_hikashop_confi

1 × SELECT * 
  FROM fh40d_acymailing_confi

1 × SELECT a.id 
  FROM fh40d_menu AS a 
  INNER JOIN `fh40d_menu_types` as b 
  on a.menutype = b.menutype

1 × SELECT currency_id 
  FROM fh40d_hikashop_currency

1 × SELECT a.* 
  FROM fh40d_hikashop_cart AS a

1 × SELECT a.*, cc.access as category_access, cc.title as category_name,  
  CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(cc.alias) != 0 THEN CONCAT_WS(':', cc.id, cc.alias) ELSE cc.id END as catslug 
  FROM fh40d_contact_details AS a 
  INNER JOIN fh40d_categories AS cc 
  on cc.id = a.catid

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 fh40d_contact_details AS a 
  LEFT JOIN fh40d_categories AS c 
  on c.id = a.catid 
  LEFT JOIN fh40d_categories as parent 
  ON parent.id = c.parent_id

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

1 × SELECT id, rules 
  FROM `fh40d_viewlevels

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

1 × SELECT `session_id` 
  FROM `fh40d_session`

1 × SELECT `enabled` 
  FROM `fh40d_extensions`

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

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

1 × SELECT a.rules 
  FROM fh40d_assets AS a

```
1 × SELECT * 
  FROM fh40d_languages
```

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

1 × SELECT `data` 
  FROM `fh40d_session`

ALTRE tabelle:

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

1 × UPDATE `fh40d_session` 
  SET `data` = '__default|a:7:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1532150847;s:18:\"session.timer.last\";i:1532150847;s:17:\"session.timer.now\";i:1532150847;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":1:{s:12:\"com_hikashop\";O:8:\"stdClass\":3:{s:7:\"cart_id\";i:0;s:7:\"zone_id\";s:3:\"105\";s:7:\"user_id\";i:0;}}}s:4:\"user\";O:5:\"JUser\":25:{s:9:\"\\0\\0\\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:1:{i:0;s:1:\"9\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:12:\"requireReset\";N;s:10:\"\\0\\0\\0_params\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";a:2:{i:0;i:1;i:1;i:9;}s:14:\"\\0\\0\\0_authLevels\";a:3:{i:0;i:1;i:1;i:1;i:2;i:5;}s:15:\"\\0\\0\\0_authActions\";N;s:12:\"\\0\\0\\0_errorMsg\";N;s:10:\"\\0\\0\\0_errors\";a:0:{}s:3:\"aid\";i:0;}s:13:\"session.token\";s:32:\"b75c98dd52f523a0c137cfd374baa18a\";}'  , `time` = '1532150847'

1 × SHOW FULL COLUMNS 
  FROM `fh40d_contact_details

1 × SHOW FULL COLUMNS 
  FROM `fh40d_users

1 × INSERT INTO `fh40d_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('p8bashifmjp9cv1ja6h6k6vd26', 0, '1532150847'

1 × UPDATE `fh40d_extensions` 
  SET `params` = '{\"mediaversion\":\"e1da23acea10356fd732b4bfa33ce58f\"}'

```
1 × DELETE  
  FROM `fh40d_session`
```

ADD-art

Informazioni sul contatto

Modulo contatti

Acquisto

Informazioni

Hai bisogno di contattarci?

Console Debug Joomla!

Sessione

__default

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

45 query eseguite 21.4 ms

Trovati 3 duplicati!

33 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: