Query Metrics
10
Database Queries
10
Different statements
6.63 ms
Query time
6
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.33 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.nom AS nom_5, t0.prenom AS prenom_6, t0.titre AS titre_7, t0.photo AS photo_8, t0.telfixe AS telfixe_9, t0.telmobile AS telmobile_10, t0.telstandard AS telstandard_11, t0.textePresentation AS textePresentation_12, t0.twitter AS twitter_13, t0.linkedin AS linkedin_14, t0.tokenConnection AS tokenConnection_15, t0.principal AS principal_16, t0.droits AS droits_17, t0.idHB AS idHB_18, t0.didaDash AS didaDash_19, t0.didaSelect AS didaSelect_20, t0.didaDetails AS didaDetails_21, t0.enabled AS enabled_22, t0.last_login AS last_login_23, t0.username AS username_24, t0.username_canonical AS username_canonical_25, t0.email_canonical AS email_canonical_26, t0.salt AS salt_27, t0.locked AS locked_28, t0.expired AS expired_29, t0.confirmation_token AS confirmation_token_30, t0.password_requested_at AS password_requested_at_31, t0.credentials_expired AS credentials_expired_32, t0.expires_at AS expires_at_33, t0.credentials_expire_at AS credentials_expire_at_34, t0.is_doc AS is_doc_35, t0.access_token_id AS access_token_id_36, t0.franchise_id AS franchise_id_37, t0.societemere_id AS societemere_id_38, t0.statut_id AS statut_id_39 FROM user t0 WHERE t0.id = ?
Parameters:
[
9763
]
|
| 2 | 0.58 ms |
SELECT t0.id AS id_1, t0.nom_immeuble AS nom_immeuble_2, t0.numero AS numero_3, t0.adresse AS adresse_4, t0.cp AS cp_5, t0.ville AS ville_6, t0.secteur_geographique AS secteur_geographique_7, t0.adresse_bis AS adresse_bis_8, t0.surface_totale AS surface_totale_9, t0.construit_le AS construit_le_10, t0.restructure_le AS restructure_le_11, t0.latitude AS latitude_12, t0.longitude AS longitude_13, t0.proprio_commentaires AS proprio_commentaires_14, t0.mandant_commentaires AS mandant_commentaires_15 FROM immeuble t0 WHERE t0.id = ?
Parameters:
[
"5080"
]
|
| 3 | 0.55 ms |
SELECT t0.id AS id_1, t0.id_hub_spot AS id_hub_spot_2 FROM proprios t0 INNER JOIN proprios_immeuble ON t0.id = proprios_immeuble.proprios_id WHERE proprios_immeuble.immeuble_id = ?
Parameters:
[
5080
]
|
| 4 | 0.41 ms |
SELECT t0.id AS id_1, t0.id_hub_spot AS id_hub_spot_2 FROM mandants t0 INNER JOIN mandants_immeuble ON t0.id = mandants_immeuble.mandants_id WHERE mandants_immeuble.immeuble_id = ?
Parameters:
[
5080
]
|
| 5 | 1.10 ms |
SELECT t0.id AS id_1, t0.directe AS directe_2, t0.premium AS premium_3, t0.adresse AS adresse_4, t0.cp AS cp_5, t0.ville AS ville_6, t0.accroche AS accroche_7, t0.condifi AS condifi_8, t0.ref_interne AS ref_interne_9, t0.descriptif AS descriptif_10, t0.equipement AS equipement_11, t0.dispo AS dispo_12, t0.photo1 AS photo1_13, t0.photo2 AS photo2_14, t0.photo3 AS photo3_15, t0.photo4 AS photo4_16, t0.photo5 AS photo5_17, t0.photo6 AS photo6_18, t0.photo7 AS photo7_19, t0.photo8 AS photo8_20, t0.photo9 AS photo9_21, t0.photo10 AS photo10_22, t0.pIntNb AS pIntNb_23, t0.pIntLoyer AS pIntLoyer_24, t0.pIntPrix AS pIntPrix_25, t0.pExtNb AS pExtNb_26, t0.pExtLoyer AS pExtLoyer_27, t0.pExtPrix AS pExtPrix_28, t0.cession AS cession_29, t0.desserte AS desserte_30, t0.nomConsultant AS nomConsultant_31, t0.telConsultant AS telConsultant_32, t0.mailConsultant AS mailConsultant_33, t0.divisible AS divisible_34, t0.dateModif AS dateModif_35, t0.virtualUrl AS virtualUrl_36, t0.dpeChiffre AS dpeChiffre_37, t0.dpeLettre AS dpeLettre_38, t0.gesChiffre AS gesChiffre_39, t0.gesLettre AS gesLettre_40, t0.active AS active_41, t0.surfaceDiv AS surfaceDiv_42, t0.surfaceTot AS surfaceTot_43, t0.latitude AS latitude_44, t0.longitude AS longitude_45, t0.dateFin AS dateFin_46, t0.activeLe AS activeLe_47, t0.prixVenteGlobal AS prixVenteGlobal_48, t0.prixVenteM AS prixVenteM_49, t0.secteurGeo AS secteurGeo_50, t0.bail AS bail_51, t0.foncier AS foncier_52, t0.taxebureaux AS taxebureaux_53, t0.honoP AS honoP_54, t0.honoT AS honoT_55, t0.classification AS classification_56, t0.indexation AS indexation_57, t0.modalites AS modalites_58, t0.regimeFiscal AS regimeFiscal_59, t0.plan1 AS plan1_60, t0.plan2 AS plan2_61, t0.plan3 AS plan3_62, t0.plan4 AS plan4_63, t0.plan5 AS plan5_64, t0.plan6 AS plan6_65, t0.plan7 AS plan7_66, t0.plan8 AS plan8_67, t0.plan9 AS plan9_68, t0.plan10 AS plan10_69, t0.libphoto1 AS libphoto1_70, t0.libphoto2 AS libphoto2_71, t0.libphoto3 AS libphoto3_72, t0.libphoto4 AS libphoto4_73, t0.libphoto5 AS libphoto5_74, t0.libphoto6 AS libphoto6_75, t0.libphoto7 AS libphoto7_76, t0.libphoto8 AS libphoto8_77, t0.libphoto9 AS libphoto9_78, t0.libphoto10 AS libphoto10_79, t0.libplan1 AS libplan1_80, t0.libplan2 AS libplan2_81, t0.libplan3 AS libplan3_82, t0.libplan4 AS libplan4_83, t0.libplan5 AS libplan5_84, t0.libplan6 AS libplan6_85, t0.libplan7 AS libplan7_86, t0.libplan8 AS libplan8_87, t0.libplan9 AS libplan9_88, t0.libplan10 AS libplan10_89, t0.descroUrl AS descroUrl_90, t0.mobileConsultant AS mobileConsultant_91, t0.loyerAnnuel AS loyerAnnuel_92, t0.loyerMensuel AS loyerMensuel_93, t0.loyerM AS loyerM_94, t0.loyerArchive AS loyerArchive_95, t0.loyerRIE AS loyerRIE_96, t0.depotGarantieE AS depotGarantieE_97, t0.depotGarantieTxt AS depotGarantieTxt_98, t0.droitEntreeE AS droitEntreeE_99, t0.droitEntreeTxt AS droitEntreeTxt_100, t0.fraisRedacE AS fraisRedacE_101, t0.fraisRedacTxt AS fraisRedacTxt_102, t0.franchiseE AS franchiseE_103, t0.franchiseMois AS franchiseMois_104, t0.franchiseTxt AS franchiseTxt_105, t0.honoE AS honoE_106, t0.taxeActivite AS taxeActivite_107, t0.taxeCommerce AS taxeCommerce_108, t0.taxeParking AS taxeParking_109, t0.teom AS teom_110, t0.txRendement AS txRendement_111, t0.independant AS independant_112, t0.haussmann AS haussmann_113, t0.neuf AS neuf_114, t0.rie AS rie_115, t0.enetage AS enetage_116, t0.unetage AS unetage_117, t0.accueil AS accueil_118, t0.securise AS securise_119, t0.openspace AS openspace_120, t0.fauxplafond AS fauxplafond_121, t0.parquet AS parquet_122, t0.tbj AS tbj_123, t0.clim AS clim_124, t0.cuisine AS cuisine_125, t0.pmr AS pmr_126, t0.erp AS erp_127, t0.fibre AS fibre_128, t0.niveau AS niveau_129, t0.rdc AS rdc_130, t0.ancien AS ancien_131, t0.lumineux AS lumineux_132, t0.atypique AS atypique_133, t0.igh AS igh_134, t0.confreres AS confreres_135, t0.etatLieux AS etatLieux_136, t0.archive AS archive_137, t0.communs AS communs_138, t0.homestaging AS homestaging_139, t0.vtour AS vtour_140, t0.plan3D AS plan3D_141, t0.dateCreation AS dateCreation_142, t0.dateArchivage AS dateArchivage_143, t0.con_ref_confrere AS con_ref_confrere_144, t0.raison_confrere AS raison_confrere_145, t0.adresse_confrere AS adresse_confrere_146, t0.cp_confrere AS cp_confrere_147, t0.ville_confrere AS ville_confrere_148, t0.tel_confrere AS tel_confrere_149, t0.fax_confrere AS fax_confrere_150, t0.nom_nego AS nom_nego_151, t0.mobile_nego AS mobile_nego_152, t0.fixe_nego AS fixe_nego_153, t0.email_nego AS email_nego_154, t0.con_ref_proprio AS con_ref_proprio_155, t0.raison_proprio AS raison_proprio_156, t0.adresse_proprio AS adresse_proprio_157, t0.cp_proprio AS cp_proprio_158, t0.ville_proprio AS ville_proprio_159, t0.tel_proprio AS tel_proprio_160, t0.fax_proprio AS fax_proprio_161, t0.nom_propriop AS nom_propriop_162, t0.mobile_propriop AS mobile_propriop_163, t0.fixe_propriop AS fixe_propriop_164, t0.email_propriop AS email_propriop_165, t0.mode_visite AS mode_visite_166, t0.futur AS futur_167, t0.sousoption AS sousoption_168, t0.popupdispo AS popupdispo_169, t0.observations AS observations_170, t0.commentaires AS commentaires_171, t0.strategique AS strategique_172, t0.date_demande_maj AS date_demande_maj_173, t0.nom_consultant_deux AS nom_consultant_deux_174, t0.tel_consultant_deux AS tel_consultant_deux_175, t0.mail_consultant_deux AS mail_consultant_deux_176, t0.mobile_consultant_deux AS mobile_consultant_deux_177, t0.offre_ref_confrere AS offre_ref_confrere_178, t0.principe_diffusion AS principe_diffusion_179, t0.cm2_euro AS cm2_euro_180, t0.cmois_euro AS cmois_euro_181, t0.can_euro AS can_euro_182, t0.cp_ref_propio AS cp_ref_propio_183, t0.con_ref_mandant AS con_ref_mandant_184, t0.cp_ref_mandant AS cp_ref_mandant_185, t0.cowork AS cowork_186, t0.nb_bureaux AS nb_bureaux_187, t0.loyer_un_mois AS loyer_un_mois_188, t0.loyer_tot_mois AS loyer_tot_mois_189, t0.confidentielle AS confidentielle_190, t0.exclu AS exclu_191, t0.nature AS nature_192, t0.type_offre AS type_offre_193, t0.immeuble_id AS immeuble_id_194, t0.diffusion_id AS diffusion_id_195 FROM offre t0 WHERE t0.immeuble_id = ?
Parameters:
[
5080
]
|
| 6 | 0.82 ms |
SELECT t0.id AS id_1, t0.refarea AS refarea_2, t0.nom AS nom_3, t0.adresse AS adresse_4, t0.cp AS cp_5, t0.tel AS tel_6, t0.logo AS logo_7, t0.hashtag AS hashtag_8, t0.ville AS ville_9, t0.franchise_id AS franchise_id_10 FROM confrere t0 WHERE t0.refarea = ? LIMIT 1
Parameters:
[
"77"
]
|
| 7 | 0.57 ms |
SELECT t0.id AS id_1, t0.manager AS manager_2, t0.equipeId AS equipeId_3, t0.userId AS userId_4 FROM equipe_collaborateur t0 WHERE t0.userId = ?
Parameters:
[
9763
]
|
| 8 | 0.45 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM nature t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 9 | 0.37 ms |
SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type_o t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 10 | 0.46 ms |
SELECT t0.id AS id_1, t0.type AS type_2, t0.raison AS raison_3, t0.naf AS naf_4, t0.adresse AS adresse_5, t0.cp AS cp_6, t0.ville AS ville_7, t0.telephone AS telephone_8, t0.suiveur AS suiveur_9, t0.type_multiple AS type_multiple_10, t0.siret AS siret_11, t0.grp_proprio_id AS grp_proprio_id_12 FROM proprios_area t0 INNER JOIN proprios_area_immeuble ON t0.id = proprios_area_immeuble.proprios_area_id WHERE proprios_area_immeuble.immeuble_id = ?
Parameters:
[
5080
]
|
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 |
|
| App\Entity\AccessToken | No errors. |
| App\Entity\Franchise | No errors. |
| App\Entity\Societe | No errors. |
| App\Entity\Statut | No errors. |
| App\Entity\EquipeCollaborateur | No errors. |
| App\Entity\Logs | No errors. |
| App\Entity\Recherche | No errors. |
| App\Entity\Visites | No errors. |
| App\Entity\Immeuble | No errors. |
| App\Entity\Offre |
|
| App\Entity\Mandants | No errors. |
| App\Entity\Proprios | No errors. |
| App\Entity\PropriosArea |
|
| App\Entity\Nature | No errors. |
| App\Entity\TypeO |
|
| App\Entity\Diffusion |
|
| App\Entity\Alerte |
|
| App\Entity\Mandat | No errors. |
| App\Entity\OffreHasActions | No errors. |
| App\Entity\SocieteHasDocuments | No errors. |
| App\Entity\RechercheHasOffres | No errors. |
| App\Entity\SondageHasOffres | No errors. |
| App\Entity\Calculette | No errors. |
| App\Entity\SelectionHasOffres | No errors. |
| App\Entity\Confrere | No errors. |
| App\Entity\Equipe | No errors. |
| App\Entity\Document | No errors. |