Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

2 Database Queries

2 Different statements

4.09 ms Query time

0 Invalid entities

Time▼	Count	Info
2.18 ms (53.30%)	1	SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.icon AS icon_4 FROM locales t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.icon AS icon_4 FROM locales t0 SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.icon AS icon_4 FROM locales t0;
1.91 ms (46.70%)	1	SELECT c0_.id AS id_0, c0_.cca2 AS cca2_1, c0_.ru AS ru_2, c0_.en AS en_3, c0_.flag AS flag_4 FROM country c0_ WHERE c0_.cca2 = 'ru' Parameters: [] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.cca2 AS cca2_1, c0_.ru AS ru_2, c0_.en AS en_3, c0_.flag AS flag_4 FROM country c0_ WHERE c0_.cca2 = 'ru' SELECT c0_.id AS id_0, c0_.cca2 AS cca2_1, c0_.ru AS ru_2, c0_.en AS en_3, c0_.flag AS flag_4 FROM country c0_ WHERE c0_.cca2 = 'ru';

Time▼

Count

Info

2.18 ms
(53.30%)

SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.icon AS icon_4 FROM locales t0

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.key AS key_2,
  t0.name AS name_3,
  t0.icon AS icon_4
FROM
  locales t0

SELECT t0.id AS id_1, t0.key AS key_2, t0.name AS name_3, t0.icon AS icon_4 FROM locales t0;

1.91 ms
(46.70%)

SELECT c0_.id AS id_0, c0_.cca2 AS cca2_1, c0_.ru AS ru_2, c0_.en AS en_3, c0_.flag AS flag_4 FROM country c0_ WHERE c0_.cca2 = 'ru'

Parameters:

[]

View formatted query View runnable query Explain query

SELECT
  c0_.id AS id_0,
  c0_.cca2 AS cca2_1,
  c0_.ru AS ru_2,
  c0_.en AS en_3,
  c0_.flag AS flag_4
FROM
  country c0_
WHERE
  c0_.cca2 = 'ru'

SELECT c0_.id AS id_0, c0_.cca2 AS cca2_1, c0_.ru AS ru_2, c0_.en AS en_3, c0_.flag AS flag_4 FROM country c0_ WHERE c0_.cca2 = 'ru';

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.
App\Entity\Locales	No errors.