Symfony Profiler

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;

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.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 = ?

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 = '203';

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

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

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,
  t0.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_9
FROM
  user_school t0
WHERE
  t0.id = ?
LIMIT
  1

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, t0.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_9 FROM user_school t0 WHERE t0.id = '1' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.campus_id AS campus_id_4,
  t0.department_id AS department_id_5,
  t0.created_at AS created_at_6,
  t0.updated_at AS updated_at_7,
  t0.user_school_id AS user_school_id_8
FROM
  user_major t0
WHERE
  t0.user_school_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.campus_id AS campus_id_4, t0.department_id AS department_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.user_school_id AS user_school_id_8 FROM user_major t0 WHERE t0.user_school_id = 1;

"START TRANSACTION"

"START TRANSACTION";

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 = ?
ORDER BY
  u0_.name ASC FOR
UPDATE

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 = '1' ORDER BY u0_.name ASC FOR UPDATE;

"COMMIT"

"COMMIT";

SELECT
  u0_.id AS id_0,
  u0_.name AS name_1,
  u0_.active AS active_2,
  u0_.tax AS tax_3,
  u0_.bookstore_id AS bookstore_id_4,
  u0_.created_at AS created_at_5,
  u0_.updated_at AS updated_at_6,
  u0_.school_settings_id AS school_settings_id_7,
  u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8
FROM
  user_school u0_
WHERE
  u0_.active = 1
  OR u0_.id = ?

SELECT u0_.id AS id_0, u0_.name AS name_1, u0_.active AS active_2, u0_.tax AS tax_3, u0_.bookstore_id AS bookstore_id_4, u0_.created_at AS created_at_5, u0_.updated_at AS updated_at_6, u0_.school_settings_id AS school_settings_id_7, u0_.user_school_transfer_attempts_id AS user_school_transfer_attempts_id_8 FROM user_school u0_ WHERE u0_.active = 1 OR u0_.id = 1;

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 = 203 ORDER BY t0.end_date DESC;

SELECT
  t0.id AS id_1,
  t0.country AS country_2,
  t0.region AS region_3,
  t0.city AS city_4,
  t0.code AS code_5,
  t0.address1 AS address1_6,
  t0.address2 AS address2_7,
  t0.created_at AS created_at_8,
  t0.updated_at AS updated_at_9
FROM
  address t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.country AS country_2, t0.region AS region_3, t0.city AS city_4, t0.code AS code_5, t0.address1 AS address1_6, t0.address2 AS address2_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM address t0 WHERE t0.id = 53;

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.login = ?
LIMIT
  2

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.login = 'nick+ucdtest6@ndic.com' LIMIT 2;

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.phone = ?
LIMIT
  2

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.phone = '290-590-8234' LIMIT 2;

"START TRANSACTION"

"START TRANSACTION";

UPDATE
  user_profile
SET
  visible = ?,
  updated_at = ?
WHERE
  id = ?

UPDATE user_profile SET visible = 2, updated_at = '2025-02-23 22:20:08' WHERE id = 203;

"COMMIT"

"COMMIT";