Symfony Profiler

SELECT
  sub.*
FROM
  (
    SELECT
      a.*
    FROM
      article a
    WHERE
      a.category = :category1
      AND a.active = :active1
    ORDER BY
      RAND()
    LIMIT
      :limit1
  ) sub
UNION
SELECT
  sub.*
FROM
  (
    SELECT
      a.*
    FROM
      article a
    WHERE
      a.category = :category2
      AND a.active = :active2
    ORDER BY
      RAND()
    LIMIT
      :limit2
  ) sub
UNION
SELECT
  sub.*
FROM
  (
    SELECT
      a.*
    FROM
      article a
    WHERE
      a.category = :category3
      AND a.active = :active3
    ORDER BY
      RAND()
    LIMIT
      :limit3
  ) sub
UNION
SELECT
  sub.*
FROM
  (
    SELECT
      a.*
    FROM
      article a
    WHERE
      a.category = :category4
      AND a.active = :active4
    ORDER BY
      RAND()
    LIMIT
      :limit4
  ) sub
UNION
SELECT
  sub.*
FROM
  (
    SELECT
      a.*
    FROM
      article a
    WHERE
      a.category = :category5
      AND a.active = :active5
    ORDER BY
      RAND()
    LIMIT
      :limit5
  ) sub
UNION
SELECT
  sub.*
FROM
  (
    SELECT
      a.*
    FROM
      article a
    WHERE
      a.category = :category6
      AND a.active = :active6
    ORDER BY
      RAND()
    LIMIT
      :limit6
  ) sub

SELECT sub.* FROM (SELECT a.* FROM article a WHERE a.category = :category1 AND a.active = :active1 ORDER BY RAND() LIMIT :limit1) sub UNION SELECT sub.* FROM (SELECT a.* FROM article a WHERE a.category = :category2 AND a.active = :active2 ORDER BY RAND() LIMIT :limit2) sub UNION SELECT sub.* FROM (SELECT a.* FROM article a WHERE a.category = :category3 AND a.active = :active3 ORDER BY RAND() LIMIT :limit3) sub UNION SELECT sub.* FROM (SELECT a.* FROM article a WHERE a.category = :category4 AND a.active = :active4 ORDER BY RAND() LIMIT :limit4) sub UNION SELECT sub.* FROM (SELECT a.* FROM article a WHERE a.category = :category5 AND a.active = :active5 ORDER BY RAND() LIMIT :limit5) sub UNION SELECT sub.* FROM (SELECT a.* FROM article a WHERE a.category = :category6 AND a.active = :active6 ORDER BY RAND() LIMIT :limit6) sub;

SELECT
  c.*
FROM
  configuration c
LIMIT
  1

SELECT c.* FROM configuration c LIMIT 1;

SELECT
  a.category,
  COUNT(a.uuid) as cnt
FROM
  article a
WHERE
  a.active = :active
  AND a.category IS NOT NULL
GROUP BY
  a.category

SELECT a.category, COUNT(a.uuid) as cnt FROM article a WHERE a.active = :active AND a.category IS NOT NULL GROUP BY a.category;

SELECT
  b.*
FROM
  blog_post b
WHERE
  b.active = :active
LIMIT
  :limitNumber OFFSET :offsetNumber

SELECT b.* FROM blog_post b WHERE b.active = :active LIMIT :limitNumber OFFSET :offsetNumber;

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;