Query Metrics
117
Database Queries
3
Different statements
49.94 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
48.27 ms (96.66%) |
114 |
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 = ?
Parameters:
[
58
]
|
0.91 ms (1.83%) |
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, 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
]
|
0.76 ms (1.51%) |
2 |
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
Parameters:
[] |
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\UserMajor | No errors. |
FMT\Data\Entity\DwollaEvent | No errors. |
FMT\Data\Entity\BookstoreTransfer | No errors. |
FMT\Data\Entity\UserProfile | No errors. |
FMT\Data\Entity\Address | No errors. |
FMT\Data\Entity\UserAvatar | No errors. |
FMT\Data\Entity\UserSchoolShopper | No errors. |
FMT\Data\Entity\UserSchoolSettings | No errors. |
FMT\Data\Entity\UserSchoolTransferAttempts | No errors. |