GET https://collections.albert-kahn.hauts-de-seine.fr/document/n-c/617a7a3ecf8b8968b335be13?pos=8

Query Metrics

214 Database Queries
17 Different statements
66.07 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
25.45 ms
(38.51%)
69
SELECT j0_.id AS id_0, j0_.token AS token_1, j0_.expiration_date AS expiration_date_2, j0_.endpoint AS endpoint_3, j0_.username AS username_4 FROM jwt j0_ WHERE j0_.username LIKE ? AND j0_.endpoint LIKE ? ORDER BY j0_.expiration_date DESC LIMIT 1
Parameters:
[
  "ak"
  "ak-fr"
]
12.09 ms
(18.29%)
21
SELECT t0.id AS id_1, t0.position AS position_2, t0.facet AS facet_3, t0.rebound AS rebound_4, t0.facet_config_id AS facet_config_id_5 FROM facet t0 WHERE t0.facet_config_id = ? ORDER BY t0.position ASC
Parameters:
[
  2
]
10.96 ms
(16.58%)
37
SELECT t0.id AS id_1, t0.name AS name_2, t0.display_order AS display_order_3, t0.enabled AS enabled_4 FROM facet_config t0 WHERE t0.enabled = ? LIMIT 1
Parameters:
[
  1
]
6.05 ms
(9.16%)
13
SELECT t0.id AS id_1, t0.path AS path_2, t0.name_tmp AS name_tmp_3, t0.copyright_tmp AS copyright_tmp_4, t0.updated_at AS updated_at_5, t0.name_id AS name_id_6, t0.copyright_id AS copyright_id_7, t0.content_id AS content_id_8, t0.publication_id AS publication_id_9, t0.legend_id AS legend_id_10 FROM image t0 INNER JOIN menu_item_image ON t0.id = menu_item_image.image_id WHERE menu_item_image.menu_item_id = ?
Parameters:
[
  7
]
4.68 ms
(7.08%)
3
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "Professionnels"
]
1.63 ms
(2.46%)
20
SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM string_translations t0 WHERE t0.object_id = ?
Parameters:
[
  36
]
1.29 ms
(1.95%)
20
SELECT t0.id AS id_1 FROM translated_text t0 WHERE t0.id = ?
Parameters:
[
  36
]
1.16 ms
(1.76%)
6
SELECT t0.id AS id_1, t0.dev_alias AS dev_alias_2, t0.position AS position_3, t0.deletable AS deletable_4, t0.component AS component_5, t0.parent_container_id AS parent_container_id_6, t7.id AS id_8, t7.title_tmp AS title_tmp_9, t7.alias AS alias_10, t7.old_slug AS old_slug_11, t7.content AS content_12, t7.position AS position_13, t7.container_header_id AS container_header_id_14, t7.container_body_id AS container_body_id_15, t7.container_footer_id AS container_footer_id_16, t7.title_id AS title_id_17, t7.slug_id AS slug_id_18, t7.parent_id AS parent_id_19, t20.id AS id_21, t20.title_tmp AS title_tmp_22, t20.alias AS alias_23, t20.old_slug AS old_slug_24, t20.content AS content_25, t20.position AS position_26, t20.container_header_id AS container_header_id_27, t20.container_body_id AS container_body_id_28, t20.container_footer_id AS container_footer_id_29, t20.title_id AS title_id_30, t20.slug_id AS slug_id_31, t20.parent_id AS parent_id_32, t33.id AS id_34, t33.title_tmp AS title_tmp_35, t33.alias AS alias_36, t33.old_slug AS old_slug_37, t33.content AS content_38, t33.position AS position_39, t33.container_header_id AS container_header_id_40, t33.container_body_id AS container_body_id_41, t33.container_footer_id AS container_footer_id_42, t33.title_id AS title_id_43, t33.slug_id AS slug_id_44, t33.parent_id AS parent_id_45, t46.id AS id_47, t46.thematic_tmp AS thematic_tmp_48, t46.title_tmp AS title_tmp_49, t46.updated_at AS updated_at_50, t46.created_at AS created_at_51, t46.is_draft AS is_draft_52, t46.is_archived AS is_archived_53, t46.delete_option AS delete_option_54, t46.content_id AS content_id_55, t46.content_preview_text_id AS content_preview_text_id_56, t46.content_text_id AS content_text_id_57, t46.legend_text_id AS legend_text_id_58, t46.title_id AS title_id_59, t46.thematic_id AS thematic_id_60, t46.editor_id AS editor_id_61 FROM container t0 LEFT JOIN sw_page t7 ON t7.container_header_id = t0.id LEFT JOIN sw_page t20 ON t20.container_footer_id = t0.id LEFT JOIN sw_page t33 ON t33.container_body_id = t0.id LEFT JOIN publication t46 ON t46.content_id = t0.id WHERE t0.dev_alias = ? LIMIT 1
Parameters:
[
  "initial_Header"
]
0.60 ms
(0.91%)
3
SELECT t0.id AS id_1, t0.dev_alias AS dev_alias_2, t0.position AS position_3, t0.deletable AS deletable_4, t0.component AS component_5, t0.parent_container_id AS parent_container_id_6, t7.id AS id_8, t7.title_tmp AS title_tmp_9, t7.alias AS alias_10, t7.old_slug AS old_slug_11, t7.content AS content_12, t7.position AS position_13, t7.container_header_id AS container_header_id_14, t7.container_body_id AS container_body_id_15, t7.container_footer_id AS container_footer_id_16, t7.title_id AS title_id_17, t7.slug_id AS slug_id_18, t7.parent_id AS parent_id_19, t20.id AS id_21, t20.title_tmp AS title_tmp_22, t20.alias AS alias_23, t20.old_slug AS old_slug_24, t20.content AS content_25, t20.position AS position_26, t20.container_header_id AS container_header_id_27, t20.container_body_id AS container_body_id_28, t20.container_footer_id AS container_footer_id_29, t20.title_id AS title_id_30, t20.slug_id AS slug_id_31, t20.parent_id AS parent_id_32, t33.id AS id_34, t33.title_tmp AS title_tmp_35, t33.alias AS alias_36, t33.old_slug AS old_slug_37, t33.content AS content_38, t33.position AS position_39, t33.container_header_id AS container_header_id_40, t33.container_body_id AS container_body_id_41, t33.container_footer_id AS container_footer_id_42, t33.title_id AS title_id_43, t33.slug_id AS slug_id_44, t33.parent_id AS parent_id_45, t46.id AS id_47, t46.thematic_tmp AS thematic_tmp_48, t46.title_tmp AS title_tmp_49, t46.updated_at AS updated_at_50, t46.created_at AS created_at_51, t46.is_draft AS is_draft_52, t46.is_archived AS is_archived_53, t46.delete_option AS delete_option_54, t46.content_id AS content_id_55, t46.content_preview_text_id AS content_preview_text_id_56, t46.content_text_id AS content_text_id_57, t46.legend_text_id AS legend_text_id_58, t46.title_id AS title_id_59, t46.thematic_id AS thematic_id_60, t46.editor_id AS editor_id_61 FROM container t0 LEFT JOIN sw_page t7 ON t7.container_header_id = t0.id LEFT JOIN sw_page t20 ON t20.container_footer_id = t0.id LEFT JOIN sw_page t33 ON t33.container_body_id = t0.id LEFT JOIN publication t46 ON t46.content_id = t0.id WHERE t0.id = ?
Parameters:
[
  16
]
0.55 ms
(0.83%)
6
SELECT c0_.id AS id_0, c0_.dev_alias AS dev_alias_1, c0_.position AS position_2, c0_.deletable AS deletable_3, c0_.component AS component_4, c0_.parent_container_id AS parent_container_id_5 FROM container c0_ WHERE c0_.parent_container_id = ? ORDER BY c0_.position ASC
Parameters:
[
  16
]
0.48 ms
(0.73%)
6
SELECT t0.id AS id_1, t0.dev_alias AS dev_alias_2, t0.text_tmp AS text_tmp_3, t0.editable AS editable_4, t0.text_id AS text_id_5 FROM content t0 INNER JOIN content_container ON t0.id = content_container.content_id WHERE content_container.container_id = ?
Parameters:
[
  16
]
0.45 ms
(0.68%)
3
SELECT t0.id AS id_1, t0.label_tmp AS label_tmp_2, t0.type AS type_3, t0.link AS link_4, t0.position AS position_5, t0.label_id AS label_id_6, t0.parent_item_id AS parent_item_id_7, t0.menu_id AS menu_id_8 FROM menu_item t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  4
]
0.24 ms
(0.36%)
2
SELECT t0.id AS id_1, t0.title_tmp AS title_tmp_2, t0.alias AS alias_3, t0.old_slug AS old_slug_4, t0.content AS content_5, t0.position AS position_6, t0.container_header_id AS container_header_id_7, t0.container_body_id AS container_body_id_8, t0.container_footer_id AS container_footer_id_9, t0.title_id AS title_id_10, t0.slug_id AS slug_id_11, t0.parent_id AS parent_id_12 FROM sw_page t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "initial"
]
0.16 ms
(0.24%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.color AS color_3, t0.position AS position_4, t0.position_order AS position_order_5, t0.dismissible AS dismissible_6, t0.enabled AS enabled_7, t0.text_id AS text_id_8 FROM alert t0 WHERE t0.enabled = ? AND t0.position = ? ORDER BY t0.position_order ASC
Parameters:
[
  1
  "top"
]
0.15 ms
(0.22%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.content AS content_3, t0.page_id AS page_id_4 FROM meta t0 WHERE t0.page_id = ?
Parameters:
[
  4
]
0.08 ms
(0.12%)
1
SELECT t0.id AS id_1, t0.label AS label_2, t0.parameters AS parameters_3, t0.script AS script_4 FROM cookie_service t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
0.07 ms
(0.11%)
1
SELECT t0.id AS id_1, t0.parameters AS parameters_2, t0.is_active AS is_active_3, t0.name_id AS name_id_4 FROM cookie t0
Parameters:
[]

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
SkinSoft\SkinWebBundle\Entity\JWT No errors.
SkinSoft\SkinWebBundle\Entity\FacetConfig No errors.
SkinSoft\SkinWebBundle\Entity\Facet No errors.
SkinSoft\SkinWebBundle\Entity\Page No errors.
SkinSoft\SkinWebBundle\Entity\Container No errors.
SkinSoft\SkinWebBundle\Entity\TranslatedText No errors.
SkinSoft\SkinWebBundle\Entity\Meta No errors.
SkinSoft\SkinWebBundle\Entity\Menu No errors.
SkinSoft\SkinWebBundle\Entity\MenuItem No errors.
SkinSoft\SkinWebBundle\Entity\Image No errors.
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation No errors.
SkinSoft\SkinWebBundle\Entity\TranslatedTextTranslation No errors.
SkinSoft\SkinWebBundle\Entity\Content No errors.
SkinSoft\SkinWebBundle\Entity\Publication No errors.
SkinSoft\SkinWebBundle\Entity\TextEditor
  • The field SkinSoft\SkinWebBundle\Entity\TextEditor#publicationContentPreviews is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity SkinSoft\SkinWebBundle\Entity\Publication#contentPreviewText does not contain the required 'inversedBy="publicationContentPreviews"' attribute.
  • The field SkinSoft\SkinWebBundle\Entity\TextEditor#publicationContents is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity SkinSoft\SkinWebBundle\Entity\Publication#contentText does not contain the required 'inversedBy="publicationContents"' attribute.
  • The field SkinSoft\SkinWebBundle\Entity\TextEditor#publicationsLegends is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity SkinSoft\SkinWebBundle\Entity\Publication#legendText does not contain the required 'inversedBy="publicationsLegends"' attribute.
SkinSoft\SkinWebBundle\Entity\Visitor
  • The field SkinSoft\SkinWebBundle\Entity\Visitor#latestNotices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity SkinSoft\SkinWebBundle\Entity\LatestNotice#visitor does not contain the required 'inversedBy="latestNotices"' attribute.
SkinSoft\SkinWebBundle\Entity\Alert No errors.
SkinSoft\SkinWebBundle\Entity\Cookie No errors.
SkinSoft\SkinWebBundle\Entity\CookieService No errors.