Symfony Profiler

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.active AS active_2,
  u0_.campus_id AS campus_id_3,
  u0_.department_id AS department_id_4,
  u0_.created_at AS created_at_5,
  u0_.updated_at AS updated_at_6,
  u0_.user_school_id AS user_school_id_7
FROM
  user_major u0_
WHERE
  u0_.user_school_id IS NOT NULL
  AND u0_.active = 1

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.campus_id AS campus_id_3, u0_.department_id AS department_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.user_school_id AS user_school_id_7 FROM user_major u0_ WHERE u0_.user_school_id IS NOT NULL AND u0_.active = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 58;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 1;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 114;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 3;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 4;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 5;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 6;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 7;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 8;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.grad_year AS grad_year_5,
  t0.first_gen AS first_gen_6,
  t0.student_type AS student_type_7,
  t0.phone AS phone_8,
  t0.about AS about_9,
  t0.snapchat_id AS snapchat_id_10,
  t0.facebook_messenger_id AS facebook_messenger_id_11,
  t0.other_email AS other_email_12,
  t0.visible AS visible_13,
  t0.facebook AS facebook_14,
  t0.twitter AS twitter_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.school_id AS school_id_18,
  t0.major_id AS major_id_19,
  t0.address_id AS address_id_20,
  t0.avatar_id AS avatar_id_21,
  t22.username AS username_23,
  t22.username_canonical AS username_canonical_24,
  t22.email AS email_25,
  t22.email_canonical AS email_canonical_26,
  t22.enabled AS enabled_27,
  t22.salt AS salt_28,
  t22.password AS password_29,
  t22.last_login AS last_login_30,
  t22.confirmation_token AS confirmation_token_31,
  t22.password_requested_at AS password_requested_at_32,
  t22.roles AS roles_33,
  t22.id AS id_34,
  t22.login AS login_35,
  t22.created_at AS created_at_36,
  t22.updated_at AS updated_at_37,
  t22.profile_id AS profile_id_38,
  t22.statistic_id AS statistic_id_39
FROM
  user_profile t0
  LEFT JOIN user t22 ON t22.profile_id = t0.id
WHERE
  t0.major_id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.grad_year AS grad_year_5, t0.first_gen AS first_gen_6, t0.student_type AS student_type_7, t0.phone AS phone_8, t0.about AS about_9, t0.snapchat_id AS snapchat_id_10, t0.facebook_messenger_id AS facebook_messenger_id_11, t0.other_email AS other_email_12, t0.visible AS visible_13, t0.facebook AS facebook_14, t0.twitter AS twitter_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.school_id AS school_id_18, t0.major_id AS major_id_19, t0.address_id AS address_id_20, t0.avatar_id AS avatar_id_21, t22.username AS username_23, t22.username_canonical AS username_canonical_24, t22.email AS email_25, t22.email_canonical AS email_canonical_26, t22.enabled AS enabled_27, t22.salt AS salt_28, t22.password AS password_29, t22.last_login AS last_login_30, t22.confirmation_token AS confirmation_token_31, t22.password_requested_at AS password_requested_at_32, t22.roles AS roles_33, t22.id AS id_34, t22.login AS login_35, t22.created_at AS created_at_36, t22.updated_at AS updated_at_37, t22.profile_id AS profile_id_38, t22.statistic_id AS statistic_id_39 FROM user_profile t0 LEFT JOIN user t22 ON t22.profile_id = t0.id WHERE t0.major_id = 9;