GET https://app.master-immo.net/reservation/new

Query Metrics

1648 Database Queries
6 Different statements
393.88 ms Query time
4 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
348.91 ms
(88.58%)
1636
SELECT t0.id AS id_1, t0.reftier AS reftier_2, t0.gender AS gender_3, t0.dep AS dep_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.address AS address_7, t0.zip_code AS zip_code_8, t0.city AS city_9, t0.country AS country_10, t0.phone AS phone_11, t0.cin AS cin_12, t0.datenaiss AS datenaiss_13, t0.lieunaiss AS lieunaiss_14, t0.phone2 AS phone2_15, t0.facebook AS facebook_16, t0.etatcivil AS etatcivil_17, t0.besoin AS besoin_18, t0.profession AS profession_19, t0.hierarchie AS hierarchie_20, t0.decideurs AS decideurs_21, t0.etat_mat AS etat_mat_22, t0.email AS email_23, t0.nationalite AS nationalite_24, t0.email_pro AS email_pro_25, t26.id AS id_27, t26.email AS email_28, t26.password AS password_29, t26.roles AS roles_30, t26.created_at AS created_at_31, t26.actif AS actif_32, t26.impersonator AS impersonator_33, t26.label AS label_34, t26.client_id AS client_id_35 FROM fos_user t0 LEFT JOIN client_user t26 ON t26.client_id = t0.id WHERE t0.id = ?
Parameters:
[
  2
]
37.88 ms
(9.62%)
1
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.typetiers = ?
Parameters:
[
  "client"
]
3.59 ms
(0.91%)
1
SELECT t0.id AS id_1, t0.Denprojet AS Denprojet_2, t0.restap AS restap_3, t0.idanal AS idanal_4, t0.codeprojet AS codeprojet_5, t0.sitjuridique AS sitjuridique_6, t0.Numtitrs AS Numtitrs_7, t0.Numregistre AS Numregistre_8, t0.Numfolio AS Numfolio_9, t0.sisea AS sisea_10, t0.fokotany AS fokotany_11, t0.Commune AS Commune_12, t0.District AS District_13, t0.Region AS Region_14, t0.Nompropriete AS Nompropriete_15, t0.contenance AS contenance_16, t0.proprietaire AS proprietaire_17, t0.Signataire AS Signataire_18, t0.PersonaPPV AS PersonaPPV_19, t0.PAterrain AS PAterrain_20, t0.contrat AS contrat_21, t0.categorie AS categorie_22, t0.refarch AS refarch_23, t0.coordong AS coordong_24, t0.aventage AS aventage_25, t0.inconv AS inconv_26, t0.contenance_av AS contenance_av_27, t0.piecejoint AS piecejoint_28, t0.suivie AS suivie_29, t0.description AS description_30, t0.coordinates AS coordinates_31, t0.date AS date_32, t0.axe AS axe_33, t0.type AS type_34, t0.min AS min_35, t0.max AS max_36, t0.supmin AS supmin_37, t0.supmax AS supmax_38, t0.noted AS noted_39, t0.budget AS budget_40, t0.budgets AS budgets_41, t0.public_visibility AS public_visibility_42, t0.nextcloud_path AS nextcloud_path_43, t0.nextcloud_share_url AS nextcloud_share_url_44, t0.fournisseur_id AS fournisseur_id_45, t0.logo_id AS logo_id_46, t0.image_principal_id AS image_principal_id_47 FROM terrain t0 WHERE t0.contrat = ?
Parameters:
[
  1
]
2.63 ms
(0.67%)
8
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.idtiers AS idtiers_3, t0.statut AS statut_4, t0.idCommercial AS idCommercial_5, t0.NomAlt AS NomAlt_6, t0.Sweb AS Sweb_7, t0.Fax AS Fax_8, t0.STAT AS STAT_9, t0.RCS AS RCS_10, t0.NIF AS NIF_11, t0.AssTva AS AssTva_12, t0.NumTva AS NumTva_13, t0.FormeJur AS FormeJur_14, t0.Effectif AS Effectif_15, t0.typetiers AS typetiers_16, t0.source AS source_17, t0.gender AS gender_18, t0.nompr AS nompr_19, t0.prenompr AS prenompr_20, t0.phonepr AS phonepr_21, t0.interes AS interes_22, t0.degr AS degr_23, t0.datec AS datec_24, t0.datetra AS datetra_25, t0.tra AS tra_26, t0.majnote AS majnote_27, t0.datemaj AS datemaj_28, t0.superficie AS superficie_29, t0.action AS action_30, t0.phonepr2 AS phonepr2_31, t0.budget AS budget_32, t0.status AS status_33, t0.urgence AS urgence_34, t0.provinces AS provinces_35, t0.axe AS axe_36, t0.projet AS projet_37, t0.created_at AS created_at_38, t0.emailpr AS emailpr_39, t0.client_user_id AS client_user_id_40 FROM tiers t0 WHERE t0.client_user_id = ?
Parameters:
[
  17
]
0.48 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4 FROM user t0 WHERE t0.id = ?
Parameters:
[
  39
]
0.39 ms
(0.10%)
1
SELECT t0.id AS id_1, t0.idUtilisateur AS idUtilisateur_2, t0.userid AS userid_3, t0.registerkey AS registerkey_4, t0.codetr AS codetr_5, t0.Fonction AS Fonction_6, t0.ClassPro AS ClassPro_7, t0.DateEmbauche AS DateEmbauche_8, t0.DateDebauche AS DateDebauche_9, t0.SalaireB AS SalaireB_10, t0.Nbenfant AS Nbenfant_11, t0.nb_enfant_fille AS nb_enfant_fille_12, t0.nb_enfant_garcon AS nb_enfant_garcon_13, t0.mere_en_vie AS mere_en_vie_14, t0.pere_en_vie AS pere_en_vie_15, t0.nb_proche AS nb_proche_16, t0.nb_proche_en_vie AS nb_proche_en_vie_17, t0.marital_status AS marital_status_18, t0.marriage_date AS marriage_date_19, t0.work_time_ratio AS work_time_ratio_20, t0.NbjourC AS NbjourC_21, t0.UpdateNbj AS UpdateNbj_22, t0.enable AS enable_23, t0.addDate AS addDate_24, t0.photo AS photo_25, t0.com AS com_26, t0.repartition AS repartition_27, t0.cicle AS cicle_28, t0.lastadd AS lastadd_29, t0.rang AS rang_30, t0.matricule AS matricule_31, t0.type_contrat AS type_contrat_32, t0.nextcloud_path AS nextcloud_path_33, t0.nextcloud_share_url AS nextcloud_share_url_34, t0.poste_id AS poste_id_35, t0.categorie_professionnelle_id AS categorie_professionnelle_id_36, t0.departement_id AS departement_id_37, t0.manager_id AS manager_id_38 FROM travailleur t0 WHERE t0.enable = ?
Parameters:
[
  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\User No errors.
App\Entity\ContractGroup No errors.
App\Entity\Documentation No errors.
App\Entity\Offre No errors.
App\Entity\Tiers No errors.
App\Entity\ClientUser No errors.
App\Entity\ActionAf No errors.
App\Entity\RedispacheTo No errors.
App\Entity\Terrain
  • The association App\Entity\Terrain#fournisseur refers to the inverse side field App\Entity\Fournisseur#terrains which does not exist.
App\Entity\Fournisseur No errors.
App\Entity\Image No errors.
App\Entity\ImageTerrain No errors.
App\Entity\TerrainTag No errors.
App\Entity\PropositionOffre No errors.
App\Entity\SourceTerrain No errors.
App\Entity\Contract
  • The field 'App\Entity\Contract#amount' has the property type 'int' that differs from the metadata field type 'string' returned by the 'bigint' DBAL type.
App\Entity\Promesse
  • The field App\Entity\Promesse#negociations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Negociation#compromis does not contain the required 'inversedBy="negociations"' attribute.
App\Entity\Reservation No errors.
App\Entity\Decaissement No errors.
App\Entity\Terrassement No errors.
App\Entity\CaisseCompte No errors.
App\Entity\Mutation No errors.
App\Entity\FosUser
  • The field App\Entity\FosUser#clientUser is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\ClientUser#client does not contain the required 'inversedBy="clientUser"' attribute.
  • The association App\Entity\FosUser#tiers refers to the owning side field App\Entity\Tiers#commercial which does not exist.
App\Entity\ObservationClient No errors.
App\Entity\Parrainage No errors.
App\Entity\Travailleur No errors.
App\Entity\Poste No errors.
App\Entity\CategorieProfessionnelle No errors.
App\Entity\Departement No errors.
App\Entity\TravailleurDocument No errors.