Query Metrics
24
Database Queries
17
Different statements
36.55 ms
Query time
2
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 1.83 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"
]
|
||||||||||||||||||||||||||
| 2 | 1.07 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:
[]
|
||||||||||||||||||||||||||
| 3 | 0.98 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 | 3.33 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 = ? ORDER BY t0.nom ASC
Parameters:
[
75
]
|
||||||||||||||||||||||||||
| 5 | 10.55 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.description AS description_3, t0.parents AS parents_4, t0.etat AS etat_5, t0.niveau AS niveau_6, t0.token AS token_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9, t0.type AS type_10, t0.image AS image_11, t0.dir AS dir_12, t0.pays AS pays_13, t0.departements AS departements_14, t0.topbar AS topbar_15, t0.sidebar AS sidebar_16, t0.id_topbar AS id_topbar_17, t0.libelle AS libelle_18, t0.super_parents AS super_parents_19, t0.synonymes AS synonymes_20, t0.num_competence AS num_competence_21, t0.num_parent AS num_parent_22, t0.url AS url_23, t0.nom_fr AS nom_fr_24, t0.nom_en AS nom_en_25, t0.nom_de AS nom_de_26, t0.nom_be AS nom_be_27, t0.restriction_pays AS restriction_pays_28, t0.arr_questions AS arr_questions_29, t0.cout AS cout_30, t0.abreviation_type AS abreviation_type_31, t0.is_expert AS is_expert_32, t0.is_interest AS is_interest_33, t0.group_type AS group_type_34, t0.expert_attributes AS expert_attributes_35, t0.interest_attributes AS interest_attributes_36, t0.ape_id AS ape_id_37, t0.demandeur_entreprise_id AS demandeur_entreprise_id_38 FROM competences t0 ORDER BY t0.nom ASC
Parameters:
[]
|
||||||||||||||||||||||||||
| 6 | 1.19 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"
]
|
||||||||||||||||||||||||||
| 7 | 0.94 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 ]
|
||||||||||||||||||||||||||
| 8 | 0.44 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 ]
|
||||||||||||||||||||||||||
| 9 | 0.48 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 ]
|
||||||||||||||||||||||||||
| 10 | 0.83 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
]
|
||||||||||||||||||||||||||
| 11 | 1.38 ms |
SELECT p0_.id AS id_0, p0_.code AS code_1, p0_.alpha2 AS alpha2_2, p0_.alpha3 AS alpha3_3, p0_.nom_en_gb AS nom_en_gb_4, p0_.nom_fr_fr AS nom_fr_fr_5, p0_.tva AS tva_6 FROM pays p0_ WHERE p0_.tva IS NOT NULL AND p0_.tva <> ?
Parameters:
[ "" ]
|
||||||||||||||||||||||||||
| 12 | 1.02 ms |
SELECT t0.id AS id_1, t0.taille AS taille_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4 FROM taille_entreprise t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 13 | 2.95 ms |
SELECT t0.id AS id_1, t0.ape AS ape_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.division AS division_5, t0.activites AS activites_6, t0.mot_cle AS mot_cle_7, t0.class AS class_8, t0.wz AS wz_9, t0.etat AS etat_10, t0.code_abreviation AS code_abreviation_11, t0.activite_de AS activite_de_12, t0.activite_en AS activite_en_13, t0.sous_section AS sous_section_14 FROM ape t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 14 | 1.32 ms |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.slug AS slug_3, t0.titre_accroche AS titre_accroche_4, t0.description AS description_5, t0.menu_links AS menu_links_6, t0.horaire_mairie AS horaire_mairie_7, t0.liens_demarches AS liens_demarches_8, t0.liens_agenda AS liens_agenda_9, t0.background_image AS background_image_10, t0.dir_bg AS dir_bg_11, t0.image AS image_12, t0.dir_image AS dir_image_13, t0.date_creation AS date_creation_14, t0.services_lateraux AS services_lateraux_15, t0.commune_id AS commune_id_16, t0.gestionnaire_id AS gestionnaire_id_17 FROM ville t0
Parameters:
[]
|
||||||||||||||||||||||||||
| 15 | 0.67 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"
]
|
||||||||||||||||||||||||||
| 16 | 0.44 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 ]
|
||||||||||||||||||||||||||
| 17 | 0.59 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" ]
|
||||||||||||||||||||||||||
| 18 | 0.78 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" ]
|
||||||||||||||||||||||||||
| 19 | 0.91 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"
]
|
||||||||||||||||||||||||||
| 20 | 0.88 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"
]
|
||||||||||||||||||||||||||
| 21 | 1.21 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
]
|
||||||||||||||||||||||||||
| 22 | 1.07 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
]
|
||||||||||||||||||||||||||
| 23 | 1.17 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
]
|
||||||||||||||||||||||||||
| 24 | 0.53 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:
[]
|
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 |
|
| App\Entity\Traduction | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Region |
|
| App\Entity\Competences | No errors. |
| App\Entity\Ape | No errors. |
| App\Entity\Entreprise | No errors. |
| App\Entity\TailleEntreprise | No errors. |
| App\Entity\Ville | No errors. |
| App\Entity\Communes | No errors. |
| App\Entity\GestionnaireVille | No errors. |
| 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. |