Query Metrics

8 Database Queries
4 Different statements
2.11 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
2 0.33 ms
SELECT t0.id AS id_1, t0.value AS value_2, t0.canonical AS canonical_3, t0.entity_type AS entity_type_4, t0.entity_id AS entity_id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.lang_id AS lang_id_8 FROM slug t0 WHERE t0.value = ? AND t0.lang_id = ? LIMIT 1
Parameters:
[
  "pays-de-la-loire"
  2
]
3 0.26 ms
SELECT t0.id AS id_1, t0.id_iresa AS id_iresa_2, t0.code_traduction AS code_traduction_3, t0.titre_court AS titre_court_4, t0.titre_long AS titre_long_5, t0.introduction AS introduction_6, t0.slug AS slug_7, t0.etat AS etat_8, t0.level AS level_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.seo_title AS seo_title_12, t0.seo_content AS seo_content_13, t0.canonical AS canonical_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.is_translated AS is_translated_17, t0.parent_id AS parent_id_18, t0.lang_id AS lang_id_19 FROM destination t0 WHERE t0.id = ?
Parameters:
[
  112
]
4 0.18 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
5 0.23 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
6 0.16 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "fr"
]
7 0.20 ms
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.code AS code_3, t0.idiresa AS idiresa_4, t0.etat AS etat_5, t0.default AS default_6, t0.code_iso AS code_iso_7, t0.flag_id AS flag_id_8 FROM language t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "en"
]
8 0.23 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.etat AS etat_3, p0_.photo_profil AS photo_profil_4, p0_.slug AS slug_5, p0_.code_traduction AS code_traduction_6, p0_.titre_actif AS titre_actif_7, p0_.type AS type_8, p0_.redirection AS redirection_9, p0_.created_at AS created_at_10, p0_.updated_at AS updated_at_11, p0_.is_translated AS is_translated_12, p0_.lang_id AS lang_id_13 FROM PAGE p0_ WHERE p0_.code_traduction = ? AND p0_.lang_id = ?
Parameters:
[
  "19"
  2
]

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\Slug No errors.
App\Entity\Language No errors.
App\Entity\media No errors.
App\Entity\Destination No errors.
App\Entity\Page No errors.