Query Metrics
42
Database Queries
7
Different statements
10.02 ms
Query time
3
Invalid entities
43
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.30 ms |
SELECT t0.faq_id AS faq_id_1, t0.faq_question AS faq_question_2, t0.faq_reponse AS faq_reponse_3, t0.faq_affich_home AS faq_affich_home_4, t0.categorie_faq AS categorie_faq_5 FROM faq t0 WHERE t0.categorie_faq = ?
Parameters:
[
7
]
|
| 2 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_EMAIL_MODIFICATION_TOKEN"
]
|
| 3 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_INACTIVITE"
]
|
| 4 | 0.23 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_INACTIVITE_COMPTE_NON_FINALISE"
]
|
| 5 | 0.23 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_DESACTIVATION"
]
|
| 6 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_DESACTIVATION_COMPTE_NON_FINALISE"
]
|
| 7 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_DESACTIVATION"
]
|
| 8 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_DESACTIVATION_COMPTE_NON_FINALISE"
]
|
| 9 | 0.17 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_INSCRIPTION_REFUSEE"
]
|
| 10 | 0.15 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_INSCRIPTION_NON_ABOUTIE"
]
|
| 11 | 0.15 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_DESINSCRIPTION"
]
|
| 12 | 0.16 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_RELANCE_DEMANDE_CONTACT"
]
|
| 13 | 0.25 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_DEMANDE_CONTACT"
]
|
| 14 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_RELANCE_DEMANDE_VISITE"
]
|
| 15 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_DEMANDE_VISITE"
]
|
| 16 | 0.23 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_DEMANDE_NON_ABOUTIE"
]
|
| 17 | 0.16 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_ECHANGE_REFUSE"
]
|
| 18 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_SUPPR_ECHANGE_VALIDE"
]
|
| 19 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_ALERTE_INSCRIPTION"
]
|
| 20 | 0.16 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_TEMPO_NOTATION"
]
|
| 21 | 0.16 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MIN_PHOTOS"
]
|
| 22 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_PHOTOS"
]
|
| 23 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_TYPOLOGIES_RECHERCHE"
]
|
| 24 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_COMMUNES_RECHERCHE"
]
|
| 25 | 0.16 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"AIDE_ANNONCES_LOGEMENT"
]
|
| 26 | 0.15 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"PRE_LAUNCHED"
]
|
| 27 | 0.24 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"PRE_LAUNCHED_MESSAGE"
]
|
| 28 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"FORMULAIRE_QUALITE"
]
|
| 29 | 0.23 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_ARCHIVAGE_AUTOMATIQUE"
]
|
| 30 | 0.29 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DESTINATAIRES_RAPPORTS_MENSUELS"
]
|
| 31 | 0.34 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_SIGNALEMENTS"
]
|
| 32 | 0.32 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"DELAI_TEMPO_SIGNALEMENT"
]
|
| 33 | 0.37 ms |
SELECT t0.blr_id AS blr_id_1, t0.blr_nom AS blr_nom_2, t0.blr_num_interne AS blr_num_interne_3, t0.blr_mail_rapport_import AS blr_mail_rapport_import_4, t0.blr_actif AS blr_actif_5, t0.blr_logo AS blr_logo_6, t0.blr_aide_inscri AS blr_aide_inscri_7, t0.blr_telephone_contact AS blr_telephone_contact_8, t0.blr_mail_contact AS blr_mail_contact_9, t0.blr_url_site_internet AS blr_url_site_internet_10, t0.blr_ddc AS blr_ddc_11, t0.blr_ddm AS blr_ddm_12, t0.blr_chart_color AS blr_chart_color_13 FROM bailleur t0 WHERE t0.blr_actif = ? ORDER BY t0.blr_nom ASC
Parameters:
[
1
]
|
| 34 | 0.32 ms |
SELECT t0_.tcp_id AS tcp_id_0, t0_.tcp_libelle AS tcp_libelle_1 FROM type_contact_privilegie t0_
Parameters:
[] |
| 35 | 0.45 ms |
SELECT b0_.blr_id AS blr_id_0, b0_.blr_nom AS blr_nom_1, b0_.blr_num_interne AS blr_num_interne_2, b0_.blr_mail_rapport_import AS blr_mail_rapport_import_3, b0_.blr_actif AS blr_actif_4, b0_.blr_logo AS blr_logo_5, b0_.blr_aide_inscri AS blr_aide_inscri_6, b0_.blr_telephone_contact AS blr_telephone_contact_7, b0_.blr_mail_contact AS blr_mail_contact_8, b0_.blr_url_site_internet AS blr_url_site_internet_9, b0_.blr_ddc AS blr_ddc_10, b0_.blr_ddm AS blr_ddm_11, b0_.blr_chart_color AS blr_chart_color_12 FROM bailleur b0_ WHERE b0_.blr_actif = 1 ORDER BY b0_.blr_nom ASC
Parameters:
[] |
| 36 | 0.34 ms |
SELECT t0_.tpg_id AS tpg_id_0, t0_.tpg_libelle AS tpg_libelle_1, t0_.tpg_reference AS tpg_reference_2, t0_.tpg_chart_color AS tpg_chart_color_3 FROM typologie t0_
Parameters:
[] |
| 37 | 0.34 ms |
SELECT c0_.com_id AS com_id_0, c0_.com_code_postal AS com_code_postal_1, c0_.com_libelle AS com_libelle_2, c0_.com_ncc AS com_ncc_3, c0_.com_code_insee AS com_code_insee_4, c0_.departement AS departement_5, c0_.com_actif AS com_actif_6, c0_.com_geopoint AS com_geopoint_7, c0_.com_geoshape AS com_geoshape_8, c0_.com_groupement AS com_groupement_9, c0_.com_rel_id AS com_rel_id_10 FROM commune c0_ LIMIT 0
Parameters:
[] |
| 38 | 0.23 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_TYPOLOGIES_RECHERCHE"
]
|
| 39 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_COMMUNES_RECHERCHE"
]
|
| 40 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MAX_PHOTOS"
]
|
| 41 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"NB_MIN_PHOTOS"
]
|
| 42 | 0.22 ms |
SELECT t0.par_id AS par_id_1, t0.par_reference AS par_reference_2, t0.par_valeur AS par_valeur_3, t0.par_libelle AS par_libelle_4 FROM parametre t0 WHERE t0.par_reference = ? LIMIT 1
Parameters:
[
"AIDE_ANNONCES_LOGEMENT"
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| App\Entity\Parametre | 22 |
| App\Entity\Bailleur | 11 |
| App\Entity\Typologie | 6 |
| App\Entity\TypeContactPrivilegie | 4 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| FOS\UserBundle\Model\User | No errors. |
| App\Entity\User | No errors. |
| App\Entity\UserFo |
|
| App\Entity\TypeContactPrivilegie | No errors. |
| App\Entity\Bailleur | No errors. |
| App\Entity\Logement |
|
| App\Entity\Typologie | No errors. |
| App\Entity\Commune | No errors. |
| App\Entity\Faq | No errors. |
| App\Entity\CategorieFaq | No errors. |
| App\Entity\Parametre | No errors. |
| App\Entity\Region |
|
| App\Entity\Notation | No errors. |