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.transaction_date AS transaction_date_24,
  t20.admin_id AS admin_id_25,
  t20.campaign_id AS campaign_id_26,
  t20.recipient_id AS recipient_id_27
FROM
  campaign t0
  LEFT JOIN transaction_history t20 ON t20.campaign_id = t0.id
WHERE
  t0.id = ?

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.transaction_date AS transaction_date_24, t20.admin_id AS admin_id_25, t20.campaign_id AS campaign_id_26, t20.recipient_id AS recipient_id_27 FROM campaign t0 LEFT JOIN transaction_history t20 ON t20.campaign_id = t0.id WHERE t0.id = '30';

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

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

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.transaction_date AS transaction_date_24,
  t20.admin_id AS admin_id_25,
  t20.campaign_id AS campaign_id_26,
  t20.recipient_id AS recipient_id_27
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.transaction_date AS transaction_date_24, t20.admin_id AS admin_id_25, t20.campaign_id AS campaign_id_26, t20.recipient_id AS recipient_id_27 FROM campaign t0 LEFT JOIN transaction_history t20 ON t20.campaign_id = t0.id WHERE t0.user_id = 129 ORDER BY t0.end_date DESC;

SELECT
  t0.id AS id_1,
  t0.students_founded AS students_founded_2,
  t0.books_purchased_for AS books_purchased_for_3,
  t0.amount_founded AS amount_founded_4,
  t0.donated_to_me AS donated_to_me_5,
  t6.username AS username_7,
  t6.username_canonical AS username_canonical_8,
  t6.email AS email_9,
  t6.email_canonical AS email_canonical_10,
  t6.enabled AS enabled_11,
  t6.salt AS salt_12,
  t6.password AS password_13,
  t6.last_login AS last_login_14,
  t6.confirmation_token AS confirmation_token_15,
  t6.password_requested_at AS password_requested_at_16,
  t6.roles AS roles_17,
  t6.id AS id_18,
  t6.login AS login_19,
  t6.created_at AS created_at_20,
  t6.updated_at AS updated_at_21,
  t6.profile_id AS profile_id_22,
  t6.statistic_id AS statistic_id_23
FROM
  user_statistic t0
  LEFT JOIN user t6 ON t6.statistic_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.students_founded AS students_founded_2, t0.books_purchased_for AS books_purchased_for_3, t0.amount_founded AS amount_founded_4, t0.donated_to_me AS donated_to_me_5, t6.username AS username_7, t6.username_canonical AS username_canonical_8, t6.email AS email_9, t6.email_canonical AS email_canonical_10, t6.enabled AS enabled_11, t6.salt AS salt_12, t6.password AS password_13, t6.last_login AS last_login_14, t6.confirmation_token AS confirmation_token_15, t6.password_requested_at AS password_requested_at_16, t6.roles AS roles_17, t6.id AS id_18, t6.login AS login_19, t6.created_at AS created_at_20, t6.updated_at AS updated_at_21, t6.profile_id AS profile_id_22, t6.statistic_id AS statistic_id_23 FROM user_statistic t0 LEFT JOIN user t6 ON t6.statistic_id = t0.id WHERE t0.id = 129;

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

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

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

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

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