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
  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.username = ?
LIMIT
  1

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.username = 'admin' LIMIT 1;

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;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user
SET
  last_api_login = ?
WHERE
  userid = ?

UPDATE user SET last_api_login = 1776027741.9593 WHERE userid = 1;

"COMMIT"

"COMMIT";

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_.externalid = ?
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_.externalid = '12' ORDER BY c0_.activatetime ASC;

SELECT
  j0_.judgingid AS judgingid_0,
  j0_.starttime AS starttime_1,
  j0_.endtime AS endtime_2,
  j0_.max_runtime_for_verdict AS max_runtime_for_verdict_3,
  j0_.result AS result_4,
  j0_.verified AS verified_5,
  j0_.jury_member AS jury_member_6,
  j0_.verify_comment AS verify_comment_7,
  j0_.valid AS valid_8,
  j0_.output_compile AS output_compile_9,
  j0_.metadata AS metadata_10,
  j0_.seen AS seen_11,
  j0_.judge_completely AS judge_completely_12,
  j0_.uuid AS uuid_13,
  c1_.cid AS cid_14,
  c1_.externalid AS externalid_15,
  c1_.name AS name_16,
  c1_.shortname AS shortname_17,
  c1_.activatetime AS activatetime_18,
  c1_.starttime AS starttime_19,
  c1_.starttime_enabled AS starttime_enabled_20,
  c1_.freezetime AS freezetime_21,
  c1_.endtime AS endtime_22,
  c1_.unfreezetime AS unfreezetime_23,
  c1_.finalizetime AS finalizetime_24,
  c1_.finalizecomment AS finalizecomment_25,
  c1_.b AS b_26,
  c1_.scoreboard_type AS scoreboard_type_27,
  c1_.medals_enabled AS medals_enabled_28,
  c1_.gold_medals AS gold_medals_29,
  c1_.silver_medals AS silver_medals_30,
  c1_.bronze_medals AS bronze_medals_31,
  c1_.deactivatetime AS deactivatetime_32,
  c1_.activatetime_string AS activatetime_string_33,
  c1_.starttime_string AS starttime_string_34,
  c1_.freezetime_string AS freezetime_string_35,
  c1_.endtime_string AS endtime_string_36,
  c1_.unfreezetime_string AS unfreezetime_string_37,
  c1_.deactivatetime_string AS deactivatetime_string_38,
  c1_.enabled AS enabled_39,
  c1_.allow_submit AS allow_submit_40,
  c1_.process_balloons AS process_balloons_41,
  c1_.runtime_as_score_tiebreaker AS runtime_as_score_tiebreaker_42,
  c1_.public AS public_43,
  c1_.open_to_all_teams AS open_to_all_teams_44,
  c1_.warning_message AS warning_message_45,
  c1_.is_locked AS is_locked_46,
  c1_.contest_problemset_type AS contest_problemset_type_47,
  s2_.submitid AS submitid_48,
  s2_.externalid AS externalid_49,
  s2_.submittime AS submittime_50,
  s2_.valid AS valid_51,
  s2_.expected_results AS expected_results_52,
  s2_.entry_point AS entry_point_53,
  s2_.import_error AS import_error_54,
  j0_.cid AS cid_55,
  j0_.submitid AS submitid_56,
  j0_.rejudgingid AS rejudgingid_57,
  j0_.prevjudgingid AS prevjudgingid_58,
  j0_.errorid AS errorid_59,
  s2_.cid AS cid_60,
  s2_.langid AS langid_61,
  s2_.teamid AS teamid_62,
  s2_.userid AS userid_63,
  s2_.probid AS probid_64,
  s2_.cid AS cid_65,
  s2_.probid AS probid_66,
  s2_.rejudgingid AS rejudgingid_67,
  s2_.origsubmitid AS origsubmitid_68
FROM
  judging j0_
  LEFT JOIN contest c1_ ON j0_.cid = c1_.cid
  LEFT JOIN submission s2_ ON j0_.submitid = s2_.submitid
  LEFT JOIN rejudging r3_ ON j0_.rejudgingid = r3_.rejudgingid
  LEFT JOIN judging_run j4_ ON j0_.judgingid = j4_.judgingid
WHERE
  j0_.cid = ?
  AND j0_.submitid = ?
GROUP BY
  j0_.judgingid
ORDER BY
  j0_.judgingid ASC

SELECT j0_.judgingid AS judgingid_0, j0_.starttime AS starttime_1, j0_.endtime AS endtime_2, j0_.max_runtime_for_verdict AS max_runtime_for_verdict_3, j0_.result AS result_4, j0_.verified AS verified_5, j0_.jury_member AS jury_member_6, j0_.verify_comment AS verify_comment_7, j0_.valid AS valid_8, j0_.output_compile AS output_compile_9, j0_.metadata AS metadata_10, j0_.seen AS seen_11, j0_.judge_completely AS judge_completely_12, j0_.uuid AS uuid_13, c1_.cid AS cid_14, c1_.externalid AS externalid_15, c1_.name AS name_16, c1_.shortname AS shortname_17, c1_.activatetime AS activatetime_18, c1_.starttime AS starttime_19, c1_.starttime_enabled AS starttime_enabled_20, c1_.freezetime AS freezetime_21, c1_.endtime AS endtime_22, c1_.unfreezetime AS unfreezetime_23, c1_.finalizetime AS finalizetime_24, c1_.finalizecomment AS finalizecomment_25, c1_.b AS b_26, c1_.scoreboard_type AS scoreboard_type_27, c1_.medals_enabled AS medals_enabled_28, c1_.gold_medals AS gold_medals_29, c1_.silver_medals AS silver_medals_30, c1_.bronze_medals AS bronze_medals_31, c1_.deactivatetime AS deactivatetime_32, c1_.activatetime_string AS activatetime_string_33, c1_.starttime_string AS starttime_string_34, c1_.freezetime_string AS freezetime_string_35, c1_.endtime_string AS endtime_string_36, c1_.unfreezetime_string AS unfreezetime_string_37, c1_.deactivatetime_string AS deactivatetime_string_38, c1_.enabled AS enabled_39, c1_.allow_submit AS allow_submit_40, c1_.process_balloons AS process_balloons_41, c1_.runtime_as_score_tiebreaker AS runtime_as_score_tiebreaker_42, c1_.public AS public_43, c1_.open_to_all_teams AS open_to_all_teams_44, c1_.warning_message AS warning_message_45, c1_.is_locked AS is_locked_46, c1_.contest_problemset_type AS contest_problemset_type_47, s2_.submitid AS submitid_48, s2_.externalid AS externalid_49, s2_.submittime AS submittime_50, s2_.valid AS valid_51, s2_.expected_results AS expected_results_52, s2_.entry_point AS entry_point_53, s2_.import_error AS import_error_54, j0_.cid AS cid_55, j0_.submitid AS submitid_56, j0_.rejudgingid AS rejudgingid_57, j0_.prevjudgingid AS prevjudgingid_58, j0_.errorid AS errorid_59, s2_.cid AS cid_60, s2_.langid AS langid_61, s2_.teamid AS teamid_62, s2_.userid AS userid_63, s2_.probid AS probid_64, s2_.cid AS cid_65, s2_.probid AS probid_66, s2_.rejudgingid AS rejudgingid_67, s2_.origsubmitid AS origsubmitid_68 FROM judging j0_ LEFT JOIN contest c1_ ON j0_.cid = c1_.cid LEFT JOIN submission s2_ ON j0_.submitid = s2_.submitid LEFT JOIN rejudging r3_ ON j0_.rejudgingid = r3_.rejudgingid LEFT JOIN judging_run j4_ ON j0_.judgingid = j4_.judgingid WHERE j0_.cid = 16 AND j0_.submitid = '60453' GROUP BY j0_.judgingid ORDER BY j0_.judgingid ASC;

SELECT
  t0.runid AS runid_1,
  t0.judgetaskid AS judgetaskid_2,
  t0.runresult AS runresult_3,
  t0.runtime AS runtime_4,
  t0.endtime AS endtime_5,
  t0.testcase_dir AS testcase_dir_6,
  t0.judgingid AS judgingid_7,
  t0.testcaseid AS testcaseid_8,
  t0.judgetaskid AS judgetaskid_9
FROM
  judging_run t0
WHERE
  t0.judgingid = ?

SELECT t0.runid AS runid_1, t0.judgetaskid AS judgetaskid_2, t0.runresult AS runresult_3, t0.runtime AS runtime_4, t0.endtime AS endtime_5, t0.testcase_dir AS testcase_dir_6, t0.judgingid AS judgingid_7, t0.testcaseid AS testcaseid_8, t0.judgetaskid AS judgetaskid_9 FROM judging_run t0 WHERE t0.judgingid = 60638;

SELECT
  j0_.runid AS runid_0,
  j0_.judgetaskid AS judgetaskid_1,
  j0_.runresult AS runresult_2,
  j0_.runtime AS runtime_3,
  j0_.endtime AS endtime_4,
  j0_.testcase_dir AS testcase_dir_5,
  j1_.output_run AS output_run_6,
  j1_.output_diff AS output_diff_7,
  j1_.output_error AS output_error_8,
  j1_.output_system AS output_system_9,
  j1_.team_message AS team_message_10,
  j1_.metadata AS metadata_11,
  j1_.validator_metadata AS validator_metadata_12,
  t2_.testcaseid AS testcaseid_13,
  t2_.md5sum_input AS md5sum_input_14,
  t2_.md5sum_output AS md5sum_output_15,
  t2_.ranknumber AS ranknumber_16,
  t2_.description AS description_17,
  t2_.orig_input_filename AS orig_input_filename_18,
  t2_.image_type AS image_type_19,
  t2_.sample AS sample_20,
  t2_.deleted AS deleted_21,
  t3_.tc_contentid AS tc_contentid_22,
  t3_.input AS input_23,
  t3_.output AS output_24,
  t3_.image AS image_25,
  t3_.image_thumb AS image_thumb_26,
  j0_.judgingid AS judgingid_27,
  j0_.testcaseid AS testcaseid_28,
  j0_.judgetaskid AS judgetaskid_29,
  j1_.runid AS runid_30,
  t2_.probid AS probid_31,
  t3_.testcaseid AS testcaseid_32
FROM
  judging_run j0_
  LEFT JOIN judging_run_output j1_ ON j0_.runid = j1_.runid
  LEFT JOIN testcase t2_ ON j0_.testcaseid = t2_.testcaseid
  LEFT JOIN testcase_content t3_ ON t2_.testcaseid = t3_.testcaseid
WHERE
  j0_.judgingid = ?
ORDER BY
  t2_.ranknumber ASC

SELECT j0_.runid AS runid_0, j0_.judgetaskid AS judgetaskid_1, j0_.runresult AS runresult_2, j0_.runtime AS runtime_3, j0_.endtime AS endtime_4, j0_.testcase_dir AS testcase_dir_5, j1_.output_run AS output_run_6, j1_.output_diff AS output_diff_7, j1_.output_error AS output_error_8, j1_.output_system AS output_system_9, j1_.team_message AS team_message_10, j1_.metadata AS metadata_11, j1_.validator_metadata AS validator_metadata_12, t2_.testcaseid AS testcaseid_13, t2_.md5sum_input AS md5sum_input_14, t2_.md5sum_output AS md5sum_output_15, t2_.ranknumber AS ranknumber_16, t2_.description AS description_17, t2_.orig_input_filename AS orig_input_filename_18, t2_.image_type AS image_type_19, t2_.sample AS sample_20, t2_.deleted AS deleted_21, t3_.tc_contentid AS tc_contentid_22, t3_.input AS input_23, t3_.output AS output_24, t3_.image AS image_25, t3_.image_thumb AS image_thumb_26, j0_.judgingid AS judgingid_27, j0_.testcaseid AS testcaseid_28, j0_.judgetaskid AS judgetaskid_29, j1_.runid AS runid_30, t2_.probid AS probid_31, t3_.testcaseid AS testcaseid_32 FROM judging_run j0_ LEFT JOIN judging_run_output j1_ ON j0_.runid = j1_.runid LEFT JOIN testcase t2_ ON j0_.testcaseid = t2_.testcaseid LEFT JOIN testcase_content t3_ ON t2_.testcaseid = t3_.testcaseid WHERE j0_.judgingid = 60638 ORDER BY t2_.ranknumber ASC;

SELECT
  t0.probid AS probid_1,
  t0.externalid AS externalid_2,
  t0.name AS name_3,
  t0.timelimit AS timelimit_4,
  t0.memlimit AS memlimit_5,
  t0.outputlimit AS outputlimit_6,
  t0.special_compare_args AS special_compare_args_7,
  t0.problemstatement_type AS problemstatement_type_8,
  t0.types AS types_9,
  t0.multipass_limit AS multipass_limit_10,
  t0.special_compare AS special_compare_11,
  t0.special_run AS special_run_12
FROM
  problem t0
WHERE
  t0.probid = ?

SELECT t0.probid AS probid_1, t0.externalid AS externalid_2, t0.name AS name_3, t0.timelimit AS timelimit_4, t0.memlimit AS memlimit_5, t0.outputlimit AS outputlimit_6, t0.special_compare_args AS special_compare_args_7, t0.problemstatement_type AS problemstatement_type_8, t0.types AS types_9, t0.multipass_limit AS multipass_limit_10, t0.special_compare AS special_compare_11, t0.special_run AS special_run_12 FROM problem t0 WHERE t0.probid = 404;