Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

3 Database Queries

2 Different statements

2.39 ms Query time

2 Invalid entities

Queries

Group similar statements

#▲	Time	Info
1	0.98 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: [`"/library/.env" 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 = '/library/.env' AND t0.active = 1 LIMIT 1;
2	1.26 ms	SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = ? LIMIT 1 Parameters: [`"library"`] View formatted query View runnable query Explain query SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = ? LIMIT 1 SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = 'library' LIMIT 1;
3	0.14 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: [`"/library/.env" 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 = '/library/.env' AND t0.active = 1 LIMIT 1;

#▲

Time

Info

0.98 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:

[
  "/library/.env"
  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 = '/library/.env' AND t0.active = 1 LIMIT 1;

1.26 ms

SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = ? LIMIT 1

Parameters:

[
  "library"
]

View formatted query View runnable query Explain query

SELECT
  u0_.locale AS locale_0
FROM
  url_post u1_
  INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id
WHERE
  u0_.slug = ?
LIMIT
  1

SELECT u0_.locale AS locale_0 FROM url_post u1_ INNER JOIN url_post_translation u0_ ON u1_.id = u0_.translatable_id WHERE u0_.slug = 'library' LIMIT 1;

0.14 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:

[
  "/library/.env"
  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 = '/library/.env' 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\User	No errors.
App\Entity\Redirection	No errors.
App\Entity\Site	No errors.
App\Entity\UrlPost	No errors.
App\Entity\Language	No errors.
App\Entity\UrlPostTranslation	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://oscar-multilangue.hrz.fr/library/.env

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping