Query Metrics
53
Database Queries
9
Different statements
24.83 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.37 ms |
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
Parameters:
[
178
]
|
2 | 0.51 ms |
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 = ?
Parameters:
[ 178 0 ] |
3 | 0.70 ms |
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
Parameters:
[
"%ROLE_STUDENT%"
]
|
4 | 1.56 ms |
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
Parameters:
[ "%ROLE_STUDENT%" [ 137 202 200 139 136 182 134 203 138 198 181 164 167 135 174 180 184 185 186 188 189 204 163 ] ] |
5 | 0.68 ms |
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%')
Parameters:
[
"%ROLE_STUDENT%"
]
|
6 | 0.39 ms |
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 = ?
Parameters:
[
33
]
|
7 | 0.81 ms |
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 = ?
Parameters:
[
1
]
|
8 | 0.54 ms |
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
Parameters:
[
137
]
|
9 | 0.38 ms |
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 = ?
Parameters:
[
52
]
|
10 | 0.85 ms |
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
Parameters:
[
202
]
|
11 | 0.43 ms |
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 = ?
Parameters:
[
51
]
|
12 | 0.43 ms |
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
Parameters:
[
200
]
|
13 | 0.33 ms |
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 = ?
Parameters:
[
40
]
|
14 | 0.73 ms |
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
Parameters:
[
139
]
|
15 | 0.37 ms |
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 = ?
Parameters:
[
32
]
|
16 | 0.49 ms |
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
Parameters:
[
136
]
|
17 | 0.32 ms |
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 = ?
Parameters:
[
43
]
|
18 | 0.72 ms |
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
Parameters:
[
182
]
|
19 | 0.33 ms |
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 = ?
Parameters:
[
42
]
|
20 | 0.53 ms |
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
Parameters:
[
134
]
|
21 | 0.27 ms |
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 = ?
Parameters:
[
53
]
|
22 | 0.36 ms |
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
Parameters:
[
203
]
|
23 | 0.37 ms |
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 = ?
Parameters:
[
34
]
|
24 | 0.54 ms |
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
Parameters:
[
138
]
|
25 | 0.36 ms |
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 = ?
Parameters:
[
50
]
|
26 | 0.45 ms |
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
Parameters:
[
198
]
|
27 | 0.32 ms |
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 = ?
Parameters:
[
41
]
|
28 | 0.56 ms |
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
Parameters:
[
181
]
|
29 | 0.82 ms |
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 = ?
Parameters:
[
36
]
|
30 | 0.49 ms |
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
Parameters:
[
164
]
|
31 | 0.31 ms |
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 = ?
Parameters:
[
37
]
|
32 | 0.51 ms |
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
Parameters:
[
167
]
|
33 | 0.34 ms |
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 = ?
Parameters:
[
49
]
|
34 | 0.51 ms |
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
Parameters:
[
135
]
|
35 | 0.31 ms |
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 = ?
Parameters:
[
38
]
|
36 | 0.47 ms |
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
Parameters:
[
174
]
|
37 | 0.25 ms |
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 = ?
Parameters:
[
39
]
|
38 | 0.44 ms |
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
Parameters:
[
180
]
|
39 | 0.27 ms |
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 = ?
Parameters:
[
44
]
|
40 | 0.41 ms |
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
Parameters:
[
184
]
|
41 | 0.26 ms |
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 = ?
Parameters:
[
45
]
|
42 | 0.51 ms |
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
Parameters:
[
185
]
|
43 | 0.26 ms |
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 = ?
Parameters:
[
46
]
|
44 | 0.53 ms |
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
Parameters:
[
186
]
|
45 | 0.25 ms |
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 = ?
Parameters:
[
47
]
|
46 | 0.49 ms |
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
Parameters:
[
188
]
|
47 | 0.24 ms |
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 = ?
Parameters:
[
48
]
|
48 | 0.48 ms |
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
Parameters:
[
189
]
|
49 | 0.29 ms |
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 = ?
Parameters:
[
54
]
|
50 | 0.46 ms |
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
Parameters:
[
204
]
|
51 | 0.27 ms |
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 = ?
Parameters:
[
35
]
|
52 | 0.52 ms |
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
Parameters:
[
163
]
|
53 | 0.47 ms |
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 = ?
Parameters:
[
178
]
|
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
FMT\Data\Entity\Transaction | No errors. |
FMT\Data\Entity\UserTransaction | No errors. |
FOS\UserBundle\Model\User | No errors. |
FMT\Data\Entity\User | No errors. |
FMT\Data\Entity\Order | No errors. |
FMT\Data\Entity\UserStatistic | No errors. |
FMT\Data\Entity\UserSchool | No errors. |
FMT\Data\Entity\Campaign | No errors. |
FMT\Data\Entity\UserContact | No errors. |
FMT\Data\Entity\UserNotifications | No errors. |
FMT\Data\Entity\UserProfile | No errors. |
FMT\Data\Entity\UserSchoolShopper | No errors. |
FMT\Data\Entity\DwollaEvent | No errors. |
FMT\Data\Entity\BookstoreTransfer | No errors. |
FMT\Data\Entity\UserMajor | No errors. |
FMT\Data\Entity\Address | No errors. |
FMT\Data\Entity\UserAvatar | No errors. |
FMT\Data\Entity\UserSchoolSettings | No errors. |
FMT\Data\Entity\UserSchoolTransferAttempts | No errors. |
FMT\Data\Entity\TransactionHistory | No errors. |
FMT\Data\Entity\CampaignBook | No errors. |
FMT\Data\Entity\CampaignContact | No errors. |