Symfony Profiler

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_3,
  t0.status AS status_4,
  t0.amount AS amount_5,
  t0.sub_type AS sub_type_6,
  t0.created_at AS created_at_7,
  t0.updated_at AS updated_at_8,
  t0.user_transaction_id AS user_transaction_id_9,
  t0.book_store_transfer_id AS book_store_transfer_id_10,
  t0.school_id AS school_id_11,
  t0.transaction_type,
  t1.resource_id AS resource_id_12,
  t1.parent_id AS parent_id_13,
  t2.external_id AS external_id_14,
  t2.fee AS fee_15,
  t2.payment_system_fee AS payment_system_fee_16,
  t2.net AS net_17,
  t2.comment AS comment_18,
  t2.unregistered_sender AS unregistered_sender_19,
  t2.thanks AS thanks_20,
  t2.thanks_notification_sent AS thanks_notification_sent_21,
  t2.anonymous AS anonymous_22,
  t2.stripe_charge_id AS stripe_charge_id_23,
  t2.sender_id AS sender_id_24,
  t2.campaign_id AS campaign_id_25,
  t2.order_id AS order_id_26,
  t2.recipient_id AS recipient_id_27
FROM
  transaction t0
  LEFT JOIN bookstore_transfer t1 ON t0.id = t1.id
  LEFT JOIN user_transaction t2 ON t0.id = t2.id
WHERE
  t0.user_transaction_id = ?

SELECT t0.id AS id_3, t0.status AS status_4, t0.amount AS amount_5, t0.sub_type AS sub_type_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.user_transaction_id AS user_transaction_id_9, t0.book_store_transfer_id AS book_store_transfer_id_10, t0.school_id AS school_id_11, t0.transaction_type, t1.resource_id AS resource_id_12, t1.parent_id AS parent_id_13, t2.external_id AS external_id_14, t2.fee AS fee_15, t2.payment_system_fee AS payment_system_fee_16, t2.net AS net_17, t2.comment AS comment_18, t2.unregistered_sender AS unregistered_sender_19, t2.thanks AS thanks_20, t2.thanks_notification_sent AS thanks_notification_sent_21, t2.anonymous AS anonymous_22, t2.stripe_charge_id AS stripe_charge_id_23, t2.sender_id AS sender_id_24, t2.campaign_id AS campaign_id_25, t2.order_id AS order_id_26, t2.recipient_id AS recipient_id_27 FROM transaction t0 LEFT JOIN bookstore_transfer t1 ON t0.id = t1.id LEFT JOIN user_transaction t2 ON t0.id = t2.id WHERE t0.user_transaction_id = 164;

SELECT
  t0.id AS id_1,
  t0.product_family_id AS product_family_id_2,
  t0.sku AS sku_3,
  t0.title AS title_4,
  t0.author AS author_5,
  t0.class AS class_6,
  t0.isbn AS isbn_7,
  t0.price AS price_8,
  t0.fee AS fee_9,
  t0.quantity AS quantity_10,
  t0.status AS status_11,
  t0.state AS state_12,
  t0.tax AS tax_13,
  t0.net AS net_14,
  t0.created_at AS created_at_15,
  t0.updated_at AS updated_at_16,
  t0.campaign_id AS campaign_id_17
FROM
  campaign_book t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.product_family_id AS product_family_id_2, t0.sku AS sku_3, t0.title AS title_4, t0.author AS author_5, t0.class AS class_6, t0.isbn AS isbn_7, t0.price AS price_8, t0.fee AS fee_9, t0.quantity AS quantity_10, t0.status AS status_11, t0.state AS state_12, t0.tax AS tax_13, t0.net AS net_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.campaign_id AS campaign_id_17 FROM campaign_book t0 WHERE t0.campaign_id = 82;

SELECT
  t1.id AS id_2,
  t1.status AS status_3,
  t1.amount AS amount_4,
  t1.sub_type AS sub_type_5,
  t1.created_at AS created_at_6,
  t1.updated_at AS updated_at_7,
  t0.external_id AS external_id_8,
  t0.fee AS fee_9,
  t0.payment_system_fee AS payment_system_fee_10,
  t0.net AS net_11,
  t0.comment AS comment_12,
  t0.unregistered_sender AS unregistered_sender_13,
  t0.thanks AS thanks_14,
  t0.thanks_notification_sent AS thanks_notification_sent_15,
  t0.anonymous AS anonymous_16,
  t0.stripe_charge_id AS stripe_charge_id_17,
  t1.user_transaction_id AS user_transaction_id_18,
  t1.book_store_transfer_id AS book_store_transfer_id_19,
  t1.school_id AS school_id_20,
  t0.sender_id AS sender_id_21,
  t0.campaign_id AS campaign_id_22,
  t0.order_id AS order_id_23,
  t0.recipient_id AS recipient_id_24,
  t1.transaction_type
FROM
  user_transaction t0
  INNER JOIN transaction t1 ON t0.id = t1.id
WHERE
  t0.campaign_id = ?

SELECT t1.id AS id_2, t1.status AS status_3, t1.amount AS amount_4, t1.sub_type AS sub_type_5, t1.created_at AS created_at_6, t1.updated_at AS updated_at_7, t0.external_id AS external_id_8, t0.fee AS fee_9, t0.payment_system_fee AS payment_system_fee_10, t0.net AS net_11, t0.comment AS comment_12, t0.unregistered_sender AS unregistered_sender_13, t0.thanks AS thanks_14, t0.thanks_notification_sent AS thanks_notification_sent_15, t0.anonymous AS anonymous_16, t0.stripe_charge_id AS stripe_charge_id_17, t1.user_transaction_id AS user_transaction_id_18, t1.book_store_transfer_id AS book_store_transfer_id_19, t1.school_id AS school_id_20, t0.sender_id AS sender_id_21, t0.campaign_id AS campaign_id_22, t0.order_id AS order_id_23, t0.recipient_id AS recipient_id_24, t1.transaction_type FROM user_transaction t0 INNER JOIN transaction t1 ON t0.id = t1.id WHERE t0.campaign_id = 82;

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 = 79;

SELECT
  t0.id AS id_1,
  t0.net AS net_2,
  t0.comment AS comment_3,
  t0.transaction_date AS transaction_date_4,
  t0.admin_id AS admin_id_5,
  t0.campaign_id AS campaign_id_6,
  t0.recipient_id AS recipient_id_7
FROM
  transaction_history t0
WHERE
  t0.campaign_id = ?

SELECT t0.id AS id_1, t0.net AS net_2, t0.comment AS comment_3, t0.transaction_date AS transaction_date_4, t0.admin_id AS admin_id_5, t0.campaign_id AS campaign_id_6, t0.recipient_id AS recipient_id_7 FROM transaction_history t0 WHERE t0.campaign_id = 82;

SELECT
  DISTINCT c0_.id AS id_0,
  c0_.start_date AS start_date_1
FROM
  campaign c0_
  INNER JOIN user u1_ ON c0_.user_id = u1_.id
  INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id
  LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id
WHERE
  c0_.start_date <= ?
  AND c0_.end_date >= ?
  AND c0_.is_paused = ?
  AND u2_.visible IN (?)
ORDER BY
  c0_.start_date DESC
LIMIT
  20

SELECT DISTINCT c0_.id AS id_0, c0_.start_date AS start_date_1 FROM campaign c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id WHERE c0_.start_date <= '2026-01-17' AND c0_.end_date >= '2026-01-17' AND c0_.is_paused = 0 AND u2_.visible IN (NULL) ORDER BY c0_.start_date DESC LIMIT 20;

SELECT
  count(DISTINCT c0_.id) AS sclr_0
FROM
  campaign c0_
  INNER JOIN user u1_ ON c0_.user_id = u1_.id
  INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id
  LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id
WHERE
  c0_.start_date <= ?
  AND c0_.end_date >= ?
  AND c0_.is_paused = ?
  AND u2_.visible IN (?)

SELECT count(DISTINCT c0_.id) AS sclr_0 FROM campaign c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id WHERE c0_.start_date <= '2026-01-17' AND c0_.end_date >= '2026-01-17' AND c0_.is_paused = 0 AND u2_.visible IN (NULL);

SELECT
  c0_.id AS id_0,
  c0_.start_date AS start_date_1,
  c0_.end_date AS end_date_2,
  c0_.shipping_option AS shipping_option_3,
  c0_.estimated_shipping AS estimated_shipping_4,
  c0_.shipping_name AS shipping_name_5,
  c0_.estimated_tax AS estimated_tax_6,
  c0_.estimated_cost AS estimated_cost_7,
  c0_.funded_total AS funded_total_8,
  c0_.purchased_total AS purchased_total_9,
  c0_.donations_from_previous AS donations_from_previous_10,
  c0_.status AS status_11,
  c0_.is_paused AS is_paused_12,
  c0_.paused_at AS paused_at_13,
  c0_.mass_mailing_called AS mass_mailing_called_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.user_id AS user_id_17,
  c0_.school_id AS school_id_18
FROM
  campaign c0_
  INNER JOIN user u1_ ON c0_.user_id = u1_.id
  INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id
  LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id
WHERE
  c0_.start_date <= ?
  AND c0_.end_date >= ?
  AND c0_.is_paused = ?
  AND u2_.visible IN (?)
  AND c0_.id IN (?)
ORDER BY
  c0_.start_date DESC

SELECT c0_.id AS id_0, c0_.start_date AS start_date_1, c0_.end_date AS end_date_2, c0_.shipping_option AS shipping_option_3, c0_.estimated_shipping AS estimated_shipping_4, c0_.shipping_name AS shipping_name_5, c0_.estimated_tax AS estimated_tax_6, c0_.estimated_cost AS estimated_cost_7, c0_.funded_total AS funded_total_8, c0_.purchased_total AS purchased_total_9, c0_.donations_from_previous AS donations_from_previous_10, c0_.status AS status_11, c0_.is_paused AS is_paused_12, c0_.paused_at AS paused_at_13, c0_.mass_mailing_called AS mass_mailing_called_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.user_id AS user_id_17, c0_.school_id AS school_id_18 FROM campaign c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id WHERE c0_.start_date <= '2026-01-17' AND c0_.end_date >= '2026-01-17' AND c0_.is_paused = 0 AND u2_.visible IN (NULL) AND c0_.id IN (82, 80, 78, 79, 30) ORDER BY c0_.start_date DESC;

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
  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
  COUNT(c0_.id) AS sclr_0
FROM
  campaign c0_
  INNER JOIN user u1_ ON c0_.user_id = u1_.id
  INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id
  LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id
WHERE
  c0_.start_date <= ?
  AND c0_.end_date >= ?
  AND c0_.is_paused = ?
  AND u2_.visible IN (?)

SELECT COUNT(c0_.id) AS sclr_0 FROM campaign c0_ INNER JOIN user u1_ ON c0_.user_id = u1_.id INNER JOIN user_profile u2_ ON u1_.profile_id = u2_.id LEFT JOIN user_major u3_ ON u2_.major_id = u3_.id WHERE c0_.start_date <= '2026-01-17' AND c0_.end_date >= '2026-01-17' AND c0_.is_paused = 0 AND u2_.visible IN (NULL);