Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

3 Different statements

2.08 ms Query time

0 Invalid entities

#▲	Time	Info
1	0.38 ms	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: [`"S1455"`] View formatted query View runnable query Explain query 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 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 = 'S1455' LIMIT 1;
2	0.23 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
3	1.35 ms	SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME Parameters: [`"pms"`] View formatted query View runnable query Explain query SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = 'pms' AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME;
4	0.12 ms	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\User	No errors.
App\Entity\College	No errors.
App\Entity\UserInfo	No errors.
App\Entity\Subject	No errors.
App\Entity\Title	No errors.
App\Entity\Qualification	No errors.
App\Entity\Degree	No errors.
App\Entity\ItemBook	No errors.
App\Entity\Project	No errors.
App\Entity\Score	No errors.
App\Entity\ItemCourse	No errors.
App\Entity\Batch	No errors.
App\Entity\Announcement	No errors.
App\Entity\AnnouncementAttachment	No errors.
App\Entity\BatchCollegeAttachment	No errors.
App\Entity\Category	No errors.
App\Entity\Level	No errors.
App\Entity\Notice	No errors.
App\Entity\NoticeAttachment	No errors.
App\Entity\ProjectAttachment	No errors.
App\Entity\Review	No errors.
App\Entity\Reviewer	No errors.
App\Entity\Suggestion	No errors.
App\Entity\Year	No errors.
App\Entity\ReviewBatch	No errors.
App\Entity\ItemAchievement	No errors.
App\Entity\ItemExcellentBook	No errors.
App\Entity\ItemHospital	No errors.
App\Entity\ItemOther	No errors.
App\Entity\ItemPolitics	No errors.
App\Entity\ItemResearch	No errors.
App\Entity\ItemMajor	No errors.
App\Entity\ItemTeacher	No errors.
App\Entity\Property	No errors.
Vich\UploaderBundle\Entity\File	No errors.