Symfony Profiler

SELECT
  a.*
FROM
  article a
WHERE
  a.active = :active
ORDER BY
  ord asc
LIMIT
  :limitNumber OFFSET :offsetNumber

SELECT a.* FROM article a WHERE a.active = :active ORDER BY ord asc LIMIT :limitNumber OFFSET :offsetNumber;

SELECT
  COUNT(*)
FROM
  article a
WHERE
  a.active = :active

SELECT COUNT(*) FROM article a WHERE a.active = :active;

SELECT
  COUNT(a.uuid) as count
FROM
  article a
WHERE
  a.active = :active

SELECT COUNT(a.uuid) as count FROM article a WHERE a.active = :active;

SELECT
  a.category as c
FROM
  article a
WHERE
  a.active = 1
  AND (
    a.category IS NOT NULL
    OR a.category != ''
  )
GROUP BY
  c

SELECT a.category as c 
                FROM article a 
                WHERE a.active = 1 AND (a.category IS NOT NULL OR a.category != '') 
                GROUP BY c;

SELECT
  YEAR(a.created_at) as y
FROM
  article a
WHERE
  a.active = 1
ORDER BY
  a.created_at DESC

SELECT YEAR(a.created_at) as y 
                FROM article a 
                WHERE a.active = 1
                ORDER BY a.created_at DESC
                ;

SELECT
  b.*
FROM
  banner b
WHERE
  b.destination_type = :type
  AND b.active = :active

SELECT b.* FROM banner b WHERE b.destination_type = :type AND b.active = :active;

SELECT
  c.*
FROM
  configuration c
LIMIT
  1

SELECT c.* FROM configuration c LIMIT 1;