Konsola diagnostyczna Joomla!

Czas

Pamięć

8 zapytań zarejestrowanych 3.0 ms

1. Czas zapytania: 0.29 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 2.263 MB Zwróconych wierszy: 0

   SELECT `data`
   
     FROM `stporg_session`
   
     WHERE `session_id` = 'j14on53lt4g11d8o98n1ltcqr2'

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.0 ms
   Optimizing	0.0 ms
   Statistics	0.0 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

2. Czas zapytania: 0.16 ms Po ostatnim zapytaniu: 1.40 ms Pamięć zapytania: 0.010 MB Pamięć przed zapytaniem: 2.402 MB Zwróconych wierszy: 0

   SELECT `session_id`
   
     FROM `stporg_session`
   
     WHERE `session_id` = 'j14on53lt4g11d8o98n1ltcqr2' 
     LIMIT 0, 1

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.0 ms
   Optimizing	0.0 ms
   Statistics	0.0 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

3. Czas zapytania: 0.41 ms Po ostatnim zapytaniu: 0.07 ms Pamięć zapytania: 0.009 MB Pamięć przed zapytaniem: 2.414 MB

   INSERT INTO `stporg_session`
   (`session_id`, `client_id`, `time`) 
     VALUES 
   ('j14on53lt4g11d8o98n1ltcqr2', 0, '1726190622')

   Objaśnienie

   Polecenie EXPLAIN niemożliwe w zapytaniu: INSERT INTO `stporg_session` (`session_id`, `client_id`, `time`) VALUES ('j14on53lt4g11d8o98n1ltcqr2', 0, '1726190622')

   Profile

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init for update	0.0 ms
   Update	0.1 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.2 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

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

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

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

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

   JROOT/libraries/joomla/factory.php:124

   JROOT/index.php:37

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

4. Czas zapytania: 0.30 ms Po ostatnim zapytaniu: 2.59 ms Pamięć zapytania: 0.013 MB Pamięć przed zapytaniem: 2.866 MB Zwróconych wierszy: 1

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

   Objaśnienie

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

   Profile

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	0.0 ms
   Optimizing	0.0 ms
   Statistics	0.0 ms
   Preparing	0.0 ms
   Unlocking tables	0.0 ms
   Preparing	0.0 ms
   Executing	0.0 ms
   Sending data	0.0 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

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

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

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

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

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

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

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

   JROOT/index.php:40

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

5. Czas zapytania: 0.23 ms Po ostatnim zapytaniu: 0.29 ms Pamięć zapytania: 0.011 MB Pamięć przed zapytaniem: 2.929 MB Zwróconych wierszy: 3

   SELECT id, rules
   
     FROM `stporg_viewlevels`

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	stporg_viewlevels	ALL	NULL	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	3	100.00

   Profile

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	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 of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

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

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

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

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

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

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

   JROOT/index.php:40

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

6. Czas zapytania: 0.75 ms Po ostatnim zapytaniu: 10.70 ms Pamięć zapytania: 0.018 MB Pamięć przed zapytaniem: 4.797 MB Zwróconych wierszy: 79

   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 stporg_menu AS m
   
     LEFT JOIN stporg_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

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	Nie można korzystać z żadnych kluczy indeksowych.	NULL	NULL	287	74.22	Using where; Uruchomiono metodę filesort
   1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	stepnica_org.m.component_id	1	100.00	Using where

   Profile

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init	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 of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.0 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

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

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

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

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

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

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

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

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

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

   JROOT/index.php:40

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

7. Czas zapytania: 0.40 ms Po ostatnim zapytaniu: 3.68 ms Pamięć zapytania: 0.018 MB Pamięć przed zapytaniem: 5.881 MB

   UPDATE `stporg_extensions`
   
     SET `params` = '{\"mediaversion\":\"b2322b0936bcf84236c26e9d145cc372\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	stporg_extensions	range	element_clientid,element_folder_clientid,extension	extension	364	NULL	1	100.00	Using where

   Profile

   Status	Duration
   Starting	0.0 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init for update	0.0 ms
   Updating	0.1 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.2 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

   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/k2/k2.php:52

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

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

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

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

   JROOT/index.php:40

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

8. Czas zapytania: 0.52 ms Po ostatnim zapytaniu: 16.78 ms Pamięć zapytania: 0.003 MB Pamięć przed zapytaniem: 7.903 MB

   UPDATE `stporg_session`
   
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1726190622;s:18:\"session.timer.last\";i:1726190622;s:17:\"session.timer.now\";i:1726190622;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{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:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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:19:\"com_mailto.formtime\";i:1726190622;s:13:\"session.token\";s:32:\"17f5a2ecb445cd3b8e6294f1d148079d\";}'
   	, `time` = '1726190623'
   
     WHERE `session_id` = 'j14on53lt4g11d8o98n1ltcqr2'

   Objaśnienie

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	stporg_session	range	PRIMARY	PRIMARY	602	NULL	1	100.00	Using where

   Profile

   Status	Duration
   Starting	0.1 ms
   Checking permissions	0.0 ms
   Opening tables	0.0 ms
   After opening tables	0.0 ms
   System lock	0.0 ms
   Table lock	0.0 ms
   Init for update	0.0 ms
   Updating	0.1 ms
   End of update loop	0.0 ms
   Query end	0.0 ms
   Commit	0.2 ms
   Closing tables	0.0 ms
   Unlocking tables	0.0 ms
   Closing tables	0.0 ms
   Starting cleanup	0.0 ms
   Freeing items	0.0 ms
   Updating status	0.0 ms
   Reset for next command	0.0 ms

   Stos wywołania

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

   [Dodaj dyrektywę xdebug.file_link_format do pliku php.ini, aby uzyskać łącza do plików]

   ---

8 typów zapytań zarejestrowanych, posortowanych według częstotliwości

WYBRANE tabele:

1. 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 stporg_menu AS m 
     LEFT JOIN stporg_extensions AS e 
     ON m.component_id = e.extension_id

2. 1 × SELECT id, rules 
     FROM `stporg_viewlevels

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

4. 1 × SELECT `session_id` 
     FROM `stporg_session`

5. 1 × SELECT `data` 
     FROM `stporg_session`

INNE tabele:

1. 1 × UPDATE `stporg_session` 
     SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1726190622;s:18:\"session.timer.last\";i:1726190622;s:17:\"session.timer.now\";i:1726190622;s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":24:{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:\"1\";}s:5:\"guest\";i:1;s:13:\"lastResetTime\";N;s:10:\"resetCount\";N;s:10:\"\\0\\0\\0_params\";O:9:\"JRegistry\":1:{s:7:\"\\0\\0\\0data\";O:8:\"stdClass\":0:{}}s:14:\"\\0\\0\\0_authGroups\";N;s:14:\"\\0\\0\\0_authLevels\";a:2:{i:0;i:1;i:1;i:1;}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:19:\"com_mailto.formtime\";i:1726190622;s:13:\"session.token\";s:32:\"17f5a2ecb445cd3b8e6294f1d148079d\";}'  , `time` = '1726190623'

2. 1 × UPDATE `stporg_extensions` 
     SET `params` = '{\"mediaversion\":\"b2322b0936bcf84236c26e9d145cc372\"}'

3. 1 × INSERT INTO `stporg_session` (`session_id`, `client_id`, `time`) 
     VALUES  ('j14on53lt4g11d8o98n1ltcqr2', 0, '1726190622'