Query Metrics

2 Database Queries
2 Different statements
36.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
35.85 ms
(99.16%)
1
SELECT s0_.id AS id_0, s0_.content AS content_1, s0_.created_at AS created_at_2, s0_.updated_at AS updated_at_3, u1_.role AS role_4, u1_.name AS name_5, u1_.id AS id_6, u1_.username AS username_7, u2_.number AS number_8, u2_.gender AS gender_9, u2_.major AS major_10, u2_.phone AS phone_11, u2_.mobile AS mobile_12, u2_.email AS email_13, u2_.address AS address_14, u2_.zipcode AS zipcode_15, u2_.id AS id_16, u2_.name AS name_17, s0_.user_id AS user_id_18, u1_.admin_college_id AS admin_college_id_19, u1_.user_info_id AS user_info_id_20, u2_.subject_id AS subject_id_21, u2_.title_id AS title_id_22, u2_.qualification_id AS qualification_id_23, u2_.degree_id AS degree_id_24, u2_.college_id AS college_id_25 FROM suggestion s0_ LEFT JOIN users u1_ ON s0_.user_id = u1_.id LEFT JOIN user_info u2_ ON u1_.user_info_id = u2_.id
Parameters:
[]
0.30 ms
(0.84%)
1
SELECT t0.role AS role_1, t0.name AS name_2, t0.id AS id_3, t0.username AS username_4, t0.admin_college_id AS admin_college_id_5, t0.user_info_id AS user_info_id_6 FROM users t0 WHERE t0.username = ? LIMIT 1
Parameters:
[
  "05824"
]

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
App\Entity\User No errors.
App\Entity\College No errors.
App\Entity\UserInfo No errors.
App\Entity\Suggestion No errors.
App\Entity\Subject No errors.
App\Entity\Title No errors.
App\Entity\Qualification No errors.
App\Entity\Degree No errors.