Symfony Profiler

SELECT
  count(
    DISTINCT (a0_.id)
  ) AS sclr_0
FROM
  articles a0_
  LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id
  LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id
  LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id
  LEFT JOIN albums a4_ ON a0_.album_id = a4_.id
  LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id
ORDER BY
  a0_.date DESC

SELECT count(DISTINCT (a0_.id)) AS sclr_0 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a3_ ON a0_.type_id = a3_.id LEFT JOIN albums a4_ ON a0_.album_id = a4_.id LEFT JOIN biblios b5_ ON a0_.biblio_id = b5_.id ORDER BY a0_.date DESC;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.description AS description_2,
  a0_.content AS content_3,
  a0_.slug AS slug_4,
  a0_.createdAt AS createdAt_5,
  a0_.lastUpdate AS lastUpdate_6,
  a0_.date AS date_7,
  a0_.isEnabled AS isEnabled_8,
  a0_.isOnFrontPage AS isOnFrontPage_9,
  a0_.isVisible AS isVisible_10,
  a0_.isDeleted AS isDeleted_11,
  a0_.youtube AS youtube_12,
  a0_.flickr AS flickr_13,
  a0_.URL AS URL_14,
  a0_.soundcloud AS soundcloud_15,
  p1_.target AS target_16,
  p1_.thumbnailDir AS thumbnailDir_17,
  p1_.hasThumbnail AS hasThumbnail_18,
  p1_.id AS id_19,
  p1_.pages AS pages_20,
  p1_.downloads AS downloads_21,
  p1_.reading AS reading_22,
  p1_.name AS name_23,
  p1_.dir AS dir_24,
  p1_.source AS source_25,
  p1_.size AS size_26,
  p1_.is_enabled AS is_enabled_27,
  p1_.is_deleted AS is_deleted_28,
  p1_.last_update AS last_update_29,
  p1_.created_at AS created_at_30,
  p1_.formatSize AS formatSize_31,
  p1_.mimetype AS mimetype_32,
  a2_.id AS id_33,
  a2_.name AS name_34,
  a2_.slug AS slug_35,
  a2_.description AS description_36,
  a3_.id AS id_37,
  a3_.title AS title_38,
  a3_.isEnabled AS isEnabled_39,
  b4_.id AS id_40,
  b4_.title AS title_41,
  b4_.isEnabled AS isEnabled_42,
  a0_.updatedBy AS updatedBy_43,
  a0_.banner_id AS banner_id_44,
  a0_.category_id AS category_id_45,
  a0_.type_id AS type_id_46,
  a0_.user_id AS user_id_47,
  a0_.album_id AS album_id_48,
  a0_.biblio_id AS biblio_id_49,
  a2_.banner_id AS banner_id_50
FROM
  articles a0_
  LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id
  LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id
  LEFT JOIN articles_types a5_ ON a0_.type_id = a5_.id
  LEFT JOIN albums a3_ ON a0_.album_id = a3_.id
  LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id
ORDER BY
  a0_.date DESC
LIMIT
  20

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.description AS description_2, a0_.content AS content_3, a0_.slug AS slug_4, a0_.createdAt AS createdAt_5, a0_.lastUpdate AS lastUpdate_6, a0_.date AS date_7, a0_.isEnabled AS isEnabled_8, a0_.isOnFrontPage AS isOnFrontPage_9, a0_.isVisible AS isVisible_10, a0_.isDeleted AS isDeleted_11, a0_.youtube AS youtube_12, a0_.flickr AS flickr_13, a0_.URL AS URL_14, a0_.soundcloud AS soundcloud_15, p1_.target AS target_16, p1_.thumbnailDir AS thumbnailDir_17, p1_.hasThumbnail AS hasThumbnail_18, p1_.id AS id_19, p1_.pages AS pages_20, p1_.downloads AS downloads_21, p1_.reading AS reading_22, p1_.name AS name_23, p1_.dir AS dir_24, p1_.source AS source_25, p1_.size AS size_26, p1_.is_enabled AS is_enabled_27, p1_.is_deleted AS is_deleted_28, p1_.last_update AS last_update_29, p1_.created_at AS created_at_30, p1_.formatSize AS formatSize_31, p1_.mimetype AS mimetype_32, a2_.id AS id_33, a2_.name AS name_34, a2_.slug AS slug_35, a2_.description AS description_36, a3_.id AS id_37, a3_.title AS title_38, a3_.isEnabled AS isEnabled_39, b4_.id AS id_40, b4_.title AS title_41, b4_.isEnabled AS isEnabled_42, a0_.updatedBy AS updatedBy_43, a0_.banner_id AS banner_id_44, a0_.category_id AS category_id_45, a0_.type_id AS type_id_46, a0_.user_id AS user_id_47, a0_.album_id AS album_id_48, a0_.biblio_id AS biblio_id_49, a2_.banner_id AS banner_id_50 FROM articles a0_ LEFT JOIN picture p1_ ON a0_.banner_id = p1_.id LEFT JOIN articles_categories a2_ ON a0_.category_id = a2_.id LEFT JOIN articles_types a5_ ON a0_.type_id = a5_.id LEFT JOIN albums a3_ ON a0_.album_id = a3_.id LEFT JOIN biblios b4_ ON a0_.biblio_id = b4_.id ORDER BY a0_.date DESC LIMIT 20;