Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.name AS name_3,
  t0.serial_number AS serial_number_4,
  t0.phone_number AS phone_number_5,
  t0.email AS email_6,
  t0.street AS street_7,
  t0.postal_code AS postal_code_8,
  t0.city AS city_9,
  t0.api_url AS api_url_10,
  t0.password AS password_11,
  t0.app_password AS app_password_12,
  t0.active AS active_13,
  t0.authorization_parameters AS authorization_parameters_14,
  t0.hours AS hours_15,
  t0.informations AS informations_16,
  t0.website AS website_17,
  t0.payment_contract_number AS payment_contract_number_18,
  t0.created_at AS created_at_19,
  t0.updated_at AS updated_at_20,
  t0.country_id AS country_id_21,
  t0.soft_id AS soft_id_22,
  t23.id AS id_24,
  t23.appointment_terminal_scan AS appointment_terminal_scan_25,
  t23.payment_minor_access AS payment_minor_access_26,
  t23.payment_online AS payment_online_27,
  t23.payment_due_date_authorization AS payment_due_date_authorization_28,
  t23.payment_display_transaction_future AS payment_display_transaction_future_29,
  t23.document_sign_minor_access AS document_sign_minor_access_30,
  t23.imaging_display AS imaging_display_31,
  t23.questionnaire_minor_access AS questionnaire_minor_access_32,
  t23.vital_card AS vital_card_33,
  t23.instant_messaging AS instant_messaging_34,
  t23.global_message AS global_message_35,
  t23.created_at AS created_at_36,
  t23.updated_at AS updated_at_37,
  t23.office_id AS office_id_38
FROM
  tea.office t0
  LEFT JOIN tea.office_settings t23 ON t23.office_id = t0.id
WHERE
  t0.serial_number = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.name AS name_3, t0.serial_number AS serial_number_4, t0.phone_number AS phone_number_5, t0.email AS email_6, t0.street AS street_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.api_url AS api_url_10, t0.password AS password_11, t0.app_password AS app_password_12, t0.active AS active_13, t0.authorization_parameters AS authorization_parameters_14, t0.hours AS hours_15, t0.informations AS informations_16, t0.website AS website_17, t0.payment_contract_number AS payment_contract_number_18, t0.created_at AS created_at_19, t0.updated_at AS updated_at_20, t0.country_id AS country_id_21, t0.soft_id AS soft_id_22, t23.id AS id_24, t23.appointment_terminal_scan AS appointment_terminal_scan_25, t23.payment_minor_access AS payment_minor_access_26, t23.payment_online AS payment_online_27, t23.payment_due_date_authorization AS payment_due_date_authorization_28, t23.payment_display_transaction_future AS payment_display_transaction_future_29, t23.document_sign_minor_access AS document_sign_minor_access_30, t23.imaging_display AS imaging_display_31, t23.questionnaire_minor_access AS questionnaire_minor_access_32, t23.vital_card AS vital_card_33, t23.instant_messaging AS instant_messaging_34, t23.global_message AS global_message_35, t23.created_at AS created_at_36, t23.updated_at AS updated_at_37, t23.office_id AS office_id_38 FROM tea.office t0 LEFT JOIN tea.office_settings t23 ON t23.office_id = t0.id WHERE t0.serial_number = 3734 AND t0.active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.app_code AS app_code_2,
  t0.uuid AS uuid_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.office_id AS office_id_6
FROM
  tea.patient t0
WHERE
  t0.app_code = ?
  AND t0.office_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.app_code AS app_code_2, t0.uuid AS uuid_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.office_id AS office_id_6 FROM tea.patient t0 WHERE t0.app_code = 3 AND t0.office_id = 2 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.uuid AS uuid_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5,
  t0.person_id AS person_id_6,
  t0.patient_id AS patient_id_7,
  t0.practitioner_office_id AS practitioner_office_id_8
FROM
  tea.patient_attachment t0
WHERE
  t0.patient_id = ?

SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.person_id AS person_id_6, t0.patient_id AS patient_id_7, t0.practitioner_office_id AS practitioner_office_id_8 FROM tea.patient_attachment t0 WHERE t0.patient_id = 2;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.phone_number AS phone_number_5,
  t0.phone_country_code AS phone_country_code_6,
  t0.phone_validated AS phone_validated_7,
  t0.email AS email_8,
  t0.email_certified AS email_certified_9,
  t0.active AS active_10,
  t0.data AS data_11,
  t0.last_connexion AS last_connexion_12,
  t0.sync_date AS sync_date_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t16.id AS id_17,
  t16.civility AS civility_18,
  t16.firstname AS firstname_19,
  t16.lastname AS lastname_20,
  t16.birthday AS birthday_21,
  t16.national_identifier AS national_identifier_22,
  t16.created_at AS created_at_23,
  t16.updated_at AS updated_at_24,
  t16.user_id AS user_id_25,
  t16.country_id AS country_id_26,
  t16.created_by_user_id AS created_by_user_id_27,
  t28.id AS id_29,
  t28.created_at AS created_at_30,
  t28.updated_at AS updated_at_31,
  t28.user_id AS user_id_32
FROM
  tea.user t0
  LEFT JOIN tea.person t16 ON t16.user_id = t0.id
  LEFT JOIN tea.user_desactivation_history t28 ON t28.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.username AS username_3, t0.password AS password_4, t0.phone_number AS phone_number_5, t0.phone_country_code AS phone_country_code_6, t0.phone_validated AS phone_validated_7, t0.email AS email_8, t0.email_certified AS email_certified_9, t0.active AS active_10, t0.data AS data_11, t0.last_connexion AS last_connexion_12, t0.sync_date AS sync_date_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.civility AS civility_18, t16.firstname AS firstname_19, t16.lastname AS lastname_20, t16.birthday AS birthday_21, t16.national_identifier AS national_identifier_22, t16.created_at AS created_at_23, t16.updated_at AS updated_at_24, t16.user_id AS user_id_25, t16.country_id AS country_id_26, t16.created_by_user_id AS created_by_user_id_27, t28.id AS id_29, t28.created_at AS created_at_30, t28.updated_at AS updated_at_31, t28.user_id AS user_id_32 FROM tea.user t0 LEFT JOIN tea.person t16 ON t16.user_id = t0.id LEFT JOIN tea.user_desactivation_history t28 ON t28.user_id = t0.id WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.roles AS roles_2,
  t0.username AS username_3,
  t0.password AS password_4,
  t0.phone_number AS phone_number_5,
  t0.phone_country_code AS phone_country_code_6,
  t0.phone_validated AS phone_validated_7,
  t0.email AS email_8,
  t0.email_certified AS email_certified_9,
  t0.active AS active_10,
  t0.data AS data_11,
  t0.last_connexion AS last_connexion_12,
  t0.sync_date AS sync_date_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t16.id AS id_17,
  t16.civility AS civility_18,
  t16.firstname AS firstname_19,
  t16.lastname AS lastname_20,
  t16.birthday AS birthday_21,
  t16.national_identifier AS national_identifier_22,
  t16.created_at AS created_at_23,
  t16.updated_at AS updated_at_24,
  t16.user_id AS user_id_25,
  t16.country_id AS country_id_26,
  t16.created_by_user_id AS created_by_user_id_27,
  t28.id AS id_29,
  t28.created_at AS created_at_30,
  t28.updated_at AS updated_at_31,
  t28.user_id AS user_id_32
FROM
  tea.user t0
  LEFT JOIN tea.person t16 ON t16.user_id = t0.id
  LEFT JOIN tea.user_desactivation_history t28 ON t28.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.roles AS roles_2, t0.username AS username_3, t0.password AS password_4, t0.phone_number AS phone_number_5, t0.phone_country_code AS phone_country_code_6, t0.phone_validated AS phone_validated_7, t0.email AS email_8, t0.email_certified AS email_certified_9, t0.active AS active_10, t0.data AS data_11, t0.last_connexion AS last_connexion_12, t0.sync_date AS sync_date_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t16.id AS id_17, t16.civility AS civility_18, t16.firstname AS firstname_19, t16.lastname AS lastname_20, t16.birthday AS birthday_21, t16.national_identifier AS national_identifier_22, t16.created_at AS created_at_23, t16.updated_at AS updated_at_24, t16.user_id AS user_id_25, t16.country_id AS country_id_26, t16.created_by_user_id AS created_by_user_id_27, t28.id AS id_29, t28.created_at AS created_at_30, t28.updated_at AS updated_at_31, t28.user_id AS user_id_32 FROM tea.user t0 LEFT JOIN tea.person t16 ON t16.user_id = t0.id LEFT JOIN tea.user_desactivation_history t28 ON t28.user_id = t0.id WHERE t0.id = 13;