Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

1 Database Queries

1 Different statements

0.37 ms Query time

0 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.37 ms	SELECT r0_.password AS password_0, r0_.name AS name_1, r0_.id AS id_2, r0_.username AS username_3, r0_.review_batch_id AS review_batch_id_4 FROM reviewer r0_ LEFT JOIN review_batch r1_ ON r0_.review_batch_id = r1_.id WHERE r0_.username = ? AND r1_.current = 1 Parameters: [`"25_zkd12"`] View formatted query View runnable query Explain query SELECT r0_.password AS password_0, r0_.name AS name_1, r0_.id AS id_2, r0_.username AS username_3, r0_.review_batch_id AS review_batch_id_4 FROM reviewer r0_ LEFT JOIN review_batch r1_ ON r0_.review_batch_id = r1_.id WHERE r0_.username = ? AND r1_.current = 1 SELECT r0_.password AS password_0, r0_.name AS name_1, r0_.id AS id_2, r0_.username AS username_3, r0_.review_batch_id AS review_batch_id_4 FROM reviewer r0_ LEFT JOIN review_batch r1_ ON r0_.review_batch_id = r1_.id WHERE r0_.username = '25_zkd12' AND r1_.current = 1;

#▲

Time

Info

0.37 ms

SELECT r0_.password AS password_0, r0_.name AS name_1, r0_.id AS id_2, r0_.username AS username_3, r0_.review_batch_id AS review_batch_id_4 FROM reviewer r0_ LEFT JOIN review_batch r1_ ON r0_.review_batch_id = r1_.id WHERE r0_.username = ? AND r1_.current = 1

Parameters:

[
  "25_zkd12"
]

View formatted query View runnable query Explain query

SELECT
  r0_.password AS password_0,
  r0_.name AS name_1,
  r0_.id AS id_2,
  r0_.username AS username_3,
  r0_.review_batch_id AS review_batch_id_4
FROM
  reviewer r0_
  LEFT JOIN review_batch r1_ ON r0_.review_batch_id = r1_.id
WHERE
  r0_.username = ?
  AND r1_.current = 1

SELECT r0_.password AS password_0, r0_.name AS name_1, r0_.id AS id_2, r0_.username AS username_3, r0_.review_batch_id AS review_batch_id_4 FROM reviewer r0_ LEFT JOIN review_batch r1_ ON r0_.review_batch_id = r1_.id WHERE r0_.username = '25_zkd12' AND r1_.current = 1;

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\Reviewer	No errors.
App\Entity\ReviewBatch	No errors.

Symfony Profiler

http://pms.cmet.ustc.edu.cn/review/login Return to referer URL

Configuration Settings

Theme