Console de débogage Joomla!

11 requêtes exécutées 28.4 ms

Temps de requête : 1.25 ms

SELECT `data`

  FROM `jos_session`

  WHERE `session_id` = '20fbbe7fe42e6b82256681164ee35bb2'

Explication

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

Profil

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.1 ms
checking permissions	0.0 ms
Opening tables	0.4 ms
init	0.0 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.1 ms
optimizing	0.0 ms
statistics	0.1 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
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.5 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:668

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.50 ms Après la dernière requête : 1.76 ms

DELETE 

  FROM `jos_session`

  WHERE `time` < '1695662229'

Explication

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

Profil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.1 ms
updating	0.2 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	1.6 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.88 ms Après la dernière requête : 0.09 ms

SELECT `session_id`

  FROM `jos_session`

  WHERE `session_id` = '20fbbe7fe42e6b82256681164ee35bb2' 
  LIMIT 0, 1

Explication

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

Profil

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

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.18 ms Après la dernière requête : 0.09 ms

INSERT INTO `jos_session`
(`session_id`, `client_id`, `time`) 
  VALUES 
('20fbbe7fe42e6b82256681164ee35bb2', 0, '1695663129')

Explication

EXPLAIN impossible sur la requête : INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('20fbbe7fe42e6b82256681164ee35bb2', 0, '1695663129')

Profil

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
update	0.1 ms
Waiting for query cache lock	0.0 ms
update	0.0 ms
end	0.0 ms
query end	1.4 ms
closing tables	0.1 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

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

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

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

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

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

JROOT/libraries/joomla/factory.php:124

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.54 ms Après la dernière requête : 5.39 ms

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explication

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

Profil

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	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
cleaning up	0.0 ms

Call Stack

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

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

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:575

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

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

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 0.46 ms Après la dernière requête : 0.13 ms

SELECT id, rules

  FROM `jos_viewlevels`

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_viewlevels	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	5	100.00	NULL

Profil

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	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.1 ms
cleaning up	0.0 ms

Call Stack

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

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:575

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

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

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 6.11 ms Après la dernière requête : 28.50 ms

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM jos_menu AS m

  LEFT JOIN jos_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

Explication

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	62	3.33	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	rsccttfrfimod1.m.component_id	1	100.00	Using where

Profil

Status	Duration
starting	0.0 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	2.4 ms
init	0.3 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.3 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.0 ms
Creating sort index	0.7 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.4 ms
Waiting for query cache lock	0.0 ms
Creating sort index	0.2 ms
Waiting for query cache lock	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
Waiting for query cache lock	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	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:353

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

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:1018

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

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

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

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.94 ms Après la dernière requête : 5.99 ms

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"9c19b228387daa4542c6a8db5bdacbf2\"}'

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

Explication

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

Profil

Status	Duration
starting	0.1 ms
checking permissions	0.0 ms
Opening tables	0.0 ms
init	0.0 ms
System lock	0.2 ms
updating	0.1 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.2 ms
query end	1.7 ms
closing tables	0.0 ms
freeing items	0.1 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/jcomments/jcomments.php:111

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:1027

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

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

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

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 5.09 ms Après la dernière requête : 29.60 ms

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

  FROM jos_categories as c

  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN `jos_content` AS i 
  ON i.`catid` = c.id 
  AND i.state = 1

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

  GROUP BY 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

  ORDER BY c.lft

Explication

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using temporary; Utilisation du tri complet de type filesort
1	PRIMARY	c	NULL	ALL	cat_idx,idx_access,idx_left_right	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	29	40.23	Using where
1	PRIMARY	<derived2>	NULL	ALL	NULL	INDEX N'A PU ÊTRE UTILISÉ	NULL	NULL	11	10.00	Using where; Not exists; Using join buffer (Block Nested Loop)
1	PRIMARY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	rsccttfrfimod1.c.id	8	100.00	Using where
2	DERIVED	parent	NULL	range	cat_idx,idx_left_right	cat_idx	153	NULL	4	100.00	Using index condition; Using temporary; Utilisation du tri complet de type filesort
2	DERIVED	cat	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout,idx_path,idx_left_right,idx_alias,idx_language	idx_left_right	8	NULL	29	11.11	Using where; Using index; Using join buffer (Block Nested Loop)

Profil

Status	Duration
starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	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
checking permissions	0.0 ms
Opening tables	1.0 ms
init	0.3 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.1 ms
optimizing	0.0 ms
optimizing	0.0 ms
statistics	0.1 ms
preparing	0.1 ms
Creating tmp table	0.0 ms
Sorting result	0.1 ms
statistics	0.3 ms
preparing	0.1 ms
Creating tmp table	0.1 ms
Sorting result	0.0 ms
executing	0.0 ms
Sending data	0.1 ms
executing	0.0 ms
Sending data	0.2 ms
Creating sort index	0.7 ms
Creating sort index	0.1 ms
end	0.0 ms
query end	0.0 ms
removing tmp table	0.1 ms
query end	0.0 ms
removing tmp table	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
Waiting for query cache lock	0.0 ms
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.6 ms
cleaning up	0.1 ms

Call Stack

JROOT/libraries/legacy/categories/categories.php:288

JROOT/libraries/legacy/categories/categories.php:181

JROOT/components/com_content/models/categories.php:109

JROOT/libraries/legacy/view/legacy.php:398

JROOT/libraries/legacy/view/categories.php:57

JROOT/libraries/joomla/cache/controller/view.php:98

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

JROOT/components/com_content/controller.php:79

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

JROOT/components/com_content/content.php:16

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

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

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

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

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

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 3.47 ms Après la dernière requête : 22.22 ms

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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 <= '2023-09-25 17:32:09') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-09-25 17:32:09') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 191 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explication

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	25	2.08	Using index condition; Using where; Utilisation du tri complet de type filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	303	rsccttfrfimod1.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	rsccttfrfimod1.m.id	1	40.00	Using where; Using index

Profil

Status	Duration
starting	0.1 ms
Waiting for query cache lock	0.0 ms
starting	0.0 ms
checking query cache for query	0.2 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
checking permissions	0.0 ms
Opening tables	0.9 ms
init	0.1 ms
System lock	0.0 ms
Waiting for query cache lock	0.0 ms
System lock	0.1 ms
optimizing	0.1 ms
statistics	0.2 ms
preparing	0.1 ms
Sorting result	0.0 ms
executing	0.1 ms
Sending data	0.0 ms
Creating sort index	0.8 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
freeing items	0.1 ms
Waiting for query cache lock	0.0 ms
freeing items	0.0 ms
storing result in query cache	0.0 ms
cleaning up	0.0 ms

Call Stack

JROOT/libraries/cms/module/helper.php:376

JROOT/libraries/cms/module/helper.php:84

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

JROOT/templates/joomspirit_76/index.php:126

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

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

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

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

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

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

JROOT/index.php:7

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

Temps de requête : 2.95 ms Après la dernière requête : 355.30 ms

UPDATE `jos_session`

  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695663129;s:18:\"session.timer.last\";i:1695663129;s:17:\"session.timer.now\";i:1695663129;s:24:\"session.client.forwarded\";s:14:\"44.192.254.173\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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\";N;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\";N;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:\"6ae8ff96c05e4236bb5e60d501c297db\";}'
	, `time` = '1695663129'

  WHERE `session_id` = '20fbbe7fe42e6b82256681164ee35bb2'

Explication

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

Profil

Status	Duration
starting	0.2 ms
checking permissions	0.0 ms
Opening tables	0.5 ms
init	0.0 ms
System lock	0.1 ms
updating	0.2 ms
end	0.0 ms
Waiting for query cache lock	0.0 ms
end	0.0 ms
query end	1.4 ms
closing tables	0.0 ms
freeing items	0.1 ms
cleaning up	0.0 ms

Call Stack

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

[Ajouter xdebug.file_link_format directive à votre php.ini file pour obtenir des liens vers les fichiers]

11 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

1 × 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,COUNT(i.`id`) AS numitems 
  FROM jos_categories as c 
  LEFT JOIN jos_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 jos_categories AS cat JOIN jos_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 jos_modules AS m 
  LEFT JOIN jos_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN jos_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT `session_id` 
  FROM `jos_session`

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

1 × SELECT `data` 
  FROM `jos_session`

Autres tables :

1 × UPDATE `jos_session` 
  SET `data` = '__default|a:9:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1695663129;s:18:\"session.timer.last\";i:1695663129;s:17:\"session.timer.now\";i:1695663129;s:24:\"session.client.forwarded\";s:14:\"44.192.254.173\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";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\";N;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\";N;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:\"6ae8ff96c05e4236bb5e60d501c297db\";}'  , `time` = '1695663129'

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"9c19b228387daa4542c6a8db5bdacbf2\"}'

1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) 
  VALUES  ('20fbbe7fe42e6b82256681164ee35bb2', 0, '1695663129'

```
1 × DELETE  
  FROM `jos_session`
```

RSCC TENNIS DE TABLE

Console de débogage Joomla!

Session

__default

Profil d'information

Temps

Mémoire

Occupation de la mémoire

Requêtes de base de données

11 requêtes exécutées 28.4 ms

11 types de requêtes exécutées, triées par occurrences.

Tables sélectionnées :

Autres tables :