Symfony Profiler

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'48637ada-1a9f-46a4-abad-9ebdfac97aa2''6d3e2d5f-5d57-4774-8f51-e128c75e6154''
    ) 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 ('1e7500b2-c45d-4dc1-a90d-33fb673ae03a', 'b8a63752-05bc-43e5-ae5c-8361ed13de22', 'a2257dea-a9ac-4cd9-9d51-0773d279b7b9', 'c407cef1-5023-499a-9cab-d096f2b85f2a', '0834125b-c942-412d-ac60-2e2b200a693e', '0459f6d3-3a08-478a-8885-e7560af429e9', 'f4e36e93-a349-430a-9d21-3ffb7c4b9143', '739f076e-dc66-4c83-b7d6-629afa81ad30', '36d5faf7-e104-4a11-b923-96e08b35aba7', 'e50d6699-62bb-4744-a344-525d909e7694', '398c5cb8-ea77-42b3-b138-11260cff7f48', '2e372850-4203-4a94-857c-2e50c8c80b46', '93f3e9bb-111e-4134-94fd-f7de1ee3ab63', ?, ?);

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        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
        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
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 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) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_59) AS dctrn_minrownum
FROM
  (
    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,
      ROW_NUMBER() OVER(
        ORDER BY
          c0_.created_at DESC,
          c0_.id DESC
      ) AS sclr_59
    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
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  15
OFFSET
  60

SELECT DISTINCT id_0, MIN(sclr_59) AS dctrn_minrownum FROM (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, ROW_NUMBER() OVER(ORDER BY c0_.created_at DESC, c0_.id DESC) AS sclr_59 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) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 15 OFFSET 60;

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
WHERE
  c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  c0_.created_at DESC,
  c0_.id DESC

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 WHERE c0_.id IN (34, 33, 32, 31, 30, 29, 28, 27, 26, 25, 24, 23, 22, 21, 20) ORDER BY c0_.created_at DESC, c0_.id DESC;