Symfony Profiler

SELECT
  idcategorie
FROM
  ann_categories
WHERE
  url_clean = 'Offres-emploi-amateur'

SELECT idcategorie FROM ann_categories WHERE url_clean='Offres-emploi-amateur' ;

SELECT
  a.*,
  e.login,
  e.email as email_extra
FROM
  ann_annonces a
  LEFT OUTER JOIN extranetusers e ON a.idextranetuser = e.idextranetuser
WHERE
  a.idannonce = 96526

SELECT a.*,e.login,e.email as email_extra
                FROM ann_annonces a
                    LEFT OUTER JOIN extranetusers e
                    ON a.idextranetuser=e.idextranetuser
                WHERE a.idannonce=96526;

SELECT
  a0_.idcategorie AS idcategorie_0,
  a0_.name AS name_1,
  a0_.description AS description_2,
  a0_.online AS online_3,
  a0_.class AS class_4,
  a0_.url_clean AS url_clean_5
FROM
  ann_categories a0_
WHERE
  a0_.idcategorie = ?

SELECT a0_.idcategorie AS idcategorie_0, a0_.name AS name_1, a0_.description AS description_2, a0_.online AS online_3, a0_.class AS class_4, a0_.url_clean AS url_clean_5 FROM ann_categories a0_ WHERE a0_.idcategorie = '7';

SELECT
  fr
FROM
  countries
WHERE
  id = 'FR'

SELECT fr FROM countries WHERE id='FR';

SELECT
  url_clean,
  name
FROM
  ann_categories
WHERE
  online = 1

SELECT url_clean, name FROM ann_categories WHERE online=1;

SELECT
  *,
  `bigregions`.idbigregion as idbigregion
FROM
  `bigregions`
  JOIN `regions` ON `regions`.`idbigregion` = `bigregions`.`idbigregion`
  JOIN `departements` ON `regions`.`idregion` = `departements`.`idregion`
ORDER BY
  `bigregions`.`bigregion` ASC,
  `departements`.`departement` ASC

SELECT *,`bigregions`.idbigregion as idbigregion
                    FROM `bigregions`
                        JOIN `regions` ON `regions`.`idbigregion`=`bigregions`.`idbigregion`
                        JOIN `departements` ON `regions`.`idregion`=`departements`.`idregion`
                    ORDER BY `bigregions`.`bigregion` ASC, `departements`.`departement` ASC;

SELECT
  *
FROM
  bannieres
WHERE
  publish = 1
  AND valid = 1
  AND is_bottom = 1
  AND date_start <= NOW()
  AND date_end >= NOW()
ORDER BY
  bannieres.order ASC
LIMIT
  0, 10

SELECT * FROM bannieres
                WHERE publish=1
                AND valid=1
                AND is_bottom=1
                AND date_start<=NOW()
                AND date_end>=NOW()
                ORDER BY bannieres.order ASC
                LIMIT 0,10;