GET https://staging.meribel-mottaret-lesbleuets.fr/vente/vente-de-la-periode-17-du-01-08-au-15-08/107

Query Metrics

13 Database Queries
10 Different statements
10.11 ms Query time
4 Invalid entities
14 Managed entities

Grouped Statements

Show all queries

Time Count Info
2.68 ms
(26.48%)
4
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
]
1.81 ms
(17.88%)
1
SELECT n0_.id AS id_0, n0_.name_fr AS name_fr_1, n0_.description AS description_2, n0_.category AS category_3 FROM nw_accom_equipment_studio_category n1_ LEFT JOIN nw_accom_equipment n0_ ON (n0_.id = n1_.accom_equipment_id) WHERE n1_.studio_category_id = ? ORDER BY n0_.position ASC
Parameters:
[
  1
]
0.98 ms
(9.70%)
1
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
]
0.80 ms
(7.94%)
1
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 WHERE t0.id = ?
Parameters:
[
  107
]
0.73 ms
(7.23%)
1
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
]
0.62 ms
(6.18%)
1
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
]
0.62 ms
(6.17%)
1
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
]
0.62 ms
(6.16%)
1
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 FROM nw_accom_day_to_day t0 WHERE t0.id = ?
Parameters:
[
  2
]
0.62 ms
(6.16%)
1
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
]
0.62 ms
(6.10%)
1
SELECT n0_.id AS id_0, n0_.name AS name_1, n0_.area AS area_2, n0_.description AS description_3 FROM nw_studio_category n0_ WHERE n0_.id = ?
Parameters:
[
  1
]

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 4
App\Entity\Residence 1
App\Entity\AdvertSell 1
App\Entity\User 1
App\Entity\Studio 1
App\Entity\Period 1
App\Entity\StudioCategory 1
App\Entity\AccomDayToDay 1
App\Entity\AccomBuilding 1
App\Entity\AccomFloor 1
App\Entity\AccomExposure 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\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.
App\Entity\AccomEquipment No errors.
App\Entity\Configuration No errors.