Query Metrics
4
Database Queries
4
Different statements
1.46 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
0.44 ms (30.25%) |
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.40 ms (27.30%) |
1 |
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:
[
254
]
|
|
0.39 ms (26.50%) |
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 = ? AND t0.enabled = ? LIMIT 1
Parameters:
[ "254" 1 ] |
|
0.23 ms (15.94%) |
1 |
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:
[
79
]
|
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\UserSchoolShopper | 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. |