Console Debug Joomla!

Informazioni profilo

Tempo

Memoria

Tempo: 0.0 ms / 0.0 ms Memoria: 0.785 MB / 0.79 MB Application: afterLoad

Tempo: 204.5 ms / 204.5 ms Memoria: 5.616 MB / 6.40 MB Application: afterInitialise

Tempo: 24.1 ms / 228.6 ms Memoria: 0.430 MB / 6.83 MB Application: afterRoute

Tempo: 104.7 ms / 333.3 ms Memoria: 1.774 MB / 8.61 MB Application: afterDispatch

Tempo: 29.1 ms / 362.4 ms Memoria: 0.405 MB / 9.01 MB Application: beforeRenderModule mod_custom (Copyright)

Tempo: 11.1 ms / 373.5 ms Memoria: 0.101 MB / 9.11 MB Application: afterRenderModule mod_custom (Copyright)

Tempo: 0.2 ms / 373.7 ms Memoria: 0.000 MB / 9.11 MB Application: beforeRenderModule mod_custom (Social Icons)

Tempo: 1.3 ms / 375.1 ms Memoria: 0.007 MB / 9.12 MB Application: afterRenderModule mod_custom (Social Icons)

Tempo: 0.1 ms / 375.2 ms Memoria: 0.000 MB / 9.11 MB Application: beforeRenderModule mod_custom (Contatti)

Tempo: 1.7 ms / 376.8 ms Memoria: 0.007 MB / 9.12 MB Application: afterRenderModule mod_custom (Contatti)

Tempo: 0.2 ms / 377.0 ms Memoria: 0.000 MB / 9.12 MB Application: beforeRenderModule mod_custom (Mappa)

Tempo: 1.4 ms / 378.5 ms Memoria: 0.007 MB / 9.12 MB Application: afterRenderModule mod_custom (Mappa)

Tempo: 0.2 ms / 378.6 ms Memoria: 0.000 MB / 9.12 MB Application: beforeRenderModule mod_custom (Galleria)

Tempo: 1.5 ms / 380.1 ms Memoria: 0.007 MB / 9.13 MB Application: afterRenderModule mod_custom (Galleria)

Tempo: 0.2 ms / 380.3 ms Memoria: 0.001 MB / 9.13 MB Application: beforeRenderModule mod_weather_gk4 (mod_weather_gk4)

Tempo: 20.5 ms / 400.8 ms Memoria: 0.339 MB / 9.47 MB Application: afterRenderModule mod_weather_gk4 (mod_weather_gk4)

Tempo: 0.5 ms / 401.3 ms Memoria: 0.000 MB / 9.42 MB Application: beforeRenderModule mod_custom (L'Epomeo)

Tempo: 1.8 ms / 403.1 ms Memoria: 0.007 MB / 9.43 MB Application: afterRenderModule mod_custom (L'Epomeo)

Tempo: 0.3 ms / 403.4 ms Memoria: 0.000 MB / 9.42 MB Application: beforeRenderModule mod_custom (Instagram)

Tempo: 27.0 ms / 430.4 ms Memoria: 0.404 MB / 9.83 MB Application: afterRenderModule mod_custom (Instagram)

Tempo: 0.2 ms / 430.6 ms Memoria: 0.000 MB / 9.83 MB Application: beforeRenderModule mod_custom (Chi siamo)

Tempo: 4.9 ms / 435.5 ms Memoria: 0.007 MB / 9.83 MB Application: afterRenderModule mod_custom (Chi siamo)

Tempo: 0.2 ms / 435.7 ms Memoria: 0.000 MB / 9.83 MB Application: beforeRenderModule mod_custom (Hero Slider)

Tempo: 5.0 ms / 440.6 ms Memoria: 0.007 MB / 9.84 MB Application: afterRenderModule mod_custom (Hero Slider)

Tempo: 0.2 ms / 440.8 ms Memoria: 0.000 MB / 9.84 MB Application: beforeRenderModule mod_custom (Contatti_Laterali)

Tempo: 5.5 ms / 446.3 ms Memoria: 0.007 MB / 9.84 MB Application: afterRenderModule mod_custom (Contatti_Laterali)

Tempo: 0.2 ms / 446.5 ms Memoria: 0.000 MB / 9.84 MB Application: beforeRenderModule mod_menu (Menu Principale)

Tempo: 25.7 ms / 472.2 ms Memoria: 0.178 MB / 10.02 MB Application: afterRenderModule mod_menu (Menu Principale)

Tempo: 0.2 ms / 472.3 ms Memoria: 0.000 MB / 10.01 MB Application: beforeRenderModule mod_languages (Lingua)

Tempo: 43.2 ms / 515.6 ms Memoria: 0.722 MB / 10.74 MB Application: afterRenderModule mod_languages (Lingua)

Tempo: 24.6 ms / 540.2 ms Memoria: 0.116 MB / 10.85 MB Application: afterRender

Query totali del database: 15.2 ms

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

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

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

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

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

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

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

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

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

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

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

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

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

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	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	Sql792208_2.s.template,const	1	Using where

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

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

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	range	idx_lft_rgt	idx_lft_rgt	4	NULL	11	Using where

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	fp	ALL	PRIMARY	NON E' POSSIBILE UTILIZZARE ALCUN INDICE	NULL	NULL	1	Using temporary; Using filesort
1	PRIMARY	a	eq_ref	PRIMARY,idx_access,idx_catid,idx_language	PRIMARY	4	Sql792208_2.fp.content_id	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql792208_2.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.a.created_by	1
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.a.modified_by	1
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.c.parent_id	1
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.a.id	1
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	10	Using where; Using index; Using join buffer

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	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
1	PRIMARY	a	eq_ref	PRIMARY,idx_access,idx_catid,idx_language	PRIMARY	4	Sql792208_2.fp.content_id	1	Using where
1	PRIMARY	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	Sql792208_2.a.catid	1	Using where
1	PRIMARY	ua	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.a.created_by	1	Using index
1	PRIMARY	uam	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.a.modified_by	1	Using index
1	PRIMARY	parent	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.c.parent_id	1	Using index
1	PRIMARY	v	eq_ref	PRIMARY	PRIMARY	4	Sql792208_2.a.id	1	Using index
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	10	Using where; Using index; Using join buffer

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

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

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

EXPLAIN non possibile sulla query: UPDATE `iezip_session` SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695503846;s:18:\"session.timer.last\";i:1695503846;s:17:\"session.timer.now\";i:1695503846;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` = '1695503847' WHERE `session_id` = 'r1iuj80seiuurva9ni9qrp3e31'

Profilo

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

20 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

5 × SELECT extension_id AS id, element AS "option", params, enabled 
  FROM iezip_extensions

2 × SELECT m2.language, m2.id 
  FROM iezip_menu as m 
  INNER JOIN iezip_associations as a 
  ON a.id=m.id 
  AND a.context='com_menus.item' 
  INNER JOIN iezip_associations as a2 
  ON a.key=a2.key 
  INNER JOIN iezip_menu as m2 
  ON a2.id=m2.id

1 × SELECT a.rules 
  FROM iezip_assets AS a

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

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

1 × SELECT COUNT(*) 
  FROM iezip_content AS a 
  LEFT JOIN iezip_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN iezip_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN iezip_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN iezip_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN iezip_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM iezip_categories AS cat JOIN iezip_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

```
1 × SELECT * 
  FROM iezip_rokcandy
```

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore,
  CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published, 
  CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published 
  FROM iezip_content AS a 
  LEFT JOIN iezip_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN iezip_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN iezip_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN iezip_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN iezip_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN (SELECT cat.id as id 
  FROM iezip_categories AS cat JOIN iezip_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

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

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

1 × SELECT `session_id` 
  FROM `iezip_session`

1 × SELECT id, rules 
  FROM `iezip_viewlevels

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

1 × SELECT COUNT(*) 
  FROM `iezip_menu`

```
1 × SELECT * 
  FROM iezip_languages
```

1 × SELECT `data` 
  FROM `iezip_session`

ALTRE tabelle:

1 × UPDATE `iezip_session` 
  SET `data` = '__default|a:6:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695503846;s:18:\"session.timer.last\";i:1695503846;s:17:\"session.timer.now\";i:1695503846;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` = '1695503847'

1 × UPDATE `iezip_extensions` 
  SET `params` = '{\"mediaversion\":\"8e7270af0689e464ec690da3a88b87f0\"}'

1 × INSERT INTO `iezip_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('r1iuj80seiuurva9ni9qrp3e31', 0, '1695503846'

Chi siamo

L'Epomeo

Serrara Fontana

Console Debug Joomla!

Sessione

__default

Informazioni profilo

Tempo

Memoria

Utilizzo memoria

Query Database

25 query eseguite 15.2 ms

Trovati 2 duplicati!

20 tipi di query eseguite, ordinate per Occurrences

Tabelle SELECT:

ALTRE tabelle: