Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

4 Database Queries

3 Different statements

1.27 ms Query time

0 Invalid entities

Grouped Statements

Show all queries

Time▼	Count	Info
0.85 ms (66.87%)	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.22 ms (17.07%)	1	SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.valid AS valid_7 FROM announcement t0 WHERE t0.id = ? Parameters: [`"20"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.valid AS valid_7 FROM announcement t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.valid AS valid_7 FROM announcement t0 WHERE t0.id = '20';
0.20 ms (16.05%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();

Time▼

Count

Info

0.85 ms
(66.87%)

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.22 ms
(17.07%)

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.valid AS valid_7 FROM announcement t0 WHERE t0.id = ?

Parameters:

[
  "20"
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.content AS content_3,
  t0.published_at AS published_at_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.valid AS valid_7
FROM
  announcement t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.published_at AS published_at_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.valid AS valid_7 FROM announcement t0 WHERE t0.id = '20';

0.20 ms
(16.05%)

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\Announcement	No errors.
App\Entity\AnnouncementAttachment	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\BatchCollegeAttachment	No errors.
App\Entity\Category	No errors.
App\Entity\College	No errors.
App\Entity\Degree	No errors.
App\Entity\Level	No errors.
App\Entity\Notice	No errors.
App\Entity\NoticeAttachment	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/announcement/20

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Entities Mapping