GET https://sandbox.bourse-aux-logements.fr/inscription

Query Metrics

42 Database Queries
7 Different statements
10.02 ms Query time
3 Invalid entities
43 Managed entities

Queries

Group similar statements

# 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
  • The field App\Entity\UserFo#ufo_cpf_id is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\CompositionFamiliale#cpf_user_fo_id does not contain the required 'inversedBy="ufo_cpf_id"' attribute.
App\Entity\TypeContactPrivilegie No errors.
App\Entity\Bailleur No errors.
App\Entity\Logement
  • The field 'App\Entity\Logement#log_latitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Logement#log_longitude' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Logement#log_surface' has the property type 'int' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Logement#log_montant_loyer' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
  • The field 'App\Entity\Logement#log_montant_charge' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
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
  • The field 'App\Entity\Region#tncc' has the property type 'string' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\Notation No errors.