Query Metrics
9
Database Queries
5
Different statements
9.69 ms
Query time
0
Invalid entities
8
Managed entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 0.61 ms |
SELECT t0.configid AS configid_1, t0.name AS name_2, t0.value AS value_3 FROM configuration t0
Parameters:
[] |
||||||||||||||||||||||||||||||
| 2 | 2.85 ms |
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_.public = 1 AND c0_.enabled = 1 AND (c0_.deactivatetime IS NULL OR c0_.deactivatetime > ?) AND c0_.activatetime <= ? ORDER BY c0_.activatetime ASC
Parameters:
[ 1762584086.7211 1762584086.7211 ]
|
||||||||||||||||||||||||||||||
| 3 | 0.88 ms |
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:
[ 1762584086.7372 1762584086.7372 ]
|
||||||||||||||||||||||||||||||
| 4 | 1.07 ms |
SELECT COUNT(*) FROM team_category t0 WHERE t0.allow_self_registration = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||
| 5 | 0.73 ms |
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:
[ 1762584086.7447 1762584086.7447 ] |
||||||||||||||||||||||||||||||
| 6 | 0.65 ms |
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:
[ 1762584086.7465 1762584086.7465 ] |
||||||||||||||||||||||||||||||
| 7 | 0.64 ms |
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_.public = 1 AND c0_.enabled = 1 AND (c0_.deactivatetime IS NULL OR c0_.deactivatetime > ?) AND c0_.activatetime <= ? ORDER BY c0_.activatetime ASC
Parameters:
[ 1762584086.7475 1762584086.7475 ] |
||||||||||||||||||||||||||||||
| 8 | 0.87 ms |
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_.public = 1 AND c0_.enabled = 1 AND (c0_.deactivatetime IS NULL OR c0_.deactivatetime > ?) AND c0_.activatetime <= ? ORDER BY c0_.activatetime ASC
Parameters:
[ 1762584086.7485 1762584086.7485 ] |
||||||||||||||||||||||||||||||
| 9 | 1.39 ms |
SELECT l0_.langid AS langid_0, l0_.externalid AS externalid_1, l0_.name AS name_2, l0_.extensions AS extensions_3, l0_.filter_compiler_files AS filter_compiler_files_4, l0_.allow_submit AS allow_submit_5, l0_.allow_judge AS allow_judge_6, l0_.time_factor AS time_factor_7, l0_.require_entry_point AS require_entry_point_8, l0_.entry_point_description AS entry_point_description_9, l0_.compiler_version AS compiler_version_10, l0_.runner_version AS runner_version_11, l0_.compiler_version_command AS compiler_version_command_12, l0_.runner_version_command AS runner_version_command_13, l0_.compile_script AS compile_script_14 FROM language l0_ WHERE l0_.allow_submit = 1
Parameters:
[] |
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\Language | 4 |
| App\Entity\Executable | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\Configuration | No errors. |
| App\Entity\Contest | No errors. |
| App\Entity\TeamCategory | No errors. |
| App\Entity\Language | No errors. |
| App\Entity\Executable | No errors. |
| App\Entity\Submission | No errors. |
| App\Entity\Version | No errors. |
| App\Entity\Problem | No errors. |