Symfony Profiler

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

SELECT
  o0_.id AS id_0,
  o0_.external_id AS external_id_1,
  o0_.price AS price_2,
  o0_.shipping AS shipping_3,
  o0_.tax AS tax_4,
  o0_.transaction_fee AS transaction_fee_5,
  o0_.fmt_fee AS fmt_fee_6,
  o0_.total AS total_7,
  o0_.status AS status_8,
  o0_.submitted AS submitted_9,
  o0_.anonymous_token AS anonymous_token_10,
  o0_.unprocessed_amount AS unprocessed_amount_11,
  o0_.created_at AS created_at_12,
  o0_.updated_at AS updated_at_13,
  o0_.user_id AS user_id_14,
  o0_.campaign_id AS campaign_id_15,
  o0_.address_id AS address_id_16
FROM
  `order` o0_
  LEFT JOIN campaign c1_ ON o0_.campaign_id = c1_.id
WHERE
  o0_.status = ?
  AND c1_.is_paused = ?
  AND c1_.end_date > ?
  AND o0_.anonymous_token = ?
  AND o0_.user_id IS NULL
ORDER BY
  o0_.created_at DESC
LIMIT
  1

SELECT o0_.id AS id_0, o0_.external_id AS external_id_1, o0_.price AS price_2, o0_.shipping AS shipping_3, o0_.tax AS tax_4, o0_.transaction_fee AS transaction_fee_5, o0_.fmt_fee AS fmt_fee_6, o0_.total AS total_7, o0_.status AS status_8, o0_.submitted AS submitted_9, o0_.anonymous_token AS anonymous_token_10, o0_.unprocessed_amount AS unprocessed_amount_11, o0_.created_at AS created_at_12, o0_.updated_at AS updated_at_13, o0_.user_id AS user_id_14, o0_.campaign_id AS campaign_id_15, o0_.address_id AS address_id_16 FROM `order` o0_ LEFT JOIN campaign c1_ ON o0_.campaign_id = c1_.id WHERE o0_.status = 'cart' AND c1_.is_paused = 0 AND c1_.end_date > '2025-02-23' AND o0_.anonymous_token = 'T7z70IUcROJrO0oqrDdqqD1HQzdPrAP5pQ77vKoLkds' AND o0_.user_id IS NULL ORDER BY o0_.created_at DESC 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;