Query Metrics

141 Database Queries
31 Different statements
122.64 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time Count Info
63.28 ms
(51.60%)
1
SELECT t0.id AS id_1, t0.request AS request_2 FROM search_request t0 WHERE t0.request = ? LIMIT 1
Parameters:
[
  "/simple-recherche?fbclid=IwAR0R_vKMqb5SsjksB5EmqKlV5RcHj5oxsKUPhBgCgiEj-5HlO02ZSjvbgts&filtrerParSousthme[0]=Intervention américaine&filtrerParSousthme[1]=Uniforme militaire&filtrerParThme[0]=Transport"
]
18.83 ms
(15.35%)
6
SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.user_status AS user_status_4, t0.password AS password_5, t0.cookie AS cookie_6, t0.lastAccess AS lastAccess_7, t0.creation_date AS creation_date_8, t0.ip AS ip_9, t0.language AS language_10, t0.totalVisit AS totalVisit_11, t0.discriminator FROM sw_visitor t0 WHERE t0.cookie = ? AND t0.discriminator IN ('sw_visitor', 'sw_visitor_extend') LIMIT 1
Parameters:
[
  "20251205-010015_69322e9f4b810=deleted; expires=Thu, 05 Dec 2024 01:00:14 GMT; Max-Age=0; path=/; httponly; samesite=lax"
]
11.13 ms
(9.08%)
21
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"
]
4.04 ms
(3.30%)
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
]
2.98 ms
(2.43%)
7
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"
]
2.90 ms
(2.37%)
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"
]
2.28 ms
(1.86%)
8
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
]
2.15 ms
(1.76%)
7
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
]
1.99 ms
(1.62%)
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.71 ms
(1.39%)
20
SELECT t0.id AS id_1 FROM translated_text t0 WHERE t0.id = ?
Parameters:
[
  36
]
1.71 ms
(1.39%)
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
]
1.65 ms
(1.34%)
2
"COMMIT"
Parameters:
[]
1.46 ms
(1.19%)
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
]
1.27 ms
(1.04%)
1
SELECT t0.id AS id_1, t0.created AS created_2, t0.visitor_id AS visitor_id_3, t0.search_id AS search_id_4 FROM search_history t0 WHERE t0.visitor_id = ? AND t0.search_id = ? LIMIT 1
Parameters:
[
  5027775
  261589
]
1.11 ms
(0.91%)
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.85 ms
(0.70%)
2
"START TRANSACTION"
Parameters:
[]
0.39 ms
(0.31%)
1
INSERT INTO sw_visitor (username, roles, user_status, password, cookie, lastAccess, creation_date, ip, language, totalVisit, discriminator) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  null
  "[]"
  "PENDING_STATUS"
  null
  "20251205-010015_69322e9f4b810=deleted; expires=Thu, 05 Dec 2024 01:00:14 GMT; Max-Age=0; path=/; httponly; samesite=lax"
  "2025-12-05 01:00:15"
  "2025-12-05 01:00:15"
  "2.21.3.133"
  "fr"
  1
  "sw_visitor"
]
0.37 ms
(0.30%)
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.34 ms
(0.28%)
3
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
  "Professionnels"
]
0.32 ms
(0.26%)
1
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.parent_container_id = ?
Parameters:
[
  97
]
0.30 ms
(0.25%)
3
SELECT t0.id AS id_1, t0.created AS created_2, t0.name AS name_3, t0.visitor_id AS visitor_id_4 FROM sw_favourite t0 WHERE t0.visitor_id = ?
Parameters:
[
  5027775
]
0.25 ms
(0.20%)
2
SELECT t0.id AS id_1, t0.thematic_tmp AS thematic_tmp_2, t0.title_tmp AS title_tmp_3, t0.updated_at AS updated_at_4, t0.created_at AS created_at_5, t0.is_draft AS is_draft_6, t0.is_archived AS is_archived_7, t0.delete_option AS delete_option_8, t0.content_id AS content_id_9, t0.content_preview_text_id AS content_preview_text_id_10, t0.content_text_id AS content_text_id_11, t0.legend_text_id AS legend_text_id_12, t0.title_id AS title_id_13, t0.thematic_id AS thematic_id_14, t0.editor_id AS editor_id_15, t16.id AS id_17, t16.name_tmp AS name_tmp_18, t16.link AS link_19, t16.publication_id AS publication_id_20, t16.sw_date_id AS sw_date_id_21, t16.name_id AS name_id_22 FROM publication t0 LEFT JOIN event t16 ON t16.publication_id = t0.id WHERE t0.content_id = ?
Parameters:
[
  87
]
0.21 ms
(0.17%)
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.container_header_id = ?
Parameters:
[
  87
]
0.18 ms
(0.14%)
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.container_footer_id = ?
Parameters:
[
  87
]
0.17 ms
(0.14%)
1
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
]
0.16 ms
(0.13%)
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.container_body_id = ?
Parameters:
[
  87
]
0.16 ms
(0.13%)
1
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
]
0.12 ms
(0.10%)
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.11 ms
(0.09%)
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:
[]
0.10 ms
(0.08%)
1
INSERT INTO search_history (created, visitor_id, search_id) VALUES (?, ?, ?)
Parameters:
[
  "2025-12-05 01:00:15"
  5027775
  261589
]
0.09 ms
(0.07%)
1
SELECT COUNT(*) FROM search_history t0 WHERE t0.visitor_id = ?
Parameters:
[
  5027775
]

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\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\Favourite No errors.
SkinSoft\SkinWebBundle\Entity\Publication No errors.
SkinSoft\SkinWebBundle\Entity\SearchHistory No errors.
SkinSoft\SkinWebBundle\Entity\SavedSearch No errors.
SkinSoft\SkinWebBundle\Entity\LatestNotice No errors.
SkinSoft\SkinWebBundle\Entity\SearchRequest No errors.
App\Entity\ExtendVisitor
  • The field App\Entity\ExtendVisitor#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\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\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\Event No errors.
SkinSoft\SkinWebBundle\Entity\SwDate No errors.
SkinSoft\SkinWebBundle\Entity\Files No errors.
SkinSoft\SkinWebBundle\Entity\Parameter No errors.
SkinSoft\SkinWebBundle\Entity\Alert No errors.
SkinSoft\SkinWebBundle\Entity\Cookie No errors.
SkinSoft\SkinWebBundle\Entity\CookieService No errors.