Symfony Profiler

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.active AS active_6,
  t0.username AS username_7,
  t0.email AS email_8,
  t0.family_name AS family_name_9,
  t0.given_name AS given_name_10,
  t0.patronymic AS patronymic_11,
  t0.birthday AS birthday_12,
  t0.mobile AS mobile_13,
  t0.phone AS phone_14,
  t0.intercom AS intercom_15,
  t0.position AS position_16,
  t0.office AS office_17,
  t0.room AS room_18,
  t0.password AS password_19,
  t0.roles AS roles_20,
  t0.sa AS sa_21,
  t0.notified AS notified_22,
  t0.notify_concordance AS notify_concordance_23,
  t0.notify_comments AS notify_comments_24,
  t0.notify_upload AS notify_upload_25,
  t0.notify_doc_states AS notify_doc_states_26,
  t0.notify_act_states AS notify_act_states_27,
  t0.notify_payment_states AS notify_payment_states_28,
  t0.notify_doc_types AS notify_doc_types_29,
  t0.notify_fast_track_start AS notify_fast_track_start_30,
  t0.notify_fast_track_end AS notify_fast_track_end_31,
  t0.image_name AS image_name_32,
  t0.slack_id AS slack_id_33,
  t0.use_slack AS use_slack_34,
  t0.chat_id AS chat_id_35,
  t0.created_by AS created_by_36,
  t0.updated_by AS updated_by_37,
  t0.department_id AS department_id_38
FROM
  employee t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.title AS title_5, t0.active AS active_6, t0.username AS username_7, t0.email AS email_8, t0.family_name AS family_name_9, t0.given_name AS given_name_10, t0.patronymic AS patronymic_11, t0.birthday AS birthday_12, t0.mobile AS mobile_13, t0.phone AS phone_14, t0.intercom AS intercom_15, t0.position AS position_16, t0.office AS office_17, t0.room AS room_18, t0.password AS password_19, t0.roles AS roles_20, t0.sa AS sa_21, t0.notified AS notified_22, t0.notify_concordance AS notify_concordance_23, t0.notify_comments AS notify_comments_24, t0.notify_upload AS notify_upload_25, t0.notify_doc_states AS notify_doc_states_26, t0.notify_act_states AS notify_act_states_27, t0.notify_payment_states AS notify_payment_states_28, t0.notify_doc_types AS notify_doc_types_29, t0.notify_fast_track_start AS notify_fast_track_start_30, t0.notify_fast_track_end AS notify_fast_track_end_31, t0.image_name AS image_name_32, t0.slack_id AS slack_id_33, t0.use_slack AS use_slack_34, t0.chat_id AS chat_id_35, t0.created_by AS created_by_36, t0.updated_by AS updated_by_37, t0.department_id AS department_id_38 FROM employee t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL));

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.state AS state_6,
  t0.notes AS notes_7,
  t0.quantity AS quantity_8,
  t0.payed AS payed_9,
  t0.test_on_prod AS test_on_prod_10,
  t0.tz AS tz_11,
  t0.created_by AS created_by_12,
  t0.updated_by AS updated_by_13,
  t0.executor_id AS executor_id_14
FROM
  ksn135_ticket t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.title AS title_5, t0.state AS state_6, t0.notes AS notes_7, t0.quantity AS quantity_8, t0.payed AS payed_9, t0.test_on_prod AS test_on_prod_10, t0.tz AS tz_11, t0.created_by AS created_by_12, t0.updated_by AS updated_by_13, t0.executor_id AS executor_id_14 FROM ksn135_ticket t0 WHERE t0.id = '26064' AND ((t0.deleted_at IS NULL));

SELECT
  t0.action AS action_1,
  t0.notes AS notes_2,
  t0.id AS id_3,
  t0.state AS state_4,
  t0.previous_state AS previous_state_5,
  t0.transition AS transition_6,
  t0.created_by AS created_by_7,
  t0.deputy_id AS deputy_id_8,
  t0.parent_id AS parent_id_9
FROM
  ksn135_ticket_log t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.id DESC

SELECT t0.action AS action_1, t0.notes AS notes_2, t0.id AS id_3, t0.state AS state_4, t0.previous_state AS previous_state_5, t0.transition AS transition_6, t0.created_by AS created_by_7, t0.deputy_id AS deputy_id_8, t0.parent_id AS parent_id_9 FROM ksn135_ticket_log t0 WHERE t0.parent_id = 26064 ORDER BY t0.id DESC;

SELECT
  t0.image_name AS image_name_1,
  t0.image_size AS image_size_2,
  t0.image_mime_type AS image_mime_type_3,
  t0.image_original_name AS image_original_name_4,
  t0.notes AS notes_5,
  t0.deleted_at AS deleted_at_6,
  t0.actual AS actual_7,
  t0.actual_color AS actual_color_8,
  t0.id AS id_9,
  t0.created_by AS created_by_10,
  t0.deleted_by AS deleted_by_11,
  t0.parent_id AS parent_id_12
FROM
  ksn135_ticket_file t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0.id DESC

SELECT t0.image_name AS image_name_1, t0.image_size AS image_size_2, t0.image_mime_type AS image_mime_type_3, t0.image_original_name AS image_original_name_4, t0.notes AS notes_5, t0.deleted_at AS deleted_at_6, t0.actual AS actual_7, t0.actual_color AS actual_color_8, t0.id AS id_9, t0.created_by AS created_by_10, t0.deleted_by AS deleted_by_11, t0.parent_id AS parent_id_12 FROM ksn135_ticket_file t0 WHERE t0.parent_id = 26064 ORDER BY t0.id DESC;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.active AS active_6,
  t0.username AS username_7,
  t0.email AS email_8,
  t0.family_name AS family_name_9,
  t0.given_name AS given_name_10,
  t0.patronymic AS patronymic_11,
  t0.birthday AS birthday_12,
  t0.mobile AS mobile_13,
  t0.phone AS phone_14,
  t0.intercom AS intercom_15,
  t0.position AS position_16,
  t0.office AS office_17,
  t0.room AS room_18,
  t0.password AS password_19,
  t0.roles AS roles_20,
  t0.sa AS sa_21,
  t0.notified AS notified_22,
  t0.notify_concordance AS notify_concordance_23,
  t0.notify_comments AS notify_comments_24,
  t0.notify_upload AS notify_upload_25,
  t0.notify_doc_states AS notify_doc_states_26,
  t0.notify_act_states AS notify_act_states_27,
  t0.notify_payment_states AS notify_payment_states_28,
  t0.notify_doc_types AS notify_doc_types_29,
  t0.notify_fast_track_start AS notify_fast_track_start_30,
  t0.notify_fast_track_end AS notify_fast_track_end_31,
  t0.image_name AS image_name_32,
  t0.slack_id AS slack_id_33,
  t0.use_slack AS use_slack_34,
  t0.chat_id AS chat_id_35,
  t0.created_by AS created_by_39,
  t0.updated_by AS updated_by_40,
  t0.department_id AS department_id_41
FROM
  employee t0
WHERE
  t0.id = ?

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.title AS title_5, t0.active AS active_6, t0.username AS username_7, t0.email AS email_8, t0.family_name AS family_name_9, t0.given_name AS given_name_10, t0.patronymic AS patronymic_11, t0.birthday AS birthday_12, t0.mobile AS mobile_13, t0.phone AS phone_14, t0.intercom AS intercom_15, t0.position AS position_16, t0.office AS office_17, t0.room AS room_18, t0.password AS password_19, t0.roles AS roles_20, t0.sa AS sa_21, t0.notified AS notified_22, t0.notify_concordance AS notify_concordance_23, t0.notify_comments AS notify_comments_24, t0.notify_upload AS notify_upload_25, t0.notify_doc_states AS notify_doc_states_26, t0.notify_act_states AS notify_act_states_27, t0.notify_payment_states AS notify_payment_states_28, t0.notify_doc_types AS notify_doc_types_29, t0.notify_fast_track_start AS notify_fast_track_start_30, t0.notify_fast_track_end AS notify_fast_track_end_31, t0.image_name AS image_name_32, t0.slack_id AS slack_id_33, t0.use_slack AS use_slack_34, t0.chat_id AS chat_id_35, t0.created_by AS created_by_39, t0.updated_by AS updated_by_40, t0.department_id AS department_id_41 FROM employee t0 WHERE t0.id = 50;

SELECT
  t0.created_at AS created_at_1,
  t0.updated_at AS updated_at_2,
  t0.deleted_at AS deleted_at_3,
  t0.id AS id_4,
  t0.title AS title_5,
  t0.start_date AS start_date_6,
  t0.end_date AS end_date_7,
  t0.ignore_notify AS ignore_notify_8,
  t0.only_one_level AS only_one_level_9,
  t0.created_by AS created_by_10,
  t0.updated_by AS updated_by_11,
  t0.employee_id AS employee_id_12,
  t0.deputy_id AS deputy_id_13
FROM
  deputy t0
WHERE
  t0.deputy_id = ?
ORDER BY
  t0.end_date DESC

SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.deleted_at AS deleted_at_3, t0.id AS id_4, t0.title AS title_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.ignore_notify AS ignore_notify_8, t0.only_one_level AS only_one_level_9, t0.created_by AS created_by_10, t0.updated_by AS updated_by_11, t0.employee_id AS employee_id_12, t0.deputy_id AS deputy_id_13 FROM deputy t0 WHERE t0.deputy_id = 1 ORDER BY t0.end_date DESC;

SELECT
  k0_.created_at AS created_at_0,
  k0_.updated_at AS updated_at_1,
  k0_.deleted_at AS deleted_at_2,
  k0_.id AS id_3,
  k0_.title AS title_4,
  k0_.active AS active_5,
  k0_.notes AS notes_6,
  k0_.result AS result_7,
  k0_.object_class AS object_class_8,
  k0_.object_id AS object_id_9,
  k0_.due_date AS due_date_10,
  k0_.created_by AS created_by_11,
  k0_.updated_by AS updated_by_12,
  k0_.recepient_id AS recepient_id_13
FROM
  ksn135_task k0_
WHERE
  (
    k0_.object_class = ?
    AND k0_.object_id = ?
  )
  AND (
    k0_.recepient_id IN (?)
    OR k0_.created_by IN (?)
  )
  AND k0_.active = 1
ORDER BY
  k0_.updated_at DESC
LIMIT
  1

SELECT k0_.created_at AS created_at_0, k0_.updated_at AS updated_at_1, k0_.deleted_at AS deleted_at_2, k0_.id AS id_3, k0_.title AS title_4, k0_.active AS active_5, k0_.notes AS notes_6, k0_.result AS result_7, k0_.object_class AS object_class_8, k0_.object_id AS object_id_9, k0_.due_date AS due_date_10, k0_.created_by AS created_by_11, k0_.updated_by AS updated_by_12, k0_.recepient_id AS recepient_id_13 FROM ksn135_task k0_ WHERE (k0_.object_class = 'Ksn135\\CompanyBundle\\Entity\\Ticket' AND k0_.object_id = 26064) AND (k0_.recepient_id IN (1) OR k0_.created_by IN (1)) AND k0_.active = 1 ORDER BY k0_.updated_at DESC LIMIT 1;

SELECT
  k0_.created_at AS created_at_0,
  k0_.updated_at AS updated_at_1,
  k0_.deleted_at AS deleted_at_2,
  k0_.id AS id_3,
  k0_.title AS title_4,
  k0_.active AS active_5,
  k0_.notes AS notes_6,
  k0_.result AS result_7,
  k0_.object_class AS object_class_8,
  k0_.object_id AS object_id_9,
  k0_.due_date AS due_date_10,
  k0_.created_by AS created_by_11,
  k0_.updated_by AS updated_by_12,
  k0_.recepient_id AS recepient_id_13
FROM
  ksn135_task k0_
WHERE
  (
    k0_.object_class = ?
    AND k0_.object_id = ?
  )
  AND (
    k0_.recepient_id IN (?)
    OR k0_.created_by IN (?)
  )
  AND k0_.active = 1
ORDER BY
  k0_.updated_at DESC
LIMIT
  1

SELECT k0_.created_at AS created_at_0, k0_.updated_at AS updated_at_1, k0_.deleted_at AS deleted_at_2, k0_.id AS id_3, k0_.title AS title_4, k0_.active AS active_5, k0_.notes AS notes_6, k0_.result AS result_7, k0_.object_class AS object_class_8, k0_.object_id AS object_id_9, k0_.due_date AS due_date_10, k0_.created_by AS created_by_11, k0_.updated_by AS updated_by_12, k0_.recepient_id AS recepient_id_13 FROM ksn135_task k0_ WHERE (k0_.object_class = 'Ksn135\\CompanyBundle\\Entity\\Ticket' AND k0_.object_id = 26064) AND (k0_.recepient_id IN (1) OR k0_.created_by IN (1)) AND k0_.active = 1 ORDER BY k0_.updated_at DESC LIMIT 1;

SELECT
  k0_.created_at AS created_at_0,
  k0_.updated_at AS updated_at_1,
  k0_.deleted_at AS deleted_at_2,
  k0_.id AS id_3,
  k0_.title AS title_4,
  k0_.active AS active_5,
  k0_.notes AS notes_6,
  k0_.result AS result_7,
  k0_.object_class AS object_class_8,
  k0_.object_id AS object_id_9,
  k0_.due_date AS due_date_10,
  k0_.created_by AS created_by_11,
  k0_.updated_by AS updated_by_12,
  k0_.recepient_id AS recepient_id_13
FROM
  ksn135_task k0_
WHERE
  (
    k0_.object_class = ?
    AND k0_.object_id = ?
  )
  AND (
    k0_.recepient_id IN (?)
    OR k0_.created_by IN (?)
  )
  AND k0_.active = 1
ORDER BY
  k0_.updated_at DESC
LIMIT
  1

SELECT k0_.created_at AS created_at_0, k0_.updated_at AS updated_at_1, k0_.deleted_at AS deleted_at_2, k0_.id AS id_3, k0_.title AS title_4, k0_.active AS active_5, k0_.notes AS notes_6, k0_.result AS result_7, k0_.object_class AS object_class_8, k0_.object_id AS object_id_9, k0_.due_date AS due_date_10, k0_.created_by AS created_by_11, k0_.updated_by AS updated_by_12, k0_.recepient_id AS recepient_id_13 FROM ksn135_task k0_ WHERE (k0_.object_class = 'Ksn135\\CompanyBundle\\Entity\\Ticket' AND k0_.object_id = 26064) AND (k0_.recepient_id IN (1) OR k0_.created_by IN (1)) AND k0_.active = 1 ORDER BY k0_.updated_at DESC LIMIT 1;

SELECT
  COUNT(DISTINCT k0_.id) AS sclr_0
FROM
  ksn135_approval k0_
  INNER JOIN ksn135_approval_participant k1_ ON (k1_.approval_id = k0_.id)
WHERE
  k0_.declined = 0
  AND k0_.accepted = 0
  AND k0_.elaborated = 0
  AND k1_.declined = 0
  AND k1_.accepted = 0
  AND k1_.participant_id IN (?)

SELECT COUNT(DISTINCT k0_.id) AS sclr_0 FROM ksn135_approval k0_ INNER JOIN ksn135_approval_participant k1_ ON (k1_.approval_id = k0_.id) WHERE k0_.declined = 0 AND k0_.accepted = 0 AND k0_.elaborated = 0 AND k1_.declined = 0 AND k1_.accepted = 0 AND k1_.participant_id IN (1);

SELECT
  COUNT(DISTINCT a0_.id) AS sclr_0
FROM
  act a0_
WHERE
  (
    a0_.created_by IN (1)
    AND a0_.state IN (
      'approved', 'elaboration', 'signing',
      'signed'
    )
  )
  OR (
    a0_.executor_id IN (1)
    AND a0_.state IN ('appointed')
  )
  OR (
    a0_.accountant_id IN (1)
    AND a0_.state IN ('accwork')
  )
ORDER BY
  a0_.updated_at DESC

SELECT COUNT(DISTINCT a0_.id) AS sclr_0 FROM act a0_ WHERE (a0_.created_by IN (1) AND a0_.state IN ('approved', 'elaboration', 'signing', 'signed')) OR (a0_.executor_id IN (1) AND a0_.state IN ('appointed')) OR (a0_.accountant_id IN (1) AND a0_.state IN ('accwork')) ORDER BY a0_.updated_at DESC;

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  doc d0_
  LEFT JOIN doc d1_ ON d0_.parent_id = d1_.id
WHERE
  (
    d0_.created_by IN (1)
    AND d0_.state IN (
      'approved', 'elaboration', 'review',
      'signing', 'inner'
    )
  )
  OR (
    d0_.extra_id IN (1)
    AND d0_.state IN ('extra')
  )
  OR (
    d0_.executor_id IN (1)
    AND d0_.state IN ('appointed', 'pending')
  )
  OR (
    d0_.docflow_id IN (1)
    AND d0_.state IN ('docflow')
  )
  OR (
    d0_.accountant_id IN (1)
    AND d0_.state IN ('accwork')
  )
  OR (
    (
      (
        d0_.state = 'approved'
        AND ? = d0_.executor_id
        AND d0_.category_id IN (2, 3, 5, 6, 10, 13)
      )
      OR (
        d0_.state = 'deputy'
        AND EXISTS (
          SELECT
            d2_.id
          FROM
            doc_setting d2_
            INNER JOIN doc_setting_deputy_employee d4_ ON d2_.id = d4_.doc_setting_id
            INNER JOIN employee e3_ ON e3_.id = d4_.base_employee_id
          WHERE
            d2_.type = d0_.type
            AND d2_.approval_routes_type_id = d0_.approval_routes_type_id
            AND d2_.deleted_at IS NULL
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d2_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d2_.id
                  AND d5_.category_id IN (d0_.category_id)
              )
            )
            AND ? = e3_.id
        )
      )
      OR (
        d0_.state = 'director'
        AND EXISTS (
          SELECT
            d6_.id
          FROM
            doc_setting d6_
            INNER JOIN doc_setting_director_employee d8_ ON d6_.id = d8_.doc_setting_id
            INNER JOIN employee e7_ ON e7_.id = d8_.base_employee_id
          WHERE
            d6_.type = d0_.type
            AND d6_.approval_routes_type_id = d0_.approval_routes_type_id
            AND d6_.deleted_at IS NULL
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d6_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d6_.id
                  AND d5_.category_id IN (d0_.category_id)
              )
            )
            AND ? = e7_.id
        )
      )
      OR (
        d0_.state IN ('review')
        AND EXISTS (
          SELECT
            e9_.id
          FROM
            doc d10_
            INNER JOIN doc_responsible_person d11_ ON d10_.id = d11_.doc_id
            INNER JOIN employee e9_ ON e9_.id = d11_.person_id
          WHERE
            d10_.id = d0_.id
            AND ? = e9_.id
        )
      )
      OR (
        d0_.state = 'findir'
        AND EXISTS (
          SELECT
            d12_.id
          FROM
            doc_setting d12_
            INNER JOIN doc_setting_findir_employee d14_ ON d12_.id = d14_.doc_setting_id
            INNER JOIN employee e13_ ON e13_.id = d14_.base_employee_id
          WHERE
            d12_.type = d0_.type
            AND d12_.approval_routes_type_id = d0_.approval_routes_type_id
            AND d12_.deleted_at IS NULL
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d12_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d12_.id
                  AND d5_.category_id IN (d0_.category_id)
              )
            )
            AND ? = e13_.id
        )
      )
      OR (
        d0_.state = 'accqueue'
        AND EXISTS (
          SELECT
            d15_.id
          FROM
            doc_setting d15_
            INNER JOIN doc_setting_approval d16_ ON d15_.id = d16_.parent_id
            INNER JOIN doc_setting_approval_employee d18_ ON d16_.id = d18_.doc_setting_approval_id
            INNER JOIN employee e17_ ON e17_.id = d18_.base_employee_id
          WHERE
            d15_.type = d0_.type
            AND d15_.approval_routes_type_id = d0_.approval_routes_type_id
            AND d15_.deleted_at IS NULL
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d15_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d15_.id
                  AND d5_.category_id IN (d0_.category_id)
              )
            )
            AND d16_.deleted_at IS NULL
            AND d16_.doc = 1
            AND ? = e17_.id
        )
      )
      OR (
        d0_.state = 'queue'
        AND EXISTS (
          SELECT
            d19_.id
          FROM
            doc_setting d19_
            INNER JOIN doc_setting_docflow d21_ ON d19_.id = d21_.doc_setting_id
            INNER JOIN employee e20_ ON e20_.id = d21_.base_employee_id
          WHERE
            d19_.type = d0_.type
            AND d19_.approval_routes_type_id = d0_.approval_routes_type_id
            AND d19_.deleted_at IS NULL
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d19_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d19_.id
                  AND d5_.category_id IN (d0_.category_id)
              )
            )
            AND ? = e20_.id
        )
      )
      OR (
        d0_.state IN ('producer', 'postproducer')
        AND EXISTS (
          SELECT
            d22_.id
          FROM
            doc_setting d22_
            INNER JOIN doc_setting_producer_option d23_ ON d22_.id = d23_.parent_id
            INNER JOIN doc_setting_producer_option_employee d25_ ON d23_.id = d25_.doc_setting_producer_option_id
            INNER JOIN employee e24_ ON e24_.id = d25_.base_employee_id
          WHERE
            d22_.type = d0_.type
            AND d22_.approval_routes_type_id = d0_.approval_routes_type_id
            AND d22_.deleted_at IS NULL
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_producer_option_project d26_
                WHERE
                  d26_.doc_setting_producer_option_id = d23_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_producer_option_project d26_
                WHERE
                  d26_.doc_setting_producer_option_id = d23_.id
                  AND d26_.base_project_id IN (d0_.project_id)
              )
            )
            AND (
              (
                SELECT
                  COUNT(*)
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d22_.id
              ) = 0
              OR EXISTS (
                SELECT
                  1
                FROM
                  doc_setting_category d5_
                WHERE
                  d5_.doc_setting_id = d22_.id
                  AND d5_.category_id IN (d0_.category_id)
              )
            )
            AND ? = e24_.id
        )
      )
    )
    AND d0_.deleted_at IS NULL
    AND IFNULL(d1_.subdoc_id, 0) <> d0_.id
  )
ORDER BY
  d0_.updated_at DESC

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM doc d0_ LEFT JOIN doc d1_ ON d0_.parent_id = d1_.id WHERE (d0_.created_by IN (1) AND d0_.state IN ('approved', 'elaboration', 'review', 'signing', 'inner')) OR (d0_.extra_id IN (1) AND d0_.state IN ('extra')) OR (d0_.executor_id IN (1) AND d0_.state IN ('appointed', 'pending')) OR (d0_.docflow_id IN (1) AND d0_.state IN ('docflow')) OR (d0_.accountant_id IN (1) AND d0_.state IN ('accwork')) OR (((d0_.state = 'approved' AND 1 = d0_.executor_id AND d0_.category_id IN (2, 3, 5, 6, 10, 13)) OR (d0_.state = 'deputy' AND EXISTS (SELECT d2_.id FROM doc_setting d2_ INNER JOIN doc_setting_deputy_employee d4_ ON d2_.id = d4_.doc_setting_id INNER JOIN employee e3_ ON e3_.id = d4_.base_employee_id WHERE d2_.type = d0_.type AND d2_.approval_routes_type_id = d0_.approval_routes_type_id AND d2_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d2_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d2_.id AND d5_.category_id IN (d0_.category_id))) AND 1 = e3_.id)) OR (d0_.state = 'director' AND EXISTS (SELECT d6_.id FROM doc_setting d6_ INNER JOIN doc_setting_director_employee d8_ ON d6_.id = d8_.doc_setting_id INNER JOIN employee e7_ ON e7_.id = d8_.base_employee_id WHERE d6_.type = d0_.type AND d6_.approval_routes_type_id = d0_.approval_routes_type_id AND d6_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d6_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d6_.id AND d5_.category_id IN (d0_.category_id))) AND 1 = e7_.id)) OR (d0_.state IN ('review') AND EXISTS (SELECT e9_.id FROM doc d10_ INNER JOIN doc_responsible_person d11_ ON d10_.id = d11_.doc_id INNER JOIN employee e9_ ON e9_.id = d11_.person_id WHERE d10_.id = d0_.id AND 1 = e9_.id)) OR (d0_.state = 'findir' AND EXISTS (SELECT d12_.id FROM doc_setting d12_ INNER JOIN doc_setting_findir_employee d14_ ON d12_.id = d14_.doc_setting_id INNER JOIN employee e13_ ON e13_.id = d14_.base_employee_id WHERE d12_.type = d0_.type AND d12_.approval_routes_type_id = d0_.approval_routes_type_id AND d12_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d12_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d12_.id AND d5_.category_id IN (d0_.category_id))) AND 1 = e13_.id)) OR (d0_.state = 'accqueue' AND EXISTS (SELECT d15_.id FROM doc_setting d15_ INNER JOIN doc_setting_approval d16_ ON d15_.id = d16_.parent_id INNER JOIN doc_setting_approval_employee d18_ ON d16_.id = d18_.doc_setting_approval_id INNER JOIN employee e17_ ON e17_.id = d18_.base_employee_id WHERE d15_.type = d0_.type AND d15_.approval_routes_type_id = d0_.approval_routes_type_id AND d15_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d15_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d15_.id AND d5_.category_id IN (d0_.category_id))) AND d16_.deleted_at IS NULL AND d16_.doc = 1 AND 1 = e17_.id)) OR (d0_.state = 'queue' AND EXISTS (SELECT d19_.id FROM doc_setting d19_ INNER JOIN doc_setting_docflow d21_ ON d19_.id = d21_.doc_setting_id INNER JOIN employee e20_ ON e20_.id = d21_.base_employee_id WHERE d19_.type = d0_.type AND d19_.approval_routes_type_id = d0_.approval_routes_type_id AND d19_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d19_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d19_.id AND d5_.category_id IN (d0_.category_id))) AND 1 = e20_.id)) OR (d0_.state IN ('producer', 'postproducer') AND EXISTS (SELECT d22_.id FROM doc_setting d22_ INNER JOIN doc_setting_producer_option d23_ ON d22_.id = d23_.parent_id INNER JOIN doc_setting_producer_option_employee d25_ ON d23_.id = d25_.doc_setting_producer_option_id INNER JOIN employee e24_ ON e24_.id = d25_.base_employee_id WHERE d22_.type = d0_.type AND d22_.approval_routes_type_id = d0_.approval_routes_type_id AND d22_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_producer_option_project d26_ WHERE d26_.doc_setting_producer_option_id = d23_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_producer_option_project d26_ WHERE d26_.doc_setting_producer_option_id = d23_.id AND d26_.base_project_id IN (d0_.project_id))) AND ((SELECT COUNT(*) FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d22_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d5_ WHERE d5_.doc_setting_id = d22_.id AND d5_.category_id IN (d0_.category_id))) AND 1 = e24_.id))) AND d0_.deleted_at IS NULL AND IFNULL(d1_.subdoc_id, 0) <> d0_.id) ORDER BY d0_.updated_at DESC;

SELECT
  COUNT(DISTINCT d0_.id) AS sclr_0
FROM
  doc_template d0_
WHERE
  (
    d0_.created_by IN (1)
    AND d0_.state IN ('elaboration', 'approved')
  )
  OR (
    d0_.accountant_id IN (1)
    AND d0_.state IN ('accounting')
  )
  OR (
    d0_.executor_id IN (1)
    AND d0_.state IN ('appointed', 'pending')
  )
ORDER BY
  d0_.updated_at DESC

SELECT COUNT(DISTINCT d0_.id) AS sclr_0 FROM doc_template d0_ WHERE (d0_.created_by IN (1) AND d0_.state IN ('elaboration', 'approved')) OR (d0_.accountant_id IN (1) AND d0_.state IN ('accounting')) OR (d0_.executor_id IN (1) AND d0_.state IN ('appointed', 'pending')) ORDER BY d0_.updated_at DESC;

SELECT
  COUNT(DISTINCT o0_.id) AS sclr_0
FROM
  oficial o0_
WHERE
  o0_.created_by IN (1)
  AND o0_.state IN ('elaboration', 'approved')
ORDER BY
  o0_.updated_at DESC

SELECT COUNT(DISTINCT o0_.id) AS sclr_0 FROM oficial o0_ WHERE o0_.created_by IN (1) AND o0_.state IN ('elaboration', 'approved') ORDER BY o0_.updated_at DESC;