Symfony Profiler

SELECT
  DISTINCT h0_.indicateur_telephonique AS indicateur_telephonique_0
FROM
  har_code_pays h0_
WHERE
  h0_.indicateur_telephonique IS NOT NULL
  AND h0_.indisponible = ?
ORDER BY
  CAST(
    h0_.indicateur_telephonique AS signed
  ) ASC

SELECT DISTINCT h0_.indicateur_telephonique AS indicateur_telephonique_0 FROM har_code_pays h0_ WHERE h0_.indicateur_telephonique IS NOT NULL AND h0_.indisponible = 0 ORDER BY CAST(h0_.indicateur_telephonique AS signed) ASC;

SELECT
  h0_.nom AS nom_0,
  h0_.periode_validite_du AS periode_validite_du_1,
  h0_.periode_validite_au AS periode_validite_au_2,
  h0_.formats AS formats_3,
  h0_.cibles AS cibles_4,
  h0_.montant AS montant_5,
  h0_.enabled AS enabled_6,
  h0_.affichage_bandeau AS affichage_bandeau_7,
  h0_.filtre_par AS filtre_par_8,
  h0_.id AS id_9,
  h0_.created AS created_10,
  h0_.changed AS changed_11,
  h0_.thematique_id AS thematique_id_12,
  h0_.zone_geographique_id AS zone_geographique_id_13,
  h0_.collection_id AS collection_id_14,
  h0_.idUsersCreator AS idUsersCreator_15,
  h0_.idUsersChanger AS idUsersChanger_16
FROM
  har_code_avantage h0_
WHERE
  h0_.periode_validite_du <= ?
  AND h0_.periode_validite_au >= ?
  AND JSON_CONTAINS(h0_.cibles, ?) = 1
  AND (
    (
      h0_.filtre_par IS NULL
      OR h0_.filtre_par = ''
    )
  )
  AND h0_.enabled = 1
  AND h0_.affichage_bandeau = 1
ORDER BY
  h0_.montant DESC
LIMIT
  1

SELECT h0_.nom AS nom_0, h0_.periode_validite_du AS periode_validite_du_1, h0_.periode_validite_au AS periode_validite_au_2, h0_.formats AS formats_3, h0_.cibles AS cibles_4, h0_.montant AS montant_5, h0_.enabled AS enabled_6, h0_.affichage_bandeau AS affichage_bandeau_7, h0_.filtre_par AS filtre_par_8, h0_.id AS id_9, h0_.created AS created_10, h0_.changed AS changed_11, h0_.thematique_id AS thematique_id_12, h0_.zone_geographique_id AS zone_geographique_id_13, h0_.collection_id AS collection_id_14, h0_.idUsersCreator AS idUsersCreator_15, h0_.idUsersChanger AS idUsersChanger_16 FROM har_code_avantage h0_ WHERE h0_.periode_validite_du <= '2025-10-24 00:00:00' AND h0_.periode_validite_au >= '2025-10-24 00:00:00' AND JSON_CONTAINS(h0_.cibles, '[\"client\"]') = 1 AND ((h0_.filtre_par IS NULL OR h0_.filtre_par = '')) AND h0_.enabled = 1 AND h0_.affichage_bandeau = 1 ORDER BY h0_.montant DESC LIMIT 1;

SELECT
  t0.type AS type_1,
  t0.titre AS titre_2,
  t0.slug AS slug_3,
  t0.sous_titre AS sous_titre_4,
  t0.tome AS tome_5,
  t0.revue_numero AS revue_numero_6,
  t0.resume AS resume_7,
  t0.date_publication AS date_publication_8,
  t0.biographie AS biographie_9,
  t0.extrait_pdf AS extrait_pdf_10,
  t0.extrait_audio AS extrait_audio_11,
  t0.sommaire AS sommaire_12,
  t0.date_modification AS date_modification_13,
  t0.prix_papier AS prix_papier_14,
  t0.prix_numerique AS prix_numerique_15,
  t0.prix_audio AS prix_audio_16,
  t0.disponibilite_epub AS disponibilite_epub_17,
  t0.largeur AS largeur_18,
  t0.hauteur AS hauteur_19,
  t0.nb_pages AS nb_pages_20,
  t0.poids AS poids_21,
  t0.isbn AS isbn_22,
  t0.ean13 AS ean13_23,
  t0.ean_epub AS ean_epub_24,
  t0.ean_pdf AS ean_pdf_25,
  t0.multilingue AS multilingue_26,
  t0.avis_expert AS avis_expert_27,
  t0.externe_id AS externe_id_28,
  t0.image_recto_url_externe AS image_recto_url_externe_29,
  t0.image_verso_url_externe AS image_verso_url_externe_30,
  t0.updated AS updated_31,
  t0.added AS added_32,
  t0.image_changed AS image_changed_33,
  t0.a_la_une AS a_la_une_34,
  t0.lien_aplat AS lien_aplat_35,
  t0.id AS id_36,
  t0.created AS created_37,
  t0.changed AS changed_38,
  t0.revue_id AS revue_id_39,
  t0.image_recto_id AS image_recto_id_40,
  t0.image_verso_id AS image_verso_id_41,
  t0.disponibilite_papier_id AS disponibilite_papier_id_42,
  t0.disponibilite_numerique_id AS disponibilite_numerique_id_43,
  t0.disponibilite_audio_id AS disponibilite_audio_id_44,
  t0.editeur_id AS editeur_id_45,
  t0.collection_id AS collection_id_46,
  t0.sous_collection_id AS sous_collection_id_47,
  t0.nature_id AS nature_id_48,
  t0.type_couverture_id AS type_couverture_id_49
FROM
  har_ouvrage t0
WHERE
  t0.id IN (NULL)

SELECT t0.type AS type_1, t0.titre AS titre_2, t0.slug AS slug_3, t0.sous_titre AS sous_titre_4, t0.tome AS tome_5, t0.revue_numero AS revue_numero_6, t0.resume AS resume_7, t0.date_publication AS date_publication_8, t0.biographie AS biographie_9, t0.extrait_pdf AS extrait_pdf_10, t0.extrait_audio AS extrait_audio_11, t0.sommaire AS sommaire_12, t0.date_modification AS date_modification_13, t0.prix_papier AS prix_papier_14, t0.prix_numerique AS prix_numerique_15, t0.prix_audio AS prix_audio_16, t0.disponibilite_epub AS disponibilite_epub_17, t0.largeur AS largeur_18, t0.hauteur AS hauteur_19, t0.nb_pages AS nb_pages_20, t0.poids AS poids_21, t0.isbn AS isbn_22, t0.ean13 AS ean13_23, t0.ean_epub AS ean_epub_24, t0.ean_pdf AS ean_pdf_25, t0.multilingue AS multilingue_26, t0.avis_expert AS avis_expert_27, t0.externe_id AS externe_id_28, t0.image_recto_url_externe AS image_recto_url_externe_29, t0.image_verso_url_externe AS image_verso_url_externe_30, t0.updated AS updated_31, t0.added AS added_32, t0.image_changed AS image_changed_33, t0.a_la_une AS a_la_une_34, t0.lien_aplat AS lien_aplat_35, t0.id AS id_36, t0.created AS created_37, t0.changed AS changed_38, t0.revue_id AS revue_id_39, t0.image_recto_id AS image_recto_id_40, t0.image_verso_id AS image_verso_id_41, t0.disponibilite_papier_id AS disponibilite_papier_id_42, t0.disponibilite_numerique_id AS disponibilite_numerique_id_43, t0.disponibilite_audio_id AS disponibilite_audio_id_44, t0.editeur_id AS editeur_id_45, t0.collection_id AS collection_id_46, t0.sous_collection_id AS sous_collection_id_47, t0.nature_id AS nature_id_48, t0.type_couverture_id AS type_couverture_id_49 FROM har_ouvrage t0 WHERE t0.id IN (NULL);

SELECT
  1
FROM
  phpcr_workspaces
WHERE
  name = ?

SELECT 1 FROM phpcr_workspaces WHERE name = 'default_live';

SELECT
  prefix,
  uri
FROM
  phpcr_namespaces

SELECT prefix, uri FROM phpcr_namespaces;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  phpcr_type_nodes.name AS node_name,
  phpcr_type_nodes.is_abstract AS node_abstract,
  phpcr_type_nodes.is_mixin AS node_mixin,
  phpcr_type_nodes.queryable AS node_queryable,
  phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
  phpcr_type_nodes.primary_item AS node_primary_item_name,
  phpcr_type_nodes.supertypes AS declared_super_type_names,
  phpcr_type_props.name AS property_name,
  phpcr_type_props.auto_created AS property_auto_created,
  phpcr_type_props.mandatory AS property_mandatory,
  phpcr_type_props.protected AS property_protected,
  phpcr_type_props.on_parent_version AS property_on_parent_version,
  phpcr_type_props.required_type AS property_required_type,
  phpcr_type_props.multiple AS property_multiple,
  phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
  phpcr_type_props.query_orderable AS property_query_orderable,
  phpcr_type_props.default_value as property_default_value,
  phpcr_type_childs.name AS child_name,
  phpcr_type_childs.auto_created AS child_auto_created,
  phpcr_type_childs.mandatory AS child_mandatory,
  phpcr_type_childs.protected AS child_protected,
  phpcr_type_childs.on_parent_version AS child_on_parent_version,
  phpcr_type_childs.default_type AS child_default_type,
  phpcr_type_childs.primary_types AS child_primary_types
FROM
  phpcr_type_nodes
  LEFT JOIN phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
  LEFT JOIN phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id

SELECT
phpcr_type_nodes.name AS node_name, phpcr_type_nodes.is_abstract AS node_abstract,
phpcr_type_nodes.is_mixin AS node_mixin, phpcr_type_nodes.queryable AS node_queryable,
phpcr_type_nodes.orderable_child_nodes AS node_has_orderable_child_nodes,
phpcr_type_nodes.primary_item AS node_primary_item_name, phpcr_type_nodes.supertypes AS declared_super_type_names,
phpcr_type_props.name AS property_name, phpcr_type_props.auto_created AS property_auto_created,
phpcr_type_props.mandatory AS property_mandatory, phpcr_type_props.protected AS property_protected,
phpcr_type_props.on_parent_version AS property_on_parent_version,
phpcr_type_props.required_type AS property_required_type, phpcr_type_props.multiple AS property_multiple,
phpcr_type_props.fulltext_searchable AS property_fulltext_searchable,
phpcr_type_props.query_orderable AS property_query_orderable, phpcr_type_props.default_value as property_default_value,
phpcr_type_childs.name AS child_name, phpcr_type_childs.auto_created AS child_auto_created,
phpcr_type_childs.mandatory AS child_mandatory, phpcr_type_childs.protected AS child_protected,
phpcr_type_childs.on_parent_version AS child_on_parent_version, phpcr_type_childs.default_type AS child_default_type,
phpcr_type_childs.primary_types AS child_primary_types
FROM
phpcr_type_nodes
LEFT JOIN
phpcr_type_props ON phpcr_type_nodes.node_type_id = phpcr_type_props.node_type_id
LEFT JOIN
phpcr_type_childs ON phpcr_type_nodes.node_type_id = phpcr_type_childs.node_type_id
;

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    EXTRACTVALUE(
      n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0'
    )
    AND (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
  )

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')));

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/default/contents'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/default/contents') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/snippets/main_menu'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/main_menu') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    n0.parent = '/cmf/snippets/main_menu'
    AND EXTRACTVALUE(
      n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0'
    )
  )
ORDER BY
  CAST(
    EXTRACTVALUE(
      n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]'
    ) AS DECIMAL
  ) ASC,
  EXTRACTVALUE(
    n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]'
  ) ASC

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (n0.parent = '/cmf/snippets/main_menu' AND EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:snippet"]) > 0')) ORDER BY CAST(EXTRACTVALUE(n0.numerical_props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') AS DECIMAL) ASC, EXTRACTVALUE(n0.props, '//sv:property[@sv:name="i18n:fr-title"]/sv:value[1]') ASC;

SELECT
  *
FROM
  phpcr_nodes
WHERE
  path = ?
  AND workspace_name = ?
ORDER BY
  depth,
  sort_order ASC

SELECT * FROM phpcr_nodes
              WHERE path = '/cmf/snippets/main_menu/menu-principal'
                AND workspace_name = 'default_live'
              ORDER BY depth, sort_order ASC;

SELECT
  path,
  parent
FROM
  phpcr_nodes
WHERE
  parent IN (?)
  AND workspace_name = ?
ORDER BY
  sort_order ASC

SELECT path, parent FROM phpcr_nodes WHERE parent IN ('/cmf/snippets/main_menu/menu-principal') AND workspace_name = 'default_live' ORDER BY sort_order ASC;

SELECT
  DATABASE()

SELECT DATABASE();

SELECT
  n0.path AS n0_path,
  n0.identifier AS n0_identifier,
  n0.props AS n0_props
FROM
  phpcr_nodes n0
WHERE
  n0.workspace_name = ?
  AND n0.type IN ('nt:unstructured', 'rep:root')
  AND (
    EXTRACTVALUE(
      n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0'
    )
    AND (
      EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0'
      )
      OR EXTRACTVALUE(
        n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0'
      )
    )
  )

SELECT n0.path AS n0_path, n0.identifier AS n0_identifier, n0.props AS n0_props FROM phpcr_nodes n0 WHERE n0.workspace_name = 'default_live' AND n0.type IN ('nt:unstructured', 'rep:root') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="i18n:fr-template"]/sv:value[text()="homepage"]) > 0') AND (EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:page"]) > 0') OR EXTRACTVALUE(n0.props, 'count(//sv:property[@sv:name="jcr:mixinTypes"]/sv:value[text()="sulu:home"]) > 0')));

SELECT
  h0_.type AS type_0,
  h0_.titre AS titre_1,
  h0_.slug AS slug_2,
  h0_.sous_titre AS sous_titre_3,
  h0_.tome AS tome_4,
  h0_.revue_numero AS revue_numero_5,
  h0_.resume AS resume_6,
  h0_.date_publication AS date_publication_7,
  h0_.biographie AS biographie_8,
  h0_.extrait_pdf AS extrait_pdf_9,
  h0_.extrait_audio AS extrait_audio_10,
  h0_.sommaire AS sommaire_11,
  h0_.date_modification AS date_modification_12,
  h0_.prix_papier AS prix_papier_13,
  h0_.prix_numerique AS prix_numerique_14,
  h0_.prix_audio AS prix_audio_15,
  h0_.disponibilite_epub AS disponibilite_epub_16,
  h0_.largeur AS largeur_17,
  h0_.hauteur AS hauteur_18,
  h0_.nb_pages AS nb_pages_19,
  h0_.poids AS poids_20,
  h0_.isbn AS isbn_21,
  h0_.ean13 AS ean13_22,
  h0_.ean_epub AS ean_epub_23,
  h0_.ean_pdf AS ean_pdf_24,
  h0_.multilingue AS multilingue_25,
  h0_.avis_expert AS avis_expert_26,
  h0_.externe_id AS externe_id_27,
  h0_.image_recto_url_externe AS image_recto_url_externe_28,
  h0_.image_verso_url_externe AS image_verso_url_externe_29,
  h0_.updated AS updated_30,
  h0_.added AS added_31,
  h0_.image_changed AS image_changed_32,
  h0_.a_la_une AS a_la_une_33,
  h0_.lien_aplat AS lien_aplat_34,
  h0_.id AS id_35,
  h0_.created AS created_36,
  h0_.changed AS changed_37,
  h0_.revue_id AS revue_id_38,
  h0_.image_recto_id AS image_recto_id_39,
  h0_.image_verso_id AS image_verso_id_40,
  h0_.disponibilite_papier_id AS disponibilite_papier_id_41,
  h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42,
  h0_.disponibilite_audio_id AS disponibilite_audio_id_43,
  h0_.editeur_id AS editeur_id_44,
  h0_.collection_id AS collection_id_45,
  h0_.sous_collection_id AS sous_collection_id_46,
  h0_.nature_id AS nature_id_47,
  h0_.type_couverture_id AS type_couverture_id_48
FROM
  har_ouvrage h0_
WHERE
  h0_.id IN (
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
    ?, ?
  )

SELECT h0_.type AS type_0, h0_.titre AS titre_1, h0_.slug AS slug_2, h0_.sous_titre AS sous_titre_3, h0_.tome AS tome_4, h0_.revue_numero AS revue_numero_5, h0_.resume AS resume_6, h0_.date_publication AS date_publication_7, h0_.biographie AS biographie_8, h0_.extrait_pdf AS extrait_pdf_9, h0_.extrait_audio AS extrait_audio_10, h0_.sommaire AS sommaire_11, h0_.date_modification AS date_modification_12, h0_.prix_papier AS prix_papier_13, h0_.prix_numerique AS prix_numerique_14, h0_.prix_audio AS prix_audio_15, h0_.disponibilite_epub AS disponibilite_epub_16, h0_.largeur AS largeur_17, h0_.hauteur AS hauteur_18, h0_.nb_pages AS nb_pages_19, h0_.poids AS poids_20, h0_.isbn AS isbn_21, h0_.ean13 AS ean13_22, h0_.ean_epub AS ean_epub_23, h0_.ean_pdf AS ean_pdf_24, h0_.multilingue AS multilingue_25, h0_.avis_expert AS avis_expert_26, h0_.externe_id AS externe_id_27, h0_.image_recto_url_externe AS image_recto_url_externe_28, h0_.image_verso_url_externe AS image_verso_url_externe_29, h0_.updated AS updated_30, h0_.added AS added_31, h0_.image_changed AS image_changed_32, h0_.a_la_une AS a_la_une_33, h0_.lien_aplat AS lien_aplat_34, h0_.id AS id_35, h0_.created AS created_36, h0_.changed AS changed_37, h0_.revue_id AS revue_id_38, h0_.image_recto_id AS image_recto_id_39, h0_.image_verso_id AS image_verso_id_40, h0_.disponibilite_papier_id AS disponibilite_papier_id_41, h0_.disponibilite_numerique_id AS disponibilite_numerique_id_42, h0_.disponibilite_audio_id AS disponibilite_audio_id_43, h0_.editeur_id AS editeur_id_44, h0_.collection_id AS collection_id_45, h0_.sous_collection_id AS sous_collection_id_46, h0_.nature_id AS nature_id_47, h0_.type_couverture_id AS type_couverture_id_48 FROM har_ouvrage h0_ WHERE h0_.id IN (78324, 19666, 77717, 76148, 74008, 75862, 2895, 1461, 537, 13, 1830, 1, 8, 9, 10, 1046, 11, 12, 14, 6434, 16092, 74511, 6402, 16137, 17636, 23898, 74344, 4710, 74399, 74481, 73971, 57535, 16);

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 1;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 241;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 307;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 314;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 316;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 315;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 322;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 332;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 343;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 349;

SELECT
  t0.libelle AS libelle_1,
  t0.slug AS slug_2,
  t0.description AS description_3,
  t0.level AS level_4,
  t0.externe_id AS externe_id_5,
  t0.id AS id_6,
  t0.created AS created_7,
  t0.changed AS changed_8,
  t0.parent_id AS parent_id_9
FROM
  har_thematique t0
WHERE
  t0.id = ?

SELECT t0.libelle AS libelle_1, t0.slug AS slug_2, t0.description AS description_3, t0.level AS level_4, t0.externe_id AS externe_id_5, t0.id AS id_6, t0.created AS created_7, t0.changed AS changed_8, t0.parent_id AS parent_id_9 FROM har_thematique t0 WHERE t0.id = 388;