Inserisci parte del titolo

Visualizza n.

This website uses cookies to manage authentication, navigation, and other functions. By using our website, you agree that we can place these types of cookies on your device.

Console Debug Joomla!

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.2 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.2 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.3 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

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

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

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

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hr2hx_extensions	ref	extension	extension	62	const	57	Using where; Using filesort

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.3 ms
Sending data	0.2 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.2 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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	5	Using where

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

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	5	Using where

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

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

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

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.1 ms
Updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.3 ms
query end	0.1 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

Status	Duration
starting	0.0 ms
checking permissions	0.0 ms
Opening tables	0.5 ms
System lock	0.0 ms
init	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
Sending data	0.1 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
removing tmp table	0.6 ms
closing tables	0.0 ms
freeing items	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.5 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

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

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	11	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	Sql875898_1.m.component_id	1

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.2 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.0 ms
executing	0.0 ms
Sorting result	0.2 ms
Sending data	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

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

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	5	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	Sql875898_1.s.template,const	1	Using where

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
init	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.2 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

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

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.0 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
init	0.0 ms
optimizing	0.0 ms
statistics	0.0 ms
preparing	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	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
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	index_merge	idx_tag_type,idx_tag,idx_core_content_id	idx_tag,idx_tag_type	4,4	NULL	3	Using intersect(idx_tag,idx_tag_type); Using where; Using temporary; Using filesort
1	SIMPLE	ct	ref	idx_alias	idx_alias	767	Sql875898_1.m.type_alias	1
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	Sql875898_1.m.core_content_id	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql875898_1.c.core_created_user_id	1

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.4 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
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
init	0.2 ms
optimizing	0.0 ms
statistics	0.5 ms
preparing	0.1 ms
Creating tmp table	0.6 ms
executing	0.0 ms
Copying to tmp table	1.6 ms
Sorting result	0.1 ms
Sending data	0.2 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Sending data	0.2 ms
end	0.0 ms
removing tmp table	0.5 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.3 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	index_merge	idx_tag_type,idx_tag,idx_core_content_id	idx_tag,idx_tag_type	4,4	NULL	3	Using intersect(idx_tag,idx_tag_type); Using where; Using temporary; Using filesort
1	SIMPLE	ct	ref	idx_alias	idx_alias	767	Sql875898_1.m.type_alias	1
1	SIMPLE	c	eq_ref	PRIMARY,tag_idx,idx_access,idx_content_type	PRIMARY	4	Sql875898_1.m.core_content_id	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	Sql875898_1.c.core_created_user_id	1

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
checking query cache for query	0.3 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
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.1 ms
init	0.2 ms
optimizing	0.0 ms
statistics	0.5 ms
preparing	0.1 ms
Creating tmp table	0.6 ms
executing	0.0 ms
Copying to tmp table	1.7 ms
Sorting result	0.1 ms
Sending data	0.2 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
Sending data	0.2 ms
end	0.0 ms
removing tmp table	0.3 ms
end	0.0 ms
query end	0.0 ms
closing tables	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
Waiting for query cache lock	0.0 ms
Waiting on query cache mutex	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.1 ms
logging slow query	0.0 ms
cleaning up	0.0 ms

EXPLAIN non possibile sulla query: UPDATE `hr2hx_session` SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1729067775;s:18:\"session.timer.last\";i:1729067775;s:17:\"session.timer.now\";i:1729067775;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":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;}}' , `time` = '1729067775' WHERE `session_id` = 'g4cuc96j4inr1lid5qi3ktoa34'

Profilo

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
System lock	0.0 ms
init	0.1 ms
Updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	0.1 ms
closing tables	0.0 ms
freeing items	0.0 ms
logging slow query	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]

27 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

6 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM hr2hx_extensions

2 × SELECT `extension_id` 
  FROM `hr2hx_extensions`

2 × SELECT m.type_alias, m.content_item_id, m.core_content_id, count(m.tag_id) AS match_count,  MAX(m.tag_date) as tag_date, MAX(c.core_title) AS core_title,MAX(c.core_alias) AS core_alias, MAX(c.core_body) AS core_body, MAX(c.core_state) AS core_state, MAX(c.core_access) AS core_access,MAX(c.core_metadata) AS core_metadata, MAX(c.core_created_user_id) AS core_created_user_id, MAX(c.core_created_by_alias) AS core_created_by_alias,MAX(c.core_created_time) as core_created_time, MAX(c.core_images) as core_images,
  CASE WHEN c.core_modified_time = '0000-00-00 00:00:00' THEN c.core_created_time ELSE c.core_modified_time END as core_modified_time,MAX(c.core_language) AS core_language, MAX(c.core_catid) AS core_catid,MAX(c.core_publish_up) AS core_publish_up, MAX(c.core_publish_down) as core_publish_down,MAX(ct.type_title) AS content_type_title, MAX(ct.router) AS router,
  CASE WHEN c.core_created_by_alias > ' ' THEN c.core_created_by_alias ELSE ua.name END AS author,ua.email AS author_email 
  FROM hr2hx_contentitem_tag_map AS m 
  INNER JOIN hr2hx_ucm_content AS c 
  ON m.type_alias = c.core_type_alias 
  AND m.core_content_id = c.core_content_id 
  AND c.core_state IN (1) 
  AND (c.core_publish_up = '0000-00-00 00:00:00' OR c.core_publish_up <= '2024-10-16 08:36:15') 
  AND (c.core_publish_down = '0000-00-00 00:00:00' OR  c.core_publish_down >= '2024-10-16 08:36:15') 
  INNER JOIN hr2hx_content_types AS ct 
  ON ct.type_alias = m.type_alias 
  LEFT JOIN hr2hx_users AS ua 
  ON ua.id = c.core_created_user_id

```
2 × SELECT * 
  FROM hr2hx_tags
```

2 × SELECT template 
  FROM hr2hx_template_styles as s

2 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM hr2hx_categories as c 
  LEFT JOIN hr2hx_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt) 
  LEFT JOIN  (SELECT cat.id as id 
  FROM hr2hx_categories AS cat JOIN hr2hx_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
2 × SELECT * 
  FROM hr2hx_extensions
```

1 × SELECT a.rules 
  FROM hr2hx_assets AS a

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

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

1 × SELECT `session_id` 
  FROM `hr2hx_session`

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

1 × SELECT id, rules 
  FROM `hr2hx_viewlevels

1 × SELECT * 
  FROM `hr2hx_content_types

1 × SELECT `data` 
  FROM `hr2hx_session`

1 × SELECT folder AS type, element AS name, params 
  FROM hr2hx_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 hr2hx_menu AS m 
  LEFT JOIN hr2hx_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT * 
  FROM hr2hx_languages
```

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

1 × SELECT extension, file, type 
  FROM hr2hx_rokcommon_configs

ALTRE tabelle:

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

1 × UPDATE `hr2hx_session` 
  SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1729067775;s:18:\"session.timer.last\";i:1729067775;s:17:\"session.timer.now\";i:1729067775;s:8:\"registry\";O:24:\"Joomla\\Registry\\Registry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":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;}}'  , `time` = '1729067775'

1 × SHOW FULL COLUMNS 
  FROM `hr2hx_tags

1 × SHOW FULL COLUMNS 
  FROM `hr2hx_extensions

1 × INSERT INTO `hr2hx_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('g4cuc96j4inr1lid5qi3ktoa34', 0, '1729067775'

1 × UPDATE `hr2hx_extensions` 
  SET `params` = '{\"mediaversion\":\"24b8f11b5d130c62bd0668ac9ce2dcaa\"}'

```
1 × DELETE  
  FROM `hr2hx_session`
```

Alessandro Santoriello

Visual Designer

Assoclima

Biesse

Creden

DeCecco

Fileni eBox

Fiorentini

Galvanina

Geberit

Giorgetti

Holon Platform

Luisa Spagnoli

Panaria

Rig'N'Roll

Scavolini

Scm

Softer

Strateg.ee

Targetti

TeamSystem

Zoppas

Console Debug Joomla!

Sessione

__default

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

38 query eseguite 46.9 ms

Trovati 6 duplicati!

27 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle:

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	idx_asset_name	idx_asset_name	152	const	1	Using temporary; Using filesort
1	SIMPLE	b	ALL	idx_lft_rgt	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	245

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	0	const row not found
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	9	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using where; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	9	Using where; Using index; Using join buffer

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