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 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 = ?

[
  "85"
]

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 = ?

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 = '85';

SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.post_id AS post_id_6 FROM post_vote t0 WHERE (t0.choice = ? AND t0.post_id = ?) ORDER BY t0.created_at DESC

[
  1
  85
]

SELECT
  t0.choice AS choice_1,
  t0.id AS id_2,
  t0.created_at AS created_at_3,
  t0.user_id AS user_id_4,
  t0.author_id AS author_id_5,
  t0.post_id AS post_id_6
FROM
  post_vote t0
WHERE
  (
    t0.choice = ?
    AND t0.post_id = ?
  )
ORDER BY
  t0.created_at DESC

SELECT t0.choice AS choice_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.user_id AS user_id_4, t0.author_id AS author_id_5, t0.post_id AS post_id_6 FROM post_vote t0 WHERE (t0.choice = 1 AND t0.post_id = 85) ORDER BY t0.created_at DESC;

SELECT COUNT(*) FROM favourite t0 WHERE t0.post_id = ? AND t0.favourite_type IN ('post')

[
  85
]

SELECT
  COUNT(*)
FROM
  favourite t0
WHERE
  t0.post_id = ?
  AND t0.favourite_type IN ('post')

SELECT COUNT(*) FROM favourite t0 WHERE t0.post_id = 85 AND t0.favourite_type IN ('post');

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.magazine_id AS magazine_id_3, t0.user_id AS user_id_4, t0.post_id AS post_id_5, t0.favourite_type FROM favourite t0 WHERE t0.post_id = ? AND t0.favourite_type IN ('post')

[
  85
]

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.magazine_id AS magazine_id_3,
  t0.user_id AS user_id_4,
  t0.post_id AS post_id_5,
  t0.favourite_type
FROM
  favourite t0
WHERE
  t0.post_id = ?
  AND t0.favourite_type IN ('post')

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.magazine_id AS magazine_id_3, t0.user_id AS user_id_4, t0.post_id AS post_id_5, t0.favourite_type FROM favourite t0 WHERE t0.post_id = 85 AND t0.favourite_type IN ('post');

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 = ?

[
  1610
]

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 = 1610;

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = ? AND t0.magazine_id = ?)

[
  1
  19
]

SELECT
  t0.is_owner AS is_owner_1,
  t0.is_confirmed AS is_confirmed_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.user_id AS user_id_5,
  t0.magazine_id AS magazine_id_6
FROM
  moderator t0
WHERE
  (
    t0.is_owner = ?
    AND t0.magazine_id = ?
  )

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE (t0.is_owner = 1 AND t0.magazine_id = 19);

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = ?

[
  19
]

SELECT
  t0.is_owner AS is_owner_1,
  t0.is_confirmed AS is_confirmed_2,
  t0.id AS id_3,
  t0.created_at AS created_at_4,
  t0.user_id AS user_id_5,
  t0.magazine_id AS magazine_id_6
FROM
  moderator t0
WHERE
  t0.magazine_id = ?

SELECT t0.is_owner AS is_owner_1, t0.is_confirmed AS is_confirmed_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.user_id AS user_id_5, t0.magazine_id AS magazine_id_6 FROM moderator t0 WHERE t0.magazine_id = 19;

SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = ? AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban')

[
  19
]

SELECT
  COUNT(*)
FROM
  magazine_log t0
WHERE
  t0.magazine_id = ?
  AND t0.log_type IN (
    'entry_deleted', 'entry_restored',
    'entry_comment_deleted', 'entry_comment_restored',
    'post_deleted', 'post_restored',
    'post_comment_deleted', 'post_comment_restored',
    'ban'
  )

SELECT COUNT(*) FROM magazine_log t0 WHERE t0.magazine_id = 19 AND t0.log_type IN ('entry_deleted', 'entry_restored', 'entry_comment_deleted', 'entry_comment_restored', 'post_deleted', 'post_restored', 'post_comment_deleted', 'post_comment_restored', 'ban');