Query Metrics

31 Database Queries
13 Different statements
31.66 ms Query time
3 Invalid entities

Queries

Group similar statements

# Time Info
1 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.maintenance AS maintenance_18, t0.logo AS logo_19, t0.contact_url AS contact_url_20, t0.contact_background AS contact_background_21, t0.contact_latitude AS contact_latitude_22, t0.contact_longitude AS contact_longitude_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM parameter t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
2 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.maintenance AS maintenance_18, t0.logo AS logo_19, t0.contact_url AS contact_url_20, t0.contact_background AS contact_background_21, t0.contact_latitude AS contact_latitude_22, t0.contact_longitude AS contact_longitude_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM parameter t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
3 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.maintenance AS maintenance_18, t0.logo AS logo_19, t0.contact_url AS contact_url_20, t0.contact_background AS contact_background_21, t0.contact_latitude AS contact_latitude_22, t0.contact_longitude AS contact_longitude_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM parameter t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
4 0.18 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.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.affichage_menu AS affichage_menu_7, t0.slug AS slug_8, t0.display AS display_9, t0.no_index AS no_index_10, t0.type_id AS type_id_11 FROM page t0 WHERE t0.display = ?
Parameters:
[
  1
]
5 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  1
]
6 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  2
]
7 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  3
]
8 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  4
]
9 9.53 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  7
]
10 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  8
]
11 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  9
]
12 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  12
]
13 0.13 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  13
]
14 0.14 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  14
]
15 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM page_type t0 WHERE t0.id = ?
Parameters:
[
  15
]
16 0.50 ms
SELECT t0.id AS id_1, t0.vignette_text AS vignette_text_2, t0.vignette_image AS vignette_image_3, t0.date_debut AS date_debut_4, t0.date_fin AS date_fin_5, t0.breadcrumb AS breadcrumb_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.title AS title_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.affichage_menu AS affichage_menu_12, t0.slug AS slug_13, t0.display AS display_14, t0.no_index AS no_index_15 FROM blog_article t0 WHERE t0.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[
  "actualites"
  1
]
17 0.38 ms
SELECT t0.id AS id_1, t0.vignette_text AS vignette_text_2, t0.vignette_image AS vignette_image_3, t0.breadcrumb AS breadcrumb_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.title AS title_7, t0.meta_title AS meta_title_8, t0.meta_description AS meta_description_9, t0.affichage_menu AS affichage_menu_10, t0.slug AS slug_11, t0.display AS display_12, t0.no_index AS no_index_13, t0.parent_id AS parent_id_14 FROM blog_category t0 WHERE t0.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[
  "actualites"
  1
]
18 1.11 ms
SELECT b0_.id AS id_0, b0_.vignette_text AS vignette_text_1, b0_.vignette_image AS vignette_image_2, b0_.date_debut AS date_debut_3, b0_.date_fin AS date_fin_4, b0_.breadcrumb AS breadcrumb_5, b0_.created_at AS created_at_6, b0_.updated_at AS updated_at_7, b0_.title AS title_8, b0_.meta_title AS meta_title_9, b0_.meta_description AS meta_description_10, b0_.affichage_menu AS affichage_menu_11, b0_.slug AS slug_12, b0_.display AS display_13, b0_.no_index AS no_index_14 FROM blog_article b0_ INNER JOIN blog_category_article b2_ ON b0_.id = b2_.article_id INNER JOIN blog_category b1_ ON b1_.id = b2_.category_id WHERE b0_.display = 1 AND ((b0_.date_debut IS NULL OR b0_.date_debut <= CURRENT_TIMESTAMP)) AND b1_.id = ? ORDER BY b0_.date_debut DESC
Parameters:
[
  3
]
19 0.45 ms
SELECT b0_.id AS id_0, b0_.vignette_text AS vignette_text_1, b0_.vignette_image AS vignette_image_2, b0_.breadcrumb AS breadcrumb_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.title AS title_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.affichage_menu AS affichage_menu_9, b0_.slug AS slug_10, b0_.display AS display_11, b0_.no_index AS no_index_12, b0_.parent_id AS parent_id_13 FROM blog_category b0_ WHERE b0_.display = 1 AND b0_.id <> ? ORDER BY b0_.title ASC
Parameters:
[
  3
]
20 0.34 ms
SELECT b0_.id AS id_0, b0_.vignette_text AS vignette_text_1, b0_.vignette_image AS vignette_image_2, b0_.breadcrumb AS breadcrumb_3, b0_.created_at AS created_at_4, b0_.updated_at AS updated_at_5, b0_.title AS title_6, b0_.meta_title AS meta_title_7, b0_.meta_description AS meta_description_8, b0_.affichage_menu AS affichage_menu_9, b0_.slug AS slug_10, b0_.display AS display_11, b0_.no_index AS no_index_12, b0_.parent_id AS parent_id_13 FROM blog_category b0_ WHERE b0_.display = 1 AND b0_.parent_id = ? ORDER BY b0_.title ASC
Parameters:
[
  3
]
21 0.44 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.title AS title_4, t0.text_color AS text_color_5, t0.type AS type_6, t0.image AS image_7, t0.image2 AS image2_8, t0.image_mobile AS image_mobile_9, t0.image_position_horizontal AS image_position_horizontal_10, t0.image_position_vertical AS image_position_vertical_11, t0.video AS video_12, t0.position AS position_13, t0.carrousel AS carrousel_14, t0.button AS button_15, t0.map_latitude AS map_latitude_16, t0.map_longitude AS map_longitude_17, t0.map_zoom AS map_zoom_18, t0.section_nethelium_affichage AS section_nethelium_affichage_19, t0.number_article AS number_article_20, t0.link_video AS link_video_21, t0.created_at AS created_at_22, t0.updated_at AS updated_at_23, t0.page_id AS page_id_24, t0.iframe_nethelium_id AS iframe_nethelium_id_25 FROM blog_category_section t0 WHERE t0.page_id = ? ORDER BY t0.position ASC
Parameters:
[
  3
]
22 1.54 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.maintenance AS maintenance_18, t0.logo AS logo_19, t0.contact_url AS contact_url_20, t0.contact_background AS contact_background_21, t0.contact_latitude AS contact_latitude_22, t0.contact_longitude AS contact_longitude_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM parameter t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
23 13.47 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.maintenance AS maintenance_18, t0.logo AS logo_19, t0.contact_url AS contact_url_20, t0.contact_background AS contact_background_21, t0.contact_latitude AS contact_latitude_22, t0.contact_longitude AS contact_longitude_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM parameter t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
24 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.address AS address_3, t0.zip AS zip_4, t0.city AS city_5, t0.email AS email_6, t0.phone AS phone_7, t0.opening_hours AS opening_hours_8, t0.net_helium AS net_helium_9, t0.facebook AS facebook_10, t0.twitter AS twitter_11, t0.instagram AS instagram_12, t0.linkedin AS linkedin_13, t0.youtube AS youtube_14, t0.gta AS gta_15, t0.gtm AS gtm_16, t0.matomo AS matomo_17, t0.maintenance AS maintenance_18, t0.logo AS logo_19, t0.contact_url AS contact_url_20, t0.contact_background AS contact_background_21, t0.contact_latitude AS contact_latitude_22, t0.contact_longitude AS contact_longitude_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25 FROM parameter t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  1
]
25 0.16 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.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.affichage_menu AS affichage_menu_7, t0.slug AS slug_8, t0.display AS display_9, t0.no_index AS no_index_10, t0.type_id AS type_id_11 FROM page t0 WHERE t0.display = ?
Parameters:
[
  1
]
26 0.16 ms
SELECT m0_.id AS id_0, m0_.type AS type_1, m0_.url AS url_2, m0_.open_window AS open_window_3, m0_.name AS name_4, m0_.display AS display_5, m0_.position AS position_6, m0_.type_blog AS type_blog_7, m0_.created_at AS created_at_8, m0_.updated_at AS updated_at_9, m0_.page_id AS page_id_10, m0_.page_blog_category_id AS page_blog_category_id_11, m0_.page_blog_article_id AS page_blog_article_id_12 FROM menu m0_ WHERE m0_.display = ? ORDER BY m0_.position ASC
Parameters:
[
  1
]
27 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM vehicle_category t0 ORDER BY t0.position ASC
Parameters:
[]
28 0.30 ms
SELECT t0.image_name AS image_name_1, t0.url AS url_2, t0.url_mobile AS url_mobile_3, t0.alt AS alt_4, t0.id AS id_5, t0.name AS name_6, t0.net_helium AS net_helium_7, t0.price AS price_8, t0.legals AS legals_9, t0.page_title AS page_title_10, t0.meta AS meta_11, t0.monthly_price AS monthly_price_12, t0.nav_image AS nav_image_13, t0.banniere AS banniere_14, t0.banniere_mobile AS banniere_mobile_15, t0.banniere_text AS banniere_text_16, t0.gamme_text AS gamme_text_17, t0.vignette_image AS vignette_image_18, t0.equipement_pdf AS equipement_pdf_19, t0.display AS display_20, t0.display_home AS display_home_21, t0.price_ttc AS price_ttc_22, t0.position AS position_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.title AS title_26, t0.meta_title AS meta_title_27, t0.meta_description AS meta_description_28, t0.affichage_menu AS affichage_menu_29, t0.slug AS slug_30, t0.no_index AS no_index_31, t0.category_id AS category_id_32 FROM vehicle t0 WHERE t0.display = ? AND t0.category_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
  1
]
29 0.23 ms
SELECT t0.image_name AS image_name_1, t0.url AS url_2, t0.url_mobile AS url_mobile_3, t0.alt AS alt_4, t0.id AS id_5, t0.name AS name_6, t0.net_helium AS net_helium_7, t0.price AS price_8, t0.legals AS legals_9, t0.page_title AS page_title_10, t0.meta AS meta_11, t0.monthly_price AS monthly_price_12, t0.nav_image AS nav_image_13, t0.banniere AS banniere_14, t0.banniere_mobile AS banniere_mobile_15, t0.banniere_text AS banniere_text_16, t0.gamme_text AS gamme_text_17, t0.vignette_image AS vignette_image_18, t0.equipement_pdf AS equipement_pdf_19, t0.display AS display_20, t0.display_home AS display_home_21, t0.price_ttc AS price_ttc_22, t0.position AS position_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.title AS title_26, t0.meta_title AS meta_title_27, t0.meta_description AS meta_description_28, t0.affichage_menu AS affichage_menu_29, t0.slug AS slug_30, t0.no_index AS no_index_31, t0.category_id AS category_id_32 FROM vehicle t0 WHERE t0.display = ? AND t0.category_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
  2
]
30 0.19 ms
SELECT t0.image_name AS image_name_1, t0.url AS url_2, t0.url_mobile AS url_mobile_3, t0.alt AS alt_4, t0.id AS id_5, t0.name AS name_6, t0.net_helium AS net_helium_7, t0.price AS price_8, t0.legals AS legals_9, t0.page_title AS page_title_10, t0.meta AS meta_11, t0.monthly_price AS monthly_price_12, t0.nav_image AS nav_image_13, t0.banniere AS banniere_14, t0.banniere_mobile AS banniere_mobile_15, t0.banniere_text AS banniere_text_16, t0.gamme_text AS gamme_text_17, t0.vignette_image AS vignette_image_18, t0.equipement_pdf AS equipement_pdf_19, t0.display AS display_20, t0.display_home AS display_home_21, t0.price_ttc AS price_ttc_22, t0.position AS position_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.title AS title_26, t0.meta_title AS meta_title_27, t0.meta_description AS meta_description_28, t0.affichage_menu AS affichage_menu_29, t0.slug AS slug_30, t0.no_index AS no_index_31, t0.category_id AS category_id_32 FROM vehicle t0 WHERE t0.display = ? AND t0.category_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
  3
]
31 0.16 ms
SELECT t0.id AS id_1, t0.background_color AS background_color_2, t0.text AS text_3, t0.display AS display_4, t0.position AS position_5, t0.days AS days_6, t0.button_background_color AS button_background_color_7, t0.button_font_color AS button_font_color_8, t0.button_font_size AS button_font_size_9, t0.button_text AS button_text_10, t0.button_url AS button_url_11, t0.button_display AS button_display_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14 FROM bandeau t0 WHERE t0.display = ? ORDER BY t0.position ASC
Parameters:
[
  1
]

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\Parameter No errors.
App\Entity\Carrousel No errors.
App\Entity\Page No errors.
App\Entity\PageType
  • The association App\Entity\PageType#menus refers to the owning side field App\Entity\Menu#type which is not defined as association, but as field.
  • The association App\Entity\PageType#menus refers to the owning side field App\Entity\Menu#type which does not exist.
App\Entity\PageSection No errors.
App\Entity\Menu
  • The association App\Entity\Menu#page refers to the inverse side field App\Entity\Page#menus which does not exist.
  • The association App\Entity\Menu#pageBlogCategory refers to the inverse side field App\Entity\BlogCategory#menus which does not exist.
  • The association App\Entity\Menu#pageBlogArticle refers to the inverse side field App\Entity\BlogArticle#menus which does not exist.
App\Entity\BlogArticle No errors.
App\Entity\BlogCategory No errors.
App\Entity\BlogCategorySection No errors.
App\Entity\BlogArticleSection No errors.
App\Entity\IframeNethelium No errors.
App\Entity\Norme
  • The mappings App\Entity\Norme#blogCategorySection and App\Entity\BlogCategorySection#normes are inconsistent with each other.
App\Entity\Marker No errors.
App\Entity\VehicleCategory No errors.
App\Entity\Image No errors.
App\Entity\Vehicle No errors.
App\Entity\VehicleVariant No errors.
App\Entity\VehicleCustomSpec No errors.
App\Entity\VehicleSection No errors.
App\Entity\Bandeau No errors.