Jaunumi

Šajā kategorijā nav rakstu. Ja šajā lapā tiek rādītas apakškategorijas, tajās var būt raksti.

Sākums
Iepriekšējā
1
2
3
4
5
6
7
Turpināt
Beigas

Joomla! kļūdu konsole

Veikti 5 vaicājumi 5.98 ms

Vaicājuma izpildes laiks: 1.63 ms Atmiņa vaicājumiem: 0.021 MB izmantots pirms vaicājuma: 1.670 MB Atrastas: 0 rindas

SELECT `data`

  FROM `sx9fk_session`

  WHERE `session_id` = X'616d646e6c6a6739733670696d73616e656f6a6b6e756b763431'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sx9fk_session	const	PRIMARY	PRIMARY	194	const	1

Vaicājuma izpildes dati

Status	Duration
Starting	0.16 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.02 ms
Query end	0.02 ms
Commit	0.02 ms
Query end	0.04 ms
closing tables	0.03 ms
Unlocking tables	0.02 ms
closing tables	0.02 ms
Query end	0.02 ms
Starting cleanup	0.02 ms
Freeing items	0.12 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Tas pats kas izsaukuma rindā zemāk.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

Vaicājuma izpildes laiks: 0.67 ms Pēc pēdējā vaicājuma: 0.98 ms Atmiņa vaicājumiem: 0.013 MB izmantots pirms vaicājuma: 1.727 MB Atrastas: 0 rindas

SELECT `session_id`

  FROM `sx9fk_session`

  WHERE `session_id` = X'616d646e6c6a6739733670696d73616e656f6a6b6e756b763431' 
  LIMIT 1

Explain

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

Vaicājuma izpildes dati

Status	Duration
Starting	0.12 ms
checking permissions	0.03 ms
Opening tables	0.03 ms
After opening tables	0.02 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

Vaicājuma izpildes laiks: 0.83 ms Pēc pēdējā vaicājuma: 0.25 ms Atmiņa vaicājumiem: 0.010 MB izmantots pirms vaicājuma: 1.744 MB

INSERT INTO `sx9fk_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'616d646e6c6a6739733670696d73616e656f6a6b6e756b763431', 1, 1765608702, 0, '', 0)

Explain

EXPLAIN nav iespējams vaicājumam: INSERT INTO `sx9fk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'616d646e6c6a6739733670696d73616e656f6a6b6e756b763431', 1, 1765608702, 0, '', 0)

Vaicājuma izpildes dati

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.02 ms
table lock	0.02 ms
init for update	0.03 ms
Update	0.17 ms
Waiting for query cache lock	0.02 ms
Update	0.02 ms
End of update loop	0.01 ms
Query end	0.03 ms
Commit	0.06 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

Vaicājuma izpildes laiks: 1.66 ms Pēc pēdējā vaicājuma: 2.38 ms Atmiņa vaicājumiem: 0.014 MB izmantots pirms vaicājuma: 1.924 MB Atrastas: 5 rindas

SELECT id, rules

  FROM `sx9fk_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	sx9fk_viewlevels	ALL	NULL	NAV IESPĒJAMS IZMANTOT INDEKSU	NULL	NULL	5

Vaicājuma izpildes dati

Status	Duration
Starting	0.14 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
table lock	0.01 ms
init	0.02 ms
Optimizing	0.03 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.08 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
Query end	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.06 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

Vaicājuma izpildes laiks: 1.19 ms Pēc pēdējā vaicājuma: 0.31 ms Atmiņa vaicājumiem: 0.015 MB izmantots pirms vaicājuma: 1.948 MB Atrastas: 2 rindas

SELECT b.id

  FROM sx9fk_usergroups AS a

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

  WHERE a.id = 9

Explain

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	2	Using where; Using index

Vaicājuma izpildes dati

Status	Duration
Starting	0.17 ms
checking permissions	0.04 ms
Opening tables	0.05 ms
After opening tables	0.06 ms
System lock	0.02 ms
table lock	0.02 ms
init	0.04 ms
Optimizing	0.05 ms
Statistics	0.14 ms
Preparing	0.03 ms
Unlocking tables	0.02 ms
Preparing	0.05 ms
Executing	0.02 ms
Sending data	0.04 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.02 ms
Query end	0.02 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Query end	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.07 ms
Updating status	0.04 ms
Reset for next command	0.03 ms

Steks

#	Izsaukšanas vieta	Datne un rindas numurs
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Pievienojiet xdebug.file_link_format direktīvu php.ini datnei, lai tiktu ģenerētas datņu saites.]

5 dažādie vaicājumi, sakārtoti pēc skaita.

SELECT vaicājumi:

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

1 × SELECT id, rules 
  FROM `sx9fk_viewlevels

1 × SELECT `session_id` 
  FROM `sx9fk_session`

1 × SELECT `data` 
  FROM `sx9fk_session`

Citi vaicājumi:

1 × INSERT INTO `sx9fk_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'616d646e6c6a6739733670696d73616e656f6a6b6e756b763431', 1, 1765608702, 0, '', 0

Joomla! kļūdu konsole

Sesija

Izpildes laika informācija

Laiks

Atmiņa

Izmantotā operatīvā atmiņa

Datu bāzes vaicājumi

Veikti 5 vaicājumi 5.98 ms

5 dažādie vaicājumi, sakārtoti pēc skaita.

SELECT vaicājumi:

Citi vaicājumi: