Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

1.39 ms Query time

0 Invalid entities

Time▼	Count	Info
1.07 ms (76.98%)	1	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 (23.02%)	1	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▼

Count

Info

1.07 ms
(76.98%)

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
(23.02%)

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.