Symfony Profiler

• Request / Response
• Performance
• Validator
• Forms
• Exception
• Logs 3
• Events
• Routing
• Cache
• Translation 60
• Security
• Twig
• Twig Components
• HTTP Client
• Doctrine
• Debug
• Messages
• Emails
• Notifications
• Serializer
• Configuration

Query Metrics

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.body AS body_2 FROM rv_web_faq r0_

[]

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.body AS body_2
FROM
  rv_web_faq r0_

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.body AS body_2 FROM rv_web_faq r0_;

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM rv_web_faq r0_

[]

SELECT
  COUNT(DISTINCT r0_.id) AS sclr_0
FROM
  rv_web_faq r0_

SELECT COUNT(DISTINCT r0_.id) AS sclr_0 FROM rv_web_faq r0_;

SELECT DISTINCT r0_.id AS id_0 FROM rv_web_faq r0_ LIMIT 10

[]

SELECT
  DISTINCT r0_.id AS id_0
FROM
  rv_web_faq r0_
LIMIT
  10

SELECT DISTINCT r0_.id AS id_0 FROM rv_web_faq r0_ LIMIT 10;

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.body AS body_2 FROM rv_web_faq r0_ WHERE r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  5
  6
  7
  8
  9
  10
  11
  12
  13
  14
]

SELECT
  r0_.id AS id_0,
  r0_.title AS title_1,
  r0_.body AS body_2
FROM
  rv_web_faq r0_
WHERE
  r0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

SELECT r0_.id AS id_0, r0_.title AS title_1, r0_.body AS body_2 FROM rv_web_faq r0_ WHERE r0_.id IN (5, 6, 7, 8, 9, 10, 11, 12, 13, 14);

SELECT r0_.id AS id_0, r0_.url AS url_1, r0_.date_ AS date__2, r0_.img AS img_3, r0_.viewed AS viewed_4, r0_.title AS title_5, r0_.subject AS subject_6, r0_.tags AS tags_7 FROM rv_web_blog r0_ WHERE r0_.published = 1 ORDER BY r0_.date_ DESC LIMIT 6

[]

SELECT
  r0_.id AS id_0,
  r0_.url AS url_1,
  r0_.date_ AS date__2,
  r0_.img AS img_3,
  r0_.viewed AS viewed_4,
  r0_.title AS title_5,
  r0_.subject AS subject_6,
  r0_.tags AS tags_7
FROM
  rv_web_blog r0_
WHERE
  r0_.published = 1
ORDER BY
  r0_.date_ DESC
LIMIT
  6

SELECT r0_.id AS id_0, r0_.url AS url_1, r0_.date_ AS date__2, r0_.img AS img_3, r0_.viewed AS viewed_4, r0_.title AS title_5, r0_.subject AS subject_6, r0_.tags AS tags_7 FROM rv_web_blog r0_ WHERE r0_.published = 1 ORDER BY r0_.date_ DESC LIMIT 6;

SELECT tags ,COUNT(*) cnt FROM (SELECT id,SUBSTRING_INDEX(SUBSTRING_INDEX(tags, ',', n.digit+1), ',', -1) tags 
            FROM rv_web_blog INNER JOIN (SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION
             ALL SELECT 3 UNION ALL SELECT 4  UNION ALL SELECT 5  UNION ALL SELECT 6  ) n ON
              LENGTH(REPLACE(tags, ',' , '')) <= LENGTH(tags)-n.digit WHERE 
               SUBSTRING_INDEX(SUBSTRING_INDEX(tags, ',', n.digit+1), ',', -1)<>'' AND published=1 
            ORDER BY id, n.digit) h GROUP BY TRIM( tags) ORDER BY cnt DESC LIMIT 0,6

[]

SELECT
  tags,
  COUNT(*) cnt
FROM
  (
    SELECT
      id,
      SUBSTRING_INDEX(
        SUBSTRING_INDEX(tags, ',', n.digit + 1),
        ',',
        -1
      ) tags
    FROM
      rv_web_blog
      INNER JOIN (
        SELECT
          0 digit
        UNION ALL
        SELECT
          1
        UNION ALL
        SELECT
          2
        UNION ALL
        SELECT
          3
        UNION ALL
        SELECT
          4
        UNION ALL
        SELECT
          5
        UNION ALL
        SELECT
          6
      ) n ON LENGTH(
        REPLACE(tags, ',', '')
      ) <= LENGTH(tags)- n.digit
    WHERE
      SUBSTRING_INDEX(
        SUBSTRING_INDEX(tags, ',', n.digit + 1),
        ',',
        -1
      )<> ''
      AND published = 1
    ORDER BY
      id,
      n.digit
  ) h
GROUP BY
  TRIM(tags)
ORDER BY
  cnt DESC
LIMIT
  0, 6

SELECT tags ,COUNT(*) cnt FROM (SELECT id,SUBSTRING_INDEX(SUBSTRING_INDEX(tags, ',', n.digit+1), ',', -1) tags 
            FROM rv_web_blog INNER JOIN (SELECT 0 digit UNION ALL SELECT 1 UNION ALL SELECT 2 UNION
             ALL SELECT 3 UNION ALL SELECT 4  UNION ALL SELECT 5  UNION ALL SELECT 6  ) n ON
              LENGTH(REPLACE(tags, ',' , '')) <= LENGTH(tags)-n.digit WHERE 
               SUBSTRING_INDEX(SUBSTRING_INDEX(tags, ',', n.digit+1), ',', -1)<>'' AND published=1 
            ORDER BY id, n.digit) h GROUP BY TRIM( tags) ORDER BY cnt DESC LIMIT 0,6;