Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

3 Different statements

1.67 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
1.09 ms (65.48%)	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.31 ms (18.73%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
0.26 ms (15.78%)	1	SELECT t0.attachment_name AS attachment_name_1, t0.id AS id_2, t0.name AS name_3, t0.notice_id AS notice_id_4 FROM notice_attachment t0 WHERE t0.id = ? Parameters: [`"213"`] View formatted query View runnable query Explain query SELECT t0.attachment_name AS attachment_name_1, t0.id AS id_2, t0.name AS name_3, t0.notice_id AS notice_id_4 FROM notice_attachment t0 WHERE t0.id = ? SELECT t0.attachment_name AS attachment_name_1, t0.id AS id_2, t0.name AS name_3, t0.notice_id AS notice_id_4 FROM notice_attachment t0 WHERE t0.id = '213';

Time▼

Count

Info

1.09 ms
(65.48%)

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.31 ms
(18.73%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

0.26 ms
(15.78%)

SELECT t0.attachment_name AS attachment_name_1, t0.id AS id_2, t0.name AS name_3, t0.notice_id AS notice_id_4 FROM notice_attachment t0 WHERE t0.id = ?

Parameters:

[
  "213"
]

View formatted query View runnable query Explain query

SELECT
  t0.attachment_name AS attachment_name_1,
  t0.id AS id_2,
  t0.name AS name_3,
  t0.notice_id AS notice_id_4
FROM
  notice_attachment t0
WHERE
  t0.id = ?

SELECT t0.attachment_name AS attachment_name_1, t0.id AS id_2, t0.name AS name_3, t0.notice_id AS notice_id_4 FROM notice_attachment t0 WHERE t0.id = '213';

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\NoticeAttachment	No errors.
App\Entity\Notice	No errors.
App\Entity\Batch	No errors.
App\Entity\BatchCollegeAttachment	No errors.
App\Entity\ItemBook	No errors.
App\Entity\Project	No errors.
App\Entity\Score	No errors.
App\Entity\ItemCourse	No errors.
App\Entity\Announcement	No errors.
App\Entity\AnnouncementAttachment	No errors.
App\Entity\Category	No errors.
App\Entity\College	No errors.
App\Entity\Degree	No errors.
App\Entity\Level	No errors.
App\Entity\ProjectAttachment	No errors.
App\Entity\Qualification	No errors.
App\Entity\Review	No errors.
App\Entity\Reviewer	No errors.
App\Entity\Subject	No errors.
App\Entity\Suggestion	No errors.
App\Entity\Title	No errors.
App\Entity\Year	No errors.
App\Entity\ReviewBatch	No errors.
App\Entity\User	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\UserInfo	No errors.
App\Entity\Property	No errors.
Vich\UploaderBundle\Entity\File	No errors.

Symfony Profiler

http://pms.cmet.ustc.edu.cn/notice-attachment/download/213

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping