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 p.id
            FROM post p
            JOIN magazine m ON p.magazine_id = m.id
            WHERE p.is_adult = false
              AND p.visibility = :visible
              AND m.is_adult = false
              AND p.ap_id IS NULL
              AND p.created_at >= :time
            ORDER BY random(), p.created_at DESC
            LIMIT :limit;

[
  "visible" => "visible"
  "time" => "2024-09-19 19:47:16"
  "limit" => 154
]

SELECT
  p.id
FROM
  post p
  JOIN magazine m ON p.magazine_id = m.id
WHERE
  p.is_adult = false
  AND p.visibility = :visible
  AND m.is_adult = false
  AND p.ap_id IS NULL
  AND p.created_at >= :time
ORDER BY
  random(),
  p.created_at DESC
LIMIT
  :limit;

SELECT p.id
            FROM post p
            JOIN magazine m ON p.magazine_id = m.id
            WHERE p.is_adult = false
              AND p.visibility = 'visible'
              AND m.is_adult = false
              AND p.ap_id IS NULL
              AND p.created_at >= '2024-09-19 19:47:16'
            ORDER BY random(), p.created_at DESC
            LIMIT 154;    
        ;

SELECT p0_.slug AS slug_0, p0_.body AS body_1, p0_.lang AS lang_2, p0_.comment_count AS comment_count_3, p0_.favourite_count AS favourite_count_4, p0_.score AS score_5, p0_.is_adult AS is_adult_6, p0_.sticky AS sticky_7, p0_.last_active AS last_active_8, p0_.ip AS ip_9, p0_.tags AS tags_10, p0_.mentions AS mentions_11, p0_.id AS id_12, p0_.body_ts AS body_ts_13, p0_.up_votes AS up_votes_14, p0_.down_votes AS down_votes_15, p0_.ranking AS ranking_16, p0_.visibility AS visibility_17, p0_.ap_id AS ap_id_18, p0_.edited_at AS edited_at_19, p0_.created_at AS created_at_20, p0_.user_id AS user_id_21, p0_.magazine_id AS magazine_id_22, p0_.image_id AS image_id_23 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id LEFT JOIN image i2_ ON p0_.image_id = i2_.id WHERE p0_.id IN (NULL)

[]

SELECT
  p0_.slug AS slug_0,
  p0_.body AS body_1,
  p0_.lang AS lang_2,
  p0_.comment_count AS comment_count_3,
  p0_.favourite_count AS favourite_count_4,
  p0_.score AS score_5,
  p0_.is_adult AS is_adult_6,
  p0_.sticky AS sticky_7,
  p0_.last_active AS last_active_8,
  p0_.ip AS ip_9,
  p0_.tags AS tags_10,
  p0_.mentions AS mentions_11,
  p0_.id AS id_12,
  p0_.body_ts AS body_ts_13,
  p0_.up_votes AS up_votes_14,
  p0_.down_votes AS down_votes_15,
  p0_.ranking AS ranking_16,
  p0_.visibility AS visibility_17,
  p0_.ap_id AS ap_id_18,
  p0_.edited_at AS edited_at_19,
  p0_.created_at AS created_at_20,
  p0_.user_id AS user_id_21,
  p0_.magazine_id AS magazine_id_22,
  p0_.image_id AS image_id_23
FROM
  post p0_
  INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id
  LEFT JOIN image i2_ ON p0_.image_id = i2_.id
WHERE
  p0_.id IN (NULL)

SELECT p0_.slug AS slug_0, p0_.body AS body_1, p0_.lang AS lang_2, p0_.comment_count AS comment_count_3, p0_.favourite_count AS favourite_count_4, p0_.score AS score_5, p0_.is_adult AS is_adult_6, p0_.sticky AS sticky_7, p0_.last_active AS last_active_8, p0_.ip AS ip_9, p0_.tags AS tags_10, p0_.mentions AS mentions_11, p0_.id AS id_12, p0_.body_ts AS body_ts_13, p0_.up_votes AS up_votes_14, p0_.down_votes AS down_votes_15, p0_.ranking AS ranking_16, p0_.visibility AS visibility_17, p0_.ap_id AS ap_id_18, p0_.edited_at AS edited_at_19, p0_.created_at AS created_at_20, p0_.user_id AS user_id_21, p0_.magazine_id AS magazine_id_22, p0_.image_id AS image_id_23 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id LEFT JOIN image i2_ ON p0_.image_id = i2_.id WHERE p0_.id IN (NULL);

SELECT e.id
            FROM entry e
            JOIN magazine m ON e.magazine_id = m.id
            WHERE e.is_adult = false
              AND e.visibility = :visible
              AND m.is_adult = false
              AND e.ap_id IS NULL
              AND e.created_at >= :time
            ORDER BY random(), e.created_at DESC
            LIMIT :limit;

[
  "visible" => "visible"
  "time" => "2024-09-19 19:47:16"
  "limit" => 154
]

SELECT
  e.id
FROM
  entry e
  JOIN magazine m ON e.magazine_id = m.id
WHERE
  e.is_adult = false
  AND e.visibility = :visible
  AND m.is_adult = false
  AND e.ap_id IS NULL
  AND e.created_at >= :time
ORDER BY
  random(),
  e.created_at DESC
LIMIT
  :limit;

SELECT e.id
            FROM entry e
            JOIN magazine m ON e.magazine_id = m.id
            WHERE e.is_adult = false
              AND e.visibility = 'visible'
              AND m.is_adult = false
              AND e.ap_id IS NULL
              AND e.created_at >= '2024-09-19 19:47:16'
            ORDER BY random(), e.created_at DESC
            LIMIT 154;    
        ;

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 LEFT JOIN image i2_ ON e0_.image_id = i2_.id WHERE e0_.id IN (NULL)

[]

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
  LEFT JOIN image i2_ ON e0_.image_id = i2_.id
WHERE
  e0_.id IN (NULL)

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 LEFT JOIN image i2_ ON e0_.image_id = i2_.id WHERE e0_.id IN (NULL);