Query Metrics
220
Database Queries
34
Different statements
102.03 ms
Query time
3
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
65.78 ms (64.47%) |
9 |
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:
[
"20251010-050452_68e893f42d0ff=deleted; expires=Thu, 10 Oct 2024 05:04:51 GMT; Max-Age=0; path=/; httponly; samesite=lax"
]
|
8.95 ms (8.77%) |
31 |
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:
[ "bourges" "bourges-fr" ] |
4.44 ms (4.35%) |
39 |
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:
[
60
]
|
3.59 ms (3.52%) |
6 |
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:
[
25907
]
|
3.30 ms (3.23%) |
39 |
SELECT t0.id AS id_1 FROM translated_text t0 WHERE t0.id = ?
Parameters:
[
60
]
|
3.25 ms (3.19%) |
26 |
SELECT t0.id AS id_1, t0.title_tmp AS title_tmp_2, t0.alias AS alias_3, t0.content AS content_4, t0.position AS position_5, t0.container_header_id AS container_header_id_6, t0.container_body_id AS container_body_id_7, t0.container_footer_id AS container_footer_id_8, t0.title_id AS title_id_9, t0.slug_id AS slug_id_10, t0.parent_id AS parent_id_11 FROM sw_page t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"initial"
]
|
2.47 ms (2.42%) |
2 |
"COMMIT"
Parameters:
[] |
1.87 ms (1.83%) |
15 |
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:
[
2
]
|
1.21 ms (1.19%) |
5 |
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.content AS content_11, t7.position AS position_12, t7.container_header_id AS container_header_id_13, t7.container_body_id AS container_body_id_14, t7.container_footer_id AS container_footer_id_15, t7.title_id AS title_id_16, t7.slug_id AS slug_id_17, t7.parent_id AS parent_id_18, t19.id AS id_20, t19.title_tmp AS title_tmp_21, t19.alias AS alias_22, t19.content AS content_23, t19.position AS position_24, t19.container_header_id AS container_header_id_25, t19.container_body_id AS container_body_id_26, t19.container_footer_id AS container_footer_id_27, t19.title_id AS title_id_28, t19.slug_id AS slug_id_29, t19.parent_id AS parent_id_30, t31.id AS id_32, t31.title_tmp AS title_tmp_33, t31.alias AS alias_34, t31.content AS content_35, t31.position AS position_36, t31.container_header_id AS container_header_id_37, t31.container_body_id AS container_body_id_38, t31.container_footer_id AS container_footer_id_39, t31.title_id AS title_id_40, t31.slug_id AS slug_id_41, t31.parent_id AS parent_id_42, t43.id AS id_44, t43.thematic_tmp AS thematic_tmp_45, t43.title_tmp AS title_tmp_46, t43.updated_at AS updated_at_47, t43.created_at AS created_at_48, t43.is_draft AS is_draft_49, t43.is_archived AS is_archived_50, t43.delete_option AS delete_option_51, t43.content_id AS content_id_52, t43.content_preview_text_id AS content_preview_text_id_53, t43.content_text_id AS content_text_id_54, t43.legend_text_id AS legend_text_id_55, t43.title_id AS title_id_56, t43.thematic_id AS thematic_id_57, t43.editor_id AS editor_id_58 FROM container t0 LEFT JOIN sw_page t7 ON t7.container_header_id = t0.id LEFT JOIN sw_page t19 ON t19.container_footer_id = t0.id LEFT JOIN sw_page t31 ON t31.container_body_id = t0.id LEFT JOIN publication t43 ON t43.content_id = t0.id WHERE t0.dev_alias = ? LIMIT 1
Parameters:
[
"initial_Header"
]
|
0.93 ms (0.91%) |
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:
[
1
]
|
0.82 ms (0.80%) |
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.content AS content_11, t7.position AS position_12, t7.container_header_id AS container_header_id_13, t7.container_body_id AS container_body_id_14, t7.container_footer_id AS container_footer_id_15, t7.title_id AS title_id_16, t7.slug_id AS slug_id_17, t7.parent_id AS parent_id_18, t19.id AS id_20, t19.title_tmp AS title_tmp_21, t19.alias AS alias_22, t19.content AS content_23, t19.position AS position_24, t19.container_header_id AS container_header_id_25, t19.container_body_id AS container_body_id_26, t19.container_footer_id AS container_footer_id_27, t19.title_id AS title_id_28, t19.slug_id AS slug_id_29, t19.parent_id AS parent_id_30, t31.id AS id_32, t31.title_tmp AS title_tmp_33, t31.alias AS alias_34, t31.content AS content_35, t31.position AS position_36, t31.container_header_id AS container_header_id_37, t31.container_body_id AS container_body_id_38, t31.container_footer_id AS container_footer_id_39, t31.title_id AS title_id_40, t31.slug_id AS slug_id_41, t31.parent_id AS parent_id_42, t43.id AS id_44, t43.thematic_tmp AS thematic_tmp_45, t43.title_tmp AS title_tmp_46, t43.updated_at AS updated_at_47, t43.created_at AS created_at_48, t43.is_draft AS is_draft_49, t43.is_archived AS is_archived_50, t43.delete_option AS delete_option_51, t43.content_id AS content_id_52, t43.content_preview_text_id AS content_preview_text_id_53, t43.content_text_id AS content_text_id_54, t43.legend_text_id AS legend_text_id_55, t43.title_id AS title_id_56, t43.thematic_id AS thematic_id_57, t43.editor_id AS editor_id_58 FROM container t0 LEFT JOIN sw_page t7 ON t7.container_header_id = t0.id LEFT JOIN sw_page t19 ON t19.container_footer_id = t0.id LEFT JOIN sw_page t31 ON t31.container_body_id = t0.id LEFT JOIN publication t43 ON t43.content_id = t0.id WHERE t0.id = ?
Parameters:
[
1
]
|
0.67 ms (0.65%) |
5 |
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:
[
1
]
|
0.57 ms (0.56%) |
1 |
SELECT t0.id AS id_1, t0.request AS request_2 FROM search_request t0 WHERE t0.request = ? LIMIT 1
Parameters:
[
"/simple-recherche?sujets[0]=Eve"
]
|
0.48 ms (0.47%) |
4 |
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:
[
1
]
|
0.44 ms (0.43%) |
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.parent_item_id = ? ORDER BY t0.position ASC
Parameters:
[
3
]
|
0.37 ms (0.36%) |
4 |
SELECT t0.id AS id_1, t0.alias AS alias_2 FROM menu t0 WHERE t0.alias = ? LIMIT 1
Parameters:
[
"NavbarMenu"
]
|
0.35 ms (0.35%) |
3 |
SELECT t0.id AS id_1, t0.title_tmp AS title_tmp_2, t0.alias AS alias_3, t0.content AS content_4, t0.position AS position_5, t0.container_header_id AS container_header_id_6, t0.container_body_id AS container_body_id_7, t0.container_footer_id AS container_footer_id_8, t0.title_id AS title_id_9, t0.slug_id AS slug_id_10, t0.parent_id AS parent_id_11 FROM sw_page t0 WHERE t0.id = ?
Parameters:
[
8
]
|
0.29 ms (0.28%) |
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.content AS content_11, t7.position AS position_12, t7.container_header_id AS container_header_id_13, t7.container_body_id AS container_body_id_14, t7.container_footer_id AS container_footer_id_15, t7.title_id AS title_id_16, t7.slug_id AS slug_id_17, t7.parent_id AS parent_id_18, t19.id AS id_20, t19.title_tmp AS title_tmp_21, t19.alias AS alias_22, t19.content AS content_23, t19.position AS position_24, t19.container_header_id AS container_header_id_25, t19.container_body_id AS container_body_id_26, t19.container_footer_id AS container_footer_id_27, t19.title_id AS title_id_28, t19.slug_id AS slug_id_29, t19.parent_id AS parent_id_30, t31.id AS id_32, t31.title_tmp AS title_tmp_33, t31.alias AS alias_34, t31.content AS content_35, t31.position AS position_36, t31.container_header_id AS container_header_id_37, t31.container_body_id AS container_body_id_38, t31.container_footer_id AS container_footer_id_39, t31.title_id AS title_id_40, t31.slug_id AS slug_id_41, t31.parent_id AS parent_id_42, t43.id AS id_44, t43.thematic_tmp AS thematic_tmp_45, t43.title_tmp AS title_tmp_46, t43.updated_at AS updated_at_47, t43.created_at AS created_at_48, t43.is_draft AS is_draft_49, t43.is_archived AS is_archived_50, t43.delete_option AS delete_option_51, t43.content_id AS content_id_52, t43.content_preview_text_id AS content_preview_text_id_53, t43.content_text_id AS content_text_id_54, t43.legend_text_id AS legend_text_id_55, t43.title_id AS title_id_56, t43.thematic_id AS thematic_id_57, t43.editor_id AS editor_id_58 FROM container t0 LEFT JOIN sw_page t7 ON t7.container_header_id = t0.id LEFT JOIN sw_page t19 ON t19.container_footer_id = t0.id LEFT JOIN sw_page t31 ON t31.container_body_id = t0.id LEFT JOIN publication t43 ON t43.content_id = t0.id WHERE t0.parent_container_id = ?
Parameters:
[
61
]
|
0.20 ms (0.20%) |
1 |
INSERT INTO sw_visitor (username, roles, user_status, password, cookie, lastAccess, creation_date, ip, language, totalVisit, discriminator) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ null "[]" "PENDING_STATUS" null "20251010-050452_68e893f42d0ff=deleted; expires=Thu, 10 Oct 2024 05:04:51 GMT; Max-Age=0; path=/; httponly; samesite=lax" "2025-10-10 05:04:52" "2025-10-10 05:04:52" "143.137.84.169" "fr" 1 "sw_visitor" ] |
0.20 ms (0.20%) |
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:
[ 25907 1284 ] |
0.17 ms (0.17%) |
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.17 ms (0.16%) |
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:
[
1
]
|
0.16 ms (0.16%) |
1 |
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:
[
61
]
|
0.15 ms (0.15%) |
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.15%) |
1 |
SELECT COUNT(*) FROM search_history t0 WHERE t0.visitor_id = ?
Parameters:
[
25907
]
|
0.14 ms (0.14%) |
1 |
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 text_translations t0 WHERE t0.object_id = ?
Parameters:
[
23
]
|
0.14 ms (0.13%) |
2 |
"START TRANSACTION"
Parameters:
[] |
0.13 ms (0.13%) |
1 |
INSERT INTO search_history (created, visitor_id, search_id) VALUES (?, ?, ?)
Parameters:
[ "2025-10-10 05:04:52" 25907 1284 ] |
0.13 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.title_tmp AS title_tmp_2, t0.alias AS alias_3, t0.content AS content_4, t0.position AS position_5, t0.container_header_id AS container_header_id_6, t0.container_body_id AS container_body_id_7, t0.container_footer_id AS container_footer_id_8, t0.title_id AS title_id_9, t0.slug_id AS slug_id_10, t0.parent_id AS parent_id_11 FROM sw_page t0 WHERE t0.container_body_id = ?
Parameters:
[
61
]
|
0.13 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.title_tmp AS title_tmp_2, t0.alias AS alias_3, t0.content AS content_4, t0.position AS position_5, t0.container_header_id AS container_header_id_6, t0.container_body_id AS container_body_id_7, t0.container_footer_id AS container_footer_id_8, t0.title_id AS title_id_9, t0.slug_id AS slug_id_10, t0.parent_id AS parent_id_11 FROM sw_page t0 WHERE t0.container_footer_id = ?
Parameters:
[
61
]
|
0.12 ms (0.12%) |
1 |
SELECT t0.id AS id_1, t0.title_tmp AS title_tmp_2, t0.alias AS alias_3, t0.content AS content_4, t0.position AS position_5, t0.container_header_id AS container_header_id_6, t0.container_body_id AS container_body_id_7, t0.container_footer_id AS container_footer_id_8, t0.title_id AS title_id_9, t0.slug_id AS slug_id_10, t0.parent_id AS parent_id_11 FROM sw_page t0 WHERE t0.container_header_id = ?
Parameters:
[
61
]
|
0.11 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.text AS text_2 FROM text_editor t0 WHERE t0.id = ?
Parameters:
[
23
]
|
0.08 ms (0.07%) |
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.07 ms (0.07%) |
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:
[
2
]
|
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\Visitor |
|
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 |
|
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. |
SkinSoft\SkinWebBundle\Entity\Content | No errors. |
SkinSoft\SkinWebBundle\Entity\TextEditor |
|
Gedmo\Translatable\Entity\MappedSuperclass\AbstractPersonalTranslation | No errors. |
SkinSoft\SkinWebBundle\Entity\TranslatedTextTranslation | No errors. |
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\TextEditorTranslation | No errors. |
SkinSoft\SkinWebBundle\Entity\Alert | No errors. |
SkinSoft\SkinWebBundle\Entity\Cookie | No errors. |
SkinSoft\SkinWebBundle\Entity\CookieService | No errors. |