Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

6 Database Queries

3 Different statements

2.43 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.10 ms (45.01%)	3	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: [`"9202244276"`] 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 = '9202244276' LIMIT 1;
1.07 ms (44.07%)	1	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;
0.27 ms (10.92%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

1.10 ms
(45.01%)

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:

[
  "9202244276"
]

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 = '9202244276' LIMIT 1;

1.07 ms
(44.07%)

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;

0.27 ms
(10.92%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

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\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.

Symfony Profiler

http://pms.cmet.ustc.edu.cn/admin?ticket=ST-121762-VgHopn19JdXKFkotuHqtm36zBrYrg-sso-5d76694cd8-ntg7c

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping