Query Metrics
37
Database Queries
15
Different statements
10.11 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
2.09 ms (20.68%) |
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
]
|
|
1.79 ms (17.73%) |
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
]
|
|
1.27 ms (12.57%) |
4 |
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:
[
58
]
|
|
0.81 ms (7.99%) |
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.66 ms (6.56%) |
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:
[
27
]
|
|
0.61 ms (6.06%) |
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:
[ "dolphin-surf" 1 ] |
|
0.51 ms (5.06%) |
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:
[ 12 "active" ] |
|
0.46 ms (4.60%) |
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.31 ms (3.03%) |
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 interior t0 WHERE t0.id = ?
Parameters:
[
22
]
|
|
0.29 ms (2.88%) |
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.29 ms (2.87%) |
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:
[
13
]
|
|
0.26 ms (2.61%) |
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
]
|
|
0.26 ms (2.55%) |
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
]
|
|
0.25 ms (2.47%) |
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.24 ms (2.34%) |
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
]
|
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 |
|
| App\Entity\PageSection | No errors. |
| App\Entity\Menu |
|
| 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 |
|
| App\Entity\VehicleVariantWheels |
|
| 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. |