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,
  c4_.id AS id_59,
  c4_.storage_path AS storage_path_60,
  c4_.original_name AS original_name_61,
  c4_.mime_type AS mime_type_62,
  c4_.extension AS extension_63,
  c4_.size AS size_64,
  c4_.checksum AS checksum_65,
  c4_.document_type AS document_type_66,
  c4_.status AS status_67,
  c4_.parsed_text AS parsed_text_68,
  c4_.parsed_meta AS parsed_meta_69,
  c4_.uploaded_by AS uploaded_by_70,
  c4_.decoded_path AS decoded_path_71,
  c4_.text_length AS text_length_72,
  c4_.context_limit AS context_limit_73,
  c4_.context_limit_exceeded AS context_limit_exceeded_74,
  c4_.page_count AS page_count_75,
  c4_.created_at AS created_at_76,
  c4_.updated_at AS updated_at_77,
  c5_.id AS id_78,
  c5_.status AS status_79,
  c5_.confidence AS confidence_80,
  c5_.finding AS finding_81,
  c5_.normalized_finding AS normalized_finding_82,
  c5_.evidence_summary AS evidence_summary_83,
  c5_.review_comment AS review_comment_84,
  c5_.reviewed_by AS reviewed_by_85,
  c5_.reviewed_at AS reviewed_at_86,
  c5_.is_manual_override AS is_manual_override_87,
  c5_.sort_order AS sort_order_88,
  c5_.processed_at AS processed_at_89,
  c5_.chunk_index AS chunk_index_90,
  c5_.block_name AS block_name_91,
  c5_.created_at AS created_at_92,
  c5_.updated_at AS updated_at_93,
  r6_.id AS id_94,
  r6_.code AS code_95,
  r6_.name AS name_96,
  r6_.description AS description_97,
  r6_.category AS category_98,
  r6_.razdel AS razdel_99,
  r6_.procedure_type AS procedure_type_100,
  r6_.norm_reference AS norm_reference_101,
  r6_.severity AS severity_102,
  r6_.is_active AS is_active_103,
  r6_.config AS config_104,
  r6_.python_script AS python_script_105,
  r6_.created_at AS created_at_106,
  r6_.updated_at AS updated_at_107,
  v7_.id AS id_108,
  v7_.code AS code_109,
  v7_.title AS title_110,
  v7_.description AS description_111,
  v7_.norm_reference AS norm_reference_112,
  v7_.risk_level AS risk_level_113,
  v7_.status AS status_114,
  v7_.detected_at AS detected_at_115,
  v7_.confirmed_at AS confirmed_at_116,
  v7_.closed_at AS closed_at_117,
  v7_.source_type AS source_type_118,
  v7_.evidence_text AS evidence_text_119,
  v7_.legal_consequence AS legal_consequence_120,
  v7_.created_at AS created_at_121,
  v7_.updated_at AS updated_at_122,
  g8_.id AS id_123,
  g8_.type AS type_124,
  g8_.status AS status_125,
  g8_.title AS title_126,
  g8_.number AS number_127,
  g8_.content_html AS content_html_128,
  g8_.content_text AS content_text_129,
  g8_.file_path AS file_path_130,
  g8_.mime_type AS mime_type_131,
  g8_.generated_at AS generated_at_132,
  g8_.approved_at AS approved_at_133,
  g8_.created_at AS created_at_134,
  g8_.updated_at AS updated_at_135,
  a9_.id AS id_136,
  a9_.status AS status_137,
  a9_.started_at AS started_at_138,
  a9_.finished_at AS finished_at_139,
  a9_.error_message AS error_message_140,
  a9_.context AS context_141,
  a9_.created_at AS created_at_142,
  a9_.updated_at AS updated_at_143,
  a10_.id AS id_144,
  a10_.code AS code_145,
  a10_.name AS name_146,
  a10_.status AS status_147,
  a10_.started_at AS started_at_148,
  a10_.finished_at AS finished_at_149,
  a10_.message AS message_150,
  a10_.error_message AS error_message_151,
  a10_.payload AS payload_152,
  a10_.sort_order AS sort_order_153,
  a10_.created_at AS created_at_154,
  a10_.updated_at AS updated_at_155,
  c0_.arbitration_manager_id AS arbitration_manager_id_156,
  c0_.bankruptcy_case_id AS bankruptcy_case_id_157,
  c0_.debtor_id AS debtor_id_158,
  c0_.inspection_scenario_id AS inspection_scenario_id_159,
  b2_.debtor_id AS debtor_id_160,
  b2_.current_arbitration_manager_id AS current_arbitration_manager_id_161,
  c4_.check_id AS check_id_162,
  c5_.check_id AS check_id_163,
  c5_.requirement_id AS requirement_id_164,
  r6_.block_id AS block_id_165,
  v7_.check_id AS check_id_166,
  v7_.requirement_id AS requirement_id_167,
  v7_.check_requirement_result_id AS check_requirement_result_id_168,
  v7_.arbitration_manager_id AS arbitration_manager_id_169,
  v7_.bankruptcy_case_id AS bankruptcy_case_id_170,
  g8_.check_id AS check_id_171,
  g8_.document_template_id AS document_template_id_172,
  a9_.check_id AS check_id_173,
  a10_.agent_run_id AS agent_run_id_174
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
  LEFT JOIN delo.check_document c4_ ON c0_.id = c4_.check_id
  LEFT JOIN delo.check_requirement_result c5_ ON c0_.id = c5_.check_id
  LEFT JOIN delo.requirement r6_ ON c5_.requirement_id = r6_.id
  LEFT JOIN delo.violation v7_ ON c0_.id = v7_.check_id
  LEFT JOIN delo.generated_document g8_ ON c0_.id = g8_.check_id
  LEFT JOIN delo.agent_run a9_ ON c0_.id = a9_.check_id
  LEFT JOIN delo.agent_run_step a10_ ON a9_.id = a10_.agent_run_id
WHERE
  c0_.public_id = ?

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, c4_.id AS id_59, c4_.storage_path AS storage_path_60, c4_.original_name AS original_name_61, c4_.mime_type AS mime_type_62, c4_.extension AS extension_63, c4_.size AS size_64, c4_.checksum AS checksum_65, c4_.document_type AS document_type_66, c4_.status AS status_67, c4_.parsed_text AS parsed_text_68, c4_.parsed_meta AS parsed_meta_69, c4_.uploaded_by AS uploaded_by_70, c4_.decoded_path AS decoded_path_71, c4_.text_length AS text_length_72, c4_.context_limit AS context_limit_73, c4_.context_limit_exceeded AS context_limit_exceeded_74, c4_.page_count AS page_count_75, c4_.created_at AS created_at_76, c4_.updated_at AS updated_at_77, c5_.id AS id_78, c5_.status AS status_79, c5_.confidence AS confidence_80, c5_.finding AS finding_81, c5_.normalized_finding AS normalized_finding_82, c5_.evidence_summary AS evidence_summary_83, c5_.review_comment AS review_comment_84, c5_.reviewed_by AS reviewed_by_85, c5_.reviewed_at AS reviewed_at_86, c5_.is_manual_override AS is_manual_override_87, c5_.sort_order AS sort_order_88, c5_.processed_at AS processed_at_89, c5_.chunk_index AS chunk_index_90, c5_.block_name AS block_name_91, c5_.created_at AS created_at_92, c5_.updated_at AS updated_at_93, r6_.id AS id_94, r6_.code AS code_95, r6_.name AS name_96, r6_.description AS description_97, r6_.category AS category_98, r6_.razdel AS razdel_99, r6_.procedure_type AS procedure_type_100, r6_.norm_reference AS norm_reference_101, r6_.severity AS severity_102, r6_.is_active AS is_active_103, r6_.config AS config_104, r6_.python_script AS python_script_105, r6_.created_at AS created_at_106, r6_.updated_at AS updated_at_107, v7_.id AS id_108, v7_.code AS code_109, v7_.title AS title_110, v7_.description AS description_111, v7_.norm_reference AS norm_reference_112, v7_.risk_level AS risk_level_113, v7_.status AS status_114, v7_.detected_at AS detected_at_115, v7_.confirmed_at AS confirmed_at_116, v7_.closed_at AS closed_at_117, v7_.source_type AS source_type_118, v7_.evidence_text AS evidence_text_119, v7_.legal_consequence AS legal_consequence_120, v7_.created_at AS created_at_121, v7_.updated_at AS updated_at_122, g8_.id AS id_123, g8_.type AS type_124, g8_.status AS status_125, g8_.title AS title_126, g8_.number AS number_127, g8_.content_html AS content_html_128, g8_.content_text AS content_text_129, g8_.file_path AS file_path_130, g8_.mime_type AS mime_type_131, g8_.generated_at AS generated_at_132, g8_.approved_at AS approved_at_133, g8_.created_at AS created_at_134, g8_.updated_at AS updated_at_135, a9_.id AS id_136, a9_.status AS status_137, a9_.started_at AS started_at_138, a9_.finished_at AS finished_at_139, a9_.error_message AS error_message_140, a9_.context AS context_141, a9_.created_at AS created_at_142, a9_.updated_at AS updated_at_143, a10_.id AS id_144, a10_.code AS code_145, a10_.name AS name_146, a10_.status AS status_147, a10_.started_at AS started_at_148, a10_.finished_at AS finished_at_149, a10_.message AS message_150, a10_.error_message AS error_message_151, a10_.payload AS payload_152, a10_.sort_order AS sort_order_153, a10_.created_at AS created_at_154, a10_.updated_at AS updated_at_155, c0_.arbitration_manager_id AS arbitration_manager_id_156, c0_.bankruptcy_case_id AS bankruptcy_case_id_157, c0_.debtor_id AS debtor_id_158, c0_.inspection_scenario_id AS inspection_scenario_id_159, b2_.debtor_id AS debtor_id_160, b2_.current_arbitration_manager_id AS current_arbitration_manager_id_161, c4_.check_id AS check_id_162, c5_.check_id AS check_id_163, c5_.requirement_id AS requirement_id_164, r6_.block_id AS block_id_165, v7_.check_id AS check_id_166, v7_.requirement_id AS requirement_id_167, v7_.check_requirement_result_id AS check_requirement_result_id_168, v7_.arbitration_manager_id AS arbitration_manager_id_169, v7_.bankruptcy_case_id AS bankruptcy_case_id_170, g8_.check_id AS check_id_171, g8_.document_template_id AS document_template_id_172, a9_.check_id AS check_id_173, a10_.agent_run_id AS agent_run_id_174 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 LEFT JOIN delo.check_document c4_ ON c0_.id = c4_.check_id LEFT JOIN delo.check_requirement_result c5_ ON c0_.id = c5_.check_id LEFT JOIN delo.requirement r6_ ON c5_.requirement_id = r6_.id LEFT JOIN delo.violation v7_ ON c0_.id = v7_.check_id LEFT JOIN delo.generated_document g8_ ON c0_.id = g8_.check_id LEFT JOIN delo.agent_run a9_ ON c0_.id = a9_.check_id LEFT JOIN delo.agent_run_step a10_ ON a9_.id = a10_.agent_run_id WHERE c0_.public_id = 'f08869e3-757f-4207-afd4-fbd48c25520c';

SELECT
  checks.public_id AS public_id,
  d.start_check_at AS start_check_at,
  d.end_check_at AS end_check_at,
  EXTRACT(
    EPOCH
    FROM
      (
        d.end_check_at - d.start_check_at
      )
  ) AS duration_seconds,
  to_char(
    d.end_check_at - d.start_check_at,
    'DD" дн. "HH24:MI:SS'
  ) AS duration_human
FROM
  delo.checks
  INNER JOIN (
    SELECT
      check_id,
      MIN(checks.created_at) AS start_check_at,
      MAX(
        check_requirement_result.updated_at
      ) AS end_check_at
    FROM
      delo.check_requirement_result
      INNER JOIN delo.checks ON checks.id = check_requirement_result.check_id
    GROUP BY
      check_id
  ) AS d ON d.check_id = checks.id
WHERE
  checks.public_id IN (?)

SELECT
    checks.public_id                                      AS public_id,
    d.start_check_at                                      AS start_check_at,
    d.end_check_at                                        AS end_check_at,
    EXTRACT(EPOCH FROM (d.end_check_at - d.start_check_at)) AS duration_seconds,
    to_char(
        d.end_check_at - d.start_check_at,
        'DD" дн. "HH24'f08869e3-757f-4207-afd4-fbd48c25520c':SS'
    ) AS duration_human
FROM delo.checks
INNER JOIN (
    SELECT
        check_id,
        MIN(checks.created_at)                     AS start_check_at,
        MAX(check_requirement_result.updated_at)  AS end_check_at
    FROM delo.check_requirement_result
    INNER JOIN delo.checks ON checks.id = check_requirement_result.check_id
    GROUP BY check_id
) AS d ON d.check_id = checks.id
WHERE checks.public_id IN (?);

SELECT
  COUNT(*)
FROM
  delo.requirement t0
WHERE
  t0.is_active = ?

SELECT COUNT(*) FROM delo.requirement t0 WHERE t0.is_active = 1;