Symfony Profiler

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

Query Metrics

(
        SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type 
        FROM entry 
        INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id 
        INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
        
            WHERE entry.visibility = :visibility
            AND m_entry.visibility = :visibility
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        UNION
        (
        SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type 
        FROM post 
        INNER JOIN magazine m_post ON post.magazine_id = m_post.id 
        INNER JOIN "user" u_post ON post.user_id = u_post.id
        
            WHERE post.visibility = :visibility
            AND m_post.visibility = :visibility
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN :timeFrom AND :timeTo)
            
        )
        ORDER BY created_at DESC, created_at DESC LIMIT 25000

[
  "visibility" => "visible"
  "timeFrom" => "2023-09-30 02:29:38"
  "timeTo" => "2024-09-30 02:29:38"
]

(
  SELECT
    entry.id,
    entry.created_at,
    entry.score,
    entry.ranking,
    entry.last_active,
    entry.comment_count,
    'entry' AS type
  FROM
    entry
    INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id
    INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
  WHERE
    entry.visibility = :visibility
    AND m_entry.visibility = :visibility
    AND entry.is_adult = false
    AND m_entry.is_adult = false
    AND (
      entry.created_at BETWEEN :timeFrom
      AND :timeTo
    )
)
UNION
  (
    SELECT
      post.id,
      post.created_at,
      post.score,
      post.ranking,
      post.last_active,
      post.comment_count,
      'post' AS type
    FROM
      post
      INNER JOIN magazine m_post ON post.magazine_id = m_post.id
      INNER JOIN "user" u_post ON post.user_id = u_post.id
    WHERE
      post.visibility = :visibility
      AND m_post.visibility = :visibility
      AND post.is_adult = false
      AND m_post.is_adult = false
      AND (
        post.created_at BETWEEN :timeFrom
        AND :timeTo
      )
  )
ORDER BY
  created_at DESC,
  created_at DESC
LIMIT
  25000

(
        SELECT entry.id, entry.created_at, entry.score, entry.ranking, entry.last_active, entry.comment_count, 'entry' AS type 
        FROM entry 
        INNER JOIN magazine m_entry ON entry.magazine_id = m_entry.id 
        INNER JOIN "user" u_entry ON entry.user_id = u_entry.id
        
            WHERE entry.visibility = 'visible'
            AND m_entry.visibility = 'visible'
            
            AND entry.is_adult = false
            AND m_entry.is_adult = false
            
            AND (entry.created_at BETWEEN '2023-09-30 02:29:38' AND '2024-09-30 02:29:38')
            
        )
        UNION
        (
        SELECT post.id, post.created_at, post.score, post.ranking, post.last_active, post.comment_count, 'post' AS type 
        FROM post 
        INNER JOIN magazine m_post ON post.magazine_id = m_post.id 
        INNER JOIN "user" u_post ON post.user_id = u_post.id
        
            WHERE post.visibility = 'visible'
            AND m_post.visibility = 'visible'
            
            AND post.is_adult = false
            AND m_post.is_adult = false
            
            AND (post.created_at BETWEEN '2023-09-30 02:29:38' AND '2024-09-30 02:29:38')
            
        )
        ORDER BY created_at DESC, created_at DESC LIMIT 25000;

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

[
  5114
  2561
  2604
  2652
  9749
  2614
  2609
  2599
  2666
  2616
  5831
  2613
  2627
  12530
  17253
  2662
  2693
  15845
  4932
  5360
  2635
  2642
  2615
  16636
  5115
]

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.url AS url_3,
  t0.body AS body_4,
  t0.type AS type_5,
  t0.lang AS lang_6,
  t0.is_oc AS is_oc_7,
  t0.has_embed AS has_embed_8,
  t0.comment_count AS comment_count_9,
  t0.favourite_count AS favourite_count_10,
  t0.score AS score_11,
  t0.is_adult AS is_adult_12,
  t0.sticky AS sticky_13,
  t0.last_active AS last_active_14,
  t0.ip AS ip_15,
  t0.ada_amount AS ada_amount_16,
  t0.tags AS tags_17,
  t0.mentions AS mentions_18,
  t0.id AS id_19,
  t0.title_ts AS title_ts_20,
  t0.body_ts AS body_ts_21,
  t0.up_votes AS up_votes_22,
  t0.down_votes AS down_votes_23,
  t0.ranking AS ranking_24,
  t0.visibility AS visibility_25,
  t0.ap_id AS ap_id_26,
  t0.edited_at AS edited_at_27,
  t0.created_at AS created_at_28,
  t0.user_id AS user_id_29,
  t0.magazine_id AS magazine_id_30,
  t0.image_id AS image_id_31,
  t0.domain_id AS domain_id_32
FROM
  entry t0
WHERE
  t0.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?
  )

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.url AS url_3, t0.body AS body_4, t0.type AS type_5, t0.lang AS lang_6, t0.is_oc AS is_oc_7, t0.has_embed AS has_embed_8, t0.comment_count AS comment_count_9, t0.favourite_count AS favourite_count_10, t0.score AS score_11, t0.is_adult AS is_adult_12, t0.sticky AS sticky_13, t0.last_active AS last_active_14, t0.ip AS ip_15, t0.ada_amount AS ada_amount_16, t0.tags AS tags_17, t0.mentions AS mentions_18, t0.id AS id_19, t0.title_ts AS title_ts_20, t0.body_ts AS body_ts_21, t0.up_votes AS up_votes_22, t0.down_votes AS down_votes_23, t0.ranking AS ranking_24, t0.visibility AS visibility_25, t0.ap_id AS ap_id_26, t0.edited_at AS edited_at_27, t0.created_at AS created_at_28, t0.user_id AS user_id_29, t0.magazine_id AS magazine_id_30, t0.image_id AS image_id_31, t0.domain_id AS domain_id_32 FROM entry t0 WHERE t0.id IN (5114, 2561, 2604, 2652, 9749, 2614, 2609, 2599, 2666, 2616, 5831, 2613, 2627, 12530, 17253, 2662, 2693, 15845, 4932, 5360, 2635, 2642, 2615, 16636, 5115);

SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL)

[]

SELECT
  t0.slug AS slug_1,
  t0.body AS body_2,
  t0.lang AS lang_3,
  t0.comment_count AS comment_count_4,
  t0.favourite_count AS favourite_count_5,
  t0.score AS score_6,
  t0.is_adult AS is_adult_7,
  t0.sticky AS sticky_8,
  t0.last_active AS last_active_9,
  t0.ip AS ip_10,
  t0.tags AS tags_11,
  t0.mentions AS mentions_12,
  t0.id AS id_13,
  t0.body_ts AS body_ts_14,
  t0.up_votes AS up_votes_15,
  t0.down_votes AS down_votes_16,
  t0.ranking AS ranking_17,
  t0.visibility AS visibility_18,
  t0.ap_id AS ap_id_19,
  t0.edited_at AS edited_at_20,
  t0.created_at AS created_at_21,
  t0.user_id AS user_id_22,
  t0.magazine_id AS magazine_id_23,
  t0.image_id AS image_id_24
FROM
  post t0
WHERE
  t0.id IN (NULL)

SELECT t0.slug AS slug_1, t0.body AS body_2, t0.lang AS lang_3, t0.comment_count AS comment_count_4, t0.favourite_count AS favourite_count_5, t0.score AS score_6, t0.is_adult AS is_adult_7, t0.sticky AS sticky_8, t0.last_active AS last_active_9, t0.ip AS ip_10, t0.tags AS tags_11, t0.mentions AS mentions_12, t0.id AS id_13, t0.body_ts AS body_ts_14, t0.up_votes AS up_votes_15, t0.down_votes AS down_votes_16, t0.ranking AS ranking_17, t0.visibility AS visibility_18, t0.ap_id AS ap_id_19, t0.edited_at AS edited_at_20, t0.created_at AS created_at_21, t0.user_id AS user_id_22, t0.magazine_id AS magazine_id_23, t0.image_id AS image_id_24 FROM post t0 WHERE t0.id IN (NULL);

SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = ?

[
  19739
]

SELECT
  t0.file_path AS file_path_1,
  t0.file_name AS file_name_2,
  t0.sha256 AS sha256_3,
  t0.width AS width_4,
  t0.height AS height_5,
  t0.blurhash AS blurhash_6,
  t0.alt_text AS alt_text_7,
  t0.source_url AS source_url_8,
  t0.id AS id_9
FROM
  image t0
WHERE
  t0.id = ?

SELECT t0.file_path AS file_path_1, t0.file_name AS file_name_2, t0.sha256 AS sha256_3, t0.width AS width_4, t0.height AS height_5, t0.blurhash AS blurhash_6, t0.alt_text AS alt_text_7, t0.source_url AS source_url_8, t0.id AS id_9 FROM image t0 WHERE t0.id = 19739;