Query Metrics

10 Database Queries
2 Different statements
1.63 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.31 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
2 0.18 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
3 0.15 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
4 0.16 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
5 0.13 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
6 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.enabled AS enabled_4 FROM facet_config t0 WHERE t0.enabled = ? LIMIT 1
Parameters:
[
  1
]
7 0.23 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
8 0.08 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.enabled AS enabled_4 FROM facet_config t0 WHERE t0.enabled = ? LIMIT 1
Parameters:
[
  1
]
9 0.08 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]
10 0.13 ms
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "bourges"
  "bourges-fr"
]

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