Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

2.08 ms Query time

0 Invalid entities

Time▼	Count	Info
1.19 ms (56.99%)	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.90 ms (43.01%)	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.19 ms
(56.99%)

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.90 ms
(43.01%)

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.