GET https://byd-brest.agence-11h10.fr/fr/configuration/seal/excellence-awd

Query Metrics

42 Database Queries
17 Different statements
49.63 ms Query time
6 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.75 ms
(25.69%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.net_helium AS net_helium_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM color t0 WHERE t0.id = ?
Parameters:
[
  2
]
8.90 ms
(17.94%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.net_helium AS net_helium_3, t0.icon AS icon_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM interior t0 WHERE t0.id = ?
Parameters:
[
  11
]
7.26 ms
(14.63%)
11
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
]
5.11 ms
(10.29%)
7
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.41 ms
(8.89%)
1
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
]
3.14 ms
(6.32%)
1
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.description AS description_9, t0.slug AS slug_10, t0.price_ttc AS price_ttc_11, t0.monthly_price AS monthly_price_12, t0.position AS position_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.vehicle_id AS vehicle_id_16 FROM vehicle_variant t0 WHERE t0.vehicle_id = ? ORDER BY t0.position ASC
Parameters:
[
  6
]
2.91 ms
(5.87%)
1
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:
[]
0.79 ms
(1.60%)
3
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
]
0.69 ms
(1.39%)
1
SELECT t0.id AS id_1, t0.price_wheel AS price_wheel_2, t0.price_color AS price_color_3, t0.price_interior AS price_interior_4, t0.image_wheel AS image_wheel_5, t0.image_color AS image_color_6, t0.image_interior AS image_interior_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.vehicle_variant_id AS vehicle_variant_id_10, t0.wheel_id AS wheel_id_11, t0.color_id AS color_id_12, t0.interior_id AS interior_id_13 FROM combinaison t0 WHERE t0.vehicle_variant_id = ? ORDER BY t0.color_id ASC, t0.interior_id ASC, t0.wheel_id ASC
Parameters:
[
  15
]
0.60 ms
(1.21%)
1
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.slug = ? AND t0.display = ? LIMIT 1
Parameters:
[
  "seal"
  1
]
0.51 ms
(1.03%)
1
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.description AS description_9, t0.slug AS slug_10, t0.price_ttc AS price_ttc_11, t0.monthly_price AS monthly_price_12, t0.position AS position_13, t0.created_at AS created_at_14, t0.updated_at AS updated_at_15, t0.vehicle_id AS vehicle_id_16 FROM vehicle_variant t0 WHERE t0.vehicle_id = ? AND t0.slug = ? LIMIT 1
Parameters:
[
  6
  "excellence-awd"
]
0.50 ms
(1.00%)
2
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
]
0.48 ms
(0.97%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.net_helium AS net_helium_3, t0.icon AS icon_4, t0.position AS position_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM wheel t0 WHERE t0.id = ?
Parameters:
[
  7
]
0.48 ms
(0.96%)
1
SELECT t0.id AS id_1, t0.address AS address_2, t0.zip AS zip_3, t0.city AS city_4, t0.email AS email_5, t0.phone AS phone_6, t0.opening_hours AS opening_hours_7, t0.contact_url AS contact_url_8, t0.contact_background AS contact_background_9, t0.contact_latitude AS contact_latitude_10, t0.contact_longitude AS contact_longitude_11, t0.contact_zoom AS contact_zoom_12, t0.position AS position_13, t0.net_helium AS net_helium_14, t0.created_at AS created_at_15, t0.updated_at AS updated_at_16, t0.title AS title_17, t0.meta_title AS meta_title_18, t0.meta_description AS meta_description_19, t0.affichage_menu AS affichage_menu_20, t0.slug AS slug_21, t0.display AS display_22, t0.no_index AS no_index_23 FROM concession t0 WHERE t0.display = ? ORDER BY t0.title ASC
Parameters:
[
  1
]
0.45 ms
(0.91%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.net_helium AS net_helium_3, t0.image AS image_4, t0.icon AS icon_5, t0.price AS price_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.vehicle_variant_id AS vehicle_variant_id_9 FROM vehicle_variant_color t0 WHERE t0.vehicle_variant_id = ?
Parameters:
[
  15
]
0.44 ms
(0.90%)
1
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
]
0.20 ms
(0.40%)
1
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.id = ?
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\Image No errors.
App\Entity\Vehicle No errors.
App\Entity\VehicleCategory No errors.
App\Entity\VehicleVariant No errors.
App\Entity\VehicleCustomSpec No errors.
App\Entity\VehicleSection No errors.
App\Entity\VehicleVariantColor No errors.
App\Entity\Combinaison
  • The association App\Entity\Combinaison#wheel refers to the inverse side field App\Entity\Wheel#combinaisons which does not exist.
  • The association App\Entity\Combinaison#color refers to the inverse side field App\Entity\Color#combinaisons which does not exist.
  • The association App\Entity\Combinaison#interior refers to the inverse side field App\Entity\Interior#combinaisons which does not exist.
App\Entity\VehicleVariantWheels
  • The mappings App\Entity\VehicleVariantWheels#images and App\Entity\WheelsColorImage#wheels are inconsistent with each other.
App\Entity\VehicleVariantInterior No errors.
App\Entity\Wheel No errors.
App\Entity\Color No errors.
App\Entity\Interior No errors.
App\Entity\Concession No errors.
App\Entity\ConcessionSection No errors.
App\Entity\BlogCategory No errors.
App\Entity\BlogArticle No errors.
App\Entity\Bandeau No errors.
App\Entity\BlogCategorySection No errors.
App\Entity\BlogArticleSection 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\IframeNethelium No errors.
App\Entity\WheelsColorImage
  • The association App\Entity\WheelsColorImage#wheels refers to the inverse side field App\Entity\VehicleVariantWheels#image which does not exist.
App\Entity\InteriorColorImage No errors.
App\Entity\VehicleVariantSpec No errors.
App\Entity\VariantWheels No errors.
App\Entity\Media No errors.
App\Entity\User No errors.
Vich\UploaderBundle\Entity\File No errors.