Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_0
    FROM
      (
        SELECT
          r0_.id AS id_0,
          r0_.code AS code_1,
          r0_.name AS name_2,
          r0_.description AS description_3,
          r0_.category AS category_4,
          r0_.razdel AS razdel_5,
          r0_.procedure_type AS procedure_type_6,
          r0_.norm_reference AS norm_reference_7,
          r0_.severity AS severity_8,
          r0_.is_active AS is_active_9,
          r0_.config AS config_10,
          r0_.python_script AS python_script_11,
          r0_.created_at AS created_at_12,
          r0_.updated_at AS updated_at_13,
          r1_.id AS id_14,
          r1_.code AS code_15,
          r1_.name AS name_16,
          r1_.description AS description_17,
          r1_.sort_order AS sort_order_18,
          r1_.is_active AS is_active_19,
          r1_.created_at AS created_at_20,
          r1_.updated_at AS updated_at_21
        FROM
          delo.requirement r0_
          LEFT JOIN delo.requirement_block r1_ ON r0_.block_id = r1_.id
        ORDER BY
          r1_.sort_order ASC,
          r0_.code ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.description AS description_3, r0_.category AS category_4, r0_.razdel AS razdel_5, r0_.procedure_type AS procedure_type_6, r0_.norm_reference AS norm_reference_7, r0_.severity AS severity_8, r0_.is_active AS is_active_9, r0_.config AS config_10, r0_.python_script AS python_script_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13, r1_.id AS id_14, r1_.code AS code_15, r1_.name AS name_16, r1_.description AS description_17, r1_.sort_order AS sort_order_18, r1_.is_active AS is_active_19, r1_.created_at AS created_at_20, r1_.updated_at AS updated_at_21 FROM delo.requirement r0_ LEFT JOIN delo.requirement_block r1_ ON r0_.block_id = r1_.id ORDER BY r1_.sort_order ASC, r0_.code ASC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_0,
  MIN(sclr_22) AS dctrn_minrownum
FROM
  (
    SELECT
      r0_.id AS id_0,
      r0_.code AS code_1,
      r0_.name AS name_2,
      r0_.description AS description_3,
      r0_.category AS category_4,
      r0_.razdel AS razdel_5,
      r0_.procedure_type AS procedure_type_6,
      r0_.norm_reference AS norm_reference_7,
      r0_.severity AS severity_8,
      r0_.is_active AS is_active_9,
      r0_.config AS config_10,
      r0_.python_script AS python_script_11,
      r0_.created_at AS created_at_12,
      r0_.updated_at AS updated_at_13,
      r1_.id AS id_14,
      r1_.code AS code_15,
      r1_.name AS name_16,
      r1_.description AS description_17,
      r1_.sort_order AS sort_order_18,
      r1_.is_active AS is_active_19,
      r1_.created_at AS created_at_20,
      r1_.updated_at AS updated_at_21,
      ROW_NUMBER() OVER(
        ORDER BY
          r1_.sort_order ASC,
          r0_.code ASC
      ) AS sclr_22
    FROM
      delo.requirement r0_
      LEFT JOIN delo.requirement_block r1_ ON r0_.block_id = r1_.id
  ) dctrn_result
GROUP BY
  id_0
ORDER BY
  dctrn_minrownum ASC
LIMIT
  25

SELECT DISTINCT id_0, MIN(sclr_22) AS dctrn_minrownum FROM (SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.description AS description_3, r0_.category AS category_4, r0_.razdel AS razdel_5, r0_.procedure_type AS procedure_type_6, r0_.norm_reference AS norm_reference_7, r0_.severity AS severity_8, r0_.is_active AS is_active_9, r0_.config AS config_10, r0_.python_script AS python_script_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13, r1_.id AS id_14, r1_.code AS code_15, r1_.name AS name_16, r1_.description AS description_17, r1_.sort_order AS sort_order_18, r1_.is_active AS is_active_19, r1_.created_at AS created_at_20, r1_.updated_at AS updated_at_21, ROW_NUMBER() OVER(ORDER BY r1_.sort_order ASC, r0_.code ASC) AS sclr_22 FROM delo.requirement r0_ LEFT JOIN delo.requirement_block r1_ ON r0_.block_id = r1_.id) dctrn_result GROUP BY id_0 ORDER BY dctrn_minrownum ASC LIMIT 25;

SELECT
  r0_.id AS id_0,
  r0_.code AS code_1,
  r0_.name AS name_2,
  r0_.description AS description_3,
  r0_.category AS category_4,
  r0_.razdel AS razdel_5,
  r0_.procedure_type AS procedure_type_6,
  r0_.norm_reference AS norm_reference_7,
  r0_.severity AS severity_8,
  r0_.is_active AS is_active_9,
  r0_.config AS config_10,
  r0_.python_script AS python_script_11,
  r0_.created_at AS created_at_12,
  r0_.updated_at AS updated_at_13,
  r1_.id AS id_14,
  r1_.code AS code_15,
  r1_.name AS name_16,
  r1_.description AS description_17,
  r1_.sort_order AS sort_order_18,
  r1_.is_active AS is_active_19,
  r1_.created_at AS created_at_20,
  r1_.updated_at AS updated_at_21,
  r0_.block_id AS block_id_22
FROM
  delo.requirement r0_
  LEFT JOIN delo.requirement_block r1_ ON r0_.block_id = r1_.id
WHERE
  r0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )
ORDER BY
  r1_.sort_order ASC,
  r0_.code ASC

SELECT r0_.id AS id_0, r0_.code AS code_1, r0_.name AS name_2, r0_.description AS description_3, r0_.category AS category_4, r0_.razdel AS razdel_5, r0_.procedure_type AS procedure_type_6, r0_.norm_reference AS norm_reference_7, r0_.severity AS severity_8, r0_.is_active AS is_active_9, r0_.config AS config_10, r0_.python_script AS python_script_11, r0_.created_at AS created_at_12, r0_.updated_at AS updated_at_13, r1_.id AS id_14, r1_.code AS code_15, r1_.name AS name_16, r1_.description AS description_17, r1_.sort_order AS sort_order_18, r1_.is_active AS is_active_19, r1_.created_at AS created_at_20, r1_.updated_at AS updated_at_21, r0_.block_id AS block_id_22 FROM delo.requirement r0_ LEFT JOIN delo.requirement_block r1_ ON r0_.block_id = r1_.id WHERE r0_.id IN (17271, 17272, 17273, 17274, 17276, 17277, 17278, 17279, 17280, 17281, 17282, 17283, 17284, 17285, 17286, 17287, 17288, 17289, 17290, 17291, 17292, 17293, 17294, 17295, 17296) ORDER BY r1_.sort_order ASC, r0_.code ASC;