Symfony Profiler

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

Query Metrics

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.title_ar AS title_ar_4, t0.subject AS subject_5, t0.subject_ar AS subject_ar_6, t0.text AS text_7, t0.text_ar AS text_ar_8, t0.date_ AS date__9, t0.img AS img_10, t0.tags AS tags_11, t0.tags_ar AS tags_ar_12, t0.tags_en AS tags_en_13, t0.viewed AS viewed_14, t0.published AS published_15, t0.id_creator AS id_creator_16, t0.title_en AS title_en_17, t0.subject_en AS subject_en_18, t0.text_en AS text_en_19 FROM rv_web_blog t0 WHERE t0.url = ? LIMIT 1

[
  "prolongation-du-programme-digital-dedie-aux-ecoles"
]

SELECT
  t0.id AS id_1,
  t0.url AS url_2,
  t0.title AS title_3,
  t0.title_ar AS title_ar_4,
  t0.subject AS subject_5,
  t0.subject_ar AS subject_ar_6,
  t0.text AS text_7,
  t0.text_ar AS text_ar_8,
  t0.date_ AS date__9,
  t0.img AS img_10,
  t0.tags AS tags_11,
  t0.tags_ar AS tags_ar_12,
  t0.tags_en AS tags_en_13,
  t0.viewed AS viewed_14,
  t0.published AS published_15,
  t0.id_creator AS id_creator_16,
  t0.title_en AS title_en_17,
  t0.subject_en AS subject_en_18,
  t0.text_en AS text_en_19
FROM
  rv_web_blog t0
WHERE
  t0.url = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.url AS url_2, t0.title AS title_3, t0.title_ar AS title_ar_4, t0.subject AS subject_5, t0.subject_ar AS subject_ar_6, t0.text AS text_7, t0.text_ar AS text_ar_8, t0.date_ AS date__9, t0.img AS img_10, t0.tags AS tags_11, t0.tags_ar AS tags_ar_12, t0.tags_en AS tags_en_13, t0.viewed AS viewed_14, t0.published AS published_15, t0.id_creator AS id_creator_16, t0.title_en AS title_en_17, t0.subject_en AS subject_en_18, t0.text_en AS text_en_19 FROM rv_web_blog t0 WHERE t0.url = 'prolongation-du-programme-digital-dedie-aux-ecoles' LIMIT 1;

"START TRANSACTION"

[]

"START TRANSACTION"

"START TRANSACTION";

UPDATE rv_web_blog SET viewed = ? WHERE id = ?

[
  393
  16
]

UPDATE
  rv_web_blog
SET
  viewed = ?
WHERE
  id = ?

UPDATE rv_web_blog SET viewed = 393 WHERE id = 16;

"COMMIT"

[]

"COMMIT"

"COMMIT";

SELECT r0_.date_ AS date__0, r0_.id AS id_1, r0_.img AS img_2, r0_.viewed AS viewed_3, r0_.url AS url_4, r0_.text AS text_5, r0_.title AS title_6, r0_.subject AS subject_7, r0_.tags AS tags_8 FROM rv_web_blog r0_ WHERE r0_.url = ?

[
  "prolongation-du-programme-digital-dedie-aux-ecoles"
]

SELECT
  r0_.date_ AS date__0,
  r0_.id AS id_1,
  r0_.img AS img_2,
  r0_.viewed AS viewed_3,
  r0_.url AS url_4,
  r0_.text AS text_5,
  r0_.title AS title_6,
  r0_.subject AS subject_7,
  r0_.tags AS tags_8
FROM
  rv_web_blog r0_
WHERE
  r0_.url = ?

SELECT r0_.date_ AS date__0, r0_.id AS id_1, r0_.img AS img_2, r0_.viewed AS viewed_3, r0_.url AS url_4, r0_.text AS text_5, r0_.title AS title_6, r0_.subject AS subject_7, r0_.tags AS tags_8 FROM rv_web_blog r0_ WHERE r0_.url = 'prolongation-du-programme-digital-dedie-aux-ecoles';

SELECT r0_.url AS url_0, r0_.text AS text_1, r0_.title AS title_2, r0_.subject AS subject_3, r0_.tags AS tags_4 FROM rv_web_blog r0_ WHERE r0_.published = 1 AND r0_.id > ? LIMIT 1

[
  16
]

SELECT
  r0_.url AS url_0,
  r0_.text AS text_1,
  r0_.title AS title_2,
  r0_.subject AS subject_3,
  r0_.tags AS tags_4
FROM
  rv_web_blog r0_
WHERE
  r0_.published = 1
  AND r0_.id > ?
LIMIT
  1

SELECT r0_.url AS url_0, r0_.text AS text_1, r0_.title AS title_2, r0_.subject AS subject_3, r0_.tags AS tags_4 FROM rv_web_blog r0_ WHERE r0_.published = 1 AND r0_.id > 16 LIMIT 1;

SELECT r0_.url AS url_0, r0_.text AS text_1, r0_.title AS title_2, r0_.subject AS subject_3, r0_.tags AS tags_4 FROM rv_web_blog r0_ WHERE r0_.published = 1 AND r0_.id < ? LIMIT 1

[
  16
]

SELECT
  r0_.url AS url_0,
  r0_.text AS text_1,
  r0_.title AS title_2,
  r0_.subject AS subject_3,
  r0_.tags AS tags_4
FROM
  rv_web_blog r0_
WHERE
  r0_.published = 1
  AND r0_.id < ?
LIMIT
  1

SELECT r0_.url AS url_0, r0_.text AS text_1, r0_.title AS title_2, r0_.subject AS subject_3, r0_.tags AS tags_4 FROM rv_web_blog r0_ WHERE r0_.published = 1 AND r0_.id < 16 LIMIT 1;

SELECT COUNT(r0_.id) AS sclr_0 FROM rv_web_comments r0_ WHERE r0_.id_page = ? AND r0_.verified = 1

[
  "b_16"
]

SELECT
  COUNT(r0_.id) AS sclr_0
FROM
  rv_web_comments r0_
WHERE
  r0_.id_page = ?
  AND r0_.verified = 1

SELECT COUNT(r0_.id) AS sclr_0 FROM rv_web_comments r0_ WHERE r0_.id_page = 'b_16' AND r0_.verified = 1;

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;