Symfony Profiler

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

Query Metrics

SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND (e0_.created_at BETWEEN ? AND ?) AND e0_.type = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY e0_.score DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25

[
  "visible"
  "visible"
  "2025-02-15 18:41:39+0000"
  "2025-03-15 18:41:39+0000"
  "video"
  "goodnewsnetwork.org"
  0
  0
]

SELECT
  e0_.slug AS slug_0,
  e0_.title AS title_1,
  e0_.url AS url_2,
  e0_.body AS body_3,
  e0_.type AS type_4,
  e0_.lang AS lang_5,
  e0_.is_oc AS is_oc_6,
  e0_.has_embed AS has_embed_7,
  e0_.comment_count AS comment_count_8,
  e0_.favourite_count AS favourite_count_9,
  e0_.score AS score_10,
  e0_.is_adult AS is_adult_11,
  e0_.sticky AS sticky_12,
  e0_.last_active AS last_active_13,
  e0_.ip AS ip_14,
  e0_.ada_amount AS ada_amount_15,
  e0_.tags AS tags_16,
  e0_.mentions AS mentions_17,
  e0_.id AS id_18,
  e0_.title_ts AS title_ts_19,
  e0_.body_ts AS body_ts_20,
  e0_.up_votes AS up_votes_21,
  e0_.down_votes AS down_votes_22,
  e0_.ranking AS ranking_23,
  e0_.visibility AS visibility_24,
  e0_.ap_id AS ap_id_25,
  e0_.edited_at AS edited_at_26,
  e0_.created_at AS created_at_27,
  e0_.user_id AS user_id_28,
  e0_.magazine_id AS magazine_id_29,
  e0_.image_id AS image_id_30,
  e0_.domain_id AS domain_id_31
FROM
  entry e0_
  INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id
  INNER JOIN "user" u2_ ON e0_.user_id = u2_.id
  LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id
WHERE
  e0_.visibility = ?
  AND m1_.visibility = ?
  AND (
    e0_.created_at BETWEEN ?
    AND ?
  )
  AND e0_.type = ?
  AND d3_.name = ?
  AND m1_.is_adult = ?
  AND e0_.is_adult = ?
ORDER BY
  e0_.score DESC,
  e0_.created_at DESC,
  e0_.id DESC
LIMIT
  25

SELECT e0_.slug AS slug_0, e0_.title AS title_1, e0_.url AS url_2, e0_.body AS body_3, e0_.type AS type_4, e0_.lang AS lang_5, e0_.is_oc AS is_oc_6, e0_.has_embed AS has_embed_7, e0_.comment_count AS comment_count_8, e0_.favourite_count AS favourite_count_9, e0_.score AS score_10, e0_.is_adult AS is_adult_11, e0_.sticky AS sticky_12, e0_.last_active AS last_active_13, e0_.ip AS ip_14, e0_.ada_amount AS ada_amount_15, e0_.tags AS tags_16, e0_.mentions AS mentions_17, e0_.id AS id_18, e0_.title_ts AS title_ts_19, e0_.body_ts AS body_ts_20, e0_.up_votes AS up_votes_21, e0_.down_votes AS down_votes_22, e0_.ranking AS ranking_23, e0_.visibility AS visibility_24, e0_.ap_id AS ap_id_25, e0_.edited_at AS edited_at_26, e0_.created_at AS created_at_27, e0_.user_id AS user_id_28, e0_.magazine_id AS magazine_id_29, e0_.image_id AS image_id_30, e0_.domain_id AS domain_id_31 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = 'visible' AND m1_.visibility = 'visible' AND (e0_.created_at BETWEEN '2025-02-15 18:41:39+0000' AND '2025-03-15 18:41:39+0000') AND e0_.type = 'video' AND d3_.name = 'goodnewsnetwork.org' AND m1_.is_adult = 0 AND e0_.is_adult = 0 ORDER BY e0_.score DESC, e0_.created_at DESC, e0_.id DESC LIMIT 25;

SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = ? AND m1_.visibility = ? AND (e0_.created_at BETWEEN ? AND ?) AND e0_.type = ? AND d3_.name = ? AND m1_.is_adult = ? AND e0_.is_adult = ? ORDER BY sclr_0 ASC

[
  "visible"
  "visible"
  "2025-02-15 18:41:39+0000"
  "2025-03-15 18:41:39+0000"
  "video"
  "goodnewsnetwork.org"
  0
  0
]

SELECT
  count(e0_.id) AS sclr_0
FROM
  entry e0_
  INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id
  INNER JOIN "user" u2_ ON e0_.user_id = u2_.id
  LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id
WHERE
  e0_.visibility = ?
  AND m1_.visibility = ?
  AND (
    e0_.created_at BETWEEN ?
    AND ?
  )
  AND e0_.type = ?
  AND d3_.name = ?
  AND m1_.is_adult = ?
  AND e0_.is_adult = ?
ORDER BY
  sclr_0 ASC

SELECT count(e0_.id) AS sclr_0 FROM entry e0_ INNER JOIN magazine m1_ ON e0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON e0_.user_id = u2_.id LEFT JOIN domain d3_ ON e0_.domain_id = d3_.id WHERE e0_.visibility = 'visible' AND m1_.visibility = 'visible' AND (e0_.created_at BETWEEN '2025-02-15 18:41:39+0000' AND '2025-03-15 18:41:39+0000') AND e0_.type = 'video' AND d3_.name = 'goodnewsnetwork.org' AND m1_.is_adult = 0 AND e0_.is_adult = 0 ORDER BY sclr_0 ASC;