Query Metrics
15
Database Queries
8
Different statements
66.84 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.18 ms (36.18%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.complex_property_id = ?
Parameters:
[
2127649517
]
|
|
20.55 ms (30.74%) |
1 |
SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ WHERE b0_.complex_property_id = ? ORDER BY b0_.created_at DESC
Parameters:
[
2127649517
]
|
|
14.89 ms (22.28%) |
1 |
SELECT b0_.id AS id_0, b0_.type AS type_1, b0_.borough AS borough_2, b0_.street AS street_3, b0_.street_number AS street_number_4, b0_.country AS country_5, b0_.created_at AS created_at_6, b0_.date_start_at AS date_start_at_7, b0_.title AS title_8, b0_.status AS status_9, b0_.state AS state_10, b0_.guarantee_type AS guarantee_type_11, b0_.is_active AS is_active_12, b0_.number_id AS number_id_13, b0_.rent AS rent_14, b0_.description AS description_15, b0_.lease_term AS lease_term_16, b0_.edited_at AS edited_at_17, b0_.house_rules AS house_rules_18, b0_.interior AS interior_19, b0_.exterior AS exterior_20, b0_.charges AS charges_21, b0_.lease_drafting_fees AS lease_drafting_fees_22, b0_.contact_name AS contact_name_23, b0_.mail_contact AS mail_contact_24, b0_.phone_contact AS phone_contact_25, b0_.security_deposit AS security_deposit_26, b0_.expenses AS expenses_27, b0_.expenses_description AS expenses_description_28, b0_.surface AS surface_29, b0_.surface_bedroom AS surface_bedroom_30, b0_.is_furniture AS is_furniture_31, b0_.is_aid_eligible AS is_aid_eligible_32, b0_.format AS format_33, b0_.postal_code AS postal_code_34, b0_.is_blocked AS is_blocked_35, b0_.is_floor AS is_floor_36, b0_.floor AS floor_37, b0_.pdl AS pdl_38, b0_.wifi AS wifi_39, b0_.dep AS dep_40, b0_.ges AS ges_41, b0_.max_folders AS max_folders_42, b0_.unique_id AS unique_id_43, b0_.min_income AS min_income_44, b0_.is_end AS is_end_45, b0_.lat AS lat_46, b0_.lng AS lng_47, b0_.is_authorize_atestation AS is_authorize_atestation_48, b0_.last_atestation AS last_atestation_49, b0_.has_guarantor AS has_guarantor_50, b0_.time_bail AS time_bail_51, b0_.type_bed AS type_bed_52, b0_.private_bathroom AS private_bathroom_53, b0_.bathrooms AS bathrooms_54, b0_.complex_property AS complex_property_55, b0_.complex_property_id AS complex_property_id_56, b0_.cover AS cover_57, b0_.has_reservation AS has_reservation_58, b0_.hide_address AS hide_address_59, b0_.bedroom_number AS bedroom_number_60, b0_.discount_price AS discount_price_61, b0_.date_end_promo AS date_end_promo_62, b0_.property_manager_id AS property_manager_id_63, b0_.tenant_id AS tenant_id_64, b0_.city_entity_id AS city_entity_id_65, b0_.residence_id AS residence_id_66 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE c1_.city = ? AND (b0_.surface BETWEEN ? AND ?) AND (b0_.rent BETWEEN ? AND ?) AND b0_.complex_property_id <> ? AND b0_.id <> ? ORDER BY b0_.created_at DESC LIMIT 3
Parameters:
[ "LYON" 75.0 225.0 45000.0 135000.0 2127649517 37385 ] |
|
4.23 ms (6.32%) |
7 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.created_at AS created_at_3, t0.uploaded_at AS uploaded_at_4, t0.image_file AS image_file_5, t0.complex_property_id AS complex_property_id_6, t0.building_id AS building_id_7, t8.id AS id_9, t8.type AS type_10, t8.borough AS borough_11, t8.street AS street_12, t8.street_number AS street_number_13, t8.country AS country_14, t8.created_at AS created_at_15, t8.date_start_at AS date_start_at_16, t8.title AS title_17, t8.status AS status_18, t8.state AS state_19, t8.guarantee_type AS guarantee_type_20, t8.is_active AS is_active_21, t8.number_id AS number_id_22, t8.rent AS rent_23, t8.description AS description_24, t8.lease_term AS lease_term_25, t8.edited_at AS edited_at_26, t8.house_rules AS house_rules_27, t8.interior AS interior_28, t8.exterior AS exterior_29, t8.charges AS charges_30, t8.lease_drafting_fees AS lease_drafting_fees_31, t8.contact_name AS contact_name_32, t8.mail_contact AS mail_contact_33, t8.phone_contact AS phone_contact_34, t8.security_deposit AS security_deposit_35, t8.expenses AS expenses_36, t8.expenses_description AS expenses_description_37, t8.surface AS surface_38, t8.surface_bedroom AS surface_bedroom_39, t8.is_furniture AS is_furniture_40, t8.is_aid_eligible AS is_aid_eligible_41, t8.format AS format_42, t8.postal_code AS postal_code_43, t8.is_blocked AS is_blocked_44, t8.is_floor AS is_floor_45, t8.floor AS floor_46, t8.pdl AS pdl_47, t8.wifi AS wifi_48, t8.dep AS dep_49, t8.ges AS ges_50, t8.max_folders AS max_folders_51, t8.unique_id AS unique_id_52, t8.min_income AS min_income_53, t8.is_end AS is_end_54, t8.lat AS lat_55, t8.lng AS lng_56, t8.is_authorize_atestation AS is_authorize_atestation_57, t8.last_atestation AS last_atestation_58, t8.has_guarantor AS has_guarantor_59, t8.time_bail AS time_bail_60, t8.type_bed AS type_bed_61, t8.private_bathroom AS private_bathroom_62, t8.bathrooms AS bathrooms_63, t8.complex_property AS complex_property_64, t8.complex_property_id AS complex_property_id_65, t8.cover AS cover_66, t8.has_reservation AS has_reservation_67, t8.hide_address AS hide_address_68, t8.bedroom_number AS bedroom_number_69, t8.discount_price AS discount_price_70, t8.date_end_promo AS date_end_promo_71, t8.property_manager_id AS property_manager_id_72, t8.tenant_id AS tenant_id_73, t8.city_entity_id AS city_entity_id_74, t8.residence_id AS residence_id_75, t0.residence_id AS residence_id_76 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
Parameters:
[
37385
]
|
|
1.15 ms (1.72%) |
1 |
SELECT t0.id AS id_1, t0.type AS type_2, t0.borough AS borough_3, t0.street AS street_4, t0.street_number AS street_number_5, t0.country AS country_6, t0.created_at AS created_at_7, t0.date_start_at AS date_start_at_8, t0.title AS title_9, t0.status AS status_10, t0.state AS state_11, t0.guarantee_type AS guarantee_type_12, t0.is_active AS is_active_13, t0.number_id AS number_id_14, t0.rent AS rent_15, t0.description AS description_16, t0.lease_term AS lease_term_17, t0.edited_at AS edited_at_18, t0.house_rules AS house_rules_19, t0.interior AS interior_20, t0.exterior AS exterior_21, t0.charges AS charges_22, t0.lease_drafting_fees AS lease_drafting_fees_23, t0.contact_name AS contact_name_24, t0.mail_contact AS mail_contact_25, t0.phone_contact AS phone_contact_26, t0.security_deposit AS security_deposit_27, t0.expenses AS expenses_28, t0.expenses_description AS expenses_description_29, t0.surface AS surface_30, t0.surface_bedroom AS surface_bedroom_31, t0.is_furniture AS is_furniture_32, t0.is_aid_eligible AS is_aid_eligible_33, t0.format AS format_34, t0.postal_code AS postal_code_35, t0.is_blocked AS is_blocked_36, t0.is_floor AS is_floor_37, t0.floor AS floor_38, t0.pdl AS pdl_39, t0.wifi AS wifi_40, t0.dep AS dep_41, t0.ges AS ges_42, t0.max_folders AS max_folders_43, t0.unique_id AS unique_id_44, t0.min_income AS min_income_45, t0.is_end AS is_end_46, t0.lat AS lat_47, t0.lng AS lng_48, t0.is_authorize_atestation AS is_authorize_atestation_49, t0.last_atestation AS last_atestation_50, t0.has_guarantor AS has_guarantor_51, t0.time_bail AS time_bail_52, t0.type_bed AS type_bed_53, t0.private_bathroom AS private_bathroom_54, t0.bathrooms AS bathrooms_55, t0.complex_property AS complex_property_56, t0.complex_property_id AS complex_property_id_57, t0.cover AS cover_58, t0.has_reservation AS has_reservation_59, t0.hide_address AS hide_address_60, t0.bedroom_number AS bedroom_number_61, t0.discount_price AS discount_price_62, t0.date_end_promo AS date_end_promo_63, t0.property_manager_id AS property_manager_id_64, t0.tenant_id AS tenant_id_65, t0.city_entity_id AS city_entity_id_66, t0.residence_id AS residence_id_67 FROM building t0 WHERE t0.id = ?
Parameters:
[
"37385"
]
|
|
0.74 ms (1.11%) |
1 |
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.user_id AS user_id_3, t0.building_id AS building_id_4 FROM liked_building t0 WHERE t0.user_id IS NULL AND t0.building_id = ? LIMIT 1
Parameters:
[
37385
]
|
|
0.66 ms (0.99%) |
2 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.city AS city_3, t0.postal_code AS postal_code_4, t0.district AS district_5, t0.alert_count AS alert_count_6, t0.is_inside_homepage AS is_inside_homepage_7 FROM city t0 WHERE t0.id = ?
Parameters:
[
28279
]
|
|
0.44 ms (0.65%) |
1 |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.full_name AS full_name_5, t0.phone AS phone_6, t0.is_active AS is_active_7, t0.first_name AS first_name_8, t0.last_name AS last_name_9, t0.country AS country_10, t0.city AS city_11, t0.lessor_type AS lessor_type_12, t0.registration_finalized AS registration_finalized_13, t0.nationality AS nationality_14, t0.agent_type AS agent_type_15, t0.representative_name AS representative_name_16, t0.sign_at AS sign_at_17, t0.edited_at AS edited_at_18, t0.customer_type AS customer_type_19, t0.head_office AS head_office_20, t0.number_tva AS number_tva_21, t0.company_type AS company_type_22, t0.street AS street_23, t0.street_number AS street_number_24, t0.adress2 AS adress2_25, t0.adress1 AS adress1_26, t0.last_postal_code AS last_postal_code_27, t0.last_city AS last_city_28, t0.last_country AS last_country_29, t0.visa_type AS visa_type_30, t0.postal_code AS postal_code_31, t0.birth_date AS birth_date_32, t0.civility AS civility_33, t0.name_legal AS name_legal_34, t0.first_name_legal AS first_name_legal_35, t0.phone_legal AS phone_legal_36, t0.email_legal AS email_legal_37, t0.activity AS activity_38, t0.first_lease AS first_lease_39, t0.commercial_mail AS commercial_mail_40, t0.pack_attestation AS pack_attestation_41, t0.agent_ender_control AS agent_ender_control_42, t0.consulat_country AS consulat_country_43, t0.step_profil AS step_profil_44, t0.date_start_at AS date_start_at_45, t0.rental_duration AS rental_duration_46, t0.status AS status_47, t0.formation_name AS formation_name_48, t0.school_name AS school_name_49, t0.school_address AS school_address_50, t0.study_level AS study_level_51, t0.company AS company_52, t0.employement_contract AS employement_contract_53, t0.trial_period AS trial_period_54, t0.net_monthly_salary AS net_monthly_salary_55, t0.guarantor_type AS guarantor_type_56, t0.physical_guarantor_type AS physical_guarantor_type_57, t0.statut_residence_principale AS statut_residence_principale_58, t0.mensual_rent AS mensual_rent_59, t0.contract_type AS contract_type_60, t0.finished_trial_period AS finished_trial_period_61, t0.income AS income_62, t0.additional_income_sources AS additional_income_sources_63, t0.additional_income_sources_student AS additional_income_sources_student_64, t0.guarantor_status AS guarantor_status_65, t0.professional_guarantee AS professional_guarantee_66, t0.physical_guarantor_nationality AS physical_guarantor_nationality_67, t0.application_message AS application_message_68, t0.local_agreement_number AS local_agreement_number_69, t0.company_address AS company_address_70, t0.representative_title AS representative_title_71, t0.representative_first_name AS representative_first_name_72, t0.send_sms AS send_sms_73, t0.managed_by_id AS managed_by_id_74, t0.team_with_id AS team_with_id_75 FROM `user` t0 WHERE t0.id = ?
Parameters:
[
527
]
|
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\Building | No errors. |
| App\Entity\User |
|
| App\Entity\City | No errors. |
| App\Entity\Residence | No errors. |
| App\Entity\RentalHistory | No errors. |
| App\Entity\BuildingEquipment | No errors. |
| App\Entity\BuildingDocument | No errors. |
| App\Entity\BuildingEditHistory | No errors. |
| App\Entity\BuildingReportingHistory | No errors. |
| App\Entity\BuildingFolder | No errors. |
| App\Entity\HousingCertificate | No errors. |
| App\Entity\WantedVisio | No errors. |
| App\Entity\LikedBuilding | No errors. |
| App\Entity\AgentCountryCovered | No errors. |
| App\Entity\Document | No errors. |
| App\Entity\RefusedVisa | No errors. |
| App\Entity\HistoryUser | No errors. |
| App\Entity\Invoice | No errors. |