Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

3.94 ms Query time

0 Invalid entities

#▲	Time	Info
1	1.13 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 WHERE t0.code = ? LIMIT 1 Parameters: [`"AR"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 WHERE t0.code = ? LIMIT 1 SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 WHERE t0.code = 'AR' LIMIT 1;
2	2.81 ms	SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 ORDER BY t0.es_name ASC Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 ORDER BY t0.es_name ASC SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 ORDER BY t0.es_name ASC;

#▲

Time

Info

1.13 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 WHERE t0.code = ? LIMIT 1

Parameters:

[
  "AR"
]

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id_1, 
  t0.code AS code_2, 
  t0.name AS name_3, 
  t0.es_name AS es_name_4 
FROM 
  country t0 
WHERE 
  t0.code = ? 
LIMIT 
  1

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 WHERE t0.code = 'AR' LIMIT 1;

2.81 ms

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 ORDER BY t0.es_name ASC

Parameters:

[]

View formatted query View runnable query Explain query

SELECT 
  t0.id AS id_1, 
  t0.code AS code_2, 
  t0.name AS name_3, 
  t0.es_name AS es_name_4 
FROM 
  country t0 
ORDER BY 
  t0.es_name ASC

SELECT t0.id AS id_1, t0.code AS code_2, t0.name AS name_3, t0.es_name AS es_name_4 FROM country t0 ORDER BY t0.es_name ASC;

Name	Service
default	doctrine.dbal.default_connection

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache is not enabled.

Class	Mapping errors
App\Entity\Country	No errors.