Query Metrics
11
Database Queries
8
Different statements
11.92 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.35 ms |
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 = ?
Parameters:
[
null
]
|
2 | 1.10 ms |
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 = ?
Parameters:
[
1
]
|
3 | 0.50 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.login = ? LIMIT 2
Parameters:
[
"stellare55brink66@gmail.com"
]
|
4 | 0.94 ms |
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 = ?
Parameters:
[
null
]
|
5 | 0.25 ms |
"START TRANSACTION"
Parameters:
[] |
6 | 0.21 ms |
INSERT INTO user_statistic (students_founded, books_purchased_for, amount_founded, donated_to_me) VALUES (?, ?, ?, ?)
Parameters:
[ 1 => 0 2 => 0 3 => 0 4 => 0 ] |
7 | 0.71 ms |
INSERT INTO user_profile (email, first_name, last_name, grad_year, first_gen, student_type, phone, about, snapchat_id, facebook_messenger_id, other_email, visible, facebook, twitter, created_at, updated_at, school_id, major_id, address_id, avatar_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "stellare55brink66@gmail.com" 2 => "nODPybgfhVkEktZ" 3 => "OIxwLhcd" 4 => null 5 => 0 6 => "Undergraduate Student" 7 => null 8 => null 9 => null 10 => null 11 => null 12 => 2 13 => 0 14 => 0 15 => "2025-02-24 09:02:14" 16 => "2025-02-24 09:02:14" 17 => null 18 => null 19 => null 20 => null ] |
8 | 3.80 ms |
INSERT INTO user (username, username_canonical, email, email_canonical, enabled, salt, password, last_login, confirmation_token, password_requested_at, roles, login, created_at, updated_at, profile_id, statistic_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 1 => "stellare55brink66@gmail.com" 2 => "stellare55brink66@gmail.com" 3 => "stellare55brink66@gmail.com" 4 => "stellare55brink66@gmail.com" 5 => 0 6 => null 7 => "NjdiYzM1OTY1NTQ3NDQuMzQ2MzExNjU=" 8 => null 9 => "0DpIOmR4__upepYVcujmvenFT74FsL6a2bv-_4HegFg" 10 => null 11 => "a:1:{i:0;s:21:"ROLE_INCOMPLETE_DONOR";}" 12 => "stellare55brink66@gmail.com" 13 => "2025-02-24 09:02:14" 14 => "2025-02-24 09:02:14" 15 => 208 16 => 208 ] |
9 | 3.35 ms |
"COMMIT"
Parameters:
[] |
10 | 0.32 ms |
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 = ?
Parameters:
[
null
]
|
11 | 0.39 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.login = ? LIMIT 2
Parameters:
[
"stellare55brink66@gmail.com"
]
|
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\DwollaEvent | No errors. |
FMT\Data\Entity\BookstoreTransfer | No errors. |
FMT\Data\Entity\UserSchoolSettings | No errors. |
FMT\Data\Entity\UserSchoolTransferAttempts | No errors. |
FMT\Data\Entity\UserMajor | No errors. |
FMT\Data\Entity\UserProfile | No errors. |
FMT\Data\Entity\Address | No errors. |
FMT\Data\Entity\UserAvatar | No errors. |