GET https://staging.meribel-mottaret-lesbleuets.fr/locations

Query Metrics

5 Database Queries
3 Different statements
4.45 ms Query time
2 Invalid entities
4 Managed entities

Queries

Group similar statements

# Time Info
1 1.12 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.role_suffix AS role_suffix_4, t0.email AS email_5, t0.photo AS photo_6, t0.website AS website_7, t0.key_collection_times AS key_collection_times_8, t0.come_by_car AS come_by_car_9, t0.come_by_plane AS come_by_plane_10, t0.come_by_train AS come_by_train_11, t0.description AS description_12, t0.name AS name_13, t0.name_localization AS name_localization_14, t0.slug AS slug_15, t0.template_folder AS template_folder_16, t0.address AS address_17, t0.zipcode AS zipcode_18, t0.city AS city_19, t0.country AS country_20, t0.phone AS phone_21, t0.information AS information_22, t0.manager_firstname AS manager_firstname_23, t0.manager_lastname AS manager_lastname_24, t0.manager_email AS manager_email_25, t0.comment AS comment_26, t0.public AS public_27, t0.active AS active_28, t0.configured AS configured_29, t0.position AS position_30 FROM nw_residence t0 WHERE t0.slug = ? AND t0.active = ? LIMIT 1
Parameters:
[
  "meribel-mottaret-lesbleuets"
  1
]
2 1.22 ms
SELECT n0_.id AS id_0, n0_.slug AS slug_1, n0_.updated_at AS updated_at_2, n0_.published AS published_3, n0_.photos_rz_authorization AS photos_rz_authorization_4, n0_.created_at AS created_at_5, n0_.title AS title_6, n0_.title_slugified AS title_slugified_7, n0_.price AS price_8, n0_.period_number AS period_number_9, n0_.studio_number AS studio_number_10, n0_.datefrom AS datefrom_11, n0_.dateto AS dateto_12, n0_.tel AS tel_13, n0_.email AS email_14, n0_.content AS content_15, n0_.quick_response_code_filename AS quick_response_code_filename_16, n0_.user_id AS user_id_17, n0_.studio_id AS studio_id_18, n0_.period_id AS period_id_19 FROM nw_advert_rent n0_ LEFT JOIN nw_studio n1_ ON n0_.studio_id = n1_.id WHERE n1_.residence_id = ? AND (n0_.dateto BETWEEN ? AND ?) ORDER BY n0_.datefrom ASC
Parameters:
[
  25
  "2026-09-08 00:00:00"
  "2029-09-08 00:00:00"
]
3 0.73 ms
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters:
[
  "meta_title"
  25
]
4 0.70 ms
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters:
[
  "meta_keywords"
  25
]
5 0.69 ms
SELECT n0_.id AS id_0, n0_.created_at AS created_at_1, n0_.updated_at AS updated_at_2, n0_.name AS name_3, n0_.short_name AS short_name_4, n0_.summary AS summary_5, n0_.content AS content_6, n0_.comment AS comment_7, n0_.residence_id AS residence_id_8 FROM nw_configuration n0_ WHERE n0_.short_name = ? AND n0_.residence_id = ?
Parameters:
[
  "meta_author"
  25
]

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.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Configuration 3
App\Entity\Residence 1

Entities Mapping

Class Mapping errors
App\Entity\Residence
  • The mappings App\Entity\Residence#documents and App\Entity\DocumentResidence#residence are inconsistent with each other.
App\Entity\DocumentResidence
  • The association App\Entity\DocumentResidence#residence refers to the inverse side field App\Entity\Residence#documentsResidences which does not exist.
App\Entity\AdvertRent No errors.
App\Entity\Studio No errors.
App\Entity\User No errors.
App\Entity\Period No errors.
App\Entity\Configuration No errors.