Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.start_date AS start_date_2,
  t0.end_date AS end_date_3,
  t0.shipping_option AS shipping_option_4,
  t0.estimated_shipping AS estimated_shipping_5,
  t0.shipping_name AS shipping_name_6,
  t0.estimated_tax AS estimated_tax_7,
  t0.estimated_cost AS estimated_cost_8,
  t0.funded_total AS funded_total_9,
  t0.purchased_total AS purchased_total_10,
  t0.donations_from_previous AS donations_from_previous_11,
  t0.status AS status_12,
  t0.is_paused AS is_paused_13,
  t0.paused_at AS paused_at_14,
  t0.mass_mailing_called AS mass_mailing_called_15,
  t0.created_at AS created_at_16,
  t0.updated_at AS updated_at_17,
  t0.user_id AS user_id_18,
  t0.school_id AS school_id_19,
  t20.id AS id_21,
  t20.net AS net_22,
  t20.comment AS comment_23,
  t20.created_at AS created_at_24,
  t20.updated_at AS updated_at_25,
  t20.admin_id AS admin_id_26,
  t20.campaign_id AS campaign_id_27,
  t20.recipient_id AS recipient_id_28
FROM
  campaign t0
  LEFT JOIN transaction_history t20 ON t20.campaign_id = t0.id
WHERE
  t0.user_id = ?
ORDER BY
  t0.end_date DESC

SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.shipping_option AS shipping_option_4, t0.estimated_shipping AS estimated_shipping_5, t0.shipping_name AS shipping_name_6, t0.estimated_tax AS estimated_tax_7, t0.estimated_cost AS estimated_cost_8, t0.funded_total AS funded_total_9, t0.purchased_total AS purchased_total_10, t0.donations_from_previous AS donations_from_previous_11, t0.status AS status_12, t0.is_paused AS is_paused_13, t0.paused_at AS paused_at_14, t0.mass_mailing_called AS mass_mailing_called_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.user_id AS user_id_18, t0.school_id AS school_id_19, t20.id AS id_21, t20.net AS net_22, t20.comment AS comment_23, t20.created_at AS created_at_24, t20.updated_at AS updated_at_25, t20.admin_id AS admin_id_26, t20.campaign_id AS campaign_id_27, t20.recipient_id AS recipient_id_28 FROM campaign t0 LEFT JOIN transaction_history t20 ON t20.campaign_id = t0.id WHERE t0.user_id = 137 ORDER BY t0.end_date DESC;

SELECT
  t0.id AS id_1,
  t0.filename AS filename_2,
  t0.comment AS comment_3,
  t0.status AS status_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6
FROM
  user_avatar t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.filename AS filename_2, t0.comment AS comment_3, t0.status AS status_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM user_avatar t0 WHERE t0.id = 33;

SELECT
  u0_.username AS username_0,
  u0_.username_canonical AS username_canonical_1,
  u0_.email AS email_2,
  u0_.email_canonical AS email_canonical_3,
  u0_.enabled AS enabled_4,
  u0_.salt AS salt_5,
  u0_.password AS password_6,
  u0_.last_login AS last_login_7,
  u0_.confirmation_token AS confirmation_token_8,
  u0_.password_requested_at AS password_requested_at_9,
  u0_.roles AS roles_10,
  u0_.id AS id_11,
  u0_.login AS login_12,
  u0_.created_at AS created_at_13,
  u0_.updated_at AS updated_at_14,
  u1_.id AS id_15,
  u1_.email AS email_16,
  u1_.first_name AS first_name_17,
  u1_.last_name AS last_name_18,
  u1_.grad_year AS grad_year_19,
  u1_.first_gen AS first_gen_20,
  u1_.student_type AS student_type_21,
  u1_.phone AS phone_22,
  u1_.about AS about_23,
  u1_.snapchat_id AS snapchat_id_24,
  u1_.facebook_messenger_id AS facebook_messenger_id_25,
  u1_.other_email AS other_email_26,
  u1_.visible AS visible_27,
  u1_.facebook AS facebook_28,
  u1_.twitter AS twitter_29,
  u1_.created_at AS created_at_30,
  u1_.updated_at AS updated_at_31,
  u0_.profile_id AS profile_id_32,
  u0_.statistic_id AS statistic_id_33,
  u1_.school_id AS school_id_34,
  u1_.major_id AS major_id_35,
  u1_.address_id AS address_id_36,
  u1_.avatar_id AS avatar_id_37
FROM
  user u0_
  LEFT JOIN user_profile u2_ ON u0_.profile_id = u2_.id
  LEFT JOIN user_profile u1_ ON u0_.profile_id = u1_.id
WHERE
  u0_.roles LIKE ?
  AND (
    u0_.roles LIKE '%ROLE_DONOR%'
    OR u0_.roles LIKE '%ROLE_STUDENT%'
  )
  AND u0_.id IN (?)
ORDER BY
  u2_.last_name ASC

SELECT u0_.username AS username_0, u0_.username_canonical AS username_canonical_1, u0_.email AS email_2, u0_.email_canonical AS email_canonical_3, u0_.enabled AS enabled_4, u0_.salt AS salt_5, u0_.password AS password_6, u0_.last_login AS last_login_7, u0_.confirmation_token AS confirmation_token_8, u0_.password_requested_at AS password_requested_at_9, u0_.roles AS roles_10, u0_.id AS id_11, u0_.login AS login_12, u0_.created_at AS created_at_13, u0_.updated_at AS updated_at_14, u1_.id AS id_15, u1_.email AS email_16, u1_.first_name AS first_name_17, u1_.last_name AS last_name_18, u1_.grad_year AS grad_year_19, u1_.first_gen AS first_gen_20, u1_.student_type AS student_type_21, u1_.phone AS phone_22, u1_.about AS about_23, u1_.snapchat_id AS snapchat_id_24, u1_.facebook_messenger_id AS facebook_messenger_id_25, u1_.other_email AS other_email_26, u1_.visible AS visible_27, u1_.facebook AS facebook_28, u1_.twitter AS twitter_29, u1_.created_at AS created_at_30, u1_.updated_at AS updated_at_31, u0_.profile_id AS profile_id_32, u0_.statistic_id AS statistic_id_33, u1_.school_id AS school_id_34, u1_.major_id AS major_id_35, u1_.address_id AS address_id_36, u1_.avatar_id AS avatar_id_37 FROM user u0_ LEFT JOIN user_profile u2_ ON u0_.profile_id = u2_.id LEFT JOIN user_profile u1_ ON u0_.profile_id = u1_.id WHERE u0_.roles LIKE '%ROLE_STUDENT%' AND (u0_.roles LIKE '%ROLE_DONOR%' OR u0_.roles LIKE '%ROLE_STUDENT%') AND u0_.id IN (137, 202, 200, 139, 136, 182, 134, 203, 138, 198, 181, 164, 167, 135, 174, 180, 184, 185, 186, 188, 189, 204, 163) ORDER BY u2_.last_name ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.tax AS tax_4,
  t0.bookstore_id AS bookstore_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.school_settings_id AS school_settings_id_8,
  t9.id AS id_10,
  t9.name AS name_11,
  t9.active AS active_12,
  t9.campus_id AS campus_id_13,
  t9.department_id AS department_id_14,
  t9.created_at AS created_at_15,
  t9.updated_at AS updated_at_16,
  t9.user_school_id AS user_school_id_17,
  t0.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_18
FROM
  user_school t0
  LEFT JOIN user_major t9 ON t9.user_school_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.tax AS tax_4, t0.bookstore_id AS bookstore_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.school_settings_id AS school_settings_id_8, t9.id AS id_10, t9.name AS name_11, t9.active AS active_12, t9.campus_id AS campus_id_13, t9.department_id AS department_id_14, t9.created_at AS created_at_15, t9.updated_at AS updated_at_16, t9.user_school_id AS user_school_id_17, t0.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_18 FROM user_school t0 LEFT JOIN user_major t9 ON t9.user_school_id = t0.id WHERE t0.id = 1;

SELECT
  DISTINCT u0_.id AS id_0,
  u1_.last_name AS last_name_1
FROM
  user u0_
  LEFT JOIN user_profile u1_ ON u0_.profile_id = u1_.id
  LEFT JOIN user_profile u2_ ON u0_.profile_id = u2_.id
WHERE
  u0_.roles LIKE ?
  AND (
    u0_.roles LIKE '%ROLE_DONOR%'
    OR u0_.roles LIKE '%ROLE_STUDENT%'
  )
ORDER BY
  u1_.last_name ASC
LIMIT
  9223372036854775807

SELECT DISTINCT u0_.id AS id_0, u1_.last_name AS last_name_1 FROM user u0_ LEFT JOIN user_profile u1_ ON u0_.profile_id = u1_.id LEFT JOIN user_profile u2_ ON u0_.profile_id = u2_.id WHERE u0_.roles LIKE '%ROLE_STUDENT%' AND (u0_.roles LIKE '%ROLE_DONOR%' OR u0_.roles LIKE '%ROLE_STUDENT%') ORDER BY u1_.last_name ASC LIMIT 9223372036854775807;

SELECT
  count(DISTINCT u0_.id) AS sclr_0
FROM
  user u0_
  LEFT JOIN user_profile u1_ ON u0_.profile_id = u1_.id
  LEFT JOIN user_profile u2_ ON u0_.profile_id = u2_.id
WHERE
  u0_.roles LIKE ?
  AND (
    u0_.roles LIKE '%ROLE_DONOR%'
    OR u0_.roles LIKE '%ROLE_STUDENT%'
  )

SELECT count(DISTINCT u0_.id) AS sclr_0 FROM user u0_ LEFT JOIN user_profile u1_ ON u0_.profile_id = u1_.id LEFT JOIN user_profile u2_ ON u0_.profile_id = u2_.id WHERE u0_.roles LIKE '%ROLE_STUDENT%' AND (u0_.roles LIKE '%ROLE_DONOR%' OR u0_.roles LIKE '%ROLE_STUDENT%');

SELECT
  u0_.id AS id_0,
  u0_.is_sent AS is_sent_1,
  u0_.title AS title_2,
  u0_.message AS message_3,
  u0_.created_at AS created_at_4,
  u0_.updated_at AS updated_at_5,
  u0_.user_id AS user_id_6
FROM
  user_notifications u0_
WHERE
  u0_.user_id = ?
  AND u0_.is_sent = ?

SELECT u0_.id AS id_0, u0_.is_sent AS is_sent_1, u0_.title AS title_2, u0_.message AS message_3, u0_.created_at AS created_at_4, u0_.updated_at AS updated_at_5, u0_.user_id AS user_id_6 FROM user_notifications u0_ WHERE u0_.user_id = 178 AND u0_.is_sent = 0;

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.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.id = 178;

SELECT
  t0.username AS username_1,
  t0.username_canonical AS username_canonical_2,
  t0.email AS email_3,
  t0.email_canonical AS email_canonical_4,
  t0.enabled AS enabled_5,
  t0.salt AS salt_6,
  t0.password AS password_7,
  t0.last_login AS last_login_8,
  t0.confirmation_token AS confirmation_token_9,
  t0.password_requested_at AS password_requested_at_10,
  t0.roles AS roles_11,
  t0.id AS id_12,
  t0.login AS login_13,
  t0.created_at AS created_at_14,
  t0.updated_at AS updated_at_15,
  t0.profile_id AS profile_id_16,
  t0.statistic_id AS statistic_id_17
FROM
  user t0
WHERE
  t0.id = ?
LIMIT
  1

SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.login AS login_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.profile_id AS profile_id_16, t0.statistic_id AS statistic_id_17 FROM user t0 WHERE t0.id = 178 LIMIT 1;