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

Query Metrics

24 Database Queries
8 Different statements
15.52 ms Query time
4 Invalid entities
48 Managed entities

Queries

Group similar statements

# Time Info
1 0.98 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 0.87 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.slug AS slug_4, t0.title AS title_5, t0.title_slugified AS title_slugified_6, t0.expired_by AS expired_by_7, t0.published AS published_8, t0.photos_rz_authorization AS photos_rz_authorization_9, t0.price AS price_10, t0.period_number AS period_number_11, t0.studio_number AS studio_number_12, t0.datefrom AS datefrom_13, t0.dateto AS dateto_14, t0.tel AS tel_15, t0.email AS email_16, t0.content AS content_17, t0.quick_response_code_filename AS quick_response_code_filename_18, t0.user_id AS user_id_19, t0.studio_id AS studio_id_20, t0.period_id AS period_id_21 FROM nw_advert_sell t0
Parameters:
[]
3 0.75 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.68 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.68 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
]
6 0.74 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  162
]
7 0.70 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.area AS area_6, t0.description AS description_7, t0.residence_id AS residence_id_8 FROM nw_studio_category t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.64 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.description AS description_5, t0.comment AS comment_6, t0.residence_id AS residence_id_7 FROM nw_accom_exposure t0 WHERE t0.id = ?
Parameters:
[
  2
]
9 0.66 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.position AS position_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9 FROM nw_accom_floor t0 WHERE t0.id = ?
Parameters:
[
  5
]
10 0.66 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.description AS description_6, t0.comment AS comment_7, t0.residence_id AS residence_id_8 FROM nw_accom_building t0 WHERE t0.id = ?
Parameters:
[
  1
]
11 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  28
]
12 0.54 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.description AS description_5, t0.comment AS comment_6, t0.residence_id AS residence_id_7 FROM nw_accom_exposure t0 WHERE t0.id = ?
Parameters:
[
  1
]
13 0.58 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.position AS position_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9 FROM nw_accom_floor t0 WHERE t0.id = ?
Parameters:
[
  1
]
14 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  79
]
15 0.56 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.slug AS slug_5, t0.area AS area_6, t0.description AS description_7, t0.residence_id AS residence_id_8 FROM nw_studio_category t0 WHERE t0.id = ?
Parameters:
[
  2
]
16 0.59 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.position AS position_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9 FROM nw_accom_floor t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 0.56 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.description AS description_6, t0.comment AS comment_7, t0.residence_id AS residence_id_8 FROM nw_accom_building t0 WHERE t0.id = ?
Parameters:
[
  2
]
18 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  157
]
19 0.55 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.position AS position_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9 FROM nw_accom_floor t0 WHERE t0.id = ?
Parameters:
[
  6
]
20 0.58 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  155
]
21 0.60 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  112
]
22 0.59 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.number AS number_5, t0.position AS position_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9 FROM nw_accom_floor t0 WHERE t0.id = ?
Parameters:
[
  4
]
23 0.59 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  123
]
24 0.61 ms
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.updated_at AS updated_at_3, t0.date AS date_4, t0.name AS name_5, t0.number AS number_6, t0.description AS description_7, t0.comment AS comment_8, t0.residence_id AS residence_id_9, t0.studio_category_id AS studio_category_id_10, t0.accom_day_to_day_id AS accom_day_to_day_id_11, t0.accom_building_id AS accom_building_id_12, t0.accom_floor_id AS accom_floor_id_13, t0.accom_exposure_id AS accom_exposure_id_14 FROM nw_studio t0 WHERE t0.id = ?
Parameters:
[
  161
]

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\AdvertSell 10
App\Entity\Studio 8
App\Entity\User 7
App\Entity\Period 6
App\Entity\AccomFloor 5
App\Entity\Configuration 3
App\Entity\StudioCategory 2
App\Entity\AccomDayToDay 2
App\Entity\AccomBuilding 2
App\Entity\AccomExposure 2
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\AdvertSell No errors.
App\Entity\User No errors.
App\Entity\Studio No errors.
App\Entity\Period No errors.
App\Entity\ImageSell No errors.
App\Entity\Configuration No errors.
App\Entity\StudioCategory
  • The mappings App\Entity\StudioCategory#accomEquipments and App\Entity\AccomEquipmentStudioCategory#studioCategory are inconsistent with each other.
App\Entity\AccomDayToDay No errors.
App\Entity\AccomBuilding No errors.
App\Entity\AccomFloor No errors.
App\Entity\AccomExposure No errors.
App\Entity\AccomEquipmentStudioCategory
  • The association App\Entity\AccomEquipmentStudioCategory#studioCategory refers to the inverse side field App\Entity\StudioCategory#accomEquipmentsStudioCategories which does not exist.