Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.public_id AS public_id_1,
  c0_.number AS number_2,
  c0_.status AS status_3,
  c0_.check_type AS check_type_4,
  c0_.procedure_type AS procedure_type_5,
  c0_.period_from AS period_from_6,
  c0_.period_to AS period_to_7,
  c0_.started_at AS started_at_8,
  c0_.finished_at AS finished_at_9,
  c0_.approved_at AS approved_at_10,
  c0_.failed_at AS failed_at_11,
  c0_.risk_level AS risk_level_12,
  c0_.violations_count AS violations_count_13,
  c0_.auto_detected_count AS auto_detected_count_14,
  c0_.manual_detected_count AS manual_detected_count_15,
  c0_.summary AS summary_16,
  c0_.notes AS notes_17,
  c0_.created_by_user_identifier AS created_by_user_identifier_18,
  c0_.updated_by_user_identifier AS updated_by_user_identifier_19,
  c0_.created_at AS created_at_20,
  c0_.updated_at AS updated_at_21,
  a1_.id AS id_22,
  a1_.full_name AS full_name_23,
  a1_.last_name AS last_name_24,
  a1_.first_name AS first_name_25,
  a1_.middle_name AS middle_name_26,
  a1_.registration_number AS registration_number_27,
  a1_.inn AS inn_28,
  a1_.snils AS snils_29,
  a1_.email AS email_30,
  a1_.phone AS phone_31,
  a1_.sro_name AS sro_name_32,
  a1_.sro_registration_number AS sro_registration_number_33,
  a1_.status AS status_34,
  a1_.created_at AS created_at_35,
  a1_.updated_at AS updated_at_36,
  b2_.id AS id_37,
  b2_.case_number AS case_number_38,
  b2_.court_name AS court_name_39,
  b2_.court_region AS court_region_40,
  b2_.procedure_type AS procedure_type_41,
  b2_.started_at AS started_at_42,
  b2_.ended_at AS ended_at_43,
  b2_.status AS status_44,
  b2_.judge_name AS judge_name_45,
  b2_.external_reference AS external_reference_46,
  b2_.created_at AS created_at_47,
  b2_.updated_at AS updated_at_48,
  d3_.id AS id_49,
  d3_.type AS type_50,
  d3_.full_name AS full_name_51,
  d3_.short_name AS short_name_52,
  d3_.inn AS inn_53,
  d3_.ogrn AS ogrn_54,
  d3_.ogrnip AS ogrnip_55,
  d3_.address AS address_56,
  d3_.created_at AS created_at_57,
  d3_.updated_at AS updated_at_58,
  c0_.arbitration_manager_id AS arbitration_manager_id_59,
  c0_.bankruptcy_case_id AS bankruptcy_case_id_60,
  c0_.debtor_id AS debtor_id_61,
  c0_.inspection_scenario_id AS inspection_scenario_id_62,
  b2_.debtor_id AS debtor_id_63,
  b2_.current_arbitration_manager_id AS current_arbitration_manager_id_64
FROM
  delo.checks c0_
  LEFT JOIN delo.arbitration_manager a1_ ON c0_.arbitration_manager_id = a1_.id
  LEFT JOIN delo.bankruptcy_case b2_ ON c0_.bankruptcy_case_id = b2_.id
  LEFT JOIN delo.debtor d3_ ON c0_.debtor_id = d3_.id
ORDER BY
  c0_.created_at DESC,
  c0_.id DESC
LIMIT
  6

SELECT c0_.id AS id_0, c0_.public_id AS public_id_1, c0_.number AS number_2, c0_.status AS status_3, c0_.check_type AS check_type_4, c0_.procedure_type AS procedure_type_5, c0_.period_from AS period_from_6, c0_.period_to AS period_to_7, c0_.started_at AS started_at_8, c0_.finished_at AS finished_at_9, c0_.approved_at AS approved_at_10, c0_.failed_at AS failed_at_11, c0_.risk_level AS risk_level_12, c0_.violations_count AS violations_count_13, c0_.auto_detected_count AS auto_detected_count_14, c0_.manual_detected_count AS manual_detected_count_15, c0_.summary AS summary_16, c0_.notes AS notes_17, c0_.created_by_user_identifier AS created_by_user_identifier_18, c0_.updated_by_user_identifier AS updated_by_user_identifier_19, c0_.created_at AS created_at_20, c0_.updated_at AS updated_at_21, a1_.id AS id_22, a1_.full_name AS full_name_23, a1_.last_name AS last_name_24, a1_.first_name AS first_name_25, a1_.middle_name AS middle_name_26, a1_.registration_number AS registration_number_27, a1_.inn AS inn_28, a1_.snils AS snils_29, a1_.email AS email_30, a1_.phone AS phone_31, a1_.sro_name AS sro_name_32, a1_.sro_registration_number AS sro_registration_number_33, a1_.status AS status_34, a1_.created_at AS created_at_35, a1_.updated_at AS updated_at_36, b2_.id AS id_37, b2_.case_number AS case_number_38, b2_.court_name AS court_name_39, b2_.court_region AS court_region_40, b2_.procedure_type AS procedure_type_41, b2_.started_at AS started_at_42, b2_.ended_at AS ended_at_43, b2_.status AS status_44, b2_.judge_name AS judge_name_45, b2_.external_reference AS external_reference_46, b2_.created_at AS created_at_47, b2_.updated_at AS updated_at_48, d3_.id AS id_49, d3_.type AS type_50, d3_.full_name AS full_name_51, d3_.short_name AS short_name_52, d3_.inn AS inn_53, d3_.ogrn AS ogrn_54, d3_.ogrnip AS ogrnip_55, d3_.address AS address_56, d3_.created_at AS created_at_57, d3_.updated_at AS updated_at_58, c0_.arbitration_manager_id AS arbitration_manager_id_59, c0_.bankruptcy_case_id AS bankruptcy_case_id_60, c0_.debtor_id AS debtor_id_61, c0_.inspection_scenario_id AS inspection_scenario_id_62, b2_.debtor_id AS debtor_id_63, b2_.current_arbitration_manager_id AS current_arbitration_manager_id_64 FROM delo.checks c0_ LEFT JOIN delo.arbitration_manager a1_ ON c0_.arbitration_manager_id = a1_.id LEFT JOIN delo.bankruptcy_case b2_ ON c0_.bankruptcy_case_id = b2_.id LEFT JOIN delo.debtor d3_ ON c0_.debtor_id = d3_.id ORDER BY c0_.created_at DESC, c0_.id DESC LIMIT 6;

SELECT
  v0_.id AS id_0,
  v0_.code AS code_1,
  v0_.title AS title_2,
  v0_.description AS description_3,
  v0_.norm_reference AS norm_reference_4,
  v0_.risk_level AS risk_level_5,
  v0_.status AS status_6,
  v0_.detected_at AS detected_at_7,
  v0_.confirmed_at AS confirmed_at_8,
  v0_.closed_at AS closed_at_9,
  v0_.source_type AS source_type_10,
  v0_.evidence_text AS evidence_text_11,
  v0_.legal_consequence AS legal_consequence_12,
  v0_.created_at AS created_at_13,
  v0_.updated_at AS updated_at_14,
  c1_.id AS id_15,
  c1_.public_id AS public_id_16,
  c1_.number AS number_17,
  c1_.status AS status_18,
  c1_.check_type AS check_type_19,
  c1_.procedure_type AS procedure_type_20,
  c1_.period_from AS period_from_21,
  c1_.period_to AS period_to_22,
  c1_.started_at AS started_at_23,
  c1_.finished_at AS finished_at_24,
  c1_.approved_at AS approved_at_25,
  c1_.failed_at AS failed_at_26,
  c1_.risk_level AS risk_level_27,
  c1_.violations_count AS violations_count_28,
  c1_.auto_detected_count AS auto_detected_count_29,
  c1_.manual_detected_count AS manual_detected_count_30,
  c1_.summary AS summary_31,
  c1_.notes AS notes_32,
  c1_.created_by_user_identifier AS created_by_user_identifier_33,
  c1_.updated_by_user_identifier AS updated_by_user_identifier_34,
  c1_.created_at AS created_at_35,
  c1_.updated_at AS updated_at_36,
  a2_.id AS id_37,
  a2_.full_name AS full_name_38,
  a2_.last_name AS last_name_39,
  a2_.first_name AS first_name_40,
  a2_.middle_name AS middle_name_41,
  a2_.registration_number AS registration_number_42,
  a2_.inn AS inn_43,
  a2_.snils AS snils_44,
  a2_.email AS email_45,
  a2_.phone AS phone_46,
  a2_.sro_name AS sro_name_47,
  a2_.sro_registration_number AS sro_registration_number_48,
  a2_.status AS status_49,
  a2_.created_at AS created_at_50,
  a2_.updated_at AS updated_at_51,
  b3_.id AS id_52,
  b3_.case_number AS case_number_53,
  b3_.court_name AS court_name_54,
  b3_.court_region AS court_region_55,
  b3_.procedure_type AS procedure_type_56,
  b3_.started_at AS started_at_57,
  b3_.ended_at AS ended_at_58,
  b3_.status AS status_59,
  b3_.judge_name AS judge_name_60,
  b3_.external_reference AS external_reference_61,
  b3_.created_at AS created_at_62,
  b3_.updated_at AS updated_at_63,
  r4_.id AS id_64,
  r4_.code AS code_65,
  r4_.name AS name_66,
  r4_.description AS description_67,
  r4_.category AS category_68,
  r4_.razdel AS razdel_69,
  r4_.procedure_type AS procedure_type_70,
  r4_.norm_reference AS norm_reference_71,
  r4_.severity AS severity_72,
  r4_.is_active AS is_active_73,
  r4_.config AS config_74,
  r4_.python_script AS python_script_75,
  r4_.created_at AS created_at_76,
  r4_.updated_at AS updated_at_77,
  v0_.check_id AS check_id_78,
  v0_.requirement_id AS requirement_id_79,
  v0_.check_requirement_result_id AS check_requirement_result_id_80,
  v0_.arbitration_manager_id AS arbitration_manager_id_81,
  v0_.bankruptcy_case_id AS bankruptcy_case_id_82,
  c1_.arbitration_manager_id AS arbitration_manager_id_83,
  c1_.bankruptcy_case_id AS bankruptcy_case_id_84,
  c1_.debtor_id AS debtor_id_85,
  c1_.inspection_scenario_id AS inspection_scenario_id_86,
  b3_.debtor_id AS debtor_id_87,
  b3_.current_arbitration_manager_id AS current_arbitration_manager_id_88,
  r4_.block_id AS block_id_89
FROM
  delo.violation v0_
  LEFT JOIN delo.checks c1_ ON v0_.check_id = c1_.id
  LEFT JOIN delo.arbitration_manager a2_ ON v0_.arbitration_manager_id = a2_.id
  LEFT JOIN delo.bankruptcy_case b3_ ON v0_.bankruptcy_case_id = b3_.id
  LEFT JOIN delo.requirement r4_ ON v0_.requirement_id = r4_.id
ORDER BY
  v0_.detected_at DESC,
  v0_.id DESC
LIMIT
  6

SELECT v0_.id AS id_0, v0_.code AS code_1, v0_.title AS title_2, v0_.description AS description_3, v0_.norm_reference AS norm_reference_4, v0_.risk_level AS risk_level_5, v0_.status AS status_6, v0_.detected_at AS detected_at_7, v0_.confirmed_at AS confirmed_at_8, v0_.closed_at AS closed_at_9, v0_.source_type AS source_type_10, v0_.evidence_text AS evidence_text_11, v0_.legal_consequence AS legal_consequence_12, v0_.created_at AS created_at_13, v0_.updated_at AS updated_at_14, c1_.id AS id_15, c1_.public_id AS public_id_16, c1_.number AS number_17, c1_.status AS status_18, c1_.check_type AS check_type_19, c1_.procedure_type AS procedure_type_20, c1_.period_from AS period_from_21, c1_.period_to AS period_to_22, c1_.started_at AS started_at_23, c1_.finished_at AS finished_at_24, c1_.approved_at AS approved_at_25, c1_.failed_at AS failed_at_26, c1_.risk_level AS risk_level_27, c1_.violations_count AS violations_count_28, c1_.auto_detected_count AS auto_detected_count_29, c1_.manual_detected_count AS manual_detected_count_30, c1_.summary AS summary_31, c1_.notes AS notes_32, c1_.created_by_user_identifier AS created_by_user_identifier_33, c1_.updated_by_user_identifier AS updated_by_user_identifier_34, c1_.created_at AS created_at_35, c1_.updated_at AS updated_at_36, a2_.id AS id_37, a2_.full_name AS full_name_38, a2_.last_name AS last_name_39, a2_.first_name AS first_name_40, a2_.middle_name AS middle_name_41, a2_.registration_number AS registration_number_42, a2_.inn AS inn_43, a2_.snils AS snils_44, a2_.email AS email_45, a2_.phone AS phone_46, a2_.sro_name AS sro_name_47, a2_.sro_registration_number AS sro_registration_number_48, a2_.status AS status_49, a2_.created_at AS created_at_50, a2_.updated_at AS updated_at_51, b3_.id AS id_52, b3_.case_number AS case_number_53, b3_.court_name AS court_name_54, b3_.court_region AS court_region_55, b3_.procedure_type AS procedure_type_56, b3_.started_at AS started_at_57, b3_.ended_at AS ended_at_58, b3_.status AS status_59, b3_.judge_name AS judge_name_60, b3_.external_reference AS external_reference_61, b3_.created_at AS created_at_62, b3_.updated_at AS updated_at_63, r4_.id AS id_64, r4_.code AS code_65, r4_.name AS name_66, r4_.description AS description_67, r4_.category AS category_68, r4_.razdel AS razdel_69, r4_.procedure_type AS procedure_type_70, r4_.norm_reference AS norm_reference_71, r4_.severity AS severity_72, r4_.is_active AS is_active_73, r4_.config AS config_74, r4_.python_script AS python_script_75, r4_.created_at AS created_at_76, r4_.updated_at AS updated_at_77, v0_.check_id AS check_id_78, v0_.requirement_id AS requirement_id_79, v0_.check_requirement_result_id AS check_requirement_result_id_80, v0_.arbitration_manager_id AS arbitration_manager_id_81, v0_.bankruptcy_case_id AS bankruptcy_case_id_82, c1_.arbitration_manager_id AS arbitration_manager_id_83, c1_.bankruptcy_case_id AS bankruptcy_case_id_84, c1_.debtor_id AS debtor_id_85, c1_.inspection_scenario_id AS inspection_scenario_id_86, b3_.debtor_id AS debtor_id_87, b3_.current_arbitration_manager_id AS current_arbitration_manager_id_88, r4_.block_id AS block_id_89 FROM delo.violation v0_ LEFT JOIN delo.checks c1_ ON v0_.check_id = c1_.id LEFT JOIN delo.arbitration_manager a2_ ON v0_.arbitration_manager_id = a2_.id LEFT JOIN delo.bankruptcy_case b3_ ON v0_.bankruptcy_case_id = b3_.id LEFT JOIN delo.requirement r4_ ON v0_.requirement_id = r4_.id ORDER BY v0_.detected_at DESC, v0_.id DESC LIMIT 6;

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  delo.checks c0_
WHERE
  c0_.status IN (?, ?, ?)

SELECT COUNT(c0_.id) AS sclr_0 FROM delo.checks c0_ WHERE c0_.status IN ('queued', 'running', 'review');

SELECT
  COUNT(c0_.id) AS sclr_0
FROM
  delo.checks c0_

SELECT COUNT(c0_.id) AS sclr_0 FROM delo.checks c0_;

SELECT
  a0_.code AS code_0,
  MAX(a0_.started_at) AS sclr_1,
  COUNT(a0_.id) AS sclr_2
FROM
  delo.agent_run_step a0_
GROUP BY
  a0_.code
ORDER BY
  sclr_2 DESC

SELECT a0_.code AS code_0, MAX(a0_.started_at) AS sclr_1, COUNT(a0_.id) AS sclr_2 FROM delo.agent_run_step a0_ GROUP BY a0_.code ORDER BY sclr_2 DESC;

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  delo.requirement r0_

SELECT COUNT(r0_.id) AS sclr_0 FROM delo.requirement r0_;

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  delo.violation v0_

SELECT COUNT(v0_.id) AS sclr_0 FROM delo.violation v0_;