Symfony Profiler

SELECT
  t0.id AS id_4,
  t0.firstname AS firstname_5,
  t0.lastname AS lastname_6,
  t0.email AS email_7,
  t0.password AS password_8,
  t0.status AS status_9,
  t0.roles AS roles_10,
  t0.created_at AS created_at_11,
  t0.updated_at AS updated_at_12,
  t0.type,
  t1.identity_code AS identity_code_13,
  t1.address AS address_14,
  t1.phone_number AS phone_number_15,
  t1.city AS city_16,
  t1.zip_code AS zip_code_17,
  t3.phone_number AS phone_number_18
FROM
  account t0
  LEFT JOIN practician t1 ON t0.id = t1.id
  LEFT JOIN administrator t2 ON t0.id = t2.id
  LEFT JOIN supervisor t3 ON t0.id = t3.id
WHERE
  t0.id = ?

SELECT t0.id AS id_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.password AS password_8, t0.status AS status_9, t0.roles AS roles_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.type, t1.identity_code AS identity_code_13, t1.address AS address_14, t1.phone_number AS phone_number_15, t1.city AS city_16, t1.zip_code AS zip_code_17, t3.phone_number AS phone_number_18 FROM account t0 LEFT JOIN practician t1 ON t0.id = t1.id LEFT JOIN administrator t2 ON t0.id = t2.id LEFT JOIN supervisor t3 ON t0.id = t3.id WHERE t0.id = 1;

SELECT
  DISTINCT id_0
FROM
  (
    SELECT
      DISTINCT id_0,
      created_at_7
    FROM
      (
        SELECT
          o0_.id AS id_0,
          o0_.number AS number_1,
          o0_.type AS type_2,
          o0_.status AS status_3,
          o0_.tint AS tint_4,
          o0_.notify AS notify_5,
          o0_.steps AS steps_6,
          o0_.created_at AS created_at_7,
          o0_.updated_at AS updated_at_8
        FROM
          `order` o0_
        WHERE
          o0_.status IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
      ) dctrn_result_inner
    ORDER BY
      created_at_7 DESC
  ) dctrn_result
LIMIT
  30

SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_7 FROM (SELECT o0_.id AS id_0, o0_.number AS number_1, o0_.type AS type_2, o0_.status AS status_3, o0_.tint AS tint_4, o0_.notify AS notify_5, o0_.steps AS steps_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8 FROM `order` o0_ WHERE o0_.status IN ('pending', 'valid', 'invalid', 'inProcess', 'inProgress', 'inDelivery', 'completed', 'invoiced', 'cancelled')) dctrn_result_inner ORDER BY created_at_7 DESC) dctrn_result LIMIT 30;

SELECT
  o0_.id AS id_0,
  o0_.number AS number_1,
  o0_.type AS type_2,
  o0_.status AS status_3,
  o0_.tint AS tint_4,
  o0_.notify AS notify_5,
  o0_.steps AS steps_6,
  o0_.created_at AS created_at_7,
  o0_.updated_at AS updated_at_8,
  o0_.patient_id AS patient_id_9,
  o0_.owner_id AS owner_id_10,
  o0_.organization_id AS organization_id_11,
  o0_.traceability_id AS traceability_id_12,
  o0_.laboratory_id AS laboratory_id_13
FROM
  `order` o0_
WHERE
  o0_.status IN (?, ?, ?, ?, ?, ?, ?, ?, ?)
  AND o0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )
ORDER BY
  o0_.created_at DESC

SELECT o0_.id AS id_0, o0_.number AS number_1, o0_.type AS type_2, o0_.status AS status_3, o0_.tint AS tint_4, o0_.notify AS notify_5, o0_.steps AS steps_6, o0_.created_at AS created_at_7, o0_.updated_at AS updated_at_8, o0_.patient_id AS patient_id_9, o0_.owner_id AS owner_id_10, o0_.organization_id AS organization_id_11, o0_.traceability_id AS traceability_id_12, o0_.laboratory_id AS laboratory_id_13 FROM `order` o0_ WHERE o0_.status IN ('pending', 'valid', 'invalid', 'inProcess', 'inProgress', 'inDelivery', 'completed', 'invoiced', 'cancelled') AND o0_.id IN (34, 33, 32, 31, 30, 28, 27, 26, 25, 24, 23, 21, 18, 12, 5, 4, 3, 1) ORDER BY o0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 34;

SELECT
  t1.id AS id_2,
  t1.firstname AS firstname_3,
  t1.lastname AS lastname_4,
  t1.email AS email_5,
  t1.password AS password_6,
  t1.status AS status_7,
  t1.roles AS roles_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t0.identity_code AS identity_code_11,
  t0.address AS address_12,
  t0.phone_number AS phone_number_13,
  t0.city AS city_14,
  t0.zip_code AS zip_code_15,
  t1.type
FROM
  practician t0
  INNER JOIN account t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.firstname AS firstname_3, t1.lastname AS lastname_4, t1.email AS email_5, t1.password AS password_6, t1.status AS status_7, t1.roles AS roles_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.identity_code AS identity_code_11, t0.address AS address_12, t0.phone_number AS phone_number_13, t0.city AS city_14, t0.zip_code AS zip_code_15, t1.type FROM practician t0 INNER JOIN account t1 ON t0.id = t1.id WHERE t1.id = 4;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 34;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3
FROM
  laboratory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM laboratory t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 33;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 33;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.name AS name_3
FROM
  laboratory t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.name AS name_3 FROM laboratory t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 32;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 32;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 31;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 31;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 30;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 30;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 28;

SELECT
  t1.id AS id_2,
  t1.firstname AS firstname_3,
  t1.lastname AS lastname_4,
  t1.email AS email_5,
  t1.password AS password_6,
  t1.status AS status_7,
  t1.roles AS roles_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t0.identity_code AS identity_code_11,
  t0.address AS address_12,
  t0.phone_number AS phone_number_13,
  t0.city AS city_14,
  t0.zip_code AS zip_code_15,
  t1.type
FROM
  practician t0
  INNER JOIN account t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.firstname AS firstname_3, t1.lastname AS lastname_4, t1.email AS email_5, t1.password AS password_6, t1.status AS status_7, t1.roles AS roles_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.identity_code AS identity_code_11, t0.address AS address_12, t0.phone_number AS phone_number_13, t0.city AS city_14, t0.zip_code AS zip_code_15, t1.type FROM practician t0 INNER JOIN account t1 ON t0.id = t1.id WHERE t1.id = 14;

SELECT
  t0.id AS id_1,
  t0.name AS name_2
FROM
  organization t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2 FROM organization t0 WHERE t0.id = 2;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 28;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 27;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 27;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 26;

SELECT
  t1.id AS id_2,
  t1.firstname AS firstname_3,
  t1.lastname AS lastname_4,
  t1.email AS email_5,
  t1.password AS password_6,
  t1.status AS status_7,
  t1.roles AS roles_8,
  t1.created_at AS created_at_9,
  t1.updated_at AS updated_at_10,
  t0.identity_code AS identity_code_11,
  t0.address AS address_12,
  t0.phone_number AS phone_number_13,
  t0.city AS city_14,
  t0.zip_code AS zip_code_15,
  t1.type
FROM
  practician t0
  INNER JOIN account t1 ON t0.id = t1.id
WHERE
  t1.id = ?

SELECT t1.id AS id_2, t1.firstname AS firstname_3, t1.lastname AS lastname_4, t1.email AS email_5, t1.password AS password_6, t1.status AS status_7, t1.roles AS roles_8, t1.created_at AS created_at_9, t1.updated_at AS updated_at_10, t0.identity_code AS identity_code_11, t0.address AS address_12, t0.phone_number AS phone_number_13, t0.city AS city_14, t0.zip_code AS zip_code_15, t1.type FROM practician t0 INNER JOIN account t1 ON t0.id = t1.id WHERE t1.id = 13;

SELECT
  t0.id AS id_1,
  t0.delivery_date AS delivery_date_2,
  t0.comment AS comment_3,
  t0.locale AS locale_4,
  t0.translatable_id AS translatable_id_5
FROM
  order_translation t0
WHERE
  t0.translatable_id = ?

SELECT t0.id AS id_1, t0.delivery_date AS delivery_date_2, t0.comment AS comment_3, t0.locale AS locale_4, t0.translatable_id AS translatable_id_5 FROM order_translation t0 WHERE t0.translatable_id = 26;

SELECT
  t0.id AS id_1,
  t0.identity AS identity_2,
  t0.gender AS gender_3,
  t0.age AS age_4
FROM
  patient t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.identity AS identity_2, t0.gender AS gender_3, t0.age AS age_4 FROM patient t0 WHERE t0.id = 25;