Query Metrics
4
Database Queries
4
Different statements
27.39 ms
Query time
1
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
17.76 ms (64.84%) |
1 |
"COMMIT"
Parameters:
[] |
6.21 ms (22.68%) |
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.updated AS updated_13, t0.created AS created_14, t0.avatar_file_name AS avatar_file_name_15, t0.balance AS balance_16, t0.abacoins AS abacoins_17, t0.first_name AS first_name_18, t0.last_name AS last_name_19, t0.phone AS phone_20, t0.address AS address_21, t0.language AS language_22, t0.type AS type_23, t0.birthday AS birthday_24, t0.theme_color AS theme_color_25, t0.is_deleted AS is_deleted_26, t0.is_available_rating AS is_available_rating_27, t0.show_info_about_payment AS show_info_about_payment_28, t0.type_available_rating AS type_available_rating_29, t0.date_of_change_status AS date_of_change_status_30, t0.country_id AS country_id_31, t0.city_id AS city_id_32, t0.school_id AS school_id_33, t0.group_id AS group_id_34, t35.id AS id_36, t35.cost_full_course AS cost_full_course_37, t35.cost_partly_course AS cost_partly_course_38, t35.status AS status_39, t35.sort_theme_id AS sort_theme_id_40, t35.sort_theme_level AS sort_theme_level_41, t35.email_signature AS email_signature_42, t35.is_subscribed AS is_subscribed_43, t35.user_id AS user_id_44 FROM fos_user t0 LEFT JOIN mc_student_profile t35 ON t35.user_id = t0.id WHERE t0.username_canonical = ? LIMIT 1
Parameters:
[
"r@r.com"
]
|
3.32 ms (12.13%) |
1 |
UPDATE fos_user SET last_login = ?, updated = ? WHERE id = ?
Parameters:
[ "2025-08-18 23:27:01" "2025-08-18 23:27:01" 794 ] |
0.10 ms (0.35%) |
1 |
"START TRANSACTION"
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 |
---|---|
FOS\UserBundle\Model\User | No errors. |
MentalSchool\AppBundle\Entity\User | No errors. |
MentalSchool\AppBundle\Entity\Country | No errors. |
MentalSchool\AppBundle\Entity\City | No errors. |
MentalSchool\AppBundle\Entity\School | No errors. |
MentalSchool\AppBundle\Entity\SchoolGroup | No errors. |
MentalSchool\AppBundle\Entity\StudentProfile | No errors. |
MentalSchool\AppBundle\Entity\TaskTemplate |
|
MentalSchool\AppBundle\Entity\Task | No errors. |
MentalSchool\AppBundle\Entity\UserPermissions | No errors. |
MentalSchool\AppBundle\Entity\UsersTasks | No errors. |
MentalSchool\AppBundle\Entity\PaymentHistory | No errors. |
MentalSchool\AppBundle\Entity\AbacoinHistory | No errors. |
MentalSchool\AppBundle\Entity\UserNotification | No errors. |
MentalSchool\AppBundle\Entity\Classroom | No errors. |
MentalSchool\AppBundle\Entity\CategorySchool | No errors. |