Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_5
    FROM
      (
        SELECT
          a0_.retranscription AS retranscription_0,
          a0_.slug AS slug_1,
          a0_.text AS text_2,
          a0_.title AS title_3,
          a0_.enabled AS enabled_4,
          a0_.id AS id_5,
          a0_.list_position AS list_position_6,
          a0_.created_at AS created_at_7,
          a0_.updated_at AS updated_at_8
        FROM
          app_information_tool a0_
          INNER JOIN information_tool_format_information_tool i2_ ON a0_.id = i2_.information_tool_id
          INNER JOIN app_information_tool_format a1_ ON a1_.id = i2_.information_tool_format_id
          INNER JOIN information_tool_thema_information_tool i4_ ON a0_.id = i4_.information_tool_id
          INNER JOIN app_information_tool_thema a3_ ON a3_.id = i4_.information_tool_thema_id
        ORDER BY
          CASE WHEN a0_.list_position IS NULL THEN
            1
          ELSE
            0
          END ASC,
          a0_.list_position ASC,
          a0_.updated_at DESC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_5 FROM (SELECT a0_.retranscription AS retranscription_0, a0_.slug AS slug_1, a0_.text AS text_2, a0_.title AS title_3, a0_.enabled AS enabled_4, a0_.id AS id_5, a0_.list_position AS list_position_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8 FROM app_information_tool a0_ INNER JOIN information_tool_format_information_tool i2_ ON a0_.id = i2_.information_tool_id INNER JOIN app_information_tool_format a1_ ON a1_.id = i2_.information_tool_format_id INNER JOIN information_tool_thema_information_tool i4_ ON a0_.id = i4_.information_tool_id INNER JOIN app_information_tool_thema a3_ ON a3_.id = i4_.information_tool_thema_id ORDER BY CASE WHEN a0_.list_position IS NULL THEN 1 ELSE 0 END ASC, a0_.list_position ASC, a0_.updated_at DESC) dctrn_result) dctrn_table;

SELECT
  a0_.title AS title_0,
  a0_.slug AS slug_1
FROM
  app_information_tool_format a0_
WHERE
  a0_.enabled = ?

SELECT a0_.title AS title_0, a0_.slug AS slug_1 FROM app_information_tool_format a0_ WHERE a0_.enabled = 1;

SELECT
  a0_.title AS title_0,
  a0_.slug AS slug_1
FROM
  app_information_tool_thema a0_
WHERE
  a0_.enabled = ?

SELECT a0_.title AS title_0, a0_.slug AS slug_1 FROM app_information_tool_thema a0_ WHERE a0_.enabled = 1;

SELECT
  DISTINCT id_5
FROM
  (
    SELECT
      DISTINCT id_5,
      CASE WHEN list_position_6 IS NULL THEN
        1
      ELSE
        0
      END,
      list_position_6,
      updated_at_8
    FROM
      (
        SELECT
          a0_.retranscription AS retranscription_0,
          a0_.slug AS slug_1,
          a0_.text AS text_2,
          a0_.title AS title_3,
          a0_.enabled AS enabled_4,
          a0_.id AS id_5,
          a0_.list_position AS list_position_6,
          a0_.created_at AS created_at_7,
          a0_.updated_at AS updated_at_8
        FROM
          app_information_tool a0_
          INNER JOIN information_tool_format_information_tool i2_ ON a0_.id = i2_.information_tool_id
          INNER JOIN app_information_tool_format a1_ ON a1_.id = i2_.information_tool_format_id
          INNER JOIN information_tool_thema_information_tool i4_ ON a0_.id = i4_.information_tool_id
          INNER JOIN app_information_tool_thema a3_ ON a3_.id = i4_.information_tool_thema_id
      ) dctrn_result_inner
    ORDER BY
      CASE WHEN list_position_6 IS NULL THEN
        1
      ELSE
        0
      END ASC,
      list_position_6 ASC,
      updated_at_8 DESC
  ) dctrn_result
LIMIT
  12

SELECT DISTINCT id_5 FROM (SELECT DISTINCT id_5, CASE WHEN list_position_6 IS NULL THEN 1 ELSE 0 END, list_position_6, updated_at_8 FROM (SELECT a0_.retranscription AS retranscription_0, a0_.slug AS slug_1, a0_.text AS text_2, a0_.title AS title_3, a0_.enabled AS enabled_4, a0_.id AS id_5, a0_.list_position AS list_position_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8 FROM app_information_tool a0_ INNER JOIN information_tool_format_information_tool i2_ ON a0_.id = i2_.information_tool_id INNER JOIN app_information_tool_format a1_ ON a1_.id = i2_.information_tool_format_id INNER JOIN information_tool_thema_information_tool i4_ ON a0_.id = i4_.information_tool_id INNER JOIN app_information_tool_thema a3_ ON a3_.id = i4_.information_tool_thema_id) dctrn_result_inner ORDER BY CASE WHEN list_position_6 IS NULL THEN 1 ELSE 0 END ASC, list_position_6 ASC, updated_at_8 DESC) dctrn_result LIMIT 12;

SELECT
  a0_.retranscription AS retranscription_0,
  a0_.slug AS slug_1,
  a0_.text AS text_2,
  a0_.title AS title_3,
  a0_.enabled AS enabled_4,
  a0_.id AS id_5,
  a0_.list_position AS list_position_6,
  a0_.created_at AS created_at_7,
  a0_.updated_at AS updated_at_8,
  a0_.link_id AS link_id_9,
  a0_.media_id AS media_id_10
FROM
  app_information_tool a0_
  INNER JOIN information_tool_format_information_tool i2_ ON a0_.id = i2_.information_tool_id
  INNER JOIN app_information_tool_format a1_ ON a1_.id = i2_.information_tool_format_id
  INNER JOIN information_tool_thema_information_tool i4_ ON a0_.id = i4_.information_tool_id
  INNER JOIN app_information_tool_thema a3_ ON a3_.id = i4_.information_tool_thema_id
WHERE
  a0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
ORDER BY
  CASE WHEN a0_.list_position IS NULL THEN
    1
  ELSE
    0
  END ASC,
  a0_.list_position ASC,
  a0_.updated_at DESC

SELECT a0_.retranscription AS retranscription_0, a0_.slug AS slug_1, a0_.text AS text_2, a0_.title AS title_3, a0_.enabled AS enabled_4, a0_.id AS id_5, a0_.list_position AS list_position_6, a0_.created_at AS created_at_7, a0_.updated_at AS updated_at_8, a0_.link_id AS link_id_9, a0_.media_id AS media_id_10 FROM app_information_tool a0_ INNER JOIN information_tool_format_information_tool i2_ ON a0_.id = i2_.information_tool_id INNER JOIN app_information_tool_format a1_ ON a1_.id = i2_.information_tool_format_id INNER JOIN information_tool_thema_information_tool i4_ ON a0_.id = i4_.information_tool_id INNER JOIN app_information_tool_thema a3_ ON a3_.id = i4_.information_tool_thema_id WHERE a0_.id IN (7, 23, 22, 37, 38, 35, 28, 26, 39, 18, 17, 30) ORDER BY CASE WHEN a0_.list_position IS NULL THEN 1 ELSE 0 END ASC, a0_.list_position ASC, a0_.updated_at DESC;

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.id AS id_4
FROM
  app_information_tool_format t0
  INNER JOIN information_tool_format_information_tool ON t0.id = information_tool_format_information_tool.information_tool_format_id
WHERE
  information_tool_format_information_tool.information_tool_id = ?

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_information_tool_format t0 INNER JOIN information_tool_format_information_tool ON t0.id = information_tool_format_information_tool.information_tool_format_id WHERE information_tool_format_information_tool.information_tool_id = 7;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.changed AS changed_3,
  t0.idMediaTypes AS idMediaTypes_4,
  t0.idPreviewImage AS idPreviewImage_5,
  t0.idCollections AS idCollections_6,
  t0.idUsersCreator AS idUsersCreator_7,
  t0.idUsersChanger AS idUsersChanger_8
FROM
  me_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = 186;

SELECT
  t0.version AS version_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.changed AS changed_4,
  t0.idMedia AS idMedia_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  me_files t0
WHERE
  t0.idMedia = ?

SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = 186;

SELECT
  t0.name AS name_1,
  t0.version AS version_2,
  t0.subVersion AS subVersion_3,
  t0.size AS size_4,
  t0.downloadCounter AS downloadCounter_5,
  t0.storageOptions AS storageOptions_6,
  t0.mimeType AS mimeType_7,
  t0.properties AS properties_8,
  t0.focusPointX AS focusPointX_9,
  t0.focusPointY AS focusPointY_10,
  t0.id AS id_11,
  t0.created AS created_12,
  t0.changed AS changed_13,
  t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14,
  t0.idFiles AS idFiles_15,
  t0.idUsersCreator AS idUsersCreator_16,
  t0.idUsersChanger AS idUsersChanger_17
FROM
  me_file_versions t0
WHERE
  t0.idFiles = ?

SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = 186;

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.copyright AS copyright_3,
  t0.credits AS credits_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t0.idFileVersions AS idFileVersions_7
FROM
  me_file_version_meta t0
WHERE
  t0.idFileVersions = ?

SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = 229;

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.id AS id_4
FROM
  app_information_tool_thema t0
  INNER JOIN information_tool_thema_information_tool ON t0.id = information_tool_thema_information_tool.information_tool_thema_id
WHERE
  information_tool_thema_information_tool.information_tool_id = ?

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_information_tool_thema t0 INNER JOIN information_tool_thema_information_tool ON t0.id = information_tool_thema_information_tool.information_tool_thema_id WHERE information_tool_thema_information_tool.information_tool_id = 7;

SELECT
  t0.cta_label AS cta_label_1,
  t0.cta_link_anchor AS cta_link_anchor_2,
  t0.cta_link_href AS cta_link_href_3,
  t0.cta_link_locale AS cta_link_locale_4,
  t0.cta_link_provider AS cta_link_provider_5,
  t0.cta_link_query AS cta_link_query_6,
  t0.cta_link_rel AS cta_link_rel_7,
  t0.cta_link_target AS cta_link_target_8,
  t0.cta_link_alternative_title AS cta_link_alternative_title_9,
  t0.id AS id_10,
  t0.cta_link_media_href_id AS cta_link_media_href_id_11
FROM
  app_link t0
WHERE
  t0.id = ?

SELECT t0.cta_label AS cta_label_1, t0.cta_link_anchor AS cta_link_anchor_2, t0.cta_link_href AS cta_link_href_3, t0.cta_link_locale AS cta_link_locale_4, t0.cta_link_provider AS cta_link_provider_5, t0.cta_link_query AS cta_link_query_6, t0.cta_link_rel AS cta_link_rel_7, t0.cta_link_target AS cta_link_target_8, t0.cta_link_alternative_title AS cta_link_alternative_title_9, t0.id AS id_10, t0.cta_link_media_href_id AS cta_link_media_href_id_11 FROM app_link t0 WHERE t0.id = 73;

SELECT
  t0.slug AS slug_1,
  t0.title AS title_2,
  t0.enabled AS enabled_3,
  t0.id AS id_4
FROM
  app_information_tool_format t0
  INNER JOIN information_tool_format_information_tool ON t0.id = information_tool_format_information_tool.information_tool_format_id
WHERE
  information_tool_format_information_tool.information_tool_id = ?

SELECT t0.slug AS slug_1, t0.title AS title_2, t0.enabled AS enabled_3, t0.id AS id_4 FROM app_information_tool_format t0 INNER JOIN information_tool_format_information_tool ON t0.id = information_tool_format_information_tool.information_tool_format_id WHERE information_tool_format_information_tool.information_tool_id = 23;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.changed AS changed_3,
  t0.idMediaTypes AS idMediaTypes_4,
  t0.idPreviewImage AS idPreviewImage_5,
  t0.idCollections AS idCollections_6,
  t0.idUsersCreator AS idUsersCreator_7,
  t0.idUsersChanger AS idUsersChanger_8
FROM
  me_media t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created AS created_2, t0.changed AS changed_3, t0.idMediaTypes AS idMediaTypes_4, t0.idPreviewImage AS idPreviewImage_5, t0.idCollections AS idCollections_6, t0.idUsersCreator AS idUsersCreator_7, t0.idUsersChanger AS idUsersChanger_8 FROM me_media t0 WHERE t0.id = 140;

SELECT
  t0.version AS version_1,
  t0.id AS id_2,
  t0.created AS created_3,
  t0.changed AS changed_4,
  t0.idMedia AS idMedia_5,
  t0.idUsersCreator AS idUsersCreator_6,
  t0.idUsersChanger AS idUsersChanger_7
FROM
  me_files t0
WHERE
  t0.idMedia = ?

SELECT t0.version AS version_1, t0.id AS id_2, t0.created AS created_3, t0.changed AS changed_4, t0.idMedia AS idMedia_5, t0.idUsersCreator AS idUsersCreator_6, t0.idUsersChanger AS idUsersChanger_7 FROM me_files t0 WHERE t0.idMedia = 140;

SELECT
  t0.name AS name_1,
  t0.version AS version_2,
  t0.subVersion AS subVersion_3,
  t0.size AS size_4,
  t0.downloadCounter AS downloadCounter_5,
  t0.storageOptions AS storageOptions_6,
  t0.mimeType AS mimeType_7,
  t0.properties AS properties_8,
  t0.focusPointX AS focusPointX_9,
  t0.focusPointY AS focusPointY_10,
  t0.id AS id_11,
  t0.created AS created_12,
  t0.changed AS changed_13,
  t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14,
  t0.idFiles AS idFiles_15,
  t0.idUsersCreator AS idUsersCreator_16,
  t0.idUsersChanger AS idUsersChanger_17
FROM
  me_file_versions t0
WHERE
  t0.idFiles = ?

SELECT t0.name AS name_1, t0.version AS version_2, t0.subVersion AS subVersion_3, t0.size AS size_4, t0.downloadCounter AS downloadCounter_5, t0.storageOptions AS storageOptions_6, t0.mimeType AS mimeType_7, t0.properties AS properties_8, t0.focusPointX AS focusPointX_9, t0.focusPointY AS focusPointY_10, t0.id AS id_11, t0.created AS created_12, t0.changed AS changed_13, t0.idFileVersionsMetaDefault AS idFileVersionsMetaDefault_14, t0.idFiles AS idFiles_15, t0.idUsersCreator AS idUsersCreator_16, t0.idUsersChanger AS idUsersChanger_17 FROM me_file_versions t0 WHERE t0.idFiles = 140;

SELECT
  t0.title AS title_1,
  t0.description AS description_2,
  t0.copyright AS copyright_3,
  t0.credits AS credits_4,
  t0.locale AS locale_5,
  t0.id AS id_6,
  t0.idFileVersions AS idFileVersions_7
FROM
  me_file_version_meta t0
WHERE
  t0.idFileVersions = ?

SELECT t0.title AS title_1, t0.description AS description_2, t0.copyright AS copyright_3, t0.credits AS credits_4, t0.locale AS locale_5, t0.id AS id_6, t0.idFileVersions AS idFileVersions_7 FROM me_file_version_meta t0 WHERE t0.idFileVersions = 183;