Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.39 ms Query time

0 Invalid entities

#▲	Time	Info
1	1.07 ms	SELECT login, img, points FROM users WHERE admin = 0 AND tournament = 1 ORDER BY points DESC LIMIT 10 Parameters: [] View formatted query View runnable query Explain query SELECT login, img, points FROM users WHERE admin = 0 AND tournament = 1 ORDER BY points DESC LIMIT 10 SELECT login, img, points FROM users WHERE admin = 0 AND tournament = 1 ORDER BY points DESC LIMIT 10;
2	0.32 ms	SELECT COUNT() AS cnt FROM users WHERE admin = 0 AND tournament = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() AS cnt FROM users WHERE admin = 0 AND tournament = 1 SELECT COUNT(*) AS cnt FROM users WHERE admin = 0 AND tournament = 1;

#▲

Time

Info

1.07 ms

SELECT login, img, points FROM users WHERE admin = 0 AND tournament = 1 ORDER BY points DESC LIMIT 10

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  login,
  img,
  points
FROM
  users
WHERE
  admin = 0
  AND tournament = 1
ORDER BY
  points DESC
LIMIT
  10

SELECT login, img, points FROM users WHERE admin = 0 AND tournament = 1 ORDER BY points DESC LIMIT 10;

0.32 ms

SELECT COUNT(*) AS cnt FROM users WHERE admin = 0 AND tournament = 1

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  COUNT(*) AS cnt
FROM
  users
WHERE
  admin = 0
  AND tournament = 1

SELECT COUNT(*) AS cnt FROM users WHERE admin = 0 AND tournament = 1;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

No loaded entities.