Query Metrics

6 Database Queries
5 Different statements
1.40 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.72 ms
(51.67%)
2
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"
]
0.20 ms
(14.27%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.url AS url_3, t0.thumbnail AS thumbnail_4, t0.lang_id AS lang_id_5 FROM catalog t0 WHERE t0.lang_id = ?
Parameters:
[
  1
]
0.19 ms
(13.42%)
1
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.nom AS nom_2, p0_.etat AS etat_3 FROM pays p0_ WHERE p0_.etat = 1
Parameters:
[]
0.15 ms
(10.92%)
1
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"
  1
]
0.14 ms
(9.71%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.nom AS nom_3, t0.etat AS etat_4 FROM pays t0 WHERE t0.id = ?
Parameters:
[
  79
]

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\Catalog No errors.
App\Entity\pays No errors.
App\Entity\Page No errors.