GET https://mitih-front-v2.synexta-developpement.fr/fr/demandesDemo

Query Metrics

22 Database Queries
13 Different statements
23.96 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 1.75 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0
Parameters:
[]
2 2.35 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.nom_en_gb AS nom_en_gb_5, t0.nom_fr_fr AS nom_fr_fr_6, t0.tva AS tva_7 FROM pays t0
Parameters:
[]
3 1.23 ms
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.nom_en_gb AS nom_en_gb_5, t0.nom_fr_fr AS nom_fr_fr_6, t0.tva AS tva_7 FROM pays t0 WHERE t0.alpha2 = ? LIMIT 1
Parameters:
[
  "fr"
]
4 1.41 ms
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.nom AS nom_3, t0.cp AS cp_4, t0.date_creation AS date_creation_5, t0.date_update AS date_update_6, t0.pays_id AS pays_id_7, t0.region_id AS region_id_8 FROM departement t0 WHERE t0.pays_id = ?
Parameters:
[
  75
]
5 1.27 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0
Parameters:
[]
6 3.30 ms
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.contenu AS contenu_2, p0_.date_debut AS date_debut_3, p0_.date_fin AS date_fin_4, p0_.date_creation AS date_creation_5, p0_.date_update AS date_update_6, p0_.mots_cles AS mots_cles_7, p0_.date_validation AS date_validation_8, p0_.url AS url_9, p0_.cout_total AS cout_total_10, p0_.duree AS duree_11, p0_.meta_description AS meta_description_12, p0_.cp AS cp_13, p0_.services AS services_14, p0_.entreprise_id AS entreprise_id_15, p0_.etat_id AS etat_id_16, p0_.cout_journalier_id AS cout_journalier_id_17, p0_.proprietaire_id AS proprietaire_id_18, p0_.filiale_id AS filiale_id_19, p0_.departement_id AS departement_id_20 FROM publicite p0_ WHERE p0_.etat_id = ? ORDER BY RAND() ASC
Parameters:
[
  1
]
7 1.04 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FR"
]
8 0.55 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FR"
]
9 0.89 ms
SELECT t0.id AS id_1, t0.route AS route_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.libelles_traduits AS libelles_traduits_5, t0.langue_id AS langue_id_6 FROM traduction t0 WHERE t0.route = ? AND t0.langue_id = ? LIMIT 1
Parameters:
[
  "footer"
  1
]
10 1.14 ms
SELECT t0.id AS id_1, t0.display_position AS display_position_2, t0.titre AS titre_3, t0.link AS link_4, t0.status AS status_5, t0.date_creation AS date_creation_6, t0.date_update AS date_update_7, t0.titre_fr AS titre_fr_8, t0.titre_en AS titre_en_9, t0.titre_de AS titre_de_10, t0.titre_be AS titre_be_11 FROM menu_links t0 WHERE t0.display_position = ? AND t0.status = ?
Parameters:
[
  "footer_centre"
  "Actif"
]
11 0.79 ms
SELECT t0.id AS id_1, t0.display_position AS display_position_2, t0.titre AS titre_3, t0.link AS link_4, t0.status AS status_5, t0.date_creation AS date_creation_6, t0.date_update AS date_update_7, t0.titre_fr AS titre_fr_8, t0.titre_en AS titre_en_9, t0.titre_de AS titre_de_10, t0.titre_be AS titre_be_11 FROM menu_links t0 WHERE t0.display_position = ? AND t0.status = ?
Parameters:
[
  "footer_droite"
  "Actif"
]
12 1.11 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.icon AS icon_3, t0.dir AS dir_4, t0.link AS link_5, t0.status AS status_6, t0.display_position AS display_position_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9 FROM social_links t0 WHERE t0.status = ?
Parameters:
[
  "Actif"
]
13 0.55 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FR"
]
14 0.97 ms
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM condition_generale t0 WHERE t0.langue_id = ? LIMIT 1
Parameters:
[
  1
]
15 1.08 ms
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM cgi t0 WHERE t0.langue_id = ? LIMIT 1
Parameters:
[
  1
]
16 1.30 ms
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM mentions_legales t0 WHERE t0.langue_id = ? LIMIT 1
Parameters:
[
  1
]
17 0.69 ms
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.icon AS icon_3, t0.dir AS dir_4, t0.link AS link_5, t0.status AS status_6, t0.display_position AS display_position_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9 FROM social_links t0 WHERE t0.link IS NULL
Parameters:
[]
18 0.55 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FR"
]
19 0.31 ms
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
  "FR"
]
20 0.69 ms
SELECT t0.id AS id_1, t0.route AS route_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.libelles_traduits AS libelles_traduits_5, t0.langue_id AS langue_id_6 FROM traduction t0 WHERE t0.route = ? AND t0.langue_id = ? LIMIT 1
Parameters:
[
  "accueil"
  1
]
21 0.47 ms
SELECT t0.id AS id_1, t0.route AS route_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.libelles_traduits AS libelles_traduits_5, t0.langue_id AS langue_id_6 FROM traduction t0 WHERE t0.route = ? AND t0.langue_id = ? LIMIT 1
Parameters:
[
  "footer"
  1
]
22 0.53 ms
SELECT t0.id AS id_1, t0.route AS route_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.libelles_traduits AS libelles_traduits_5, t0.langue_id AS langue_id_6 FROM traduction t0 WHERE t0.route = ? AND t0.langue_id = ? LIMIT 1
Parameters:
[
  "header"
  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\Langue
  • The field App\Entity\Langue#traductions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Traduction#langue does not contain the required 'inversedBy="traductions"' attribute.
App\Entity\Traduction No errors.
App\Entity\Pays No errors.
App\Entity\Departement No errors.
App\Entity\Region
  • The field App\Entity\Region#children is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Departement#region does not contain the required 'inversedBy="children"' attribute.
App\Entity\Publicite No errors.
App\Entity\Entreprise No errors.
App\Entity\Etat No errors.
App\Entity\CoutJournalier No errors.
App\Entity\User No errors.
App\Entity\Filiale
  • The association App\Entity\Filiale#gestionnaire refers to the inverse side field App\Entity\GestionnaireFiliale#filiales which does not exist.
App\Entity\MenuLinks No errors.
App\Entity\SocialLinks No errors.
App\Entity\ConditionGenerale No errors.
App\Entity\Cgi No errors.
App\Entity\MentionsLegales No errors.