Symfony Profiler

SELECT
  b.*
FROM
  blog_post b
WHERE
  b.active = :active
ORDER BY
  created_at ASC
LIMIT
  :limitNumber OFFSET :offsetNumber

SELECT b.* FROM blog_post b WHERE b.active = :active ORDER BY created_at ASC LIMIT :limitNumber OFFSET :offsetNumber;

SELECT
  COUNT(*)
FROM
  blog_post b
WHERE
  b.active = :active

SELECT COUNT(*) FROM blog_post b WHERE b.active = :active;

SELECT
  COUNT(b.uuid) as count
FROM
  blog_post b
WHERE
  b.active = :active

SELECT COUNT(b.uuid) as count FROM blog_post b WHERE b.active = :active;

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

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

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

SELECT YEAR(b.created_at) as y 
                FROM blog_post b 
                WHERE b.active = 1
                ORDER BY b.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;