Query Metrics
14
Database Queries
7
Different statements
42.08 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.16 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.tags AS tags_3 FROM sous_type t0
Parameters:
[] |
| 2 | 17.86 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (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 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract') AND a1_.is_actif = 1 AND e0_.statut_name IN ('available', 'under_offer') AND e0_.typebien IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.numeromandat DESC) dctrn_result) dctrn_table
Parameters:
[
[
"boutique"
"entreprise"
"bureaux"
"entrepot"
"local"
]
]
|
| 3 | 0.35 ms |
SELECT e0_.prix AS prix_0, e0_.typebien AS typebien_1 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name IN ('available', 'under_offer') AND a1_.is_actif = 1) AND (e0_.deleted_at IS NULL) ORDER BY e0_.prix ASC
Parameters:
[] |
| 4 | 18.39 ms |
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, numeromandat_3 FROM (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 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract') AND a1_.is_actif = 1 AND e0_.statut_name IN ('available', 'under_offer') AND e0_.typebien IN (?)) AND (e0_.deleted_at IS NULL)) dctrn_result_inner ORDER BY numeromandat_3 DESC) dctrn_result LIMIT 99999999999
Parameters:
[
[
"boutique"
"entreprise"
"bureaux"
"entrepot"
"local"
]
]
|
| 5 | 3.18 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, e0_.agent_id AS agent_id_60, e0_.sous_type_id AS sous_type_id_61 FROM estate e0_ INNER JOIN agent a1_ ON e0_.agent_id = a1_.id AND (a1_.deleted_at IS NULL) WHERE (e0_.statut_name NOT IN ('under_contract') AND a1_.is_actif = 1 AND e0_.statut_name IN ('available', 'under_offer') AND e0_.typebien IN (?) AND e0_.id IN (?)) AND (e0_.deleted_at IS NULL) ORDER BY e0_.numeromandat DESC
Parameters:
[
[
"boutique"
"entreprise"
"bureaux"
"entrepot"
"local"
]
[
5848
5761
5760
5759
5755
5130
5287
5286
4738
5458
5457
5758
5456
5283
5282
5279
5280
]
]
|
| 6 | 0.29 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:
[
95
]
|
| 7 | 0.22 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:
[
150
]
|
| 8 | 0.18 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:
[
120
]
|
| 9 | 0.28 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:
[
119
]
|
| 10 | 0.30 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:
[
52
]
|
| 11 | 0.24 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:
[
4
]
|
| 12 | 0.19 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:
[
61
]
|
| 13 | 0.21 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:
[
22
]
|
| 14 | 0.23 ms |
SELECT b0_.id AS id_0, b0_.is_actif AS is_actif_1, b0_.title AS title_2, b0_.sub_title AS sub_title_3, b0_.url AS url_4, b0_.url_txt AS url_txt_5, b0_.image AS image_6, b0_.created_by AS created_by_7, b0_.updated_by AS updated_by_8, b0_.created_at AS created_at_9, b0_.updated_at AS updated_at_10, b0_.deleted_at AS deleted_at_11 FROM banner b0_ WHERE (b0_.is_actif = 1) AND (b0_.deleted_at IS NULL)
Parameters:
[] |
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\SousType | No errors. |
| App\Entity\Estate | No errors. |
| App\Entity\Agent | No errors. |
| App\Entity\User | No errors. |
| App\Entity\SearchNotification | No errors. |
| App\Entity\Review | No errors. |
| App\Entity\Banner | No errors. |
| App\Entity\Search | No errors. |
| App\Entity\Purchaser | 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. |