Symfony Profiler

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
  INNER JOIN "user" u2_ ON p0_.user_id = u2_.id
WHERE
  p0_.visibility = ?
  AND m1_.visibility = ?
  AND p0_.magazine_id = ?
  AND m1_.is_adult = ?
  AND p0_.is_adult = ?
ORDER BY
  p0_.sticky DESC,
  p0_.last_active DESC,
  p0_.created_at DESC,
  p0_.id DESC
LIMIT
  15

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 INNER JOIN "user" u2_ ON p0_.user_id = u2_.id WHERE p0_.visibility = 'visible' AND m1_.visibility = 'visible' AND p0_.magazine_id = 49 AND m1_.is_adult = 0 AND p0_.is_adult = 0 ORDER BY p0_.sticky DESC, p0_.last_active DESC, p0_.created_at DESC, p0_.id DESC LIMIT 15;

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 = 366) 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 = ?
    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 = 310) ORDER BY t0.created_at DESC;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.up_votes DESC,
  t0.created_at ASC

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.post_id = 310 ORDER BY t0.up_votes DESC, t0.created_at ASC;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.parent_id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?
  )

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (813, 814, 815, 816, 817, 818, 819, 820, 821, 822, 823, 824, 825, 826, 827, 828, 829, 830, 831, 832, 833, 834, 835, 836, 838, 839, 840, 841, 842, 843, 844, 845, 846, 847, 848, 849, 850, 851, 852, 853, 854, 855, 856, 857, 858, 859, 860, 861, 862, 863, 864, 865, 866, 867, 869, 870, 872, 873, 874, 875, 876, 877, 878, 880);

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.post_id = 310 ORDER BY t0.created_at ASC;

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.comment_id AS comment_id_6
FROM
  post_comment_vote t0
WHERE
  (
    t0.choice = ?
    AND t0.comment_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.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 878) 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.comment_id AS comment_id_6
FROM
  post_comment_vote t0
WHERE
  (
    t0.choice = ?
    AND t0.comment_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.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 880) 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 = ?
    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 = 175) ORDER BY t0.created_at DESC;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.up_votes DESC,
  t0.created_at ASC

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.post_id = 175 ORDER BY t0.up_votes DESC, t0.created_at ASC;

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.parent_id IN (?, ?, ?)

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.parent_id IN (449, 450, 452);

SELECT
  t0.body AS body_1,
  t0.lang AS lang_2,
  t0.favourite_count AS favourite_count_3,
  t0.score AS score_4,
  t0.last_active AS last_active_5,
  t0.ip AS ip_6,
  t0.tags AS tags_7,
  t0.mentions AS mentions_8,
  t0.is_adult AS is_adult_9,
  t0.update_mark AS update_mark_10,
  t0.id AS id_11,
  t0.body_ts AS body_ts_12,
  t0.up_votes AS up_votes_13,
  t0.down_votes AS down_votes_14,
  t0.visibility AS visibility_15,
  t0.ap_id AS ap_id_16,
  t0.edited_at AS edited_at_17,
  t0.created_at AS created_at_18,
  t0.user_id AS user_id_19,
  t0.post_id AS post_id_20,
  t0.magazine_id AS magazine_id_21,
  t0.parent_id AS parent_id_22,
  t0.root_id AS root_id_23,
  t0.image_id AS image_id_24
FROM
  post_comment t0
WHERE
  t0.post_id = ?
ORDER BY
  t0.created_at ASC

SELECT t0.body AS body_1, t0.lang AS lang_2, t0.favourite_count AS favourite_count_3, t0.score AS score_4, t0.last_active AS last_active_5, t0.ip AS ip_6, t0.tags AS tags_7, t0.mentions AS mentions_8, t0.is_adult AS is_adult_9, t0.update_mark AS update_mark_10, t0.id AS id_11, t0.body_ts AS body_ts_12, t0.up_votes AS up_votes_13, t0.down_votes AS down_votes_14, t0.visibility AS visibility_15, t0.ap_id AS ap_id_16, t0.edited_at AS edited_at_17, t0.created_at AS created_at_18, t0.user_id AS user_id_19, t0.post_id AS post_id_20, t0.magazine_id AS magazine_id_21, t0.parent_id AS parent_id_22, t0.root_id AS root_id_23, t0.image_id AS image_id_24 FROM post_comment t0 WHERE t0.post_id = 175 ORDER BY t0.created_at ASC;

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.comment_id AS comment_id_6
FROM
  post_comment_vote t0
WHERE
  (
    t0.choice = ?
    AND t0.comment_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.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 450) 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.comment_id AS comment_id_6
FROM
  post_comment_vote t0
WHERE
  (
    t0.choice = ?
    AND t0.comment_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.comment_id AS comment_id_6 FROM post_comment_vote t0 WHERE (t0.choice = 1 AND t0.comment_id = 452) ORDER BY t0.created_at DESC;

SELECT
  count(p0_.id) AS sclr_0
FROM
  post p0_
  INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id
  INNER JOIN "user" u2_ ON p0_.user_id = u2_.id
WHERE
  p0_.visibility = ?
  AND m1_.visibility = ?
  AND p0_.magazine_id = ?
  AND m1_.is_adult = ?
  AND p0_.is_adult = ?
ORDER BY
  sclr_0 ASC

SELECT count(p0_.id) AS sclr_0 FROM post p0_ INNER JOIN magazine m1_ ON p0_.magazine_id = m1_.id INNER JOIN "user" u2_ ON p0_.user_id = u2_.id WHERE p0_.visibility = 'visible' AND m1_.visibility = 'visible' AND p0_.magazine_id = 49 AND m1_.is_adult = 0 AND p0_.is_adult = 0 ORDER BY sclr_0 ASC;

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 = 49);

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

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 = 49 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');