Symfony Profiler

SELECT
  COUNT(DISTINCT k0_.id) AS sclr_0
FROM
  ksn135_ticket k0_
WHERE
  (
    k0_.created_by IN (1)
    AND k0_.state IN ('elaboration')
  )
  OR (
    k0_.executor_id IN (1)
    AND k0_.state IN (
      'selected', 'inprogress', 'release'
    )
  )
  OR k0_.state IN ('analyze', 'done')
ORDER BY
  k0_.updated_at DESC

SELECT COUNT(DISTINCT k0_.id) AS sclr_0 FROM ksn135_ticket k0_ WHERE (k0_.created_by IN (1) AND k0_.state IN ('elaboration')) OR (k0_.executor_id IN (1) AND k0_.state IN ('selected', 'inprogress', 'release')) OR k0_.state IN ('analyze', 'done') ORDER BY k0_.updated_at 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
  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
  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
  count(k0_.id) AS sclr_0
FROM
  ksn135_ticket k0_
WHERE
  k0_.state = 'archive'
  AND k0_.deleted_at IS NULL
  AND k0_.payed = 0
  AND k0_.quantity > 0

SELECT count(k0_.id) AS sclr_0 FROM ksn135_ticket k0_ WHERE k0_.state = 'archive' AND k0_.deleted_at IS NULL AND k0_.payed = 0 AND k0_.quantity > 0;

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
  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
  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
  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
  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
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  payment p0_
  LEFT JOIN doc d1_ ON p0_.doc_id = d1_.id
WHERE
  (
    p0_.created_by IN (1)
    AND p0_.state IN ('elaboration')
  )
  OR (
    p0_.docflow_id IN (1)
    AND p0_.state IN ('docflow')
  )
  OR (
    p0_.accountant_id IN (1)
    AND p0_.state IN ('accounted')
  )
  OR (
    p0_.producer_id IN (1)
    AND p0_.state IN ('produced')
  )
  OR (
    (
      p0_.state = 'docflow'
      AND (
        p0_.without_doc = 1
        OR d1_.kind_id = 12
      )
      AND EXISTS (
        SELECT
          e2_.id
        FROM
          employee e2_
        WHERE
          e2_.id = ?
          AND e2_.deleted_at IS NULL
          AND e2_.active = 1
          AND FIND_IN_SET(
            'ROLE_DOCFLOW',
            IFNULL(e2_.roles, '')
          ) > 0
          AND FIND_IN_SET(
            'ROLE_PAYMENT_CONFIDENTIAL',
            IFNULL(e2_.roles, '')
          ) > 0
      )
    )
    OR (
      p0_.state = 'accounted'
      AND EXISTS (
        SELECT
          e3_.id
        FROM
          employee e3_
        WHERE
          e3_.id = ?
          AND e3_.deleted_at IS NULL
          AND e3_.active = 1
          AND FIND_IN_SET(
            'ROLE_ACCOUNTING_FINANCIAL_CONTROL',
            IFNULL(e3_.roles, '')
          ) > 0
          AND FIND_IN_SET(
            'ROLE_PAYMENT_CONFIDENTIAL',
            IFNULL(e3_.roles, '')
          ) > 0
      )
    )
    OR (
      p0_.state = 'produced'
      AND (
        (
          EXISTS (
            SELECT
              d4_.id
            FROM
              doc_setting d4_
              INNER JOIN doc_setting_producer_option d5_ ON d4_.id = d5_.parent_id
              INNER JOIN doc_setting_producer_option_employee d7_ ON d5_.id = d7_.doc_setting_producer_option_id
              INNER JOIN employee e6_ ON e6_.id = d7_.base_employee_id
            WHERE
              d4_.type = d1_.type
              AND d4_.deleted_at IS NULL
              AND (
                (
                  SELECT
                    COUNT(*)
                  FROM
                    doc_setting_producer_option_project d8_
                  WHERE
                    d8_.doc_setting_producer_option_id = d5_.id
                ) = 0
                OR EXISTS (
                  SELECT
                    1
                  FROM
                    doc_setting_producer_option_project d8_
                  WHERE
                    d8_.doc_setting_producer_option_id = d5_.id
                    AND d8_.base_project_id IN (d1_.project_id)
                )
              )
              AND (
                (
                  SELECT
                    COUNT(*)
                  FROM
                    doc_setting_category d9_
                  WHERE
                    d9_.doc_setting_id = d4_.id
                ) = 0
                OR EXISTS (
                  SELECT
                    1
                  FROM
                    doc_setting_category d9_
                  WHERE
                    d9_.doc_setting_id = d4_.id
                    AND d9_.category_id IN (d1_.category_id)
                )
              )
              AND ? = e6_.id
          )
          OR (
            EXISTS (
              SELECT
                p10_.id
              FROM
                payment_setting p10_
                INNER JOIN payment_setting_employee p12_ ON p10_.id = p12_.payment_setting_id
                INNER JOIN employee e11_ ON e11_.id = p12_.base_employee_id
              WHERE
                p10_.deleted_at IS NULL
                AND (
                  (
                    SELECT
                      COUNT(*)
                    FROM
                      payment_setting_project p13_
                    WHERE
                      p13_.payment_setting_id = p10_.id
                  ) = 0
                  OR EXISTS (
                    SELECT
                      1
                    FROM
                      payment_setting_project p13_
                    WHERE
                      p13_.payment_setting_id = p10_.id
                      AND p13_.base_project_id IN (p0_.project_id)
                  )
                )
                AND (
                  (
                    SELECT
                      COUNT(*)
                    FROM
                      payment_setting_category p14_
                    WHERE
                      p14_.payment_setting_id = p10_.id
                  ) = 0
                  OR EXISTS (
                    SELECT
                      1
                    FROM
                      payment_setting_category p14_
                    WHERE
                      p14_.payment_setting_id = p10_.id
                      AND p14_.category_id IN (d1_.category_id)
                  )
                )
                AND ? = e11_.id
            )
          )
        )
      )
    )
    AND p0_.deleted_at IS NULL
  )
ORDER BY
  p0_.updated_at DESC

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM payment p0_ LEFT JOIN doc d1_ ON p0_.doc_id = d1_.id WHERE (p0_.created_by IN (1) AND p0_.state IN ('elaboration')) OR (p0_.docflow_id IN (1) AND p0_.state IN ('docflow')) OR (p0_.accountant_id IN (1) AND p0_.state IN ('accounted')) OR (p0_.producer_id IN (1) AND p0_.state IN ('produced')) OR ((p0_.state = 'docflow' AND (p0_.without_doc = 1 OR d1_.kind_id = 12) AND EXISTS (SELECT e2_.id FROM employee e2_ WHERE e2_.id = 1 AND e2_.deleted_at IS NULL AND e2_.active = 1 AND FIND_IN_SET('ROLE_DOCFLOW', IFNULL(e2_.roles, '')) > 0 AND FIND_IN_SET('ROLE_PAYMENT_CONFIDENTIAL', IFNULL(e2_.roles, '')) > 0)) OR (p0_.state = 'accounted' AND EXISTS (SELECT e3_.id FROM employee e3_ WHERE e3_.id = 1 AND e3_.deleted_at IS NULL AND e3_.active = 1 AND FIND_IN_SET('ROLE_ACCOUNTING_FINANCIAL_CONTROL', IFNULL(e3_.roles, '')) > 0 AND FIND_IN_SET('ROLE_PAYMENT_CONFIDENTIAL', IFNULL(e3_.roles, '')) > 0)) OR (p0_.state = 'produced' AND ((EXISTS (SELECT d4_.id FROM doc_setting d4_ INNER JOIN doc_setting_producer_option d5_ ON d4_.id = d5_.parent_id INNER JOIN doc_setting_producer_option_employee d7_ ON d5_.id = d7_.doc_setting_producer_option_id INNER JOIN employee e6_ ON e6_.id = d7_.base_employee_id WHERE d4_.type = d1_.type AND d4_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM doc_setting_producer_option_project d8_ WHERE d8_.doc_setting_producer_option_id = d5_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_producer_option_project d8_ WHERE d8_.doc_setting_producer_option_id = d5_.id AND d8_.base_project_id IN (d1_.project_id))) AND ((SELECT COUNT(*) FROM doc_setting_category d9_ WHERE d9_.doc_setting_id = d4_.id) = 0 OR EXISTS (SELECT 1 FROM doc_setting_category d9_ WHERE d9_.doc_setting_id = d4_.id AND d9_.category_id IN (d1_.category_id))) AND 1 = e6_.id) OR (EXISTS (SELECT p10_.id FROM payment_setting p10_ INNER JOIN payment_setting_employee p12_ ON p10_.id = p12_.payment_setting_id INNER JOIN employee e11_ ON e11_.id = p12_.base_employee_id WHERE p10_.deleted_at IS NULL AND ((SELECT COUNT(*) FROM payment_setting_project p13_ WHERE p13_.payment_setting_id = p10_.id) = 0 OR EXISTS (SELECT 1 FROM payment_setting_project p13_ WHERE p13_.payment_setting_id = p10_.id AND p13_.base_project_id IN (p0_.project_id))) AND ((SELECT COUNT(*) FROM payment_setting_category p14_ WHERE p14_.payment_setting_id = p10_.id) = 0 OR EXISTS (SELECT 1 FROM payment_setting_category p14_ WHERE p14_.payment_setting_id = p10_.id AND p14_.category_id IN (d1_.category_id))) AND 1 = e11_.id))))) AND p0_.deleted_at IS NULL) ORDER BY p0_.updated_at DESC;