Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.prenom AS prenom_1,
  a0_.nom AS nom_2,
  a0_.date_crea AS date_crea_3,
  a0_.date_modif AS date_modif_4,
  a0_.texte AS texte_5
FROM
  auteurs a0_
WHERE
  a0_.nom LIKE ?
ORDER BY
  a0_.date_crea DESC

SELECT a0_.id AS id_0, a0_.prenom AS prenom_1, a0_.nom AS nom_2, a0_.date_crea AS date_crea_3, a0_.date_modif AS date_modif_4, a0_.texte AS texte_5 FROM auteurs a0_ WHERE a0_.nom LIKE 'Trenet' ORDER BY a0_.date_crea DESC;

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.video AS video_2,
  m0_.poster AS poster_3,
  m0_.categorie AS categorie_4,
  m0_.legende AS legende_5,
  m0_.title AS title_6,
  m0_.actif AS actif_7,
  m0_.date_crea AS date_crea_8,
  m0_.date_modif AS date_modif_9,
  m0_.poster_bd AS poster_bd_10,
  m0_.ordre_g AS ordre_g_11,
  m0_.ordre AS ordre_12
FROM
  medias m0_
  LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id
  LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id
WHERE
  m0_.actif = 1
  AND LOWER(
    REPLACE(
      REPLACE(
        REPLACE(
          REPLACE(
            REPLACE(
              REPLACE(
                REPLACE(
                  REPLACE(
                    REPLACE(
                      REPLACE(
                        REPLACE(
                          REPLACE(
                            REPLACE(
                              REPLACE(
                                REPLACE(
                                  REPLACE(m0_.titre, '-', ' '),
                                  ',',
                                  ''
                                ),
                                '\'',
                                ' '
                              ),
                              '’',
                              ' '
                            ),
                            'é',
                            'e'
                          ),
                          'è',
                          'e'
                        ),
                        'ê',
                        'e'
                      ),
                      'ë',
                      'e'
                    ),
                    'à',
                    'a'
                  ),
                  'â',
                  'a'
                ),
                'ä',
                'a'
              ),
              'î',
              'i'
            ),
            'ï',
            'i'
          ),
          'ù',
          'u'
        ),
        'û',
        'u'
      ),
      'ü',
      'u'
    )
  ) LIKE ?
  AND a1_.nom LIKE ?
ORDER BY
  m0_.titre ASC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id WHERE m0_.actif = 1 AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, '-', ' '), ',', ''), '\'', ' '), '’', ' '), 'é', 'e'), 'è', 'e'), 'ê', 'e'), 'ë', 'e'), 'à', 'a'), 'â', 'a'), 'ä', 'a'), 'î', 'i'), 'ï', 'i'), 'ù', 'u'), 'û', 'u'), 'ü', 'u')) LIKE '%le cor%' AND a1_.nom LIKE 'Trenet' ORDER BY m0_.titre ASC;

SELECT
  t0.id AS id_1,
  t0.texte AS texte_2,
  t0.date_crea AS date_crea_3,
  t0.date_modif AS date_modif_4,
  t0.actif AS actif_5,
  t0.media_id AS media_id_6
FROM
  paroles t0
WHERE
  t0.media_id = ?

SELECT t0.id AS id_1, t0.texte AS texte_2, t0.date_crea AS date_crea_3, t0.date_modif AS date_modif_4, t0.actif AS actif_5, t0.media_id AS media_id_6 FROM paroles t0 WHERE t0.media_id = 32;

SELECT
  m0_.id AS id_0,
  m0_.titre AS titre_1,
  m0_.video AS video_2,
  m0_.poster AS poster_3,
  m0_.categorie AS categorie_4,
  m0_.legende AS legende_5,
  m0_.title AS title_6,
  m0_.actif AS actif_7,
  m0_.date_crea AS date_crea_8,
  m0_.date_modif AS date_modif_9,
  m0_.poster_bd AS poster_bd_10,
  m0_.ordre_g AS ordre_g_11,
  m0_.ordre AS ordre_12
FROM
  medias m0_
  LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id
  LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id
WHERE
  LOWER(
    REPLACE(
      REPLACE(
        REPLACE(a1_.nom, 'é', 'e'),
        'è',
        'e'
      ),
      'ê',
      'e'
    )
  ) LIKE ?
  AND LOWER(
    REPLACE(
      REPLACE(
        REPLACE(
          REPLACE(
            REPLACE(
              REPLACE(
                REPLACE(
                  REPLACE(
                    REPLACE(
                      REPLACE(
                        REPLACE(
                          REPLACE(
                            REPLACE(
                              REPLACE(
                                REPLACE(m0_.titre, '', ''),
                                '\'',
                                ' '
                              ),
                              '’',
                              ' '
                            ),
                            'é',
                            'e'
                          ),
                          'è',
                          'e'
                        ),
                        'ê',
                        'e'
                      ),
                      'ë',
                      'e'
                    ),
                    'à',
                    'a'
                  ),
                  'â',
                  'a'
                ),
                'ä',
                'a'
              ),
              'î',
              'i'
            ),
            'ï',
            'i'
          ),
          'ù',
          'u'
        ),
        'û',
        'u'
      ),
      'ü',
      'u'
    )
  ) LIKE ?
ORDER BY
  m0_.date_crea DESC

SELECT m0_.id AS id_0, m0_.titre AS titre_1, m0_.video AS video_2, m0_.poster AS poster_3, m0_.categorie AS categorie_4, m0_.legende AS legende_5, m0_.title AS title_6, m0_.actif AS actif_7, m0_.date_crea AS date_crea_8, m0_.date_modif AS date_modif_9, m0_.poster_bd AS poster_bd_10, m0_.ordre_g AS ordre_g_11, m0_.ordre AS ordre_12 FROM medias m0_ LEFT JOIN medias_auteurs m2_ ON m0_.id = m2_.medias_id LEFT JOIN auteurs a1_ ON a1_.id = m2_.auteurs_id WHERE LOWER(REPLACE(REPLACE(REPLACE(a1_.nom, 'é', 'e'), 'è', 'e'), 'ê', 'e')) LIKE 'Trenet' AND LOWER(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(REPLACE(m0_.titre, '', ''), '\'', ' '), '’', ' '), 'é', 'e'), 'è', 'e'), 'ê', 'e'), 'ë', 'e'), 'à', 'a'), 'â', 'a'), 'ä', 'a'), 'î', 'i'), 'ï', 'i'), 'ù', 'u'), 'û', 'u'), 'ü', 'u')) LIKE 'Le cor' ORDER BY m0_.date_crea DESC;

SELECT
  t0.id AS id_1,
  t0.prenom AS prenom_2,
  t0.nom AS nom_3,
  t0.date_crea AS date_crea_4,
  t0.date_modif AS date_modif_5,
  t0.texte AS texte_6
FROM
  auteurs t0
  INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id
WHERE
  medias_auteurs.medias_id = ?

SELECT t0.id AS id_1, t0.prenom AS prenom_2, t0.nom AS nom_3, t0.date_crea AS date_crea_4, t0.date_modif AS date_modif_5, t0.texte AS texte_6 FROM auteurs t0 INNER JOIN medias_auteurs ON t0.id = medias_auteurs.auteurs_id WHERE medias_auteurs.medias_id = 32;