GET https://preprod.roomlers.com/search/advanced?city=Strasbourg&lat=48.5734053&lng=7.7521113

Response
200 OK
IP
216.73.216.128
Profiled on
Token
ac4a49

Query Metrics

3 Database Queries
3 Different statements
17.16 ms Query time
1 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 1.40 ms 
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.city = ? LIMIT 1
Parameters: 
[
  "Strasbourg"
]
View formatted query    View runnable query    Explain query
2 11.85 ms 
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_.contact_name AS contact_name_22, b0_.mail_contact AS mail_contact_23, b0_.phone_contact AS phone_contact_24, b0_.security_deposit AS security_deposit_25, b0_.expenses AS expenses_26, b0_.expenses_description AS expenses_description_27, b0_.surface AS surface_28, b0_.surface_bedroom AS surface_bedroom_29, b0_.is_furniture AS is_furniture_30, b0_.is_aid_eligible AS is_aid_eligible_31, b0_.format AS format_32, b0_.postal_code AS postal_code_33, b0_.is_blocked AS is_blocked_34, b0_.is_floor AS is_floor_35, b0_.floor AS floor_36, b0_.pdl AS pdl_37, b0_.wifi AS wifi_38, b0_.dep AS dep_39, b0_.ges AS ges_40, b0_.max_folders AS max_folders_41, b0_.unique_id AS unique_id_42, b0_.min_income AS min_income_43, b0_.is_end AS is_end_44, b0_.lat AS lat_45, b0_.lng AS lng_46, b0_.is_authorize_atestation AS is_authorize_atestation_47, b0_.last_atestation AS last_atestation_48, b0_.has_guarantor AS has_guarantor_49, b0_.time_bail AS time_bail_50, b0_.type_bed AS type_bed_51, b0_.private_bathroom AS private_bathroom_52, b0_.bathrooms AS bathrooms_53, b0_.complex_property AS complex_property_54, b0_.complex_property_id AS complex_property_id_55, b0_.cover AS cover_56, b0_.has_reservation AS has_reservation_57, b0_.hide_address AS hide_address_58, b0_.bedroom_number AS bedroom_number_59, b0_.property_manager_id AS property_manager_id_60, b0_.tenant_id AS tenant_id_61, b0_.city_entity_id AS city_entity_id_62, b0_.residence_id AS residence_id_63 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE b0_.is_active = ? AND c1_.city = ? ORDER BY b0_.id DESC LIMIT 16
Parameters: 
[
  1
  "STRASBOURG"
]
View formatted query    View runnable query    Explain query
3 3.91 ms 
SELECT COUNT(b0_.id) AS sclr_0 FROM building b0_ INNER JOIN city c1_ ON b0_.city_entity_id = c1_.id WHERE b0_.is_active = ? AND c1_.city = ?
Parameters: 
[
  1
  "STRASBOURG"
]
View formatted query    View runnable query    Explain query

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\City No errors.
App\Entity\Building No errors.
App\Entity\BuildingReportingHistory No errors.
App\Entity\Residence No errors.
App\Entity\User
  • The field App\Entity\User#invoices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Invoice#user does not contain the required 'inversedBy="invoices"' attribute.