Query Metrics
13Database Queries
12Different statements
75.62 msQuery time
0Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
60.25 ms (79.67%) | 1 | "COMMIT" Parameters: [] |
10.88 ms (14.39%) | 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.title_block AS title_block_5, t0.description AS description_6, t0.description_html AS description_html_7, t0.svg_html AS svg_html_8, t0.backgroundColor AS backgroundColor_9, t0.html AS html_10, t0.type AS type_11, t0.type_block AS type_block_12, t0.sequence AS sequence_13, t0.style AS style_14, t0.visibility_user AS visibility_user_15, t0.only_visitor AS only_visitor_16, t0.visibility_title AS visibility_title_17, t0.visibility_date AS visibility_date_18, t0.start_page AS start_page_19, t0.image_name AS image_name_20, t0.image_original_name AS image_original_name_21, t0.image_mime_type AS image_mime_type_22, t0.image_size AS image_size_23, t0.image_dimensions AS image_dimensions_24, t0.page_id AS page_id_25, t0.savetemplate_id AS savetemplate_id_26, t0.article_id AS article_id_27 FROM pages_pages_has_blocks t0 WHERE t0.page_id = ? AND t0.type = ? AND t0.start_page = ? ORDER BY t0.sequence ASC Parameters: [ 43 "prod" 0 ] |
0.88 ms (1.16%) | 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: [ "cgv" 1 ] |
0.67 ms (0.89%) | 1 | UPDATE pages_pages SET views = ?, updated_at = ? WHERE id = ? Parameters: [ 1718 "2024-11-23 23:13:26" 43 ] |
0.54 ms (0.71%) | 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: [
"%blog%"
] |
0.42 ms (0.56%) | 1 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.expired_at AS expired_at_4, t0.identifiant AS identifiant_5, t0.email AS email_6, t0.title AS title_7, t0.description_initial AS description_initial_8, t0.description_content AS description_content_9, t0.description_cta AS description_cta_10, t0.path_cta AS path_cta_11, t0.button_cta AS button_cta_12, t0.title1 AS title1_13, t0.subtitle1 AS subtitle1_14, t0.description1 AS description1_15, t0.title2 AS title2_16, t0.subtitle2 AS subtitle2_17, t0.description2 AS description2_18, t0.title3 AS title3_19, t0.subtitle3 AS subtitle3_20, t0.description3 AS description3_21, t0.min AS min_22, t0.min_hours AS min_hours_23, t0.max AS max_24, t0.max_hours AS max_hours_25, t0.price_day AS price_day_26, t0.price_hour AS price_hour_27, t0.views AS views_28 FROM pages_simulation_content t0 WHERE t0.identifiant = ? LIMIT 1 Parameters: [
"cgv"
] |
0.42 ms (0.56%) | 1 | SELECT p0_.id AS id_0, p0_.created_at AS created_at_1, p0_.updated_at AS updated_at_2, p0_.name AS name_3, p0_.folder_slug AS folder_slug_4, p0_.folder_slug2 AS folder_slug2_5, p0_.folder_slug3 AS folder_slug3_6, p0_.title AS title_7, p0_.short_title AS short_title_8, p0_.description AS description_9, p0_.short_description AS short_description_10, p0_.views AS views_11, p0_.locale AS locale_12, p0_.noblock AS noblock_13, p0_.robots AS robots_14, p0_.type AS type_15, p0_.sitemap AS sitemap_16, p0_.menu_absolute AS menu_absolute_17, p0_.theme AS theme_18, p0_.style AS style_19, p0_.javascript AS javascript_20, p0_.redirect AS redirect_21, p0_.identifiant AS identifiant_22, p0_.sequence AS sequence_23, p0_.canonical AS canonical_24, p0_.author AS author_25, p0_.premium AS premium_26, p0_.navbar AS navbar_27, p0_.navbar_background_color AS navbar_background_color_28, p0_.image_name AS image_name_29, p0_.image_original_name AS image_original_name_30, p0_.image_mime_type AS image_mime_type_31, p0_.image_size AS image_size_32, p0_.image_dimensions AS image_dimensions_33, p0_.fiche_id AS fiche_id_34 FROM pages_pages p0_ WHERE (p0_.locale = ? AND p0_.name IS NULL) AND p0_.folder_slug = ? AND p0_.folder_slug2 IS NULL AND p0_.folder_slug3 IS NULL Parameters: [ "fr" "cgv" ] |
0.41 ms (0.54%) | 1 | 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.identifiant_key AS identifiant_key_5, t0.title AS title_6, t0.description AS description_7, t0.description_content AS description_content_8, t0.views AS views_9 FROM pages_secure_content t0 WHERE t0.identifiant = ? LIMIT 1 Parameters: [
"cgv"
] |
0.41 ms (0.54%) | 1 | SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.folder_slug AS folder_slug_4, t0.folder_slug2 AS folder_slug2_5, t0.folder_slug3 AS folder_slug3_6, t0.title AS title_7, t0.tag AS tag_8, t0.status AS status_9, t0.theme AS theme_10, t0.short_title AS short_title_11, t0.short_description AS short_description_12, t0.description_cover AS description_cover_13, t0.description_content AS description_content_14, t0.description_content_end AS description_content_end_15, t0.title_mitillo_plus AS title_mitillo_plus_16, t0.path_mirtillo_plus AS path_mirtillo_plus_17, t0.description_mirtillo_plus AS description_mirtillo_plus_18, t0.title_button_mirtillo_plus AS title_button_mirtillo_plus_19, t0.description_after_cover AS description_after_cover_20, t0.page_id AS page_id_21 FROM pages_contents t0 WHERE t0.folder_slug = ? AND t0.status = ? LIMIT 1 Parameters: [ "cgv" "ONLINE" ] |
0.34 ms (0.45%) | 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.short_title AS short_title_5, t0.short_description AS short_description_6, t0.folder_slug AS folder_slug_7, t0.folder_slug2 AS folder_slug2_8, t0.folder_slug3 AS folder_slug3_9, t0.tag AS tag_10, t0.description AS description_11, t0.description_premium AS description_premium_12, t0.status AS status_13, t0.theme AS theme_14, t0.category_id AS category_id_15, t0.user_id AS user_id_16 FROM fiches_articles t0 WHERE t0.folder_slug = ? AND t0.status = ? LIMIT 1 Parameters: [ "cgv" "ONLINE" ] |
0.23 ms (0.31%) | 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.description AS description_6, t0.short_title AS short_title_7, t0.short_description AS short_description_8, t0.project AS project_9 FROM cvs_big_categories t0 ORDER BY t0.title ASC Parameters: [] |
0.17 ms (0.23%) | 1 | "START TRANSACTION" 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 |
---|---|
App\Entity\Seo\Redirection | No errors. |
App\Entity\Pages\SimulationContent | No errors. |
App\Entity\Pages\SecureContent | No errors. |
App\Entity\Pages\Contents | No errors. |
Vich\UploaderBundle\Entity\File | No errors. |
App\Entity\Pages\Pages | No errors. |
App\Entity\Fiches\Articles | No errors. |
App\Entity\Fiches\Categories | No errors. |
App\Entity\Core\Users | No errors. |
App\Entity\Pages\PagesHasBlocks | No errors. |
App\Entity\Pages\SaveTemplates | No errors. |
App\Entity\Articles\Articles | No errors. |
App\Entity\Core\Tools | No errors. |
App\Entity\Cvs\BigCategories | No errors. |