Query Metrics
2
Database Queries
2
Different statements
2.57 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.28 ms |
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.contact_name AS contact_name_23, t0.mail_contact AS mail_contact_24, t0.phone_contact AS phone_contact_25, t0.security_deposit AS security_deposit_26, t0.expenses AS expenses_27, t0.expenses_description AS expenses_description_28, t0.surface AS surface_29, t0.surface_bedroom AS surface_bedroom_30, t0.is_furniture AS is_furniture_31, t0.is_aid_eligible AS is_aid_eligible_32, t0.format AS format_33, t0.postal_code AS postal_code_34, t0.is_blocked AS is_blocked_35, t0.is_floor AS is_floor_36, t0.floor AS floor_37, t0.pdl AS pdl_38, t0.wifi AS wifi_39, t0.dep AS dep_40, t0.ges AS ges_41, t0.max_folders AS max_folders_42, t0.unique_id AS unique_id_43, t0.min_income AS min_income_44, t0.is_end AS is_end_45, t0.lat AS lat_46, t0.lng AS lng_47, t0.is_authorize_atestation AS is_authorize_atestation_48, t0.last_atestation AS last_atestation_49, t0.has_guarantor AS has_guarantor_50, t0.time_bail AS time_bail_51, t0.type_bed AS type_bed_52, t0.private_bathroom AS private_bathroom_53, t0.bathrooms AS bathrooms_54, t0.complex_property AS complex_property_55, t0.complex_property_id AS complex_property_id_56, t0.cover AS cover_57, t0.has_reservation AS has_reservation_58, t0.hide_address AS hide_address_59, t0.bedroom_number AS bedroom_number_60, t0.property_manager_id AS property_manager_id_61, t0.tenant_id AS tenant_id_62, t0.city_entity_id AS city_entity_id_63, t0.residence_id AS residence_id_64 FROM building t0 WHERE t0.id = ?
Parameters:
[
"10405"
]
|
| 2 | 1.29 ms |
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.contact_name AS contact_name_31, t8.mail_contact AS mail_contact_32, t8.phone_contact AS phone_contact_33, t8.security_deposit AS security_deposit_34, t8.expenses AS expenses_35, t8.expenses_description AS expenses_description_36, t8.surface AS surface_37, t8.surface_bedroom AS surface_bedroom_38, t8.is_furniture AS is_furniture_39, t8.is_aid_eligible AS is_aid_eligible_40, t8.format AS format_41, t8.postal_code AS postal_code_42, t8.is_blocked AS is_blocked_43, t8.is_floor AS is_floor_44, t8.floor AS floor_45, t8.pdl AS pdl_46, t8.wifi AS wifi_47, t8.dep AS dep_48, t8.ges AS ges_49, t8.max_folders AS max_folders_50, t8.unique_id AS unique_id_51, t8.min_income AS min_income_52, t8.is_end AS is_end_53, t8.lat AS lat_54, t8.lng AS lng_55, t8.is_authorize_atestation AS is_authorize_atestation_56, t8.last_atestation AS last_atestation_57, t8.has_guarantor AS has_guarantor_58, t8.time_bail AS time_bail_59, t8.type_bed AS type_bed_60, t8.private_bathroom AS private_bathroom_61, t8.bathrooms AS bathrooms_62, t8.complex_property AS complex_property_63, t8.complex_property_id AS complex_property_id_64, t8.cover AS cover_65, t8.has_reservation AS has_reservation_66, t8.hide_address AS hide_address_67, t8.bedroom_number AS bedroom_number_68, t8.property_manager_id AS property_manager_id_69, t8.tenant_id AS tenant_id_70, t8.city_entity_id AS city_entity_id_71, t8.residence_id AS residence_id_72, t0.residence_id AS residence_id_73 FROM building_document t0 LEFT JOIN building t8 ON t0.building_id = t8.id WHERE t0.building_id = ?
Parameters:
[
10405
]
|
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. |