GET https://staging.meribel-mottaret-lesbleuets.fr/note/36

Query Metrics

8 Database Queries
5 Different statements
6.73 ms Query time
3 Invalid entities
6 Managed entities

Queries

Group similar statements

# Time Info
1 1.14 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.83 ms
SELECT t0.id AS id_1, t0.date AS date_2, t0.name AS name_3, t0.content AS content_4, t0.slug AS slug_5, t0.comment AS comment_6, t0.supervisor AS supervisor_7, t0.admin AS admin_8, t0.editor AS editor_9, t0.premium AS premium_10, t0.std AS std_11, t0.visitor AS visitor_12, t0.front AS front_13, t0.published AS published_14, t0.pinned AS pinned_15, t0.residence_id AS residence_id_16, t0.document_id AS document_id_17 FROM nw_note t0 WHERE t0.id = ?
Parameters:
[
  "36"
]
3 0.82 ms
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.description AS description_3, n0_.file_name AS file_name_4, n0_.slug AS slug_5, n0_.comment AS comment_6 FROM nw_note_document n1_ LEFT JOIN nw_document n0_ ON (n1_.document_id = n0_.id) WHERE n1_.note_id = ?
Parameters:
[
  "36"
]
4 0.75 ms
SELECT n0_.id AS id_0, n0_.date AS date_1, n0_.name AS name_2, n0_.comment AS comment_3 FROM nw_note_category n1_ LEFT JOIN nw_category n0_ ON (n1_.category_id = n0_.id) WHERE n1_.note_id = ?
Parameters:
[
  "36"
]
5 0.80 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
]
6 0.74 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_description"
  25
]
7 0.82 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
]
8 0.82 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 4
App\Entity\Residence 1
App\Entity\Note 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\Note No errors.
App\Entity\Document No errors.
App\Entity\NoteResidence
  • The association App\Entity\NoteResidence#residence refers to the inverse side field App\Entity\Residence#notesResidences which does not exist.
App\Entity\NoteDocument No errors.
App\Entity\NoteCategory No errors.
App\Entity\Category No errors.
App\Entity\Configuration No errors.