Symfony Profiler

SELECT
  COUNT(j0_.judgingid) AS sclr_0,
  p1_.probid AS probid_1
FROM
  judging j0_
  INNER JOIN submission s2_ ON j0_.submitid = s2_.submitid
  INNER JOIN problem p1_ ON s2_.probid = p1_.probid
  INNER JOIN team t3_ ON s2_.teamid = t3_.teamid
  INNER JOIN team_category t4_ ON t3_.categoryid = t4_.categoryid
WHERE
  j0_.valid = 1
  AND j0_.result IS NOT NULL
  AND s2_.cid = ?
  AND s2_.probid IN (?, ?, ?)
  AND t4_.visible = 1
  AND s2_.submittime >= ?
  AND s2_.submittime < ?
  AND j0_.result = ?
GROUP BY
  s2_.probid

SELECT COUNT(j0_.judgingid) AS sclr_0, p1_.probid AS probid_1 FROM judging j0_ INNER JOIN submission s2_ ON j0_.submitid = s2_.submitid INNER JOIN problem p1_ ON s2_.probid = p1_.probid INNER JOIN team t3_ ON s2_.teamid = t3_.teamid INNER JOIN team_category t4_ ON t3_.categoryid = t4_.categoryid WHERE j0_.valid = 1 AND j0_.result IS NOT NULL AND s2_.cid = 16 AND s2_.probid IN (26, 27, 29) AND t4_.visible = 1 AND s2_.submittime >= 1768590662 AND s2_.submittime < 1770167462 AND j0_.result = 'correct' GROUP BY s2_.probid;

SELECT
  COUNT(j0_.judgingid) AS sclr_0,
  p1_.probid AS probid_1
FROM
  judging j0_
  INNER JOIN submission s2_ ON j0_.submitid = s2_.submitid
  INNER JOIN problem p1_ ON s2_.probid = p1_.probid
  INNER JOIN team t3_ ON s2_.teamid = t3_.teamid
  INNER JOIN team_category t4_ ON t3_.categoryid = t4_.categoryid
WHERE
  j0_.valid = 1
  AND j0_.result IS NOT NULL
  AND s2_.cid = ?
  AND s2_.probid IN (?, ?, ?)
  AND t4_.visible = 1
  AND s2_.submittime >= ?
  AND s2_.submittime < ?
  AND j0_.result <> ?
GROUP BY
  s2_.probid

SELECT COUNT(j0_.judgingid) AS sclr_0, p1_.probid AS probid_1 FROM judging j0_ INNER JOIN submission s2_ ON j0_.submitid = s2_.submitid INNER JOIN problem p1_ ON s2_.probid = p1_.probid INNER JOIN team t3_ ON s2_.teamid = t3_.teamid INNER JOIN team_category t4_ ON t3_.categoryid = t4_.categoryid WHERE j0_.valid = 1 AND j0_.result IS NOT NULL AND s2_.cid = 16 AND s2_.probid IN (26, 27, 29) AND t4_.visible = 1 AND s2_.submittime >= 1768590662 AND s2_.submittime < 1770167462 AND j0_.result <> 'correct' GROUP BY s2_.probid;

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 > 1770700603.614) AND c0_.activatetime <= 1770700603.614 ORDER BY c0_.activatetime 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,
  p2_.attachmentid AS attachmentid_16,
  p2_.name AS name_17,
  p2_.type AS type_18,
  c0_.cid AS cid_19,
  c0_.probid AS probid_20,
  p1_.special_compare AS special_compare_21,
  p1_.special_run AS special_run_22,
  p2_.probid AS probid_23
FROM
  contestproblem c0_
  INNER JOIN problem p1_ ON c0_.probid = p1_.probid
  LEFT JOIN testcase t3_ ON p1_.probid = t3_.probid
  LEFT JOIN problem_attachment p2_ ON p1_.probid = p2_.probid
WHERE
  c0_.cid = ?
  AND c0_.allow_submit = 1
ORDER BY
  c0_.shortname ASC,
  p2_.name 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, p2_.attachmentid AS attachmentid_16, p2_.name AS name_17, p2_.type AS type_18, c0_.cid AS cid_19, c0_.probid AS probid_20, p1_.special_compare AS special_compare_21, p1_.special_run AS special_run_22, p2_.probid AS probid_23 FROM contestproblem c0_ INNER JOIN problem p1_ ON c0_.probid = p1_.probid LEFT JOIN testcase t3_ ON p1_.probid = t3_.probid LEFT JOIN problem_attachment p2_ ON p1_.probid = p2_.probid WHERE c0_.cid = 16 AND c0_.allow_submit = 1 ORDER BY c0_.shortname ASC, p2_.name 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 > 1770700603.6889) AND c0_.activatetime <= 1770700603.6889 ORDER BY c0_.activatetime ASC;

SELECT
  p0_.probid AS probid_0,
  SUM(t1_.sample) AS sclr_1
FROM
  contestproblem c2_
  INNER JOIN problem p0_ ON c2_.probid = p0_.probid
  LEFT JOIN testcase t1_ ON p0_.probid = t1_.probid
WHERE
  c2_.cid = ?
  AND c2_.allow_submit = 1
GROUP BY
  c2_.probid

SELECT p0_.probid AS probid_0, SUM(t1_.sample) AS sclr_1 FROM contestproblem c2_ INNER JOIN problem p0_ ON c2_.probid = p0_.probid LEFT JOIN testcase t1_ ON p0_.probid = t1_.probid WHERE c2_.cid = 16 AND c2_.allow_submit = 1 GROUP BY c2_.probid;

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.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 = 16;

SELECT
  COUNT(l0_.langid) AS sclr_0
FROM
  language l0_
WHERE
  l0_.time_factor <> 1
  AND l0_.langid IN (?, ?, ?, ?)

SELECT COUNT(l0_.langid) AS sclr_0 FROM language l0_ WHERE l0_.time_factor <> 1 AND l0_.langid IN ('c', 'cpp', 'java', 'py3');

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

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