GET https://caenttc.fr/

Query Metrics

48 Database Queries
14 Different statements
5.66 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
2.01 ms
(35.46%)
20
SELECT t0.id AS id_1, t0.name AS name_2, t0.params AS params_3, t0.denomination AS denomination_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.facebook_title AS facebook_title_7, t0.facebook_description AS facebook_description_8, t0.facebook_image AS facebook_image_9, t0.twitter_title AS twitter_title_10, t0.twitter_description AS twitter_description_11, t0.twitter_image AS twitter_image_12, t0.redirection AS redirection_13, t0.url_redirection AS url_redirection_14, t0.noindex AS noindex_15, t0.nofollow AS nofollow_16, t0.noodp AS noodp_17, t0.noimageindex AS noimageindex_18, t0.noarchive AS noarchive_19, t0.nosnippet AS nosnippet_20, t0.tag_manager AS tag_manager_21, t0.tag_manager_no_script AS tag_manager_no_script_22, t0.category AS category_23, t0.category_footer_id AS category_footer_id_24 FROM front_route t0 WHERE t0.id = ?
Parameters:
[
  111
]
0.67 ms
(11.88%)
1
SELECT t0.id AS id_1, t0.template AS template_2, t0.pos AS pos_3, t0.image AS image_4 FROM choose_home_components t0 ORDER BY t0.pos ASC
Parameters:
[]
0.66 ms
(11.62%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.params AS params_3, t0.denomination AS denomination_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.facebook_title AS facebook_title_7, t0.facebook_description AS facebook_description_8, t0.facebook_image AS facebook_image_9, t0.twitter_title AS twitter_title_10, t0.twitter_description AS twitter_description_11, t0.twitter_image AS twitter_image_12, t0.redirection AS redirection_13, t0.url_redirection AS url_redirection_14, t0.noindex AS noindex_15, t0.nofollow AS nofollow_16, t0.noodp AS noodp_17, t0.noimageindex AS noimageindex_18, t0.noarchive AS noarchive_19, t0.nosnippet AS nosnippet_20, t0.tag_manager AS tag_manager_21, t0.tag_manager_no_script AS tag_manager_no_script_22, t0.category AS category_23, t0.category_footer_id AS category_footer_id_24 FROM front_route t0 WHERE t0.category_footer_id = ?
Parameters:
[
  1
]
0.55 ms
(9.69%)
6
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3, t0.url_custom AS url_custom_4, t0.ancrage AS ancrage_5, t0.parent_id AS parent_id_6, t0.route_id AS route_id_7 FROM menu_sub_items t0 WHERE t0.parent_id = ?
Parameters:
[
  18
]
0.43 ms
(7.52%)
2
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.params AS params_2, f0_.denomination AS denomination_3, f0_.meta_title AS meta_title_4, f0_.meta_description AS meta_description_5, f0_.facebook_title AS facebook_title_6, f0_.facebook_description AS facebook_description_7, f0_.facebook_image AS facebook_image_8, f0_.twitter_title AS twitter_title_9, f0_.twitter_description AS twitter_description_10, f0_.twitter_image AS twitter_image_11, f0_.redirection AS redirection_12, f0_.url_redirection AS url_redirection_13, f0_.noindex AS noindex_14, f0_.nofollow AS nofollow_15, f0_.noodp AS noodp_16, f0_.noimageindex AS noimageindex_17, f0_.noarchive AS noarchive_18, f0_.nosnippet AS nosnippet_19, f0_.tag_manager AS tag_manager_20, f0_.tag_manager_no_script AS tag_manager_no_script_21, f0_.category AS category_22, f0_.category_footer_id AS category_footer_id_23 FROM front_route f0_ WHERE f0_.name = ?
Parameters:
[
  "app_front_home"
]
0.24 ms
(4.15%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM partenaire_category t0
Parameters:
[]
0.20 ms
(3.62%)
2
SELECT t0.id AS id_1, t0.image AS image_2, t0.url_partenaire AS url_partenaire_3, t0.name AS name_4, t0.category_footer_id AS category_footer_id_5 FROM partenaire_footer t0 WHERE t0.category_footer_id = ?
Parameters:
[
  4
]
0.19 ms
(3.43%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.icon AS icon_3, t0.url AS url_4, t0.active AS active_5, t0.position AS position_6 FROM reseau_social t0 WHERE t0.active = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.19 ms
(3.35%)
2
SELECT t0.id AS id_1, t0.image AS image_2, t0.url_partenaire AS url_partenaire_3, t0.name AS name_4, t0.firstname AS firstname_5, t0.lastname AS lastname_6, t0.email AS email_7, t0.phone AS phone_8, t0.adresse AS adresse_9, t0.city AS city_10, t0.postal_code AS postal_code_11, t0.category_id AS category_id_12 FROM partenaire t0 WHERE t0.category_id = ?
Parameters:
[
  1
]
0.14 ms
(2.40%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.params AS params_3, t0.denomination AS denomination_4, t0.meta_title AS meta_title_5, t0.meta_description AS meta_description_6, t0.facebook_title AS facebook_title_7, t0.facebook_description AS facebook_description_8, t0.facebook_image AS facebook_image_9, t0.twitter_title AS twitter_title_10, t0.twitter_description AS twitter_description_11, t0.twitter_image AS twitter_image_12, t0.redirection AS redirection_13, t0.url_redirection AS url_redirection_14, t0.noindex AS noindex_15, t0.nofollow AS nofollow_16, t0.noodp AS noodp_17, t0.noimageindex AS noimageindex_18, t0.noarchive AS noarchive_19, t0.nosnippet AS nosnippet_20, t0.tag_manager AS tag_manager_21, t0.tag_manager_no_script AS tag_manager_no_script_22, t0.category AS category_23, t0.category_footer_id AS category_footer_id_24 FROM front_route t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "app_front_home"
]
0.11 ms
(1.91%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM contact t0
Parameters:
[]
0.10 ms
(1.73%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM menu_name t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "header_menu"
]
0.09 ms
(1.64%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.parent AS parent_3, t0.position AS position_4, t0.url_custom AS url_custom_5, t0.ancrage AS ancrage_6, t0.menu_id AS menu_id_7, t0.route_id AS route_id_8 FROM menu_items t0 WHERE t0.menu_id = ? ORDER BY t0.position ASC
Parameters:
[
  1
]
0.09 ms
(1.59%)
1
SELECT t0.id AS id_1, t0.categorie_name AS categorie_name_2 FROM category_footer t0
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.