Query Metrics
29Database Queries
9Different statements
42.87 msQuery time
0Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
| 22.03 ms (51.38%) | 6 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.link AS link_5, t0.sequence AS sequence_6, t0.type AS type_7, t0.description AS description_8, t0.linkPicture AS linkPicture_9, t0.parent_id AS parent_id_10 FROM menu_website_items t0 WHERE t0.parent_id = ? ORDER BY t0.sequence ASC Parameters: [
3
] |
| 13.32 ms (31.06%) | 2 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.identifiant AS identifiant_4, t0.title AS title_5, t0.description AS description_6, t0.locale AS locale_7 FROM articles_blocks t0 Parameters: [] |
| 2.66 ms (6.20%) | 9 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.published_at AS published_at_4, t0.slug AS slug_5, t0.title AS title_6, t0.title_ariane AS title_ariane_7, t0.shortTitle AS shortTitle_8, t0.subtitle AS subtitle_9, t0.type AS type_10, t0.short_description AS short_description_11, t0.description AS description_12, t0.description_start AS description_start_13, t0.tags AS tags_14, t0.visibility AS visibility_15, t0.language AS language_16, t0.carousel AS carousel_17, t0.featured AS featured_18, t0.autopublished_at AS autopublished_at_19, t0.translation AS translation_20, t0.sitemap AS sitemap_21, t0.robots AS robots_22, t0.type_editor AS type_editor_23, t0.canonical AS canonical_24, t0.author AS author_25, t0.url AS url_26, t0.cta_html AS cta_html_27, t0.keyword AS keyword_28, t0.pageslug AS pageslug_29, t0.pageslug2 AS pageslug2_30, t0.pageslug3 AS pageslug3_31, t0.visibleArticles AS visibleArticles_32, t0.onlyPage AS onlyPage_33, t0.identifiant AS identifiant_34, t0.image_name AS image_name_35, t0.image_original_name AS image_original_name_36, t0.image_mime_type AS image_mime_type_37, t0.image_size AS image_size_38, t0.image_dimensions AS image_dimensions_39 FROM articles_articles t0 WHERE t0.identifiant IS NULL AND t0.language = ? LIMIT 1 Parameters: [
"en"
] |
| 1.57 ms (3.66%) | 4 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.locale AS locale_4, t0.keypair AS keypair_5, t0.value AS value_6 FROM core_translations t0 WHERE t0.keypair = ? AND t0.locale = ? LIMIT 1 Parameters: [ "Outils" "en" ] |
| 1.01 ms (2.35%) | 3 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.title AS title_3, t0.link AS link_4, t0.visibility AS visibility_5, t0.target_blank AS target_blank_6, t0.type AS type_7, t0.type_menu AS type_menu_8, t0.sequence AS sequence_9, t0.typeButton AS typeButton_10, t0.html_submenu AS html_submenu_11, t0.visibilityUser AS visibilityUser_12, t0.private AS private_13, t0.no_private AS no_private_14, t0.locale AS locale_15 FROM menu_website_parents t0 WHERE t0.locale = ? AND t0.type = ? AND t0.no_private = ? ORDER BY t0.sequence ASC Parameters: [ "fr" "header" 1 ] |
| 0.91 ms (2.11%) | 1 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.title AS title_4, t0.slug AS slug_5, t0.url AS url_6, t0.visibility AS visibility_7, t0.type AS type_8 FROM seo_redirection t0 WHERE t0.slug = ? AND t0.visibility = ? LIMIT 1 Parameters: [ "fr/azerty/abc" 1 ] |
| 0.64 ms (1.48%) | 1 | SELECT a0_.id AS id_0, a0_.created_at AS created_at_1, a0_.updated_at AS updated_at_2, a0_.published_at AS published_at_3, a0_.slug AS slug_4, a0_.title AS title_5, a0_.title_ariane AS title_ariane_6, a0_.shortTitle AS shortTitle_7, a0_.subtitle AS subtitle_8, a0_.type AS type_9, a0_.short_description AS short_description_10, a0_.description AS description_11, a0_.description_start AS description_start_12, a0_.tags AS tags_13, a0_.visibility AS visibility_14, a0_.language AS language_15, a0_.carousel AS carousel_16, a0_.featured AS featured_17, a0_.autopublished_at AS autopublished_at_18, a0_.translation AS translation_19, a0_.sitemap AS sitemap_20, a0_.robots AS robots_21, a0_.type_editor AS type_editor_22, a0_.canonical AS canonical_23, a0_.author AS author_24, a0_.url AS url_25, a0_.cta_html AS cta_html_26, a0_.keyword AS keyword_27, a0_.pageslug AS pageslug_28, a0_.pageslug2 AS pageslug2_29, a0_.pageslug3 AS pageslug3_30, a0_.visibleArticles AS visibleArticles_31, a0_.onlyPage AS onlyPage_32, a0_.identifiant AS identifiant_33, a0_.image_name AS image_name_34, a0_.image_original_name AS image_original_name_35, a0_.image_mime_type AS image_mime_type_36, a0_.image_size AS image_size_37, a0_.image_dimensions AS image_dimensions_38 FROM articles_articles a0_ WHERE a0_.language = ? AND a0_.pageslug = ? AND a0_.pageslug2 = ? AND a0_.pageslug3 IS NULL Parameters: [ "fr" "azerty" "abc" ] |
| 0.40 ms (0.94%) | 1 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.locale AS locale_4, t0.keypair AS keypair_5, t0.value AS value_6 FROM core_translations t0 WHERE t0.locale = ? Parameters: [
"fr"
] |
| 0.35 ms (0.81%) | 2 | SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.title_page AS title_page_3, c0_.name AS name_4, c0_.description AS description_5, c0_.sequence AS sequence_6, c0_.type AS type_7, c0_.category AS category_8, c0_.type_website AS type_website_9, c0_.tool_id AS tool_id_10 FROM core_tools c0_ WHERE c0_.type_website LIKE ? ORDER BY c0_.id ASC Parameters: [
"%article%"
] |
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 |
|---|---|
| App\Entity\Seo\Redirection | No errors. |
| Vich\UploaderBundle\Entity\File | No errors. |
| App\Entity\Articles\Articles | No errors. |
| App\Entity\Core\Tools | No errors. |
| App\Entity\Core\Translations | No errors. |
| App\Entity\Menu\WebsiteParents | No errors. |
| App\Entity\Menu\WebsiteItems | No errors. |
| App\Entity\Articles\Blocks | No errors. |