Symfony Profiler

SELECT
  u0_.username AS username_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.firstname AS firstname_3,
  u0_.lastname AS lastname_4,
  u0_.gender AS gender_5,
  u0_.birthdate AS birthdate_6,
  u0_.origin_place AS origin_place_7,
  u0_.phone AS phone_8,
  u0_.phone_alternate AS phone_alternate_9,
  u0_.telegram_chat_id AS telegram_chat_id_10,
  u0_.avatar_name AS avatar_name_11,
  u0_.fonction AS fonction_12,
  u0_.roles AS roles_13,
  u0_.privileges AS privileges_14,
  u0_.locale AS locale_15,
  u0_.timezone AS timezone_16,
  u0_.authenticator_name AS authenticator_name_17,
  u0_.authenticator_user_id AS authenticator_user_id_18,
  u0_.confirmation_token AS confirmation_token_19,
  u0_.newsletter_subscribed AS newsletter_subscribed_20,
  u0_.observation AS observation_21,
  u0_.motorcycles AS motorcycles_22,
  u0_.password_updated_at AS password_updated_at_23,
  u0_.must_change_password AS must_change_password_24,
  u0_.logged_in_at AS logged_in_at_25,
  u0_.bad_customer AS bad_customer_26,
  u0_.disabled AS disabled_27,
  u0_.id AS id_28,
  u0_.created_at AS created_at_29,
  u0_.updated_at AS updated_at_30,
  u0_.deleted_at AS deleted_at_31,
  u0_.creator_id AS creator_id_32,
  u0_.modifier_id AS modifier_id_33,
  u0_.e_shop_id AS e_shop_id_34,
  a1_.id AS id_35,
  a1_.name AS name_36,
  a1_.type AS type_37,
  a1_.email AS email_38,
  a1_.phone AS phone_39,
  a1_.phone_alternate AS phone_alternate_40,
  a1_.url AS url_41,
  a1_.image AS image_42,
  a1_.locale AS locale_43,
  a1_.timezone AS timezone_44,
  a1_.observation AS observation_45,
  a1_.bad_customer AS bad_customer_46,
  a1_.disabled AS disabled_47,
  a1_.created_at AS created_at_48,
  a1_.updated_at AS updated_at_49,
  a1_.deleted_at AS deleted_at_50,
  a1_.creator_id AS creator_id_51,
  a1_.modifier_id AS modifier_id_52,
  u2_.id AS id_53,
  u2_.name AS name_54,
  u2_.description AS description_55,
  u2_.disabled AS disabled_56,
  u2_.created_at AS created_at_57,
  u2_.updated_at AS updated_at_58,
  u2_.deleted_at AS deleted_at_59,
  u2_.creator_id AS creator_id_60,
  u2_.modifier_id AS modifier_id_61,
  u2_.e_shop_id AS e_shop_id_62,
  t3_.name AS name_63,
  t3_.text_color AS text_color_64,
  t3_.background_color AS background_color_65,
  t3_.icon AS icon_66,
  t3_.id AS id_67,
  t3_.created_at AS created_at_68,
  t3_.updated_at AS updated_at_69,
  t3_.deleted_at AS deleted_at_70,
  t3_.creator_id AS creator_id_71,
  t3_.modifier_id AS modifier_id_72,
  u0_.account_id AS account_id_73,
  a1_.address_invoice_id AS address_invoice_id_74,
  a1_.address_delivery_id AS address_delivery_id_75
FROM
  `user` u0_
  LEFT JOIN account a1_ ON u0_.account_id = a1_.id
  AND (a1_.deleted_at IS NULL)
  LEFT JOIN user_user_group u4_ ON u0_.id = u4_.user_id
  LEFT JOIN user_group u2_ ON u2_.id = u4_.user_group_id
  AND (u2_.deleted_at IS NULL)
  LEFT JOIN user_tag u5_ ON u0_.id = u5_.user_id
  LEFT JOIN tag t3_ ON t3_.id = u5_.tag_id
  AND (t3_.deleted_at IS NULL)
WHERE
  (u0_.id = ?)
  AND (u0_.deleted_at IS NULL)
ORDER BY
  u0_.lastname ASC,
  u0_.firstname ASC,
  u2_.name ASC

SELECT u0_.username AS username_0, u0_.email AS email_1, u0_.password AS password_2, u0_.firstname AS firstname_3, u0_.lastname AS lastname_4, u0_.gender AS gender_5, u0_.birthdate AS birthdate_6, u0_.origin_place AS origin_place_7, u0_.phone AS phone_8, u0_.phone_alternate AS phone_alternate_9, u0_.telegram_chat_id AS telegram_chat_id_10, u0_.avatar_name AS avatar_name_11, u0_.fonction AS fonction_12, u0_.roles AS roles_13, u0_.privileges AS privileges_14, u0_.locale AS locale_15, u0_.timezone AS timezone_16, u0_.authenticator_name AS authenticator_name_17, u0_.authenticator_user_id AS authenticator_user_id_18, u0_.confirmation_token AS confirmation_token_19, u0_.newsletter_subscribed AS newsletter_subscribed_20, u0_.observation AS observation_21, u0_.motorcycles AS motorcycles_22, u0_.password_updated_at AS password_updated_at_23, u0_.must_change_password AS must_change_password_24, u0_.logged_in_at AS logged_in_at_25, u0_.bad_customer AS bad_customer_26, u0_.disabled AS disabled_27, u0_.id AS id_28, u0_.created_at AS created_at_29, u0_.updated_at AS updated_at_30, u0_.deleted_at AS deleted_at_31, u0_.creator_id AS creator_id_32, u0_.modifier_id AS modifier_id_33, u0_.e_shop_id AS e_shop_id_34, a1_.id AS id_35, a1_.name AS name_36, a1_.type AS type_37, a1_.email AS email_38, a1_.phone AS phone_39, a1_.phone_alternate AS phone_alternate_40, a1_.url AS url_41, a1_.image AS image_42, a1_.locale AS locale_43, a1_.timezone AS timezone_44, a1_.observation AS observation_45, a1_.bad_customer AS bad_customer_46, a1_.disabled AS disabled_47, a1_.created_at AS created_at_48, a1_.updated_at AS updated_at_49, a1_.deleted_at AS deleted_at_50, a1_.creator_id AS creator_id_51, a1_.modifier_id AS modifier_id_52, u2_.id AS id_53, u2_.name AS name_54, u2_.description AS description_55, u2_.disabled AS disabled_56, u2_.created_at AS created_at_57, u2_.updated_at AS updated_at_58, u2_.deleted_at AS deleted_at_59, u2_.creator_id AS creator_id_60, u2_.modifier_id AS modifier_id_61, u2_.e_shop_id AS e_shop_id_62, t3_.name AS name_63, t3_.text_color AS text_color_64, t3_.background_color AS background_color_65, t3_.icon AS icon_66, t3_.id AS id_67, t3_.created_at AS created_at_68, t3_.updated_at AS updated_at_69, t3_.deleted_at AS deleted_at_70, t3_.creator_id AS creator_id_71, t3_.modifier_id AS modifier_id_72, u0_.account_id AS account_id_73, a1_.address_invoice_id AS address_invoice_id_74, a1_.address_delivery_id AS address_delivery_id_75 FROM `user` u0_ LEFT JOIN account a1_ ON u0_.account_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN user_user_group u4_ ON u0_.id = u4_.user_id LEFT JOIN user_group u2_ ON u2_.id = u4_.user_group_id AND (u2_.deleted_at IS NULL) LEFT JOIN user_tag u5_ ON u0_.id = u5_.user_id LEFT JOIN tag t3_ ON t3_.id = u5_.tag_id AND (t3_.deleted_at IS NULL) WHERE (u0_.id = 1) AND (u0_.deleted_at IS NULL) ORDER BY u0_.lastname ASC, u0_.firstname ASC, u2_.name ASC;

SELECT
  t0.id AS id_1,
  t0.alias AS alias_2,
  t0.company AS company_3,
  t0.firstname AS firstname_4,
  t0.lastname AS lastname_5,
  t0.address1 AS address1_6,
  t0.address2 AS address2_7,
  t0.postal_code AS postal_code_8,
  t0.city AS city_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.deleted_at AS deleted_at_12,
  t0.e_shop_id AS e_shop_id_13,
  t0.user_id AS user_id_14,
  t0.state_id AS state_id_15,
  t16.id AS id_17,
  t16.iso_code AS iso_code_18,
  t16.name AS name_19,
  t16.e_shop_id AS e_shop_id_20,
  t16.country_id AS country_id_21,
  t0.country_id AS country_id_22,
  t23.id AS id_24,
  t23.iso_code AS iso_code_25,
  t23.name AS name_26,
  t23.e_shop_id AS e_shop_id_27
FROM
  address t0
  LEFT JOIN state t16 ON t0.state_id = t16.id
  INNER JOIN country t23 ON t0.country_id = t23.id
WHERE
  t0.user_id = ?
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT t0.id AS id_1, t0.alias AS alias_2, t0.company AS company_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.address1 AS address1_6, t0.address2 AS address2_7, t0.postal_code AS postal_code_8, t0.city AS city_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.deleted_at AS deleted_at_12, t0.e_shop_id AS e_shop_id_13, t0.user_id AS user_id_14, t0.state_id AS state_id_15, t16.id AS id_17, t16.iso_code AS iso_code_18, t16.name AS name_19, t16.e_shop_id AS e_shop_id_20, t16.country_id AS country_id_21, t0.country_id AS country_id_22, t23.id AS id_24, t23.iso_code AS iso_code_25, t23.name AS name_26, t23.e_shop_id AS e_shop_id_27 FROM address t0 LEFT JOIN state t16 ON t0.state_id = t16.id INNER JOIN country t23 ON t0.country_id = t23.id WHERE t0.user_id = 1 AND ((t0.deleted_at IS NULL));