Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

2.30 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	1.27 ms	SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1 Parameters: [`"/_profiler/209117?panel=time" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1 SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = '/_profiler/209117?panel=time' AND t0.active = 1 LIMIT 1;
2	0.86 ms	SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = ? AND u1_.locale = ? LIMIT 1 Parameters: [`"_profiler" "fr"`] View formatted query View runnable query Explain query SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = ? AND u1_.locale = ? LIMIT 1 SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = '_profiler' AND u1_.locale = 'fr' LIMIT 1;
3	0.16 ms	SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1 Parameters: [`"/_profiler/209117?panel=time" 1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1 SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = '/_profiler/209117?panel=time' AND t0.active = 1 LIMIT 1;

#▲

Time

Info

1.27 ms

SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "/_profiler/209117?panel=time"
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.id_module AS id_module_2,
  t0.type_module AS type_module_3,
  t0.old AS old_4,
  t0.new AS new_5,
  t0.active AS active_6,
  t0.lien_externe AS lien_externe_7,
  t0.DateCreation AS DateCreation_8,
  t0.DateModification AS DateModification_9,
  t0.locale AS locale_10,
  t0.IdSite AS IdSite_11
FROM
  redirection t0
WHERE
  t0.old = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = '/_profiler/209117?panel=time' AND t0.active = 1 LIMIT 1;

0.86 ms

SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = ? AND u1_.locale = ? LIMIT 1

Parameters:

[
  "_profiler"
  "fr"
]

View formatted query View runnable query Explain query

SELECT
  u0_.id AS id_0,
  u0_.id_module AS id_module_1,
  u0_.type AS type_2,
  u0_.created_at AS created_at_3,
  u0_.updated_at AS updated_at_4
FROM
  url_post u0_
  INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id
WHERE
  u1_.slug = ?
  AND u1_.locale = ?
LIMIT
  1

SELECT u0_.id AS id_0, u0_.id_module AS id_module_1, u0_.type AS type_2, u0_.created_at AS created_at_3, u0_.updated_at AS updated_at_4 FROM url_post u0_ INNER JOIN url_post_translation u1_ ON u0_.id = u1_.translatable_id WHERE u1_.slug = '_profiler' AND u1_.locale = 'fr' LIMIT 1;

0.16 ms

SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = ? AND t0.active = ? LIMIT 1

Parameters:

[
  "/_profiler/209117?panel=time"
  1
]

View formatted query View runnable query Explain query

SELECT
  t0.id AS id_1,
  t0.id_module AS id_module_2,
  t0.type_module AS type_module_3,
  t0.old AS old_4,
  t0.new AS new_5,
  t0.active AS active_6,
  t0.lien_externe AS lien_externe_7,
  t0.DateCreation AS DateCreation_8,
  t0.DateModification AS DateModification_9,
  t0.locale AS locale_10,
  t0.IdSite AS IdSite_11
FROM
  redirection t0
WHERE
  t0.old = ?
  AND t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.id_module AS id_module_2, t0.type_module AS type_module_3, t0.old AS old_4, t0.new AS new_5, t0.active AS active_6, t0.lien_externe AS lien_externe_7, t0.DateCreation AS DateCreation_8, t0.DateModification AS DateModification_9, t0.locale AS locale_10, t0.IdSite AS IdSite_11 FROM redirection t0 WHERE t0.old = '/_profiler/209117?panel=time' AND t0.active = 1 LIMIT 1;

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

Class	Mapping errors
App\Entity\Redirection	No errors.
App\Entity\Site	No errors.
App\Entity\UrlPost	No errors.
App\Entity\UrlPostTranslation	No errors.
App\Entity\User	No errors.
App\Entity\ListeMenu	No errors.
App\Entity\TextParametrable	No errors.
App\Entity\Email	No errors.
App\Entity\ParametreSite	No errors.
App\Entity\Media	No errors.
App\Entity\ReseauSociaux	No errors.
App\Entity\ModulesCookies	No errors.
App\Entity\PostAffichage	No errors.
App\Entity\Category	The association App\Entity\Category#modele_gallerie refers to the inverse side field App\Entity\ModelGallerie#category which does not exist.
App\Entity\Widget	The association App\Entity\Widget#type_affichage_home refers to the inverse side field App\Entity\PostAffichage#widget which does not exist.

Symfony Profiler

https://new-site.hrz.fr/_profiler/209117?panel=time

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping