https://oscar-multilangue.hrz.fr/localite/blaye-en

Query Metrics

6 Database Queries
4 Different statements
3.77 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 1.04 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:
[
  "/localite/blaye-en"
  1
]
2 0.15 ms
SELECT l0_.id AS id_0, l0_.active AS active_1, l0_.name AS name_2, l0_.language_code AS language_code_3, l0_.flag AS flag_4, l0_.created_at AS created_at_5, l0_.updated_at AS updated_at_6 FROM language l0_ WHERE l0_.active = 1 ORDER BY l0_.id ASC
Parameters:
[]
3 0.96 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[
  "fr"
  "blaye-en"
]
4 0.45 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[
  "en"
  "blaye-en"
]
5 0.16 ms
SELECT s0_.id AS id_0, s0_.position AS position_1, s0_.actif AS actif_2, s0_.activite_primaire_ids AS activite_primaire_ids_3, s0_.activite_secondaire_ids AS activite_secondaire_ids_4, s0_.tag_managerhead AS tag_managerhead_5, s0_.tag_managerbody AS tag_managerbody_6, s0_.DateCreation AS DateCreation_7, s0_.DateModification AS DateModification_8 FROM secteurs s0_ INNER JOIN secteurs_translation s1_ ON s0_.id = s1_.translatable_id WHERE s1_.locale = ? AND s0_.actif = 1 AND s1_.libelle_url = ?
Parameters:
[
  "en"
  "blaye-en"
]
6 1.02 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:
[
  "blaye-en"
]

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\Secteurs No errors.
App\Entity\Language No errors.
App\Entity\SecteursTranslation No errors.
App\Entity\UrlRef No errors.
App\Entity\UrlPost No errors.
App\Entity\UrlPostTranslation No errors.