Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.lien AS lien_2,
  t0.description AS description_3
FROM
  lien_externe t0

SELECT t0.id AS id_1, t0.lien AS lien_2, t0.description AS description_3 FROM lien_externe t0;

SELECT
  count(r0_.id) AS sclr_0
FROM
  ressources r0_
  LEFT JOIN type t1_ ON r0_.type_id = t1_.id
  LEFT JOIN ressource_numero_semaine r3_ ON r0_.id = r3_.ressource_id
  LEFT JOIN numero_semaine n2_ ON n2_.id = r3_.numero_semaine_id
  LEFT JOIN format f4_ ON r0_.format_id = f4_.id
  LEFT JOIN categories c5_ ON r0_.categorie_id = c5_.id

SELECT count(r0_.id) AS sclr_0 FROM ressources r0_ LEFT JOIN type t1_ ON r0_.type_id = t1_.id LEFT JOIN ressource_numero_semaine r3_ ON r0_.id = r3_.ressource_id LEFT JOIN numero_semaine n2_ ON n2_.id = r3_.numero_semaine_id LEFT JOIN format f4_ ON r0_.format_id = f4_.id LEFT JOIN categories c5_ ON r0_.categorie_id = c5_.id;

SELECT
  r0_.id AS id_0,
  r0_.nom AS nom_1,
  r0_.description AS description_2,
  r0_.fichier AS fichier_3,
  r0_.updated_at AS updated_at_4,
  r0_.lien_externe AS lien_externe_5,
  r0_.type_id AS type_id_6,
  r0_.categorie_id AS categorie_id_7,
  r0_.ressource_ephemerides_id AS ressource_ephemerides_id_8,
  r0_.format_id AS format_id_9
FROM
  ressources r0_
  LEFT JOIN type t1_ ON r0_.type_id = t1_.id
  LEFT JOIN ressource_numero_semaine r3_ ON r0_.id = r3_.ressource_id
  LEFT JOIN numero_semaine n2_ ON n2_.id = r3_.numero_semaine_id
  LEFT JOIN format f4_ ON r0_.format_id = f4_.id
  LEFT JOIN categories c5_ ON r0_.categorie_id = c5_.id
ORDER BY
  r0_.nom DESC
LIMIT
  10
OFFSET
  80

SELECT r0_.id AS id_0, r0_.nom AS nom_1, r0_.description AS description_2, r0_.fichier AS fichier_3, r0_.updated_at AS updated_at_4, r0_.lien_externe AS lien_externe_5, r0_.type_id AS type_id_6, r0_.categorie_id AS categorie_id_7, r0_.ressource_ephemerides_id AS ressource_ephemerides_id_8, r0_.format_id AS format_id_9 FROM ressources r0_ LEFT JOIN type t1_ ON r0_.type_id = t1_.id LEFT JOIN ressource_numero_semaine r3_ ON r0_.id = r3_.ressource_id LEFT JOIN numero_semaine n2_ ON n2_.id = r3_.numero_semaine_id LEFT JOIN format f4_ ON r0_.format_id = f4_.id LEFT JOIN categories c5_ ON r0_.categorie_id = c5_.id ORDER BY r0_.nom DESC LIMIT 10 OFFSET 80;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 187;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type t0 WHERE t0.id = 7;

SELECT
  t0.id AS id_1,
  t0.format AS format_2
FROM
  format t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.format AS format_2 FROM format t0 WHERE t0.id = 71;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 21;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 64;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 207;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 206;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 155;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 154;

SELECT
  t0.id AS id_1,
  t0.libelle AS libelle_2
FROM
  type t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.libelle AS libelle_2 FROM type t0 WHERE t0.id = 8;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 205;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 204;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2
FROM
  categories t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2 FROM categories t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.no_semaine AS no_semaine_2,
  t3.id AS id_4,
  t3.titre AS titre_5,
  t3.description AS description_6,
  t3.photo AS photo_7,
  t3.url_photp_wp AS url_photp_wp_8,
  t3.photo_projection AS photo_projection_9,
  t3.details_sequence AS details_sequence_10,
  t3.theme AS theme_11,
  t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12
FROM
  numero_semaine t0
  LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id
  INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id
WHERE
  ressource_numero_semaine.ressource_id = ?

SELECT t0.id AS id_1, t0.no_semaine AS no_semaine_2, t3.id AS id_4, t3.titre AS titre_5, t3.description AS description_6, t3.photo AS photo_7, t3.url_photp_wp AS url_photp_wp_8, t3.photo_projection AS photo_projection_9, t3.details_sequence AS details_sequence_10, t3.theme AS theme_11, t3.no_semaine_ephemeride_id AS no_semaine_ephemeride_id_12 FROM numero_semaine t0 LEFT JOIN ephemerides t3 ON t3.no_semaine_ephemeride_id = t0.id INNER JOIN ressource_numero_semaine ON t0.id = ressource_numero_semaine.numero_semaine_id WHERE ressource_numero_semaine.ressource_id = 61;