Symfony Profiler

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

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 > 1770700510.4002) AND c0_.activatetime <= 1770700510.4002 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 > ?
  )
  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 > 1770700510.4145) AND c0_.activatetime <= 1770700510.4145 ORDER BY c0_.activatetime ASC;

SELECT
  COALESCE(t0_.display_name, t0_.name) AS sclr_0,
  t0_.teamid AS teamid_1,
  t0_.externalid AS externalid_2,
  t0_.icpcid AS icpcid_3,
  t0_.label AS label_4,
  t0_.name AS name_5,
  t0_.display_name AS display_name_6,
  t0_.enabled AS enabled_7,
  t0_.publicdescription AS publicdescription_8,
  t0_.location AS location_9,
  t0_.internalcomments AS internalcomments_10,
  t0_.judging_last_started AS judging_last_started_11,
  t0_.penalty AS penalty_12,
  t1_.categoryid AS categoryid_13,
  t1_.externalid AS externalid_14,
  t1_.icpcid AS icpcid_15,
  t1_.name AS name_16,
  t1_.sortorder AS sortorder_17,
  t1_.color AS color_18,
  t1_.visible AS visible_19,
  t1_.allow_self_registration AS allow_self_registration_20,
  t2_.affilid AS affilid_21,
  t2_.externalid AS externalid_22,
  t2_.icpcid AS icpcid_23,
  t2_.shortname AS shortname_24,
  t2_.name AS name_25,
  t2_.country AS country_26,
  t2_.internalcomments AS internalcomments_27,
  t0_.affilid AS affilid_28,
  t0_.categoryid AS categoryid_29
FROM
  team t0_
  INNER JOIN team_category t1_ ON t0_.categoryid = t1_.categoryid
  LEFT JOIN rankcache r3_ ON (
    r3_.teamid = t0_.teamid
    AND r3_.cid = ?
  )
  LEFT JOIN team_affiliation t2_ ON t0_.affilid = t2_.affilid
WHERE
  t0_.enabled = 1
  AND t1_.visible = 1
ORDER BY
  t1_.sortorder ASC,
  r3_.sort_key_public DESC,
  sclr_0 ASC

SELECT COALESCE(t0_.display_name, t0_.name) AS sclr_0, t0_.teamid AS teamid_1, t0_.externalid AS externalid_2, t0_.icpcid AS icpcid_3, t0_.label AS label_4, t0_.name AS name_5, t0_.display_name AS display_name_6, t0_.enabled AS enabled_7, t0_.publicdescription AS publicdescription_8, t0_.location AS location_9, t0_.internalcomments AS internalcomments_10, t0_.judging_last_started AS judging_last_started_11, t0_.penalty AS penalty_12, t1_.categoryid AS categoryid_13, t1_.externalid AS externalid_14, t1_.icpcid AS icpcid_15, t1_.name AS name_16, t1_.sortorder AS sortorder_17, t1_.color AS color_18, t1_.visible AS visible_19, t1_.allow_self_registration AS allow_self_registration_20, t2_.affilid AS affilid_21, t2_.externalid AS externalid_22, t2_.icpcid AS icpcid_23, t2_.shortname AS shortname_24, t2_.name AS name_25, t2_.country AS country_26, t2_.internalcomments AS internalcomments_27, t0_.affilid AS affilid_28, t0_.categoryid AS categoryid_29 FROM team t0_ INNER JOIN team_category t1_ ON t0_.categoryid = t1_.categoryid LEFT JOIN rankcache r3_ ON (r3_.teamid = t0_.teamid AND r3_.cid = 17) LEFT JOIN team_affiliation t2_ ON t0_.affilid = t2_.affilid WHERE t0_.enabled = 1 AND t1_.visible = 1 ORDER BY t1_.sortorder ASC, r3_.sort_key_public DESC, sclr_0 ASC;

SELECT
  c0_.shortname AS shortname_0,
  c0_.points AS points_1,
  c0_.allow_submit AS allow_submit_2,
  c0_.allow_judge AS allow_judge_3,
  c0_.color AS color_4,
  c0_.lazy_eval_results AS lazy_eval_results_5,
  p1_.probid AS probid_6,
  p1_.externalid AS externalid_7,
  p1_.name AS name_8,
  p1_.timelimit AS timelimit_9,
  p1_.memlimit AS memlimit_10,
  p1_.outputlimit AS outputlimit_11,
  p1_.special_compare_args AS special_compare_args_12,
  p1_.problemstatement_type AS problemstatement_type_13,
  p1_.types AS types_14,
  p1_.multipass_limit AS multipass_limit_15,
  c0_.cid AS cid_16,
  c0_.probid AS probid_17,
  p1_.special_compare AS special_compare_18,
  p1_.special_run AS special_run_19
FROM
  contestproblem c0_
  INNER JOIN problem p1_ ON c0_.probid = p1_.probid
WHERE
  c0_.allow_submit = 1
  AND c0_.cid = ?
ORDER BY
  c0_.shortname ASC

SELECT c0_.shortname AS shortname_0, c0_.points AS points_1, c0_.allow_submit AS allow_submit_2, c0_.allow_judge AS allow_judge_3, c0_.color AS color_4, c0_.lazy_eval_results AS lazy_eval_results_5, p1_.probid AS probid_6, p1_.externalid AS externalid_7, p1_.name AS name_8, p1_.timelimit AS timelimit_9, p1_.memlimit AS memlimit_10, p1_.outputlimit AS outputlimit_11, p1_.special_compare_args AS special_compare_args_12, p1_.problemstatement_type AS problemstatement_type_13, p1_.types AS types_14, p1_.multipass_limit AS multipass_limit_15, c0_.cid AS cid_16, c0_.probid AS probid_17, p1_.special_compare AS special_compare_18, p1_.special_run AS special_run_19 FROM contestproblem c0_ INNER JOIN problem p1_ ON c0_.probid = p1_.probid WHERE c0_.allow_submit = 1 AND c0_.cid = 17 ORDER BY c0_.shortname ASC;

SELECT
  t0.langid AS langid_1,
  t0.externalid AS externalid_2,
  t0.name AS name_3,
  t0.extensions AS extensions_4,
  t0.filter_compiler_files AS filter_compiler_files_5,
  t0.allow_submit AS allow_submit_6,
  t0.allow_judge AS allow_judge_7,
  t0.time_factor AS time_factor_8,
  t0.require_entry_point AS require_entry_point_9,
  t0.entry_point_description AS entry_point_description_10,
  t0.compiler_version AS compiler_version_11,
  t0.runner_version AS runner_version_12,
  t0.compiler_version_command AS compiler_version_command_13,
  t0.runner_version_command AS runner_version_command_14,
  t0.compile_script AS compile_script_15
FROM
  language t0
  INNER JOIN contestlanguage ON t0.langid = contestlanguage.langid
WHERE
  contestlanguage.cid = ?

SELECT t0.langid AS langid_1, t0.externalid AS externalid_2, t0.name AS name_3, t0.extensions AS extensions_4, t0.filter_compiler_files AS filter_compiler_files_5, t0.allow_submit AS allow_submit_6, t0.allow_judge AS allow_judge_7, t0.time_factor AS time_factor_8, t0.require_entry_point AS require_entry_point_9, t0.entry_point_description AS entry_point_description_10, t0.compiler_version AS compiler_version_11, t0.runner_version AS runner_version_12, t0.compiler_version_command AS compiler_version_command_13, t0.runner_version_command AS runner_version_command_14, t0.compile_script AS compile_script_15 FROM language t0 INNER JOIN contestlanguage ON t0.langid = contestlanguage.langid WHERE contestlanguage.cid = 17;

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;

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

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;

SELECT
  t0_.affilid AS affilid_0,
  t0_.externalid AS externalid_1,
  t0_.icpcid AS icpcid_2,
  t0_.shortname AS shortname_3,
  t0_.name AS name_4,
  t0_.country AS country_5,
  t0_.internalcomments AS internalcomments_6
FROM
  team_affiliation t0_
  INNER JOIN team t1_ ON t0_.affilid = t1_.affilid
WHERE
  t1_.categoryid IN (?)

SELECT t0_.affilid AS affilid_0, t0_.externalid AS externalid_1, t0_.icpcid AS icpcid_2, t0_.shortname AS shortname_3, t0_.name AS name_4, t0_.country AS country_5, t0_.internalcomments AS internalcomments_6 FROM team_affiliation t0_ INNER JOIN team t1_ ON t0_.affilid = t1_.affilid WHERE t1_.categoryid IN (2);

SELECT
  t0_.categoryid AS categoryid_0,
  t0_.externalid AS externalid_1,
  t0_.icpcid AS icpcid_2,
  t0_.name AS name_3,
  t0_.sortorder AS sortorder_4,
  t0_.color AS color_5,
  t0_.visible AS visible_6,
  t0_.allow_self_registration AS allow_self_registration_7
FROM
  team_category t0_
WHERE
  t0_.visible = 1
ORDER BY
  t0_.sortorder ASC,
  t0_.name ASC,
  t0_.categoryid ASC

SELECT t0_.categoryid AS categoryid_0, t0_.externalid AS externalid_1, t0_.icpcid AS icpcid_2, t0_.name AS name_3, t0_.sortorder AS sortorder_4, t0_.color AS color_5, t0_.visible AS visible_6, t0_.allow_self_registration AS allow_self_registration_7 FROM team_category t0_ WHERE t0_.visible = 1 ORDER BY t0_.sortorder ASC, t0_.name ASC, t0_.categoryid ASC;

SELECT
  s0_.submissions_restricted AS submissions_restricted_0,
  s0_.pending_restricted AS pending_restricted_1,
  s0_.is_correct_restricted AS is_correct_restricted_2,
  s0_.solvetime_restricted AS solvetime_restricted_3,
  s0_.runtime_restricted AS runtime_restricted_4,
  s0_.submissions_public AS submissions_public_5,
  s0_.pending_public AS pending_public_6,
  s0_.is_correct_public AS is_correct_public_7,
  s0_.solvetime_public AS solvetime_public_8,
  s0_.runtime_public AS runtime_public_9,
  s0_.is_first_to_solve AS is_first_to_solve_10,
  s0_.cid AS cid_11,
  s0_.teamid AS teamid_12,
  s0_.probid AS probid_13
FROM
  scorecache s0_
WHERE
  s0_.cid = ?

SELECT s0_.submissions_restricted AS submissions_restricted_0, s0_.pending_restricted AS pending_restricted_1, s0_.is_correct_restricted AS is_correct_restricted_2, s0_.solvetime_restricted AS solvetime_restricted_3, s0_.runtime_restricted AS runtime_restricted_4, s0_.submissions_public AS submissions_public_5, s0_.pending_public AS pending_public_6, s0_.is_correct_public AS is_correct_public_7, s0_.solvetime_public AS solvetime_public_8, s0_.runtime_public AS runtime_public_9, s0_.is_first_to_solve AS is_first_to_solve_10, s0_.cid AS cid_11, s0_.teamid AS teamid_12, s0_.probid AS probid_13 FROM scorecache s0_ WHERE s0_.cid = 17;

SELECT
  r0_.points_restricted AS points_restricted_0,
  r0_.totaltime_restricted AS totaltime_restricted_1,
  r0_.totalruntime_restricted AS totalruntime_restricted_2,
  r0_.points_public AS points_public_3,
  r0_.totaltime_public AS totaltime_public_4,
  r0_.totalruntime_public AS totalruntime_public_5,
  r0_.sort_key_public AS sort_key_public_6,
  r0_.sort_key_restricted AS sort_key_restricted_7,
  r0_.cid AS cid_8,
  r0_.teamid AS teamid_9
FROM
  rankcache r0_
WHERE
  r0_.cid = ?

SELECT r0_.points_restricted AS points_restricted_0, r0_.totaltime_restricted AS totaltime_restricted_1, r0_.totalruntime_restricted AS totalruntime_restricted_2, r0_.points_public AS points_public_3, r0_.totaltime_public AS totaltime_public_4, r0_.totalruntime_public AS totalruntime_public_5, r0_.sort_key_public AS sort_key_public_6, r0_.sort_key_restricted AS sort_key_restricted_7, r0_.cid AS cid_8, r0_.teamid AS teamid_9 FROM rankcache r0_ WHERE r0_.cid = 17;

SELECT
  t0_.categoryid AS categoryid_0,
  t0_.externalid AS externalid_1,
  t0_.icpcid AS icpcid_2,
  t0_.name AS name_3,
  t0_.sortorder AS sortorder_4,
  t0_.color AS color_5,
  t0_.visible AS visible_6,
  t0_.allow_self_registration AS allow_self_registration_7
FROM
  team_category t0_
WHERE
  t0_.visible = 1

SELECT t0_.categoryid AS categoryid_0, t0_.externalid AS externalid_1, t0_.icpcid AS icpcid_2, t0_.name AS name_3, t0_.sortorder AS sortorder_4, t0_.color AS color_5, t0_.visible AS visible_6, t0_.allow_self_registration AS allow_self_registration_7 FROM team_category t0_ WHERE t0_.visible = 1;

SELECT
  COUNT(*)
FROM
  team_category t0
WHERE
  t0.allow_self_registration = ?

SELECT COUNT(*) FROM team_category t0 WHERE t0.allow_self_registration = 1;