Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

37.20 ms Query time

0 Invalid entities

Time▼	Count	Info
24.30 ms (65.33%)	2	SELECT DATABASE() Parameters: [] View formatted query View runnable query Explain query SELECT DATABASE() SELECT DATABASE();
12.90 ms (34.67%)	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;

Time▼

Count

Info

24.30 ms
(65.33%)

SELECT DATABASE()

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  DATABASE()

SELECT DATABASE();

12.90 ms
(34.67%)

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;

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