Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.state AS state_3,
  t0.description AS description_4,
  t0.creation_date AS creation_date_5,
  t0.updated_date AS updated_date_6,
  t0.is_locked AS is_locked_7,
  t0.closed_by_id AS closed_by_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  reporting t0
WHERE
  t0.state = ?
ORDER BY
  t0.id DESC
LIMIT
  1

SELECT t0.id AS id_1, t0.year AS year_2, t0.state AS state_3, t0.description AS description_4, t0.creation_date AS creation_date_5, t0.updated_date AS updated_date_6, t0.is_locked AS is_locked_7, t0.closed_by_id AS closed_by_id_8, t0.created_by_id AS created_by_id_9 FROM reporting t0 WHERE t0.state = 0 ORDER BY t0.id DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.year AS year_2,
  t0.state AS state_3,
  t0.description AS description_4,
  t0.creation_date AS creation_date_5,
  t0.updated_date AS updated_date_6,
  t0.is_locked AS is_locked_7,
  t0.closed_by_id AS closed_by_id_8,
  t0.created_by_id AS created_by_id_9
FROM
  reporting t0

SELECT t0.id AS id_1, t0.year AS year_2, t0.state AS state_3, t0.description AS description_4, t0.creation_date AS creation_date_5, t0.updated_date AS updated_date_6, t0.is_locked AS is_locked_7, t0.closed_by_id AS closed_by_id_8, t0.created_by_id AS created_by_id_9 FROM reporting t0;

SELECT
  COUNT(v.value) as valeur,
  v.value as town
FROM
  `values` v
  join field f on f.id = v.field_id
  join meta_data m on m.id = f.meta_data_id
  join enterprise e on e.id = v.enterprise_id
where
  e.reporting_id = 8
  and m.code = 'town'
group by
  v.value
order by
  v.value ASC;

SELECT COUNT(v.value) as valeur,   v.value as town FROM `values` v join field f on f.id = v.field_id join meta_data m on m.id = f.meta_data_id join enterprise e on e.id =v.enterprise_id where e.reporting_id=8 and m.code='town' group by v.value order by v.value ASC;;