Query Metrics
27Database Queries
8Different statements
4.74 msQuery time
0Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.78 ms | 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/resume" 1 ] |
| 2 | 0.44 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.name AS name_4, t0.folder_slug AS folder_slug_5, t0.folder_slug2 AS folder_slug2_6, t0.folder_slug3 AS folder_slug3_7, t0.title AS title_8, t0.short_title AS short_title_9, t0.description AS description_10, t0.short_description AS short_description_11, t0.views AS views_12, t0.locale AS locale_13, t0.noblock AS noblock_14, t0.robots AS robots_15, t0.type AS type_16, t0.sitemap AS sitemap_17, t0.menu_absolute AS menu_absolute_18, t0.theme AS theme_19, t0.style AS style_20, t0.javascript AS javascript_21, t0.redirect AS redirect_22, t0.identifiant AS identifiant_23, t0.sequence AS sequence_24, t0.canonical AS canonical_25, t0.author AS author_26, t0.premium AS premium_27, t0.navbar AS navbar_28, t0.navbar_background_color AS navbar_background_color_29, t0.image_name AS image_name_30, t0.image_original_name AS image_original_name_31, t0.image_mime_type AS image_mime_type_32, t0.image_size AS image_size_33, t0.image_dimensions AS image_dimensions_34, t0.fiche_id AS fiche_id_35 FROM pages_pages t0 WHERE t0.name = ? AND t0.locale = ? LIMIT 1 Parameters: [ "resume" "fr" ] |
| 3 | 0.17 ms | 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: [
"%blog%"
] |
| 4 | 0.13 ms | 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"
] |
| 5 | 0.23 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "en" ] |
| 6 | 0.20 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "fr" ] |
| 7 | 0.16 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "de" ] |
| 8 | 0.19 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "es" ] |
| 9 | 0.18 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "nl" ] |
| 10 | 0.17 ms | 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 ] |
| 11 | 0.11 ms | 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-right" 1 ] |
| 12 | 0.10 ms | 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 | 0.09 ms | 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: [
13
] |
| 14 | 0.09 ms | 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: [
14
] |
| 15 | 0.10 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "en" ] |
| 16 | 0.13 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "fr" ] |
| 17 | 0.13 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "de" ] |
| 18 | 0.13 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "es" ] |
| 19 | 0.12 ms | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.language AS language_4, t0.redirect_link AS redirect_link_5, t0.page_id AS page_id_6, t0.pagecible_id AS pagecible_id_7 FROM pages_pages_has_languages t0 WHERE t0.page_id = ? AND t0.language = ? LIMIT 1 Parameters: [ 31 "nl" ] |
| 20 | 0.12 ms | 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
] |
| 21 | 0.13 ms | 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: [
13
] |
| 22 | 0.12 ms | 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: [
14
] |
| 23 | 0.17 ms | 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" ] |
| 24 | 0.12 ms | 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: [ "Entreprises" "en" ] |
| 25 | 0.11 ms | 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: [ "Blog" "en" ] |
| 26 | 0.13 ms | 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" "footer" 1 ] |
| 27 | 0.17 ms | 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: [ "Start now for free" "en" ] |
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\Pages\Pages | No errors. |
| App\Entity\Fiches\Articles | No errors. |
| App\Entity\Core\Tools | No errors. |
| App\Entity\Core\Translations | No errors. |
| App\Entity\Pages\PagesHasLanguages | No errors. |
| App\Entity\Menu\WebsiteParents | No errors. |
| App\Entity\Menu\WebsiteItems | No errors. |