Symfony Profiler

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
  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 > 1775850022.0951) AND c0_.activatetime <= 1775850022.0951 ORDER BY c0_.activatetime 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 = 28;

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
  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
  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 = 28 AND c0_.allow_submit = 1 ORDER BY c0_.shortname ASC, p2_.name 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 = 28 AND c2_.allow_submit = 1 GROUP BY c2_.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 = 28 AND s2_.probid IN (156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311) AND t4_.visible = 1 AND s2_.submittime >= 1770786596 AND s2_.submittime < 1772363396 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 = 28 AND s2_.probid IN (156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311) AND t4_.visible = 1 AND s2_.submittime >= 1770786596 AND s2_.submittime < 1772363396 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 = 28 AND s2_.probid IN (156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311) AND t4_.visible = 1 AND s2_.submittime >= 1772363396 AND s2_.submittime < 1773940196 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 = 28 AND s2_.probid IN (156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311) AND t4_.visible = 1 AND s2_.submittime >= 1772363396 AND s2_.submittime < 1773940196 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 = 28 AND s2_.probid IN (156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311) AND t4_.visible = 1 AND s2_.submittime >= 1773940196 AND s2_.submittime < 1775516996 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 = 28 AND s2_.probid IN (156, 157, 158, 159, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 170, 171, 172, 173, 174, 175, 176, 177, 178, 179, 291, 292, 293, 294, 295, 296, 297, 298, 299, 300, 301, 302, 303, 304, 305, 306, 307, 308, 309, 310, 311) AND t4_.visible = 1 AND s2_.submittime >= 1773940196 AND s2_.submittime < 1775516996 AND j0_.result <> 'correct' GROUP BY s2_.probid;