Symfony Profiler

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
  )
  AND (k0_.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) AND (k0_.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.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.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 = ?
  AND (
    (t0.deleted_at IS NULL)
  )
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 AND ((t0.deleted_at IS NULL)) 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_.type AS type_5,
  k0_.accepted AS accepted_6,
  k0_.declined AS declined_7,
  k0_.elaborated AS elaborated_8,
  k0_.reason AS reason_9,
  k0_.object_class AS object_class_10,
  k0_.object_id AS object_id_11,
  k0_.created_by AS created_by_12,
  k0_.updated_by AS updated_by_13,
  k0_.project_id AS project_id_14
FROM
  ksn135_approval k0_
  INNER JOIN ksn135_approval_participant k1_ ON (
    k1_.approval_id = k0_.id
    AND k1_.declined = 0
    AND k1_.accepted = 0
  )
  AND (k1_.deleted_at IS NULL)
WHERE
  (
    (
      k0_.declined = 0
      AND k0_.accepted = 0
      AND k0_.object_class = ?
      AND k0_.object_id = ?
    )
    AND k1_.participant_id IN (?)
  )
  AND (k0_.deleted_at IS NULL)
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_.type AS type_5, k0_.accepted AS accepted_6, k0_.declined AS declined_7, k0_.elaborated AS elaborated_8, k0_.reason AS reason_9, k0_.object_class AS object_class_10, k0_.object_id AS object_id_11, k0_.created_by AS created_by_12, k0_.updated_by AS updated_by_13, k0_.project_id AS project_id_14 FROM ksn135_approval k0_ INNER JOIN ksn135_approval_participant k1_ ON (k1_.approval_id = k0_.id AND k1_.declined = 0 AND k1_.accepted = 0) AND (k1_.deleted_at IS NULL) WHERE ((k0_.declined = 0 AND k0_.accepted = 0 AND k0_.object_class = 'Ksn135\\CompanyBundle\\Entity\\Ticket' AND k0_.object_id = 26064) AND k1_.participant_id IN (1)) AND (k0_.deleted_at IS NULL) 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_.created_by IN (?)
    AND k0_.active = 0
  )
  AND (k0_.deleted_at IS NULL)
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_.created_by IN (1) AND k0_.active = 0) AND (k0_.deleted_at IS NULL) 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_.created_by IN (?)
    AND k0_.active = 1
    AND CHAR_LENGTH(k0_.result) > 0
  )
  AND (k0_.deleted_at IS NULL)
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_.created_by IN (1) AND k0_.active = 1 AND CHAR_LENGTH(k0_.result) > 0) AND (k0_.deleted_at IS NULL) ORDER BY k0_.updated_at DESC LIMIT 1;