Symfony Profiler

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 = ?

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 = 111;

SELECT
  DISTINCT f0_.id AS id_0,
  f0_.equipe_a AS equipe_a_1,
  f0_.equipe_b AS equipe_b_2,
  a1_.division_affichage AS division_affichage_3,
  f0_.billetterie AS billetterie_4,
  DATE_FORMAT(f0_.date_reelle, '%Y-%m-%d') AS sclr_5,
  DATE_FORMAT(f0_.heure, '%H:%i') AS sclr_6,
  f2_.logo AS logo_7,
  f3_.logo AS logo_8
FROM
  fftt_rencontre f0_
  LEFT JOIN fftt_equipe f4_ ON (
    f0_.division_rencontre_id = f4_.division_id
  )
  LEFT JOIN affichage a1_ ON (f4_.affichage_id = a1_.id)
  LEFT JOIN fftt_club f2_ ON (f0_.club_a_id = f2_.id)
  LEFT JOIN fftt_club f3_ ON (f0_.club_b_id = f3_.id)
WHERE
  DATE_FORMAT(f0_.date_reelle, '%Y-%m-%d') >= DATE_FORMAT(?, '%Y-%m-%d')
  AND (
    f0_.billetterie IS NOT NULL
    OR f0_.billetterie <> ''
  )
ORDER BY
  sclr_5 ASC

SELECT DISTINCT f0_.id AS id_0, f0_.equipe_a AS equipe_a_1, f0_.equipe_b AS equipe_b_2, a1_.division_affichage AS division_affichage_3, f0_.billetterie AS billetterie_4, DATE_FORMAT(f0_.date_reelle, '%Y-%m-%d') AS sclr_5, DATE_FORMAT(f0_.heure, '%H:%i') AS sclr_6, f2_.logo AS logo_7, f3_.logo AS logo_8 FROM fftt_rencontre f0_ LEFT JOIN fftt_equipe f4_ ON (f0_.division_rencontre_id = f4_.division_id) LEFT JOIN affichage a1_ ON (f4_.affichage_id = a1_.id) LEFT JOIN fftt_club f2_ ON (f0_.club_a_id = f2_.id) LEFT JOIN fftt_club f3_ ON (f0_.club_b_id = f3_.id) WHERE DATE_FORMAT(f0_.date_reelle, '%Y-%m-%d') >= DATE_FORMAT('2024-12-22 00:01:00', '%Y-%m-%d') AND (f0_.billetterie IS NOT NULL OR f0_.billetterie <> '') ORDER BY sclr_5 ASC;

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 = ?

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 = 1;

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 = ?

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 = 18;

SELECT
  t0.id AS id_1,
  t0.date AS date_2,
  t0.message AS message_3,
  t0.user_id AS user_id_4,
  t0.article_id AS article_id_5
FROM
  article_commentary t0
WHERE
  t0.article_id = ?
ORDER BY
  t0.date DESC

SELECT t0.id AS id_1, t0.date AS date_2, t0.message AS message_3, t0.user_id AS user_id_4, t0.article_id AS article_id_5 FROM article_commentary t0 WHERE t0.article_id = 128 ORDER BY t0.date DESC;

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

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 = 1 ORDER BY t0.position ASC;

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 = ?

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 = 'app_front_billetterie';

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.position AS position_3
FROM
  partenaire_category t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.position AS position_3 FROM partenaire_category t0;

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 = ?

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 = 4;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.text AS text_2,
  a0_.active AS active_3,
  a0_.image AS image_4,
  a0_.content AS content_5,
  a0_.date AS date_6,
  a0_.notification_send AS notification_send_7,
  a0_.tag AS tag_8,
  a0_.slug AS slug_9,
  a0_.article_category_id AS article_category_id_10
FROM
  article a0_
WHERE
  a0_.active = 1
ORDER BY
  a0_.date DESC
LIMIT
  3

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.text AS text_2, a0_.active AS active_3, a0_.image AS image_4, a0_.content AS content_5, a0_.date AS date_6, a0_.notification_send AS notification_send_7, a0_.tag AS tag_8, a0_.slug AS slug_9, a0_.article_category_id AS article_category_id_10 FROM article a0_ WHERE a0_.active = 1 ORDER BY a0_.date DESC LIMIT 3;

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 = ?

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 = 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

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 = 'app_front_billetterie' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3
FROM
  contact t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3 FROM contact t0;

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

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3 FROM menu_name t0 WHERE t0.name = 'header_menu' LIMIT 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

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 = 1 ORDER BY t0.position ASC;

SELECT
  t0.id AS id_1,
  t0.categorie_name AS categorie_name_2
FROM
  category_footer t0

SELECT t0.id AS id_1, t0.categorie_name AS categorie_name_2 FROM category_footer t0;