Symfony Profiler

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.website AS website_2,
  c0_.description AS description_3,
  c0_.external_id AS external_id_4,
  c0_.details AS details_5,
  c0_.logo_image_name AS logo_image_name_6,
  c0_.cover_image_name AS cover_image_name_7,
  c0_.tagline AS tagline_8,
  c0_.contact_email AS contact_email_9,
  c0_.phone AS phone_10,
  c0_.stream_url AS stream_url_11,
  c0_.stream_type AS stream_type_12,
  c0_.total_followers AS total_followers_13,
  c0_.industry AS industry_14,
  c0_.size AS size_15,
  c0_.address1 AS address1_16,
  c0_.address2 AS address2_17,
  c0_.city AS city_18,
  c0_.postal_code AS postal_code_19,
  c0_.state AS state_20,
  c0_.country AS country_21,
  c0_.social_linkedin AS social_linkedin_22,
  c0_.social_x AS social_x_23,
  c0_.social_facebook AS social_facebook_24,
  c0_.social_instagram AS social_instagram_25,
  c0_.social_youtube AS social_youtube_26,
  c0_.created_at AS created_at_27,
  c0_.updated_at AS updated_at_28,
  c1_.id AS id_29,
  c1_.name AS name_30,
  c1_.notes AS notes_31,
  c1_.storage AS storage_32,
  c1_.bucket_key AS bucket_key_33,
  c1_.bucket_secret AS bucket_secret_34,
  c1_.bucket_name AS bucket_name_35,
  c1_.bucket_region AS bucket_region_36,
  c1_.bucket_endpoint AS bucket_endpoint_37,
  c1_.configuration AS configuration_38,
  c1_.domain AS domain_39,
  c1_.is_show_public AS is_show_public_40,
  c1_.is_community_sharing_enable AS is_community_sharing_enable_41,
  c1_.course_commission AS course_commission_42,
  c1_.sync_containers AS sync_containers_43,
  c1_.is_sync_container_changed AS is_sync_container_changed_44,
  c1_.created_at AS created_at_45,
  c1_.updated_at AS updated_at_46,
  c0_.client_id AS client_id_47,
  c0_.company_category_id AS company_category_id_48
FROM
  company c0_
  INNER JOIN client c1_ ON c0_.client_id = c1_.id
  INNER JOIN company_container c3_ ON c0_.id = c3_.company_id
  INNER JOIN container c2_ ON c2_.id = c3_.container_id
WHERE
  c0_.id IN (
    SELECT
      c4_.id
    FROM
      company c4_
      INNER JOIN client c5_ ON c4_.client_id = c5_.id
      INNER JOIN company_container c7_ ON c4_.id = c7_.company_id
      INNER JOIN container c6_ ON c6_.id = c7_.container_id
    WHERE
      c5_.id = ?
      AND c6_.id = ?
  )
ORDER BY
  c0_.id ASC

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.website AS website_2, c0_.description AS description_3, c0_.external_id AS external_id_4, c0_.details AS details_5, c0_.logo_image_name AS logo_image_name_6, c0_.cover_image_name AS cover_image_name_7, c0_.tagline AS tagline_8, c0_.contact_email AS contact_email_9, c0_.phone AS phone_10, c0_.stream_url AS stream_url_11, c0_.stream_type AS stream_type_12, c0_.total_followers AS total_followers_13, c0_.industry AS industry_14, c0_.size AS size_15, c0_.address1 AS address1_16, c0_.address2 AS address2_17, c0_.city AS city_18, c0_.postal_code AS postal_code_19, c0_.state AS state_20, c0_.country AS country_21, c0_.social_linkedin AS social_linkedin_22, c0_.social_x AS social_x_23, c0_.social_facebook AS social_facebook_24, c0_.social_instagram AS social_instagram_25, c0_.social_youtube AS social_youtube_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, c1_.id AS id_29, c1_.name AS name_30, c1_.notes AS notes_31, c1_.storage AS storage_32, c1_.bucket_key AS bucket_key_33, c1_.bucket_secret AS bucket_secret_34, c1_.bucket_name AS bucket_name_35, c1_.bucket_region AS bucket_region_36, c1_.bucket_endpoint AS bucket_endpoint_37, c1_.configuration AS configuration_38, c1_.domain AS domain_39, c1_.is_show_public AS is_show_public_40, c1_.is_community_sharing_enable AS is_community_sharing_enable_41, c1_.course_commission AS course_commission_42, c1_.sync_containers AS sync_containers_43, c1_.is_sync_container_changed AS is_sync_container_changed_44, c1_.created_at AS created_at_45, c1_.updated_at AS updated_at_46, c0_.client_id AS client_id_47, c0_.company_category_id AS company_category_id_48 FROM company c0_ INNER JOIN client c1_ ON c0_.client_id = c1_.id INNER JOIN company_container c3_ ON c0_.id = c3_.company_id INNER JOIN container c2_ ON c2_.id = c3_.container_id WHERE c0_.id IN (SELECT c4_.id FROM company c4_ INNER JOIN client c5_ ON c4_.client_id = c5_.id INNER JOIN company_container c7_ ON c4_.id = c7_.company_id INNER JOIN container c6_ ON c6_.id = c7_.container_id WHERE c5_.id = '59' AND c6_.id = '18') ORDER BY c0_.id ASC;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.token AS token_3,
  t0.expire_at AS expire_at_4,
  t0.is_active AS is_active_5,
  t0.refresh_token AS refresh_token_6,
  t0.rt_expire_at AS rt_expire_at_7,
  t0.short_token AS short_token_8,
  t0.user_id AS user_id_9,
  t0.container_id AS container_id_10
FROM
  access_token t0
WHERE
  t0.token = ?
  AND t0.container_id = ?
  AND t0.is_active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.token AS token_3, t0.expire_at AS expire_at_4, t0.is_active AS is_active_5, t0.refresh_token AS refresh_token_6, t0.rt_expire_at AS rt_expire_at_7, t0.short_token AS short_token_8, t0.user_id AS user_id_9, t0.container_id AS container_id_10 FROM access_token t0 WHERE t0.token = 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJpYXQiOjE3NjExOTgyMTksImV4cCI6MTc2MTI4NDYxOSwicm9sZXMiOlsiUk9MRV9BRE1JTiJdLCJ1c2VybmFtZSI6ImNlY2lsZS5rZWxsZXJAaW5zZWwuY2giLCJpcCI6IjE2MS42Mi4yNTIuMzQiLCJjaWQiOjU5LCJjbnRpZCI6MTh9.CN3MeG1EC3rFpjos-ZKy7BOxLYdIPZnkWZXp8977sG856ISevwqhP7eM5MOqN5cv2XAJZKiBxYTPe5vJq9R8w1DMYY2ES7rBmfKVtc8mYMopoMwZP7U7Ano1xe9o26xl-xrMyJ-LdAy9MSO-jMOklqgMVOWQFGabTyVwi324k73aYIiBAN4STYEoleOSZeWPjp7jw3tY0wN1ZPXL0hvdujdlR_qw7-sfPuNo0Ds9zW1JlphDhUgxYZyBoLrYZBVvm6x6iOL_WmExMNqEomdovhicNyWRV3N3MApwgxOojbGyclc8fBviniZTHszVmf0UGTNPyaSdAONvJR73VsVLuw' AND t0.container_id = 18 AND t0.is_active = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.color AS color_3,
  t0.text_color AS text_color_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.client_id AS client_id_7,
  t0.newsfeed_category_id AS newsfeed_category_id_8
FROM
  special_title t0
  INNER JOIN user_special_title ON t0.id = user_special_title.special_title_id
WHERE
  user_special_title.user_id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.color AS color_3, t0.text_color AS text_color_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.client_id AS client_id_7, t0.newsfeed_category_id AS newsfeed_category_id_8 FROM special_title t0 INNER JOIN user_special_title ON t0.id = user_special_title.special_title_id WHERE user_special_title.user_id = 1271;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.password AS password_3,
  t0.first_name AS first_name_4,
  t0.last_name AS last_name_5,
  t0.locale AS locale_6,
  t0.status AS status_7,
  t0.company AS company_8,
  t0.job_title AS job_title_9,
  t0.image_name AS image_name_10,
  t0.source AS source_11,
  t0.is_onboarded AS is_onboarded_12,
  t0.is_blocked AS is_blocked_13,
  t0.onboarded_at AS onboarded_at_14,
  t0.last_login_at AS last_login_at_15,
  t0.is_display_as_guest AS is_display_as_guest_16,
  t0.is_expose_email AS is_expose_email_17,
  t0.is_allow_communication AS is_allow_communication_18,
  t0.timezone AS timezone_19,
  t0.is_pwd_generated AS is_pwd_generated_20,
  t0.is_online AS is_online_21,
  t0.is_show_disclaimer AS is_show_disclaimer_22,
  t0.sa_linkedin AS sa_linkedin_23,
  t0.sa_twitter AS sa_twitter_24,
  t0.sa_facebook AS sa_facebook_25,
  t0.sa_instagram AS sa_instagram_26,
  t0.sa_youtube AS sa_youtube_27,
  t0.country AS country_28,
  t0.fail_attempt_count AS fail_attempt_count_29,
  t0.last_fail_attempt_at AS last_fail_attempt_at_30,
  t0.login_block_until_at AS login_block_until_at_31,
  t0.is_consider_speaker AS is_consider_speaker_32,
  t0.is_consider_moderator AS is_consider_moderator_33,
  t0.is_show_public AS is_show_public_34,
  t0.is_notification_assign AS is_notification_assign_35,
  t0.is_notification_chat AS is_notification_chat_36,
  t0.is_notification_follow AS is_notification_follow_37,
  t0.gln_number AS gln_number_38,
  t0.ord AS ord_39,
  t0.ord_state AS ord_state_40,
  t0.is_notification_chat_group AS is_notification_chat_group_41,
  t0.invite_code AS invite_code_42,
  t0.headline AS headline_43,
  t0.user_container_domain AS user_container_domain_44,
  t0.is_unsubscribed_invite AS is_unsubscribed_invite_45,
  t0.is_email_off AS is_email_off_46,
  t0.created_at AS created_at_47,
  t0.updated_at AS updated_at_48,
  t0.client_id AS client_id_49,
  t0.relation_manager_id AS relation_manager_id_50,
  t0.user_container_id AS user_container_id_51,
  t0.organization_id AS organization_id_52
FROM
  user t0
  INNER JOIN company_owner ON t0.id = company_owner.user_id
WHERE
  company_owner.company_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.first_name AS first_name_4, t0.last_name AS last_name_5, t0.locale AS locale_6, t0.status AS status_7, t0.company AS company_8, t0.job_title AS job_title_9, t0.image_name AS image_name_10, t0.source AS source_11, t0.is_onboarded AS is_onboarded_12, t0.is_blocked AS is_blocked_13, t0.onboarded_at AS onboarded_at_14, t0.last_login_at AS last_login_at_15, t0.is_display_as_guest AS is_display_as_guest_16, t0.is_expose_email AS is_expose_email_17, t0.is_allow_communication AS is_allow_communication_18, t0.timezone AS timezone_19, t0.is_pwd_generated AS is_pwd_generated_20, t0.is_online AS is_online_21, t0.is_show_disclaimer AS is_show_disclaimer_22, t0.sa_linkedin AS sa_linkedin_23, t0.sa_twitter AS sa_twitter_24, t0.sa_facebook AS sa_facebook_25, t0.sa_instagram AS sa_instagram_26, t0.sa_youtube AS sa_youtube_27, t0.country AS country_28, t0.fail_attempt_count AS fail_attempt_count_29, t0.last_fail_attempt_at AS last_fail_attempt_at_30, t0.login_block_until_at AS login_block_until_at_31, t0.is_consider_speaker AS is_consider_speaker_32, t0.is_consider_moderator AS is_consider_moderator_33, t0.is_show_public AS is_show_public_34, t0.is_notification_assign AS is_notification_assign_35, t0.is_notification_chat AS is_notification_chat_36, t0.is_notification_follow AS is_notification_follow_37, t0.gln_number AS gln_number_38, t0.ord AS ord_39, t0.ord_state AS ord_state_40, t0.is_notification_chat_group AS is_notification_chat_group_41, t0.invite_code AS invite_code_42, t0.headline AS headline_43, t0.user_container_domain AS user_container_domain_44, t0.is_unsubscribed_invite AS is_unsubscribed_invite_45, t0.is_email_off AS is_email_off_46, t0.created_at AS created_at_47, t0.updated_at AS updated_at_48, t0.client_id AS client_id_49, t0.relation_manager_id AS relation_manager_id_50, t0.user_container_id AS user_container_id_51, t0.organization_id AS organization_id_52 FROM user t0 INNER JOIN company_owner ON t0.id = company_owner.user_id WHERE company_owner.company_id = 1;

SELECT
  t0.id AS id_1,
  t0.ord AS ord_2,
  t0.academic_title_id AS academic_title_id_3,
  t0.user_id AS user_id_4
FROM
  rel_user_academic_title t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.ord AS ord_2, t0.academic_title_id AS academic_title_id_3, t0.user_id AS user_id_4 FROM rel_user_academic_title t0 WHERE t0.user_id = 1271;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.client_id AS client_id_5
FROM
  company_tag t0
  INNER JOIN company_tag_company ON t0.id = company_tag_company.company_tag_id
WHERE
  company_tag_company.company_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.client_id AS client_id_5 FROM company_tag t0 INNER JOIN company_tag_company ON t0.id = company_tag_company.company_tag_id WHERE company_tag_company.company_id = 1;

SELECT
  t0.locale AS locale_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.translatable_id AS translatable_id_4
FROM
  academic_title_translation t0
WHERE
  (
    t0.locale = ?
    AND t0.translatable_id = ?
  )

SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM academic_title_translation t0 WHERE (t0.locale = 'de' AND t0.translatable_id = 24);

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.updated_at AS updated_at_3,
  t0.client_id AS client_id_4
FROM
  academic_title t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.client_id AS client_id_4 FROM academic_title t0 WHERE t0.id = 24;

SELECT
  t0.locale AS locale_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.translatable_id AS translatable_id_4
FROM
  special_title_translation t0
WHERE
  (
    t0.locale = ?
    AND t0.translatable_id = ?
  )

SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM special_title_translation t0 WHERE (t0.locale = 'de' AND t0.translatable_id = 53);

SELECT
  c0_.id AS id_0,
  c0_.domain AS domain_1,
  c0_.name AS name_2,
  c0_.container_group AS container_group_3,
  c0_.storage AS storage_4,
  c0_.bucket_key AS bucket_key_5,
  c0_.bucket_secret AS bucket_secret_6,
  c0_.bucket_name AS bucket_name_7,
  c0_.bucket_region AS bucket_region_8,
  c0_.bucket_endpoint AS bucket_endpoint_9,
  c0_.is_active AS is_active_10,
  c0_.configuration AS configuration_11,
  c0_.design_configuration AS design_configuration_12,
  c0_.description AS description_13,
  c0_.image_name AS image_name_14,
  c0_.navigation AS navigation_15,
  c0_.is_live_now AS is_live_now_16,
  c0_.video_gallery_ids AS video_gallery_ids_17,
  c0_.user_static_fields AS user_static_fields_18,
  c0_.logo_image_name AS logo_image_name_19,
  c0_.is_show_public AS is_show_public_20,
  c0_.is_main_container AS is_main_container_21,
  c0_.is_show_public_container AS is_show_public_container_22,
  c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23,
  c0_.old_id AS old_id_24,
  c0_.is_login_container AS is_login_container_25,
  c0_.course_commission AS course_commission_26,
  c0_.created_at AS created_at_27,
  c0_.updated_at AS updated_at_28,
  u1_.id AS id_29,
  u1_.name AS name_30,
  u1_.is_generated AS is_generated_31,
  u1_.created_at AS created_at_32,
  u1_.updated_at AS updated_at_33,
  c0_.client_id AS client_id_34,
  c0_.container_category_id AS container_category_id_35,
  u1_.client_id AS client_id_36
FROM
  container c0_
  LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id
  LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id
WHERE
  c0_.domain = ?
  OR c0_.domain = ?

SELECT c0_.id AS id_0, c0_.domain AS domain_1, c0_.name AS name_2, c0_.container_group AS container_group_3, c0_.storage AS storage_4, c0_.bucket_key AS bucket_key_5, c0_.bucket_secret AS bucket_secret_6, c0_.bucket_name AS bucket_name_7, c0_.bucket_region AS bucket_region_8, c0_.bucket_endpoint AS bucket_endpoint_9, c0_.is_active AS is_active_10, c0_.configuration AS configuration_11, c0_.design_configuration AS design_configuration_12, c0_.description AS description_13, c0_.image_name AS image_name_14, c0_.navigation AS navigation_15, c0_.is_live_now AS is_live_now_16, c0_.video_gallery_ids AS video_gallery_ids_17, c0_.user_static_fields AS user_static_fields_18, c0_.logo_image_name AS logo_image_name_19, c0_.is_show_public AS is_show_public_20, c0_.is_main_container AS is_main_container_21, c0_.is_show_public_container AS is_show_public_container_22, c0_.is_newsfeed_sharing_enable AS is_newsfeed_sharing_enable_23, c0_.old_id AS old_id_24, c0_.is_login_container AS is_login_container_25, c0_.course_commission AS course_commission_26, c0_.created_at AS created_at_27, c0_.updated_at AS updated_at_28, u1_.id AS id_29, u1_.name AS name_30, u1_.is_generated AS is_generated_31, u1_.created_at AS created_at_32, u1_.updated_at AS updated_at_33, c0_.client_id AS client_id_34, c0_.container_category_id AS container_category_id_35, u1_.client_id AS client_id_36 FROM container c0_ LEFT JOIN container_user_group c2_ ON c0_.id = c2_.container_id LEFT JOIN user_group u1_ ON u1_.id = c2_.user_group_id WHERE c0_.domain = 'neuronews.ch' OR c0_.domain = 'www.neuronews.ch';

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.text_color AS text_color_3,
  t0.ord AS ord_4,
  t0.type AS type_5,
  t0.image_name AS image_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.client_id AS client_id_9,
  t0.parent_id AS parent_id_10
FROM
  common_category t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.color AS color_2, t0.text_color AS text_color_3, t0.ord AS ord_4, t0.type AS type_5, t0.image_name AS image_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.client_id AS client_id_9, t0.parent_id AS parent_id_10 FROM common_category t0 WHERE t0.id = 1068;

SELECT
  t0.locale AS locale_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.translatable_id AS translatable_id_4
FROM
  common_category_translation t0
WHERE
  (
    t0.locale = ?
    AND t0.translatable_id = ?
  )

SELECT t0.locale AS locale_1, t0.id AS id_2, t0.name AS name_3, t0.translatable_id AS translatable_id_4 FROM common_category_translation t0 WHERE (t0.locale = 'de' AND t0.translatable_id = 1068);

SELECT
  t0.id AS id_1,
  t0.color AS color_2,
  t0.text_color AS text_color_3,
  t0.ord AS ord_4,
  t0.type AS type_5,
  t0.image_name AS image_name_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.client_id AS client_id_9,
  t0.parent_id AS parent_id_10
FROM
  common_category t0
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.color AS color_2, t0.text_color AS text_color_3, t0.ord AS ord_4, t0.type AS type_5, t0.image_name AS image_name_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.client_id AS client_id_9, t0.parent_id AS parent_id_10 FROM common_category t0 WHERE t0.parent_id = 1068;

SELECT
  u0_.id AS id_0,
  u0_.email AS email_1,
  u0_.password AS password_2,
  u0_.first_name AS first_name_3,
  u0_.last_name AS last_name_4,
  u0_.locale AS locale_5,
  u0_.status AS status_6,
  u0_.company AS company_7,
  u0_.job_title AS job_title_8,
  u0_.image_name AS image_name_9,
  u0_.source AS source_10,
  u0_.is_onboarded AS is_onboarded_11,
  u0_.is_blocked AS is_blocked_12,
  u0_.onboarded_at AS onboarded_at_13,
  u0_.last_login_at AS last_login_at_14,
  u0_.is_display_as_guest AS is_display_as_guest_15,
  u0_.is_expose_email AS is_expose_email_16,
  u0_.is_allow_communication AS is_allow_communication_17,
  u0_.timezone AS timezone_18,
  u0_.is_pwd_generated AS is_pwd_generated_19,
  u0_.is_online AS is_online_20,
  u0_.is_show_disclaimer AS is_show_disclaimer_21,
  u0_.sa_linkedin AS sa_linkedin_22,
  u0_.sa_twitter AS sa_twitter_23,
  u0_.sa_facebook AS sa_facebook_24,
  u0_.sa_instagram AS sa_instagram_25,
  u0_.sa_youtube AS sa_youtube_26,
  u0_.country AS country_27,
  u0_.fail_attempt_count AS fail_attempt_count_28,
  u0_.last_fail_attempt_at AS last_fail_attempt_at_29,
  u0_.login_block_until_at AS login_block_until_at_30,
  u0_.is_consider_speaker AS is_consider_speaker_31,
  u0_.is_consider_moderator AS is_consider_moderator_32,
  u0_.is_show_public AS is_show_public_33,
  u0_.is_notification_assign AS is_notification_assign_34,
  u0_.is_notification_chat AS is_notification_chat_35,
  u0_.is_notification_follow AS is_notification_follow_36,
  u0_.gln_number AS gln_number_37,
  u0_.ord AS ord_38,
  u0_.ord_state AS ord_state_39,
  u0_.is_notification_chat_group AS is_notification_chat_group_40,
  u0_.invite_code AS invite_code_41,
  u0_.headline AS headline_42,
  u0_.user_container_domain AS user_container_domain_43,
  u0_.is_unsubscribed_invite AS is_unsubscribed_invite_44,
  u0_.is_email_off AS is_email_off_45,
  u0_.created_at AS created_at_46,
  u0_.updated_at AS updated_at_47,
  r1_.id AS id_48,
  r1_.role AS role_49,
  u0_.client_id AS client_id_50,
  u0_.relation_manager_id AS relation_manager_id_51,
  u0_.user_container_id AS user_container_id_52,
  u0_.organization_id AS organization_id_53,
  r1_.container_id AS container_id_54,
  r1_.user_id AS user_id_55
FROM
  user u0_
  LEFT JOIN role_container r1_ ON u0_.id = r1_.user_id
WHERE
  u0_.client_id = ?
  AND u0_.email = ?
  AND r1_.container_id = ?

SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.first_name AS first_name_3, u0_.last_name AS last_name_4, u0_.locale AS locale_5, u0_.status AS status_6, u0_.company AS company_7, u0_.job_title AS job_title_8, u0_.image_name AS image_name_9, u0_.source AS source_10, u0_.is_onboarded AS is_onboarded_11, u0_.is_blocked AS is_blocked_12, u0_.onboarded_at AS onboarded_at_13, u0_.last_login_at AS last_login_at_14, u0_.is_display_as_guest AS is_display_as_guest_15, u0_.is_expose_email AS is_expose_email_16, u0_.is_allow_communication AS is_allow_communication_17, u0_.timezone AS timezone_18, u0_.is_pwd_generated AS is_pwd_generated_19, u0_.is_online AS is_online_20, u0_.is_show_disclaimer AS is_show_disclaimer_21, u0_.sa_linkedin AS sa_linkedin_22, u0_.sa_twitter AS sa_twitter_23, u0_.sa_facebook AS sa_facebook_24, u0_.sa_instagram AS sa_instagram_25, u0_.sa_youtube AS sa_youtube_26, u0_.country AS country_27, u0_.fail_attempt_count AS fail_attempt_count_28, u0_.last_fail_attempt_at AS last_fail_attempt_at_29, u0_.login_block_until_at AS login_block_until_at_30, u0_.is_consider_speaker AS is_consider_speaker_31, u0_.is_consider_moderator AS is_consider_moderator_32, u0_.is_show_public AS is_show_public_33, u0_.is_notification_assign AS is_notification_assign_34, u0_.is_notification_chat AS is_notification_chat_35, u0_.is_notification_follow AS is_notification_follow_36, u0_.gln_number AS gln_number_37, u0_.ord AS ord_38, u0_.ord_state AS ord_state_39, u0_.is_notification_chat_group AS is_notification_chat_group_40, u0_.invite_code AS invite_code_41, u0_.headline AS headline_42, u0_.user_container_domain AS user_container_domain_43, u0_.is_unsubscribed_invite AS is_unsubscribed_invite_44, u0_.is_email_off AS is_email_off_45, u0_.created_at AS created_at_46, u0_.updated_at AS updated_at_47, r1_.id AS id_48, r1_.role AS role_49, u0_.client_id AS client_id_50, u0_.relation_manager_id AS relation_manager_id_51, u0_.user_container_id AS user_container_id_52, u0_.organization_id AS organization_id_53, r1_.container_id AS container_id_54, r1_.user_id AS user_id_55 FROM user u0_ LEFT JOIN role_container r1_ ON u0_.id = r1_.user_id WHERE u0_.client_id = 59 AND u0_.email = 'cecile.keller@insel.ch' AND r1_.container_id = 18;