Query Metrics
3
Database Queries
3
Different statements
21.01 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.79 ms |
SELECT a0_.id AS id_0, a0_.code_negociateur AS code_negociateur_1, a0_.slug AS slug_2, a0_.prenom AS prenom_3, a0_.nom AS nom_4, a0_.is_actif AS is_actif_5, a0_.siret AS siret_6, a0_.raison_sociale AS raison_sociale_7, a0_.cos_id AS cos_id_8, a0_.photo AS photo_9, a0_.bio AS bio_10, a0_.secteur AS secteur_11, a0_.cp AS cp_12, a0_.latitude AS latitude_13, a0_.longitude AS longitude_14, a0_.email AS email_15, a0_.telephone AS telephone_16, a0_.whatsapp AS whatsapp_17, a0_.facebook AS facebook_18, a0_.twitter AS twitter_19, a0_.linkedin AS linkedin_20, a0_.instagram AS instagram_21, a0_.video AS video_22, a0_.comment AS comment_23, a0_.rating AS rating_24, a0_.fonction AS fonction_25, a0_.created_at AS created_at_26, a0_.updated_at AS updated_at_27, a0_.deleted_at AS deleted_at_28 FROM agent a0_ WHERE (a0_.slug = ? AND a0_.is_actif = 1) AND (a0_.deleted_at IS NULL)
Parameters:
[
"aurelie-bersier"
]
|
| 2 | 19.57 ms |
SELECT e0_.id AS id_0, e0_.refannonce AS refannonce_1, e0_.identifiant_technique AS identifiant_technique_2, e0_.numeromandat AS numeromandat_3, e0_.mandat_at AS mandat_at_4, e0_.statut AS statut_5, e0_.statut_name AS statut_name_6, e0_.slug AS slug_7, e0_.typebien AS typebien_8, e0_.si_mandatexclusif AS si_mandatexclusif_9, e0_.libelle AS libelle_10, e0_.descriptif AS descriptif_11, e0_.prix AS prix_12, e0_.surface AS surface_13, e0_.surf_terrain AS surf_terrain_14, e0_.nbpieces AS nbpieces_15, e0_.nbchambres AS nbchambres_16, e0_.latitude AS latitude_17, e0_.longitude AS longitude_18, e0_.orientation AS orientation_19, e0_.photos AS photos_20, e0_.features AS features_21, e0_.icones AS icones_22, e0_.is_new_checked AS is_new_checked_23, e0_.is_delete_checked AS is_delete_checked_24, e0_.import_type AS import_type_25, e0_.ca AS ca_26, e0_.ebe AS ebe_27, e0_.created_at AS created_at_28, e0_.updated_at AS updated_at_29, e0_.deleted_at AS deleted_at_30, a1_.id AS id_31, a1_.code_negociateur AS code_negociateur_32, a1_.slug AS slug_33, a1_.prenom AS prenom_34, a1_.nom AS nom_35, a1_.is_actif AS is_actif_36, a1_.siret AS siret_37, a1_.raison_sociale AS raison_sociale_38, a1_.cos_id AS cos_id_39, a1_.photo AS photo_40, a1_.bio AS bio_41, a1_.secteur AS secteur_42, a1_.cp AS cp_43, a1_.latitude AS latitude_44, a1_.longitude AS longitude_45, a1_.email AS email_46, a1_.telephone AS telephone_47, a1_.whatsapp AS whatsapp_48, a1_.facebook AS facebook_49, a1_.twitter AS twitter_50, a1_.linkedin AS linkedin_51, a1_.instagram AS instagram_52, a1_.video AS video_53, a1_.comment AS comment_54, a1_.rating AS rating_55, a1_.fonction AS fonction_56, a1_.created_at AS created_at_57, a1_.updated_at AS updated_at_58, a1_.deleted_at AS deleted_at_59, a2_.id AS id_60, a2_.code_negociateur AS code_negociateur_61, a2_.slug AS slug_62, a2_.prenom AS prenom_63, a2_.nom AS nom_64, a2_.is_actif AS is_actif_65, a2_.siret AS siret_66, a2_.raison_sociale AS raison_sociale_67, a2_.cos_id AS cos_id_68, a2_.photo AS photo_69, a2_.bio AS bio_70, a2_.secteur AS secteur_71, a2_.cp AS cp_72, a2_.latitude AS latitude_73, a2_.longitude AS longitude_74, a2_.email AS email_75, a2_.telephone AS telephone_76, a2_.whatsapp AS whatsapp_77, a2_.facebook AS facebook_78, a2_.twitter AS twitter_79, a2_.linkedin AS linkedin_80, a2_.instagram AS instagram_81, a2_.video AS video_82, a2_.comment AS comment_83, a2_.rating AS rating_84, a2_.fonction AS fonction_85, a2_.created_at AS created_at_86, a2_.updated_at AS updated_at_87, a2_.deleted_at AS deleted_at_88, e0_.agent_id AS agent_id_89, e0_.sous_type_id AS sous_type_id_90 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) LEFT JOIN share_with_agents s3_ ON e0_.id = s3_.estate_id LEFT JOIN agent a2_ ON a2_.id = s3_.agent_id AND (a2_.deleted_at IS NULL) WHERE ((a1_.id = ? OR (a2_.id = ? AND e0_.statut_name IN ('sold', 'under_contract')))) AND (e0_.deleted_at IS NULL) ORDER BY e0_.si_mandatexclusif DESC, e0_.numeromandat DESC
Parameters:
[ 151 151 ] |
| 3 | 0.65 ms |
SELECT t0.id AS id_1, t0.survey_id AS survey_id_2, t0.author AS author_3, t0.subject AS subject_4, t0.comment AS comment_5, t0.date AS date_6, t0.collaborator_id AS collaborator_id_7, t0.rating AS rating_8, t0.agent_id AS agent_id_9 FROM review t0 WHERE t0.agent_id = ? ORDER BY t0.date DESC
Parameters:
[
151
]
|
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\Agent | No errors. |
| App\Entity\Estate | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\SousType | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SearchNotification | No errors. |
| App\Entity\Search | No errors. |
| App\Entity\Purchaser | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\Photo | No errors. |
| App\Entity\VideoCategory | No errors. |
| App\Entity\TutorielCategory | No errors. |
| App\Entity\Config | No errors. |
| App\Entity\Tutoriel | No errors. |
| App\Entity\Progiciel | No errors. |
| App\Entity\Video | No errors. |
| App\Entity\History | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| Setono\GoogleAnalyticsServerSideTrackingBundle\Entity\Hit | No errors. |