Symfony Profiler

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.eyJpYXQiOjE3NjEyMTY4ODksImV4cCI6MTc2MTMwMzI4OSwicm9sZXMiOlsiUk9MRV9TVVBFUl9BRE1JTiJdLCJ1c2VybmFtZSI6ImluZm9AZXhwZXJ0c2hhcmUubGl2ZSIsImlwIjoiMTg1LjEzNy4xNzIuMTIiLCJjaWQiOjU5LCJjbnRpZCI6ODN9.J2S2Mtf0dtKN2bBUCzeKI1tytX8grJCXJKc4TgbpfpbyYUZy2Fc8Nu956wjwchAaPZ8PpPzIE8DtJ_jm1QzAVQZAtM2kK9btiE1_-rYt6np-ClqzhS-i8I7Vr839tqNU6JlbSbxJUHZWPJaMojO0VyE1FxO1MHUFgNkxZMjHH0MwDaogWqVDpjsLvNQpZikyhaUAE3y_guP69rXxKdYnm8w-_iMPVKuwqvKHKAefeg7_vnvatycArRh97dCrtp6L6TMaAUcwodqFASegXCOGzBbS4o3KYD-m7jp4R0dXQ9VUz0HrzDazQpAojGJUfa0omqAjuABvq29JPh_rWqxrBA' AND t0.container_id = 83 AND t0.is_active = 1 LIMIT 1;

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 = 'bethesda.doclift.com' OR c0_.domain = 'www.bethesda.doclift.com';

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 = 'info@expertshare.live' AND r1_.container_id = 83;

SELECT
  n0_.id AS id_0,
  n0_.created_at AS created_at_1,
  n0_.updated_at AS updated_at_2,
  u1_.id AS id_3,
  u1_.email AS email_4,
  u1_.password AS password_5,
  u1_.first_name AS first_name_6,
  u1_.last_name AS last_name_7,
  u1_.locale AS locale_8,
  u1_.status AS status_9,
  u1_.company AS company_10,
  u1_.job_title AS job_title_11,
  u1_.image_name AS image_name_12,
  u1_.source AS source_13,
  u1_.is_onboarded AS is_onboarded_14,
  u1_.is_blocked AS is_blocked_15,
  u1_.onboarded_at AS onboarded_at_16,
  u1_.last_login_at AS last_login_at_17,
  u1_.is_display_as_guest AS is_display_as_guest_18,
  u1_.is_expose_email AS is_expose_email_19,
  u1_.is_allow_communication AS is_allow_communication_20,
  u1_.timezone AS timezone_21,
  u1_.is_pwd_generated AS is_pwd_generated_22,
  u1_.is_online AS is_online_23,
  u1_.is_show_disclaimer AS is_show_disclaimer_24,
  u1_.sa_linkedin AS sa_linkedin_25,
  u1_.sa_twitter AS sa_twitter_26,
  u1_.sa_facebook AS sa_facebook_27,
  u1_.sa_instagram AS sa_instagram_28,
  u1_.sa_youtube AS sa_youtube_29,
  u1_.country AS country_30,
  u1_.fail_attempt_count AS fail_attempt_count_31,
  u1_.last_fail_attempt_at AS last_fail_attempt_at_32,
  u1_.login_block_until_at AS login_block_until_at_33,
  u1_.is_consider_speaker AS is_consider_speaker_34,
  u1_.is_consider_moderator AS is_consider_moderator_35,
  u1_.is_show_public AS is_show_public_36,
  u1_.is_notification_assign AS is_notification_assign_37,
  u1_.is_notification_chat AS is_notification_chat_38,
  u1_.is_notification_follow AS is_notification_follow_39,
  u1_.gln_number AS gln_number_40,
  u1_.ord AS ord_41,
  u1_.ord_state AS ord_state_42,
  u1_.is_notification_chat_group AS is_notification_chat_group_43,
  u1_.invite_code AS invite_code_44,
  u1_.headline AS headline_45,
  u1_.user_container_domain AS user_container_domain_46,
  u1_.is_unsubscribed_invite AS is_unsubscribed_invite_47,
  u1_.is_email_off AS is_email_off_48,
  u1_.created_at AS created_at_49,
  u1_.updated_at AS updated_at_50,
  n2_.id AS id_51,
  n2_.post_text AS post_text_52,
  n2_.is_published AS is_published_53,
  n2_.media_file_names AS media_file_names_54,
  n2_.post_type AS post_type_55,
  n2_.type_id AS type_id_56,
  n2_.initial_comments AS initial_comments_57,
  n2_.post_metadata AS post_metadata_58,
  n2_.total_likes AS total_likes_59,
  n2_.assign_users AS assign_users_60,
  n2_.media_file_type AS media_file_type_61,
  n2_.post_sub_type AS post_sub_type_62,
  n2_.dicom_file_info AS dicom_file_info_63,
  n2_.title AS title_64,
  n2_.vote_expiry AS vote_expiry_65,
  n2_.vote_result AS vote_result_66,
  n2_.commented_at AS commented_at_67,
  n2_.is_container_feed_sent AS is_container_feed_sent_68,
  n2_.created_at AS created_at_69,
  n2_.updated_at AS updated_at_70,
  n0_.user_id AS user_id_71,
  n0_.newsfeed_id AS newsfeed_id_72,
  u1_.client_id AS client_id_73,
  u1_.relation_manager_id AS relation_manager_id_74,
  u1_.user_container_id AS user_container_id_75,
  u1_.organization_id AS organization_id_76,
  n2_.user_id AS user_id_77,
  n2_.container_id AS container_id_78,
  n2_.newsfeed_category_id AS newsfeed_category_id_79,
  n2_.company_id AS company_id_80
FROM
  newsfeed_saved n0_
  LEFT JOIN user u1_ ON n0_.user_id = u1_.id
  LEFT JOIN newsfeed n2_ ON n0_.newsfeed_id = n2_.id
WHERE
  n0_.id IN (
    SELECT
      n3_.id
    FROM
      newsfeed_saved n3_
      LEFT JOIN user u4_ ON n3_.user_id = u4_.id
      LEFT JOIN newsfeed n5_ ON n3_.newsfeed_id = n5_.id
    WHERE
      u1_.id = ?
      AND n5_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )
ORDER BY
  n0_.id ASC
LIMIT
  30

SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, u1_.id AS id_3, u1_.email AS email_4, u1_.password AS password_5, u1_.first_name AS first_name_6, u1_.last_name AS last_name_7, u1_.locale AS locale_8, u1_.status AS status_9, u1_.company AS company_10, u1_.job_title AS job_title_11, u1_.image_name AS image_name_12, u1_.source AS source_13, u1_.is_onboarded AS is_onboarded_14, u1_.is_blocked AS is_blocked_15, u1_.onboarded_at AS onboarded_at_16, u1_.last_login_at AS last_login_at_17, u1_.is_display_as_guest AS is_display_as_guest_18, u1_.is_expose_email AS is_expose_email_19, u1_.is_allow_communication AS is_allow_communication_20, u1_.timezone AS timezone_21, u1_.is_pwd_generated AS is_pwd_generated_22, u1_.is_online AS is_online_23, u1_.is_show_disclaimer AS is_show_disclaimer_24, u1_.sa_linkedin AS sa_linkedin_25, u1_.sa_twitter AS sa_twitter_26, u1_.sa_facebook AS sa_facebook_27, u1_.sa_instagram AS sa_instagram_28, u1_.sa_youtube AS sa_youtube_29, u1_.country AS country_30, u1_.fail_attempt_count AS fail_attempt_count_31, u1_.last_fail_attempt_at AS last_fail_attempt_at_32, u1_.login_block_until_at AS login_block_until_at_33, u1_.is_consider_speaker AS is_consider_speaker_34, u1_.is_consider_moderator AS is_consider_moderator_35, u1_.is_show_public AS is_show_public_36, u1_.is_notification_assign AS is_notification_assign_37, u1_.is_notification_chat AS is_notification_chat_38, u1_.is_notification_follow AS is_notification_follow_39, u1_.gln_number AS gln_number_40, u1_.ord AS ord_41, u1_.ord_state AS ord_state_42, u1_.is_notification_chat_group AS is_notification_chat_group_43, u1_.invite_code AS invite_code_44, u1_.headline AS headline_45, u1_.user_container_domain AS user_container_domain_46, u1_.is_unsubscribed_invite AS is_unsubscribed_invite_47, u1_.is_email_off AS is_email_off_48, u1_.created_at AS created_at_49, u1_.updated_at AS updated_at_50, n2_.id AS id_51, n2_.post_text AS post_text_52, n2_.is_published AS is_published_53, n2_.media_file_names AS media_file_names_54, n2_.post_type AS post_type_55, n2_.type_id AS type_id_56, n2_.initial_comments AS initial_comments_57, n2_.post_metadata AS post_metadata_58, n2_.total_likes AS total_likes_59, n2_.assign_users AS assign_users_60, n2_.media_file_type AS media_file_type_61, n2_.post_sub_type AS post_sub_type_62, n2_.dicom_file_info AS dicom_file_info_63, n2_.title AS title_64, n2_.vote_expiry AS vote_expiry_65, n2_.vote_result AS vote_result_66, n2_.commented_at AS commented_at_67, n2_.is_container_feed_sent AS is_container_feed_sent_68, n2_.created_at AS created_at_69, n2_.updated_at AS updated_at_70, n0_.user_id AS user_id_71, n0_.newsfeed_id AS newsfeed_id_72, u1_.client_id AS client_id_73, u1_.relation_manager_id AS relation_manager_id_74, u1_.user_container_id AS user_container_id_75, u1_.organization_id AS organization_id_76, n2_.user_id AS user_id_77, n2_.container_id AS container_id_78, n2_.newsfeed_category_id AS newsfeed_category_id_79, n2_.company_id AS company_id_80 FROM newsfeed_saved n0_ LEFT JOIN user u1_ ON n0_.user_id = u1_.id LEFT JOIN newsfeed n2_ ON n0_.newsfeed_id = n2_.id WHERE n0_.id IN (SELECT n3_.id FROM newsfeed_saved n3_ LEFT JOIN user u4_ ON n3_.user_id = u4_.id LEFT JOIN newsfeed n5_ ON n3_.newsfeed_id = n5_.id WHERE u1_.id = 15874 AND n5_.id IN ('2931', '2912', '2867', '2866', '2865', '2428', '2366', '2263', '1735', '1356')) ORDER BY n0_.id ASC LIMIT 30;

SELECT
  count(DISTINCT n0_.id) AS sclr_0
FROM
  newsfeed_saved n0_
  LEFT JOIN user u1_ ON n0_.user_id = u1_.id
  LEFT JOIN newsfeed n2_ ON n0_.newsfeed_id = n2_.id
WHERE
  n0_.id IN (
    SELECT
      n3_.id
    FROM
      newsfeed_saved n3_
      LEFT JOIN user u4_ ON n3_.user_id = u4_.id
      LEFT JOIN newsfeed n5_ ON n3_.newsfeed_id = n5_.id
    WHERE
      u1_.id = ?
      AND n5_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
  )

SELECT count(DISTINCT n0_.id) AS sclr_0 FROM newsfeed_saved n0_ LEFT JOIN user u1_ ON n0_.user_id = u1_.id LEFT JOIN newsfeed n2_ ON n0_.newsfeed_id = n2_.id WHERE n0_.id IN (SELECT n3_.id FROM newsfeed_saved n3_ LEFT JOIN user u4_ ON n3_.user_id = u4_.id LEFT JOIN newsfeed n5_ ON n3_.newsfeed_id = n5_.id WHERE u1_.id = 15874 AND n5_.id IN ('2931', '2912', '2867', '2866', '2865', '2428', '2366', '2263', '1735', '1356'));