Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_5
    FROM
      (
        SELECT
          c0_.title AS title_0,
          c0_.text AS text_1,
          c0_.public AS public_2,
          c0_.created_at AS created_at_3,
          c0_.updated_at AS updated_at_4,
          c0_.id AS id_5
        FROM
          community_news c0_
        WHERE
          c0_.public = 1
        ORDER BY
          c0_.created_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT c0_.title AS title_0, c0_.text AS text_1, c0_.public AS public_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5 FROM community_news c0_ WHERE c0_.public = 1 ORDER BY c0_.created_at DESC) dctrn_result) dctrn_table;

SELECT
  DISTINCT id_5
FROM
  (
    SELECT
      DISTINCT id_5,
      created_at_3
    FROM
      (
        SELECT
          c0_.title AS title_0,
          c0_.text AS text_1,
          c0_.public AS public_2,
          c0_.created_at AS created_at_3,
          c0_.updated_at AS updated_at_4,
          c0_.id AS id_5
        FROM
          community_news c0_
        WHERE
          c0_.public = 1
      ) dctrn_result_inner
    ORDER BY
      created_at_3 DESC
  ) dctrn_result
LIMIT
  10

SELECT DISTINCT id_5 FROM (SELECT DISTINCT id_5, created_at_3 FROM (SELECT c0_.title AS title_0, c0_.text AS text_1, c0_.public AS public_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5 FROM community_news c0_ WHERE c0_.public = 1) dctrn_result_inner ORDER BY created_at_3 DESC) dctrn_result LIMIT 10;

SELECT
  c0_.title AS title_0,
  c0_.text AS text_1,
  c0_.public AS public_2,
  c0_.created_at AS created_at_3,
  c0_.updated_at AS updated_at_4,
  c0_.id AS id_5,
  c0_.created_by AS created_by_6,
  c0_.updated_by AS updated_by_7
FROM
  community_news c0_
WHERE
  c0_.public = 1
  AND c0_.id IN (?)
ORDER BY
  c0_.created_at DESC

SELECT c0_.title AS title_0, c0_.text AS text_1, c0_.public AS public_2, c0_.created_at AS created_at_3, c0_.updated_at AS updated_at_4, c0_.id AS id_5, c0_.created_by AS created_by_6, c0_.updated_by AS updated_by_7 FROM community_news c0_ WHERE c0_.public = 1 AND c0_.id IN (1) ORDER BY c0_.created_at DESC;

SELECT
  t0.id AS id_1,
  t0.Username AS Username_2,
  t0.Email AS Email_3,
  t0.NewEmail AS NewEmail_4,
  t0.Locale AS Locale_5,
  t0.LastActive AS LastActive_6,
  t0.PassWord AS PassWord_7,
  t0.Status AS Status_8,
  t0.Reminders AS Reminders_9,
  t0.Name AS Name_10,
  t0.ShortName AS ShortName_11,
  t0.HideAttribute AS HideAttribute_12,
  t0.ProfileLanguage AS ProfileLanguage_13,
  t0.Accommodation AS Accommodation_14,
  t0.AdditionalAccommodationInfo AS AdditionalAccommodationInfo_15,
  t0.ILiveWith AS ILiveWith_16,
  t0.StandardOffers AS StandardOffers_17,
  t0.MaxGuests AS MaxGuests_18,
  t0.MaxLengthOfStay AS MaxLengthOfStay_19,
  t0.Organizations AS Organizations_20,
  t0.Restrictions AS Restrictions_21,
  t0.HouseRules AS HouseRules_22,
  t0.created AS created_23,
  t0.updated AS updated_24,
  t0.AboutMe AS AboutMe_25,
  t0.Occupation AS Occupation_26,
  t0.Gender AS Gender_27,
  t0.BirthDate AS BirthDate_28,
  t0.PastTrips AS PastTrips_29,
  t0.PlannedTrips AS PlannedTrips_30,
  t0.Hobbies AS Hobbies_31,
  t0.Books AS Books_32,
  t0.Music AS Music_33,
  t0.Movies AS Movies_34,
  t0.PleaseBring AS PleaseBring_35,
  t0.WhereYouSleep AS WhereYouSleep_36,
  t0.OfferGuests AS OfferGuests_37,
  t0.OfferHosts AS OfferHosts_38,
  t0.GettingThere AS GettingThere_39,
  t0.LastSwitchToActive AS LastSwitchToActive_40,
  t0.bewelcomed AS bewelcomed_41,
  t0.RegistrationKey AS RegistrationKey_42,
  t0.HostingInterest AS HostingInterest_43
FROM
  member t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.Username AS Username_2, t0.Email AS Email_3, t0.NewEmail AS NewEmail_4, t0.Locale AS Locale_5, t0.LastActive AS LastActive_6, t0.PassWord AS PassWord_7, t0.Status AS Status_8, t0.Reminders AS Reminders_9, t0.Name AS Name_10, t0.ShortName AS ShortName_11, t0.HideAttribute AS HideAttribute_12, t0.ProfileLanguage AS ProfileLanguage_13, t0.Accommodation AS Accommodation_14, t0.AdditionalAccommodationInfo AS AdditionalAccommodationInfo_15, t0.ILiveWith AS ILiveWith_16, t0.StandardOffers AS StandardOffers_17, t0.MaxGuests AS MaxGuests_18, t0.MaxLengthOfStay AS MaxLengthOfStay_19, t0.Organizations AS Organizations_20, t0.Restrictions AS Restrictions_21, t0.HouseRules AS HouseRules_22, t0.created AS created_23, t0.updated AS updated_24, t0.AboutMe AS AboutMe_25, t0.Occupation AS Occupation_26, t0.Gender AS Gender_27, t0.BirthDate AS BirthDate_28, t0.PastTrips AS PastTrips_29, t0.PlannedTrips AS PlannedTrips_30, t0.Hobbies AS Hobbies_31, t0.Books AS Books_32, t0.Music AS Music_33, t0.Movies AS Movies_34, t0.PleaseBring AS PleaseBring_35, t0.WhereYouSleep AS WhereYouSleep_36, t0.OfferGuests AS OfferGuests_37, t0.OfferHosts AS OfferHosts_38, t0.GettingThere AS GettingThere_39, t0.LastSwitchToActive AS LastSwitchToActive_40, t0.bewelcomed AS bewelcomed_41, t0.RegistrationKey AS RegistrationKey_42, t0.HostingInterest AS HostingInterest_43 FROM member t0 WHERE t0.id = 2;

SELECT
  t0.HouseNumber AS HouseNumber_1,
  t0.StreetName AS StreetName_2,
  t0.Zip AS Zip_3,
  t0.wheelChairAccessible AS wheelChairAccessible_4,
  t0.latitude AS latitude_5,
  t0.longitude AS longitude_6,
  t0.active AS active_7,
  t0.id AS id_8,
  t0.member_id AS member_id_9,
  t0.location AS location_10
FROM
  address t0
WHERE
  t0.member_id IN (?)

SELECT t0.HouseNumber AS HouseNumber_1, t0.StreetName AS StreetName_2, t0.Zip AS Zip_3, t0.wheelChairAccessible AS wheelChairAccessible_4, t0.latitude AS latitude_5, t0.longitude AS longitude_6, t0.active AS active_7, t0.id AS id_8, t0.member_id AS member_id_9, t0.location AS location_10 FROM address t0 WHERE t0.member_id IN (2);

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.object_id AS object_id_5
FROM
  member_translations t0
WHERE
  t0.object_id = ?
ORDER BY
  t0.locale ASC

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.object_id AS object_id_5 FROM member_translations t0 WHERE t0.object_id = 2 ORDER BY t0.locale ASC;

SELECT
  COUNT(*)
FROM
  community_news_comment t0
WHERE
  t0.community_news_id = ?

SELECT COUNT(*) FROM community_news_comment t0 WHERE t0.community_news_id = 1;