Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.isEnabled AS isEnabled_4,
  t0.createdAt AS createdAt_5,
  t0.date AS date_6,
  t0.document_id AS document_id_7,
  t8.id AS id_9,
  t8.target AS target_10,
  t8.pages AS pages_11,
  t8.downloads AS downloads_12,
  t8.reading AS reading_13,
  t8.name AS name_14,
  t8.dir AS dir_15,
  t8.source AS source_16,
  t8.size AS size_17,
  t8.is_enabled AS is_enabled_18,
  t8.is_deleted AS is_deleted_19,
  t8.last_update AS last_update_20,
  t8.created_at AS created_at_21,
  t8.formatSize AS formatSize_22,
  t8.mimetype AS mimetype_23,
  t0.cover_id AS cover_id_24,
  t25.target AS target_26,
  t25.thumbnailDir AS thumbnailDir_27,
  t25.hasThumbnail AS hasThumbnail_28,
  t25.id AS id_29,
  t25.pages AS pages_30,
  t25.downloads AS downloads_31,
  t25.reading AS reading_32,
  t25.name AS name_33,
  t25.dir AS dir_34,
  t25.source AS source_35,
  t25.size AS size_36,
  t25.is_enabled AS is_enabled_37,
  t25.is_deleted AS is_deleted_38,
  t25.last_update AS last_update_39,
  t25.created_at AS created_at_40,
  t25.formatSize AS formatSize_41,
  t25.mimetype AS mimetype_42,
  t0.category_id AS category_id_43,
  t44.id AS id_45,
  t44.label AS label_46,
  t44.description AS description_47,
  t44.slug AS slug_48,
  t0.createdBy AS createdBy_49,
  t0.updatedBy AS updatedBy_50
FROM
  resources t0
  LEFT JOIN file t8 ON t0.document_id = t8.id
  LEFT JOIN picture t25 ON t0.cover_id = t25.id
  LEFT JOIN resources_categories t44 ON t0.category_id = t44.id
ORDER BY
  t0.date DESC,
  t0.id DESC

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.isEnabled AS isEnabled_4, t0.createdAt AS createdAt_5, t0.date AS date_6, t0.document_id AS document_id_7, t8.id AS id_9, t8.target AS target_10, t8.pages AS pages_11, t8.downloads AS downloads_12, t8.reading AS reading_13, t8.name AS name_14, t8.dir AS dir_15, t8.source AS source_16, t8.size AS size_17, t8.is_enabled AS is_enabled_18, t8.is_deleted AS is_deleted_19, t8.last_update AS last_update_20, t8.created_at AS created_at_21, t8.formatSize AS formatSize_22, t8.mimetype AS mimetype_23, t0.cover_id AS cover_id_24, t25.target AS target_26, t25.thumbnailDir AS thumbnailDir_27, t25.hasThumbnail AS hasThumbnail_28, t25.id AS id_29, t25.pages AS pages_30, t25.downloads AS downloads_31, t25.reading AS reading_32, t25.name AS name_33, t25.dir AS dir_34, t25.source AS source_35, t25.size AS size_36, t25.is_enabled AS is_enabled_37, t25.is_deleted AS is_deleted_38, t25.last_update AS last_update_39, t25.created_at AS created_at_40, t25.formatSize AS formatSize_41, t25.mimetype AS mimetype_42, t0.category_id AS category_id_43, t44.id AS id_45, t44.label AS label_46, t44.description AS description_47, t44.slug AS slug_48, t0.createdBy AS createdBy_49, t0.updatedBy AS updatedBy_50 FROM resources t0 LEFT JOIN file t8 ON t0.document_id = t8.id LEFT JOIN picture t25 ON t0.cover_id = t25.id LEFT JOIN resources_categories t44 ON t0.category_id = t44.id ORDER BY t0.date DESC, t0.id DESC;