Symfony Profiler

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  training_request t0_
  LEFT JOIN training_campain t1_ ON t0_.training_campain_id = t1_.id
WHERE
  t1_.user_id = ?
  AND t1_.external = 0

SELECT COUNT(t0_.id) AS sclr_0 FROM training_request t0_ LEFT JOIN training_campain t1_ ON t0_.training_campain_id = t1_.id WHERE t1_.user_id = 33 AND t1_.external = 0;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.budget AS budget_2,
  a0_.accountant_last_name AS accountant_last_name_3,
  a0_.accountant_first_name AS accountant_first_name_4,
  a0_.accountant_email AS accountant_email_5,
  a0_.accountant_phone AS accountant_phone_6,
  a0_.goal AS goal_7,
  a0_.information AS information_8,
  a0_.useful_link AS useful_link_9,
  a0_.date AS date_10,
  a0_.edit_date AS edit_date_11,
  a0_.set_up_date AS set_up_date_12,
  a0_.`terminated` AS terminated_13,
  a0_.by_manager AS by_manager_14,
  a0_.for_dpo AS for_dpo_15,
  a0_.estimation_time AS estimation_time_16,
  a0_.real_time AS real_time_17,
  a0_.`priority` AS priority_18,
  a0_.by_group AS by_group_19,
  a0_.group_user_concerned AS group_user_concerned_20,
  a0_.user_id AS user_id_21,
  a0_.group_user_id AS group_user_id_22,
  a0_.group_action_id AS group_action_id_23
FROM
  action a0_
WHERE
  (
    a0_.user_id = ?
    AND a0_.by_group = 0
  )
  OR (
    a0_.user_id = ?
    AND a0_.by_group = 1
    AND a0_.group_user_id <> ?
  )
  OR (
    a0_.user_id = ?
    AND a0_.by_group = 1
    AND a0_.group_user_id = ?
    AND a0_.group_user_concerned = 1
  )
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.budget AS budget_2, a0_.accountant_last_name AS accountant_last_name_3, a0_.accountant_first_name AS accountant_first_name_4, a0_.accountant_email AS accountant_email_5, a0_.accountant_phone AS accountant_phone_6, a0_.goal AS goal_7, a0_.information AS information_8, a0_.useful_link AS useful_link_9, a0_.date AS date_10, a0_.edit_date AS edit_date_11, a0_.set_up_date AS set_up_date_12, a0_.`terminated` AS terminated_13, a0_.by_manager AS by_manager_14, a0_.for_dpo AS for_dpo_15, a0_.estimation_time AS estimation_time_16, a0_.real_time AS real_time_17, a0_.`priority` AS priority_18, a0_.by_group AS by_group_19, a0_.group_user_concerned AS group_user_concerned_20, a0_.user_id AS user_id_21, a0_.group_user_id AS group_user_id_22, a0_.group_action_id AS group_action_id_23 FROM action a0_ WHERE (a0_.user_id = 33 AND a0_.by_group = 0) OR (a0_.user_id = 33 AND a0_.by_group = 1 AND a0_.group_user_id <> 33) OR (a0_.user_id = 33 AND a0_.by_group = 1 AND a0_.group_user_id = 33 AND a0_.group_user_concerned = 1) ORDER BY a0_.name ASC;

SELECT
  t0.id AS id_1,
  t0.cnil_informed AS cnil_informed_2,
  t0.notice_72_h AS notice_72_h_3,
  t0.type AS type_4,
  t0.people_number AS people_number_5,
  t0.file_type AS file_type_6,
  t0.consequences AS consequences_7,
  t0.taken_measures AS taken_measures_8,
  t0.people_informed AS people_informed_9,
  t0.date AS date_10,
  t0.creation_date AS creation_date_11,
  t0.edit_date AS edit_date_12,
  t0.`group` AS group_13,
  t0.file AS file_14,
  t0.user_id AS user_id_15
FROM
  incident t0
WHERE
  t0.user_id = ?
  AND t0.cnil_informed = ?
  AND t0.people_informed = ?

SELECT t0.id AS id_1, t0.cnil_informed AS cnil_informed_2, t0.notice_72_h AS notice_72_h_3, t0.type AS type_4, t0.people_number AS people_number_5, t0.file_type AS file_type_6, t0.consequences AS consequences_7, t0.taken_measures AS taken_measures_8, t0.people_informed AS people_informed_9, t0.date AS date_10, t0.creation_date AS creation_date_11, t0.edit_date AS edit_date_12, t0.`group` AS group_13, t0.file AS file_14, t0.user_id AS user_id_15 FROM incident t0 WHERE t0.user_id = 33 AND t0.cnil_informed = 0 AND t0.people_informed = 0;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.type AS type_3,
  t0.contact_first_name AS contact_first_name_4,
  t0.contact_last_name AS contact_last_name_5,
  t0.contact_phone AS contact_phone_6,
  t0.contact_email AS contact_email_7,
  t0.privacy_policy_link AS privacy_policy_link_8,
  t0.date AS date_9,
  t0.edit_date AS edit_date_10,
  t0.`group` AS group_11,
  t0.conformity_id AS conformity_id_12,
  t0.user_id AS user_id_13,
  t0.type_id AS type_id_14
FROM
  subcontractor t0
WHERE
  t0.user_id = ?
ORDER BY
  t0.name ASC

SELECT t0.id AS id_1, t0.name AS name_2, t0.type AS type_3, t0.contact_first_name AS contact_first_name_4, t0.contact_last_name AS contact_last_name_5, t0.contact_phone AS contact_phone_6, t0.contact_email AS contact_email_7, t0.privacy_policy_link AS privacy_policy_link_8, t0.date AS date_9, t0.edit_date AS edit_date_10, t0.`group` AS group_11, t0.conformity_id AS conformity_id_12, t0.user_id AS user_id_13, t0.type_id AS type_id_14 FROM subcontractor t0 WHERE t0.user_id = 33 ORDER BY t0.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.type AS type_2,
  s0_.contact_first_name AS contact_first_name_3,
  s0_.contact_last_name AS contact_last_name_4,
  s0_.contact_phone AS contact_phone_5,
  s0_.contact_email AS contact_email_6,
  s0_.privacy_policy_link AS privacy_policy_link_7,
  s0_.date AS date_8,
  s0_.edit_date AS edit_date_9,
  s0_.`group` AS group_10,
  s0_.conformity_id AS conformity_id_11,
  s0_.user_id AS user_id_12,
  s0_.type_id AS type_id_13
FROM
  subcontractor s0_
WHERE
  s0_.user_id IS NOT NULL
  AND (
    s0_.user_id = ?
    OR s0_.user_id = ?
  )
  AND s0_.`group` = 1
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.type AS type_2, s0_.contact_first_name AS contact_first_name_3, s0_.contact_last_name AS contact_last_name_4, s0_.contact_phone AS contact_phone_5, s0_.contact_email AS contact_email_6, s0_.privacy_policy_link AS privacy_policy_link_7, s0_.date AS date_8, s0_.edit_date AS edit_date_9, s0_.`group` AS group_10, s0_.conformity_id AS conformity_id_11, s0_.user_id AS user_id_12, s0_.type_id AS type_id_13 FROM subcontractor s0_ WHERE s0_.user_id IS NOT NULL AND (s0_.user_id = 33 OR s0_.user_id = 11) AND s0_.`group` = 1 ORDER BY s0_.name ASC;

SELECT
  AVG(t0_.result) AS sclr_0
FROM
  training_request_history t0_
  LEFT JOIN training_request t1_ ON t0_.training_request_id = t1_.id
  LEFT JOIN training_campain t2_ ON t1_.training_campain_id = t2_.id
WHERE
  t2_.user_id = ?
  AND t2_.external = 0

SELECT AVG(t0_.result) AS sclr_0 FROM training_request_history t0_ LEFT JOIN training_request t1_ ON t0_.training_request_id = t1_.id LEFT JOIN training_campain t2_ ON t1_.training_campain_id = t2_.id WHERE t2_.user_id = 33 AND t2_.external = 0;

SELECT
  t0.id AS id_1,
  t0.request_date AS request_date_2,
  t0.rights AS rights_3,
  t0.customer AS customer_4,
  t0.answer_date AS answer_date_5,
  t0.accountant_name AS accountant_name_6,
  t0.accountant_email AS accountant_email_7,
  t0.precisions AS precisions_8,
  t0.file AS file_9,
  t0.user_id AS user_id_10
FROM
  exercising_claim_request t0
WHERE
  t0.user_id = ?
  AND t0.answer_date IS NULL

SELECT t0.id AS id_1, t0.request_date AS request_date_2, t0.rights AS rights_3, t0.customer AS customer_4, t0.answer_date AS answer_date_5, t0.accountant_name AS accountant_name_6, t0.accountant_email AS accountant_email_7, t0.precisions AS precisions_8, t0.file AS file_9, t0.user_id AS user_id_10 FROM exercising_claim_request t0 WHERE t0.user_id = 33 AND t0.answer_date IS NULL;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.number AS number_3,
  t0.creation_date AS creation_date_4,
  t0.edit_date AS edit_date_5,
  t0.main_purpose AS main_purpose_6,
  t0.purpose_1 AS purpose_1_7,
  t0.purpose_2 AS purpose_2_8,
  t0.purpose_3 AS purpose_3_9,
  t0.purpose_4 AS purpose_4_10,
  t0.purpose_5 AS purpose_5_11,
  t0.others_purpose AS others_purpose_12,
  t0.description AS description_13,
  t0.personal_data AS personal_data_14,
  t0.people_data AS people_data_15,
  t0.transfer_outside_ue_countries AS transfer_outside_ue_countries_16,
  t0.sensitive_data AS sensitive_data_17,
  t0.consent_asked AS consent_asked_18,
  t0.consent_how AS consent_how_19,
  t0.pia_criteria AS pia_criteria_20,
  t0.pia_needed AS pia_needed_21,
  t0.pia_file AS pia_file_22,
  t0.pia_exoneration AS pia_exoneration_23,
  t0.legal_basis AS legal_basis_24,
  t0.data_source AS data_source_25,
  t0.automated_decision AS automated_decision_26,
  t0.insufficient_criteria AS insufficient_criteria_27,
  t0.data_retention_period AS data_retention_period_28,
  t0.treatment_accountant AS treatment_accountant_29,
  t0.dpo AS dpo_30,
  t0.service_accountant AS service_accountant_31,
  t0.editor AS editor_32,
  t0.`group` AS group_33,
  t0.user_id AS user_id_34,
  t0.state_id AS state_id_35,
  t0.company_subcontractor_type_id AS company_subcontractor_type_id_36
FROM
  treatment t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.number AS number_3, t0.creation_date AS creation_date_4, t0.edit_date AS edit_date_5, t0.main_purpose AS main_purpose_6, t0.purpose_1 AS purpose_1_7, t0.purpose_2 AS purpose_2_8, t0.purpose_3 AS purpose_3_9, t0.purpose_4 AS purpose_4_10, t0.purpose_5 AS purpose_5_11, t0.others_purpose AS others_purpose_12, t0.description AS description_13, t0.personal_data AS personal_data_14, t0.people_data AS people_data_15, t0.transfer_outside_ue_countries AS transfer_outside_ue_countries_16, t0.sensitive_data AS sensitive_data_17, t0.consent_asked AS consent_asked_18, t0.consent_how AS consent_how_19, t0.pia_criteria AS pia_criteria_20, t0.pia_needed AS pia_needed_21, t0.pia_file AS pia_file_22, t0.pia_exoneration AS pia_exoneration_23, t0.legal_basis AS legal_basis_24, t0.data_source AS data_source_25, t0.automated_decision AS automated_decision_26, t0.insufficient_criteria AS insufficient_criteria_27, t0.data_retention_period AS data_retention_period_28, t0.treatment_accountant AS treatment_accountant_29, t0.dpo AS dpo_30, t0.service_accountant AS service_accountant_31, t0.editor AS editor_32, t0.`group` AS group_33, t0.user_id AS user_id_34, t0.state_id AS state_id_35, t0.company_subcontractor_type_id AS company_subcontractor_type_id_36 FROM treatment t0 WHERE t0.user_id = 33;

SELECT
  COUNT(t0_.id) AS sclr_0
FROM
  training_request t0_
  LEFT JOIN training_campain t1_ ON t0_.training_campain_id = t1_.id
WHERE
  t1_.user_id = ?
  AND t0_.answer_date IS NOT NULL
  AND t1_.external = 0

SELECT COUNT(t0_.id) AS sclr_0 FROM training_request t0_ LEFT JOIN training_campain t1_ ON t0_.training_campain_id = t1_.id WHERE t1_.user_id = 33 AND t0_.answer_date IS NOT NULL AND t1_.external = 0;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.siret AS siret_3,
  t0.address AS address_4,
  t0.address_2 AS address_2_5,
  t0.zip_code AS zip_code_6,
  t0.city AS city_7,
  t0.company_phone AS company_phone_8,
  t0.phone AS phone_9,
  t0.email AS email_10,
  t0.contact_first_name AS contact_first_name_11,
  t0.contact_last_name AS contact_last_name_12,
  t0.contact_email AS contact_email_13,
  t0.contact_phone AS contact_phone_14,
  t0.contact_job AS contact_job_15,
  t0.accountant_first_name AS accountant_first_name_16,
  t0.accountant_last_name AS accountant_last_name_17,
  t0.accountant_email AS accountant_email_18,
  t0.accountant_phone AS accountant_phone_19,
  t0.accountant_job AS accountant_job_20,
  t0.picture AS picture_21,
  t0.manager_dpo AS manager_dpo_22,
  t0.demo AS demo_23,
  t0.credit AS credit_24,
  t0.employees_number AS employees_number_25,
  t0.language AS language_26,
  t0.manager_id AS manager_id_27,
  t0.lawyer_id AS lawyer_id_28,
  t0.user_id AS user_id_29,
  t30.id AS id_31,
  t30.email AS email_32,
  t30.password AS password_33,
  t30.salt AS salt_34,
  t30.registration_date AS registration_date_35,
  t30.password_request_date AS password_request_date_36,
  t30.password_request AS password_request_37,
  t30.last_login AS last_login_38,
  t30.enabled AS enabled_39,
  t30.roles AS roles_40,
  t30.errored_login_count AS errored_login_count_41,
  t30.locked AS locked_42,
  t30.manager_id AS manager_id_43,
  t30.user_id AS user_id_44,
  t30.subuser_id AS subuser_id_45,
  t30.login_log_id AS login_log_id_46,
  t0.current_subscription_id AS current_subscription_id_47
FROM
  user t0
  LEFT JOIN account t30 ON t30.user_id = t0.id
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.siret AS siret_3, t0.address AS address_4, t0.address_2 AS address_2_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.company_phone AS company_phone_8, t0.phone AS phone_9, t0.email AS email_10, t0.contact_first_name AS contact_first_name_11, t0.contact_last_name AS contact_last_name_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.contact_job AS contact_job_15, t0.accountant_first_name AS accountant_first_name_16, t0.accountant_last_name AS accountant_last_name_17, t0.accountant_email AS accountant_email_18, t0.accountant_phone AS accountant_phone_19, t0.accountant_job AS accountant_job_20, t0.picture AS picture_21, t0.manager_dpo AS manager_dpo_22, t0.demo AS demo_23, t0.credit AS credit_24, t0.employees_number AS employees_number_25, t0.language AS language_26, t0.manager_id AS manager_id_27, t0.lawyer_id AS lawyer_id_28, t0.user_id AS user_id_29, t30.id AS id_31, t30.email AS email_32, t30.password AS password_33, t30.salt AS salt_34, t30.registration_date AS registration_date_35, t30.password_request_date AS password_request_date_36, t30.password_request AS password_request_37, t30.last_login AS last_login_38, t30.enabled AS enabled_39, t30.roles AS roles_40, t30.errored_login_count AS errored_login_count_41, t30.locked AS locked_42, t30.manager_id AS manager_id_43, t30.user_id AS user_id_44, t30.subuser_id AS subuser_id_45, t30.login_log_id AS login_log_id_46, t0.current_subscription_id AS current_subscription_id_47 FROM user t0 LEFT JOIN account t30 ON t30.user_id = t0.id WHERE t0.user_id = 33;

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.email AS email_4,
  t0.phone AS phone_5,
  t0.company_name AS company_name_6,
  t0.address AS address_7,
  t0.address_2 AS address_2_8,
  t0.zip_code AS zip_code_9,
  t0.city AS city_10,
  t11.id AS id_12,
  t11.email AS email_13,
  t11.password AS password_14,
  t11.salt AS salt_15,
  t11.registration_date AS registration_date_16,
  t11.password_request_date AS password_request_date_17,
  t11.password_request AS password_request_18,
  t11.last_login AS last_login_19,
  t11.enabled AS enabled_20,
  t11.roles AS roles_21,
  t11.errored_login_count AS errored_login_count_22,
  t11.locked AS locked_23,
  t11.manager_id AS manager_id_24,
  t11.user_id AS user_id_25,
  t11.subuser_id AS subuser_id_26,
  t11.login_log_id AS login_log_id_27
FROM
  manager t0
  LEFT JOIN account t11 ON t11.manager_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.email AS email_4, t0.phone AS phone_5, t0.company_name AS company_name_6, t0.address AS address_7, t0.address_2 AS address_2_8, t0.zip_code AS zip_code_9, t0.city AS city_10, t11.id AS id_12, t11.email AS email_13, t11.password AS password_14, t11.salt AS salt_15, t11.registration_date AS registration_date_16, t11.password_request_date AS password_request_date_17, t11.password_request AS password_request_18, t11.last_login AS last_login_19, t11.enabled AS enabled_20, t11.roles AS roles_21, t11.errored_login_count AS errored_login_count_22, t11.locked AS locked_23, t11.manager_id AS manager_id_24, t11.user_id AS user_id_25, t11.subuser_id AS subuser_id_26, t11.login_log_id AS login_log_id_27 FROM manager t0 LEFT JOIN account t11 ON t11.manager_id = t0.id WHERE t0.id = 11;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.link AS link_3,
  t0.content AS content_4,
  t0.date AS date_5,
  t0.picture AS picture_6,
  t0.enabled AS enabled_7
FROM
  info t0
WHERE
  t0.enabled = ?
ORDER BY
  t0.date DESC
LIMIT
  4

SELECT t0.id AS id_1, t0.title AS title_2, t0.link AS link_3, t0.content AS content_4, t0.date AS date_5, t0.picture AS picture_6, t0.enabled AS enabled_7 FROM info t0 WHERE t0.enabled = 1 ORDER BY t0.date DESC LIMIT 4;

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.budget AS budget_2,
  a0_.accountant_last_name AS accountant_last_name_3,
  a0_.accountant_first_name AS accountant_first_name_4,
  a0_.accountant_email AS accountant_email_5,
  a0_.accountant_phone AS accountant_phone_6,
  a0_.goal AS goal_7,
  a0_.information AS information_8,
  a0_.useful_link AS useful_link_9,
  a0_.date AS date_10,
  a0_.edit_date AS edit_date_11,
  a0_.set_up_date AS set_up_date_12,
  a0_.`terminated` AS terminated_13,
  a0_.by_manager AS by_manager_14,
  a0_.for_dpo AS for_dpo_15,
  a0_.estimation_time AS estimation_time_16,
  a0_.real_time AS real_time_17,
  a0_.`priority` AS priority_18,
  a0_.by_group AS by_group_19,
  a0_.group_user_concerned AS group_user_concerned_20,
  a0_.user_id AS user_id_21,
  a0_.group_user_id AS group_user_id_22,
  a0_.group_action_id AS group_action_id_23
FROM
  action a0_
WHERE
  (
    (
      a0_.user_id = ?
      AND a0_.by_group = 0
    )
    OR (
      a0_.user_id = ?
      AND a0_.by_group = 1
      AND a0_.group_user_id <> ?
    )
    OR (
      a0_.user_id = ?
      AND a0_.by_group = 1
      AND a0_.group_user_id = ?
      AND a0_.group_user_concerned = 1
    )
  )
  AND a0_.set_up_date <= ?
ORDER BY
  a0_.set_up_date ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.budget AS budget_2, a0_.accountant_last_name AS accountant_last_name_3, a0_.accountant_first_name AS accountant_first_name_4, a0_.accountant_email AS accountant_email_5, a0_.accountant_phone AS accountant_phone_6, a0_.goal AS goal_7, a0_.information AS information_8, a0_.useful_link AS useful_link_9, a0_.date AS date_10, a0_.edit_date AS edit_date_11, a0_.set_up_date AS set_up_date_12, a0_.`terminated` AS terminated_13, a0_.by_manager AS by_manager_14, a0_.for_dpo AS for_dpo_15, a0_.estimation_time AS estimation_time_16, a0_.real_time AS real_time_17, a0_.`priority` AS priority_18, a0_.by_group AS by_group_19, a0_.group_user_concerned AS group_user_concerned_20, a0_.user_id AS user_id_21, a0_.group_user_id AS group_user_id_22, a0_.group_action_id AS group_action_id_23 FROM action a0_ WHERE ((a0_.user_id = 33 AND a0_.by_group = 0) OR (a0_.user_id = 33 AND a0_.by_group = 1 AND a0_.group_user_id <> 33) OR (a0_.user_id = 33 AND a0_.by_group = 1 AND a0_.group_user_id = 33 AND a0_.group_user_concerned = 1)) AND a0_.set_up_date <= '2025-02-16 14:45:29' ORDER BY a0_.set_up_date ASC;

SELECT
  SUM(t0_.emails_count) AS sclr_0
FROM
  training_campain t0_
WHERE
  t0_.user_id = ?
  AND t0_.traineeship = 1
  AND t0_.external = 0

SELECT SUM(t0_.emails_count) AS sclr_0 FROM training_campain t0_ WHERE t0_.user_id = 33 AND t0_.traineeship = 1 AND t0_.external = 0;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.salt AS salt_4,
  t0.registration_date AS registration_date_5,
  t0.password_request_date AS password_request_date_6,
  t0.password_request AS password_request_7,
  t0.last_login AS last_login_8,
  t0.enabled AS enabled_9,
  t0.roles AS roles_10,
  t0.errored_login_count AS errored_login_count_11,
  t0.locked AS locked_12,
  t0.manager_id AS manager_id_13,
  t0.user_id AS user_id_14,
  t0.subuser_id AS subuser_id_15,
  t0.login_log_id AS login_log_id_16
FROM
  account t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.salt AS salt_4, t0.registration_date AS registration_date_5, t0.password_request_date AS password_request_date_6, t0.password_request AS password_request_7, t0.last_login AS last_login_8, t0.enabled AS enabled_9, t0.roles AS roles_10, t0.errored_login_count AS errored_login_count_11, t0.locked AS locked_12, t0.manager_id AS manager_id_13, t0.user_id AS user_id_14, t0.subuser_id AS subuser_id_15, t0.login_log_id AS login_log_id_16 FROM account t0 WHERE t0.id = 173;

SELECT
  t0.id AS id_1,
  t0.company_name AS company_name_2,
  t0.siret AS siret_3,
  t0.address AS address_4,
  t0.address_2 AS address_2_5,
  t0.zip_code AS zip_code_6,
  t0.city AS city_7,
  t0.company_phone AS company_phone_8,
  t0.phone AS phone_9,
  t0.email AS email_10,
  t0.contact_first_name AS contact_first_name_11,
  t0.contact_last_name AS contact_last_name_12,
  t0.contact_email AS contact_email_13,
  t0.contact_phone AS contact_phone_14,
  t0.contact_job AS contact_job_15,
  t0.accountant_first_name AS accountant_first_name_16,
  t0.accountant_last_name AS accountant_last_name_17,
  t0.accountant_email AS accountant_email_18,
  t0.accountant_phone AS accountant_phone_19,
  t0.accountant_job AS accountant_job_20,
  t0.picture AS picture_21,
  t0.manager_dpo AS manager_dpo_22,
  t0.demo AS demo_23,
  t0.credit AS credit_24,
  t0.employees_number AS employees_number_25,
  t0.language AS language_26,
  t0.manager_id AS manager_id_27,
  t0.lawyer_id AS lawyer_id_28,
  t0.user_id AS user_id_29,
  t30.id AS id_31,
  t30.email AS email_32,
  t30.password AS password_33,
  t30.salt AS salt_34,
  t30.registration_date AS registration_date_35,
  t30.password_request_date AS password_request_date_36,
  t30.password_request AS password_request_37,
  t30.last_login AS last_login_38,
  t30.enabled AS enabled_39,
  t30.roles AS roles_40,
  t30.errored_login_count AS errored_login_count_41,
  t30.locked AS locked_42,
  t30.manager_id AS manager_id_43,
  t30.user_id AS user_id_44,
  t30.subuser_id AS subuser_id_45,
  t30.login_log_id AS login_log_id_46,
  t0.current_subscription_id AS current_subscription_id_47
FROM
  user t0
  LEFT JOIN account t30 ON t30.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.company_name AS company_name_2, t0.siret AS siret_3, t0.address AS address_4, t0.address_2 AS address_2_5, t0.zip_code AS zip_code_6, t0.city AS city_7, t0.company_phone AS company_phone_8, t0.phone AS phone_9, t0.email AS email_10, t0.contact_first_name AS contact_first_name_11, t0.contact_last_name AS contact_last_name_12, t0.contact_email AS contact_email_13, t0.contact_phone AS contact_phone_14, t0.contact_job AS contact_job_15, t0.accountant_first_name AS accountant_first_name_16, t0.accountant_last_name AS accountant_last_name_17, t0.accountant_email AS accountant_email_18, t0.accountant_phone AS accountant_phone_19, t0.accountant_job AS accountant_job_20, t0.picture AS picture_21, t0.manager_dpo AS manager_dpo_22, t0.demo AS demo_23, t0.credit AS credit_24, t0.employees_number AS employees_number_25, t0.language AS language_26, t0.manager_id AS manager_id_27, t0.lawyer_id AS lawyer_id_28, t0.user_id AS user_id_29, t30.id AS id_31, t30.email AS email_32, t30.password AS password_33, t30.salt AS salt_34, t30.registration_date AS registration_date_35, t30.password_request_date AS password_request_date_36, t30.password_request AS password_request_37, t30.last_login AS last_login_38, t30.enabled AS enabled_39, t30.roles AS roles_40, t30.errored_login_count AS errored_login_count_41, t30.locked AS locked_42, t30.manager_id AS manager_id_43, t30.user_id AS user_id_44, t30.subuser_id AS subuser_id_45, t30.login_log_id AS login_log_id_46, t0.current_subscription_id AS current_subscription_id_47 FROM user t0 LEFT JOIN account t30 ON t30.user_id = t0.id WHERE t0.id = 33;