Symfony Profiler

Query Metrics

7 Database Queries

7 Different statements

3.63 ms Query time

0 Invalid entities

5 Managed entities

Grouped Statements

Show all queries

Time▼

Count

Info

0.80 ms
(22.04%)

SELECT c0_.cid AS cid_0, c0_.externalid AS externalid_1, c0_.name AS name_2, c0_.shortname AS shortname_3, c0_.activatetime AS activatetime_4, c0_.starttime AS starttime_5, c0_.starttime_enabled AS starttime_enabled_6, c0_.freezetime AS freezetime_7, c0_.endtime AS endtime_8, c0_.unfreezetime AS unfreezetime_9, c0_.finalizetime AS finalizetime_10, c0_.finalizecomment AS finalizecomment_11, c0_.b AS b_12, c0_.scoreboard_type AS scoreboard_type_13, c0_.medals_enabled AS medals_enabled_14, c0_.gold_medals AS gold_medals_15, c0_.silver_medals AS silver_medals_16, c0_.bronze_medals AS bronze_medals_17, c0_.deactivatetime AS deactivatetime_18, c0_.activatetime_string AS activatetime_string_19, c0_.starttime_string AS starttime_string_20, c0_.freezetime_string AS freezetime_string_21, c0_.endtime_string AS endtime_string_22, c0_.unfreezetime_string AS unfreezetime_string_23, c0_.deactivatetime_string AS deactivatetime_string_24, c0_.enabled AS enabled_25, c0_.allow_submit AS allow_submit_26, c0_.process_balloons AS process_balloons_27, c0_.runtime_as_score_tiebreaker AS runtime_as_score_tiebreaker_28, c0_.public AS public_29, c0_.open_to_all_teams AS open_to_all_teams_30, c0_.warning_message AS warning_message_31, c0_.is_locked AS is_locked_32, c0_.contest_problemset_type AS contest_problemset_type_33 FROM contest c0_ WHERE c0_.enabled = 1 AND (c0_.deactivatetime IS NULL OR c0_.deactivatetime > ?) AND c0_.activatetime <= ? ORDER BY c0_.activatetime ASC

Parameters:

[
  1770712604.3843
  1770712604.3843
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  c0_.cid AS cid_0,
  c0_.externalid AS externalid_1,
  c0_.name AS name_2,
  c0_.shortname AS shortname_3,
  c0_.activatetime AS activatetime_4,
  c0_.starttime AS starttime_5,
  c0_.starttime_enabled AS starttime_enabled_6,
  c0_.freezetime AS freezetime_7,
  c0_.endtime AS endtime_8,
  c0_.unfreezetime AS unfreezetime_9,
  c0_.finalizetime AS finalizetime_10,
  c0_.finalizecomment AS finalizecomment_11,
  c0_.b AS b_12,
  c0_.scoreboard_type AS scoreboard_type_13,
  c0_.medals_enabled AS medals_enabled_14,
  c0_.gold_medals AS gold_medals_15,
  c0_.silver_medals AS silver_medals_16,
  c0_.bronze_medals AS bronze_medals_17,
  c0_.deactivatetime AS deactivatetime_18,
  c0_.activatetime_string AS activatetime_string_19,
  c0_.starttime_string AS starttime_string_20,
  c0_.freezetime_string AS freezetime_string_21,
  c0_.endtime_string AS endtime_string_22,
  c0_.unfreezetime_string AS unfreezetime_string_23,
  c0_.deactivatetime_string AS deactivatetime_string_24,
  c0_.enabled AS enabled_25,
  c0_.allow_submit AS allow_submit_26,
  c0_.process_balloons AS process_balloons_27,
  c0_.runtime_as_score_tiebreaker AS runtime_as_score_tiebreaker_28,
  c0_.public AS public_29,
  c0_.open_to_all_teams AS open_to_all_teams_30,
  c0_.warning_message AS warning_message_31,
  c0_.is_locked AS is_locked_32,
  c0_.contest_problemset_type AS contest_problemset_type_33
FROM
  contest c0_
WHERE
  c0_.enabled = 1
  AND (
    c0_.deactivatetime IS NULL
    OR c0_.deactivatetime > ?
  )
  AND c0_.activatetime <= ?
ORDER BY
  c0_.activatetime ASC

SELECT c0_.cid AS cid_0, c0_.externalid AS externalid_1, c0_.name AS name_2, c0_.shortname AS shortname_3, c0_.activatetime AS activatetime_4, c0_.starttime AS starttime_5, c0_.starttime_enabled AS starttime_enabled_6, c0_.freezetime AS freezetime_7, c0_.endtime AS endtime_8, c0_.unfreezetime AS unfreezetime_9, c0_.finalizetime AS finalizetime_10, c0_.finalizecomment AS finalizecomment_11, c0_.b AS b_12, c0_.scoreboard_type AS scoreboard_type_13, c0_.medals_enabled AS medals_enabled_14, c0_.gold_medals AS gold_medals_15, c0_.silver_medals AS silver_medals_16, c0_.bronze_medals AS bronze_medals_17, c0_.deactivatetime AS deactivatetime_18, c0_.activatetime_string AS activatetime_string_19, c0_.starttime_string AS starttime_string_20, c0_.freezetime_string AS freezetime_string_21, c0_.endtime_string AS endtime_string_22, c0_.unfreezetime_string AS unfreezetime_string_23, c0_.deactivatetime_string AS deactivatetime_string_24, c0_.enabled AS enabled_25, c0_.allow_submit AS allow_submit_26, c0_.process_balloons AS process_balloons_27, c0_.runtime_as_score_tiebreaker AS runtime_as_score_tiebreaker_28, c0_.public AS public_29, c0_.open_to_all_teams AS open_to_all_teams_30, c0_.warning_message AS warning_message_31, c0_.is_locked AS is_locked_32, c0_.contest_problemset_type AS contest_problemset_type_33 FROM contest c0_ WHERE c0_.enabled = 1 AND (c0_.deactivatetime IS NULL OR c0_.deactivatetime > 1770712604.3843) AND c0_.activatetime <= 1770712604.3843 ORDER BY c0_.activatetime ASC;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 159)
7	App\Service\DOMJudgeService->getCurrentContests (line 178)
8	App\Service\DOMJudgeService->getCurrentContest (line 336)
9	App\Service\DOMJudgeService->getUpdates (line 70)
10	App\Controller\Jury\JuryMiscController->updatesAction (line 181)
11	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
12	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
13	Symfony\Component\HttpKernel\Kernel->handle (line 35)
14	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
15	require_once (line 5)

0.62 ms
(17.02%)

SELECT t0.roleid AS roleid_1, t0.role AS role_2, t0.description AS description_3 FROM role t0 INNER JOIN userrole ON t0.roleid = userrole.roleid WHERE userrole.userid = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.roleid AS roleid_1,
  t0.role AS role_2,
  t0.description AS description_3
FROM
  role t0
  INNER JOIN userrole ON t0.roleid = userrole.roleid
WHERE
  userrole.userid = ?

SELECT t0.roleid AS roleid_1, t0.role AS role_2, t0.description AS description_3 FROM role t0 INNER JOIN userrole ON t0.roleid = userrole.roleid WHERE userrole.userid = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 1130)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->getManyToManyStatement (line 1052)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadManyToManyCollection (line 3311)
4	Doctrine\ORM\UnitOfWork->loadCollection (line 706)
5	Doctrine\ORM\PersistentCollection->doInitialize (line 218)
6	Doctrine\ORM\PersistentCollection->initialize (line 157)
7	Doctrine\Common\Collections\AbstractLazyCollection->toArray (line 408)
8	App\Entity\User->getUserRoles (line 463)
9	App\Entity\User->getRoles (line 33)
10	App\EventListener\UpdateUserRolesListener->__invoke (line 116)
11	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
12	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
13	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
14	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
15	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
16	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
17	Symfony\Component\HttpKernel\Kernel->handle (line 35)
18	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
19	require_once (line 5)

0.51 ms
(14.13%)

SELECT t0.userid AS userid_1, t0.externalid AS externalid_2, t0.username AS username_3, t0.name AS name_4, t0.email AS email_5, t0.last_login AS last_login_6, t0.last_api_login AS last_api_login_7, t0.first_login AS first_login_8, t0.last_ip_address AS last_ip_address_9, t0.password AS password_10, t0.ip_address AS ip_address_11, t0.enabled AS enabled_12, t0.teamid AS teamid_13 FROM user t0 WHERE t0.userid = ?

Parameters:

[
  1
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.userid AS userid_1,
  t0.externalid AS externalid_2,
  t0.username AS username_3,
  t0.name AS name_4,
  t0.email AS email_5,
  t0.last_login AS last_login_6,
  t0.last_api_login AS last_api_login_7,
  t0.first_login AS first_login_8,
  t0.last_ip_address AS last_ip_address_9,
  t0.password AS password_10,
  t0.ip_address AS ip_address_11,
  t0.enabled AS enabled_12,
  t0.teamid AS teamid_13
FROM
  user t0
WHERE
  t0.userid = ?

SELECT t0.userid AS userid_1, t0.externalid AS externalid_2, t0.username AS username_3, t0.name AS name_4, t0.email AS email_5, t0.last_login AS last_login_6, t0.last_api_login AS last_api_login_7, t0.first_login AS first_login_8, t0.last_ip_address AS last_ip_address_9, t0.password AS password_10, t0.ip_address AS ip_address_11, t0.enabled AS enabled_12, t0.teamid AS teamid_13 FROM user t0 WHERE t0.userid = 1;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 789)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->load (line 807)
3	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadById (line 530)
4	Doctrine\ORM\EntityManager->find (line 196)
5	Doctrine\ORM\EntityRepository->find (line 92)
6	Symfony\Bridge\Doctrine\Security\User\EntityUserProvider->refreshUser (line 214)
7	Symfony\Component\Security\Http\Firewall\ContextListener->refreshUser (line 131)
8	Symfony\Component\Security\Http\Firewall\ContextListener->authenticate (line 46)
9	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->authenticate (line 26)
10	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
11	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
12	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
13	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
14	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
15	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
16	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
17	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
18	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
19	Symfony\Component\HttpKernel\Kernel->handle (line 35)
20	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
21	require_once (line 5)

0.50 ms
(13.66%)

SELECT j0_.hostname AS hostname_0, j0_.polltime AS polltime_1 FROM judgehost j0_ WHERE j0_.enabled = 1 AND j0_.hidden = 0 AND j0_.polltime < ?

Parameters:

[
  1770712484
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  j0_.hostname AS hostname_0,
  j0_.polltime AS polltime_1
FROM
  judgehost j0_
WHERE
  j0_.enabled = 1
  AND j0_.hidden = 0
  AND j0_.polltime < ?

SELECT j0_.hostname AS hostname_0, j0_.polltime AS polltime_1 FROM judgehost j0_ WHERE j0_.enabled = 1 AND j0_.hidden = 0 AND j0_.polltime < 1770712484;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 366)
7	App\Service\DOMJudgeService->getUpdates (line 70)
8	App\Controller\Jury\JuryMiscController->updatesAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.46 ms
(12.75%)

SELECT i0_.errorid AS errorid_0, i0_.description AS description_1 FROM internal_error i0_ WHERE i0_.status = ?

Parameters:

[
  "open"
]

View formatted query View runnable query Explain query View query backtrace

SELECT
  i0_.errorid AS errorid_0,
  i0_.description AS description_1
FROM
  internal_error i0_
WHERE
  i0_.status = ?

SELECT i0_.errorid AS errorid_0, i0_.description AS description_1 FROM internal_error i0_ WHERE i0_.status = 'open';

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 387)
7	App\Service\DOMJudgeService->getUpdates (line 70)
8	App\Controller\Jury\JuryMiscController->updatesAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

0.45 ms
(12.42%)

SELECT t0.configid AS configid_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  t0.configid AS configid_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  configuration t0

SELECT t0.configid AS configid_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 982)
2	Doctrine\ORM\Persisters\Entity\BasicEntityPersister->loadAll (line 224)
3	Doctrine\ORM\EntityRepository->findBy (line 206)
4	Doctrine\ORM\EntityRepository->findAll (line 330)
5	App\Service\ConfigurationService->getDbValues (line 61)
6	App\Service\ConfigurationService->get (line 38)
7	App\Security\DOMJudgeXHeadersAuthenticator->supports (line 111)
8	Symfony\Component\Security\Http\Authentication\AuthenticatorManager->supports (line 34)
9	Symfony\Component\Security\Http\Firewall\AuthenticatorManagerListener->supports (line 40)
10	Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticatorManagerListener->supports (line 38)
11	Symfony\Bundle\SecurityBundle\Debug\WrappedLazyListener->supports (line 25)
12	Symfony\Component\Security\Http\Firewall\AbstractListener->__invoke (line 83)
13	Symfony\Bundle\SecurityBundle\Debug\TraceableFirewallListener->callListeners (line 95)
14	Symfony\Component\Security\Http\Firewall->onKernelRequest (line 116)
15	Symfony\Component\EventDispatcher\Debug\WrappedListener->__invoke (line 220)
16	Symfony\Component\EventDispatcher\EventDispatcher->callListeners (line 56)
17	Symfony\Component\EventDispatcher\EventDispatcher->dispatch (line 139)
18	Symfony\Component\EventDispatcher\Debug\TraceableEventDispatcher->dispatch (line 157)
19	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
20	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
21	Symfony\Component\HttpKernel\Kernel->handle (line 35)
22	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
23	require_once (line 5)

0.29 ms
(7.98%)

SELECT r0_.rejudgingid AS rejudgingid_0, r0_.starttime AS starttime_1, r0_.endtime AS endtime_2 FROM rejudging r0_ WHERE r0_.endtime IS NULL

Parameters:

[]

View formatted query View runnable query Explain query View query backtrace

SELECT
  r0_.rejudgingid AS rejudgingid_0,
  r0_.starttime AS starttime_1,
  r0_.endtime AS endtime_2
FROM
  rejudging r0_
WHERE
  r0_.endtime IS NULL

SELECT r0_.rejudgingid AS rejudgingid_0, r0_.starttime AS starttime_1, r0_.endtime AS endtime_2 FROM rejudging r0_ WHERE r0_.endtime IS NULL;

#	File/Call
1	Doctrine\DBAL\Connection->executeQuery (line 31)
2	Doctrine\ORM\Query\Exec\FinalizedSelectExecutor->execute (line 330)
3	Doctrine\ORM\Query->_doExecute (line 1218)
4	Doctrine\ORM\AbstractQuery->executeIgnoreQueryCache (line 1172)
5	Doctrine\ORM\AbstractQuery->execute (line 907)
6	Doctrine\ORM\AbstractQuery->getResult (line 378)
7	App\Service\DOMJudgeService->getUpdates (line 70)
8	App\Controller\Jury\JuryMiscController->updatesAction (line 181)
9	Symfony\Component\HttpKernel\HttpKernel->handleRaw (line 76)
10	Symfony\Component\HttpKernel\HttpKernel->handle (line 197)
11	Symfony\Component\HttpKernel\Kernel->handle (line 35)
12	Symfony\Component\Runtime\Runner\Symfony\HttpKernelRunner->run (line 29)
13	require_once (line 5)

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
App\Entity\Role	2
App\Entity\User	1
App\Entity\Team	1
App\Entity\Configuration	1

Entities Mapping

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\Team	No errors.
App\Entity\Role	No errors.
App\Entity\Submission	No errors.
App\Entity\Configuration	No errors.
App\Entity\Contest	No errors.
App\Entity\Judgehost	No errors.
App\Entity\Rejudging	No errors.
App\Entity\InternalError	No errors.

Symfony Profiler

GET https://hjx.walab.info/jury/updates?_=1770711684302

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping