Symfony Profiler

SELECT
  c0_.permalink AS permalink_0,
  c1_.type AS type_1
FROM
  cms_content_entry c1_
  LEFT JOIN cms_content_entry_revision c2_ ON c1_.published_revision_id = c2_.id
  LEFT JOIN cms_content_entry_revision_translation c0_ ON c2_.id = c0_.content_entry_revision_id
WHERE
  c0_.locale = ?
  AND c1_.id = ?

SELECT c0_.permalink AS permalink_0, c1_.type AS type_1 FROM cms_content_entry c1_ LEFT JOIN cms_content_entry_revision c2_ ON c1_.published_revision_id = c2_.id LEFT JOIN cms_content_entry_revision_translation c0_ ON c2_.id = c0_.content_entry_revision_id WHERE c0_.locale = 'en' AND c1_.id = 4;

SELECT
  c0_.id AS id_0,
  c1_.`values` AS values_1
FROM
  cms_custom_content_entry_revision c1_
  LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id
WHERE
  c0_.id IN (?)

SELECT c0_.id AS id_0, c1_.`values` AS values_1 FROM cms_custom_content_entry_revision c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (627);

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  cms_content_entry_revision c0_
  LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id
  LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id
WHERE
  c0_.is_published_revision = 1
  AND c1_.type = ?
  AND c2_.locale = ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cms_content_entry_revision c0_ LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id WHERE c0_.is_published_revision = 1 AND c1_.type = 'cms.custom_content_type.1' AND c2_.locale = 'nl';

SELECT
  c0_.id AS id_0,
  c0_.is_published_revision AS is_published_revision_1,
  c0_.time_created AS time_created_2,
  c0_.autosave AS autosave_3,
  c1_.id AS id_4,
  c1_.type AS type_5,
  c1_.sort_order AS sort_order_6,
  c1_.depth AS depth_7,
  c1_.`left` AS left_8,
  c1_.`right` AS right_9,
  c1_.is_deleted AS is_deleted_10,
  c1_.restrict_sites AS restrict_sites_11,
  c1_.time_created AS time_created_12,
  c1_.time_published AS time_published_13,
  c1_.time_deleted AS time_deleted_14,
  c0_.content_entry_id AS content_entry_id_15,
  c0_.author_id AS author_id_16,
  c1_.published_revision_id AS published_revision_id_17,
  c1_.draft_revision_id AS draft_revision_id_18,
  c1_.parent_id AS parent_id_19
FROM
  cms_content_entry_revision c0_
  LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id
  LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id
WHERE
  c0_.is_published_revision = 1
  AND c1_.type = ?
  AND c2_.locale = ?
ORDER BY
  c1_.`left` ASC,
  c1_.sort_order ASC

SELECT c0_.id AS id_0, c0_.is_published_revision AS is_published_revision_1, c0_.time_created AS time_created_2, c0_.autosave AS autosave_3, c1_.id AS id_4, c1_.type AS type_5, c1_.sort_order AS sort_order_6, c1_.depth AS depth_7, c1_.`left` AS left_8, c1_.`right` AS right_9, c1_.is_deleted AS is_deleted_10, c1_.restrict_sites AS restrict_sites_11, c1_.time_created AS time_created_12, c1_.time_published AS time_published_13, c1_.time_deleted AS time_deleted_14, c0_.content_entry_id AS content_entry_id_15, c0_.author_id AS author_id_16, c1_.published_revision_id AS published_revision_id_17, c1_.draft_revision_id AS draft_revision_id_18, c1_.parent_id AS parent_id_19 FROM cms_content_entry_revision c0_ LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id WHERE c0_.is_published_revision = 1 AND c1_.type = 'cms.custom_content_type.1' AND c2_.locale = 'nl' ORDER BY c1_.`left` ASC, c1_.sort_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.locale AS locale_1,
  c0_.name AS name_2,
  c0_.permalink AS permalink_3,
  c0_.search_text AS search_text_4,
  c1_.id AS id_5,
  c2_.id AS id_6,
  c0_.content_entry_revision_id AS content_entry_revision_id_7
FROM
  cms_content_entry_revision_translation c0_
  LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id
  LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id
WHERE
  c0_.content_entry_revision_id IN (?, ?, ?, ?)
  AND c0_.locale = ?

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.name AS name_2, c0_.permalink AS permalink_3, c0_.search_text AS search_text_4, c1_.id AS id_5, c2_.id AS id_6, c0_.content_entry_revision_id AS content_entry_revision_id_7 FROM cms_content_entry_revision_translation c0_ LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id WHERE c0_.content_entry_revision_id IN (650, 626, 627, 631) AND c0_.locale = 'nl';

SELECT
  c0_.id AS id_0,
  c1_.`values` AS values_1
FROM
  cms_custom_content_entry_revision c1_
  LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id
WHERE
  c0_.id IN (?, ?, ?)

SELECT c0_.id AS id_0, c1_.`values` AS values_1 FROM cms_custom_content_entry_revision c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (650, 626, 631);

SELECT
  t0.id AS id_1,
  t0.storage AS storage_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.type AS type_7,
  t0.time_uploaded AS time_uploaded_8,
  t0.public_storage AS public_storage_9,
  t0.public_storage_identifier AS public_storage_identifier_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.derivatives AS derivatives_13,
  t0.enqueued_derivatives AS enqueued_derivatives_14,
  t0.folder_id AS folder_id_15
FROM
  cms_upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = 3;

SELECT
  t0.id AS id_1,
  t0.storage AS storage_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.type AS type_7,
  t0.time_uploaded AS time_uploaded_8,
  t0.public_storage AS public_storage_9,
  t0.public_storage_identifier AS public_storage_identifier_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.derivatives AS derivatives_13,
  t0.enqueued_derivatives AS enqueued_derivatives_14,
  t0.folder_id AS folder_id_15
FROM
  cms_upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = 6;

SELECT
  t0.id AS id_1,
  t0.storage AS storage_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.type AS type_7,
  t0.time_uploaded AS time_uploaded_8,
  t0.public_storage AS public_storage_9,
  t0.public_storage_identifier AS public_storage_identifier_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.derivatives AS derivatives_13,
  t0.enqueued_derivatives AS enqueued_derivatives_14,
  t0.folder_id AS folder_id_15
FROM
  cms_upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = 5;

SELECT
  t0.id AS id_1,
  t0.storage AS storage_2,
  t0.storage_identifier AS storage_identifier_3,
  t0.public_name AS public_name_4,
  t0.size AS size_5,
  t0.mime_type AS mime_type_6,
  t0.type AS type_7,
  t0.time_uploaded AS time_uploaded_8,
  t0.public_storage AS public_storage_9,
  t0.public_storage_identifier AS public_storage_identifier_10,
  t0.width AS width_11,
  t0.height AS height_12,
  t0.derivatives AS derivatives_13,
  t0.enqueued_derivatives AS enqueued_derivatives_14,
  t0.folder_id AS folder_id_15
FROM
  cms_upload t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.storage AS storage_2, t0.storage_identifier AS storage_identifier_3, t0.public_name AS public_name_4, t0.size AS size_5, t0.mime_type AS mime_type_6, t0.type AS type_7, t0.time_uploaded AS time_uploaded_8, t0.public_storage AS public_storage_9, t0.public_storage_identifier AS public_storage_identifier_10, t0.width AS width_11, t0.height AS height_12, t0.derivatives AS derivatives_13, t0.enqueued_derivatives AS enqueued_derivatives_14, t0.folder_id AS folder_id_15 FROM cms_upload t0 WHERE t0.id = 4;

SELECT
  COUNT(DISTINCT c0_.id) AS sclr_0
FROM
  cms_content_entry_revision c0_
  LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id
  LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id
WHERE
  c0_.is_published_revision = 1
  AND c1_.type = ?
  AND c2_.locale = ?
  AND c1_.parent_id = ?

SELECT COUNT(DISTINCT c0_.id) AS sclr_0 FROM cms_content_entry_revision c0_ LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id WHERE c0_.is_published_revision = 1 AND c1_.type = 'cms.custom_content_type.2' AND c2_.locale = 'nl' AND c1_.parent_id = 4;

SELECT
  c0_.id AS id_0,
  c0_.is_published_revision AS is_published_revision_1,
  c0_.time_created AS time_created_2,
  c0_.autosave AS autosave_3,
  c1_.id AS id_4,
  c1_.type AS type_5,
  c1_.sort_order AS sort_order_6,
  c1_.depth AS depth_7,
  c1_.`left` AS left_8,
  c1_.`right` AS right_9,
  c1_.is_deleted AS is_deleted_10,
  c1_.restrict_sites AS restrict_sites_11,
  c1_.time_created AS time_created_12,
  c1_.time_published AS time_published_13,
  c1_.time_deleted AS time_deleted_14,
  c0_.content_entry_id AS content_entry_id_15,
  c0_.author_id AS author_id_16,
  c1_.published_revision_id AS published_revision_id_17,
  c1_.draft_revision_id AS draft_revision_id_18,
  c1_.parent_id AS parent_id_19
FROM
  cms_content_entry_revision c0_
  LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id
  LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id
WHERE
  c0_.is_published_revision = 1
  AND c1_.type = ?
  AND c2_.locale = ?
  AND c1_.parent_id = ?
ORDER BY
  c1_.`left` ASC,
  c1_.sort_order ASC

SELECT c0_.id AS id_0, c0_.is_published_revision AS is_published_revision_1, c0_.time_created AS time_created_2, c0_.autosave AS autosave_3, c1_.id AS id_4, c1_.type AS type_5, c1_.sort_order AS sort_order_6, c1_.depth AS depth_7, c1_.`left` AS left_8, c1_.`right` AS right_9, c1_.is_deleted AS is_deleted_10, c1_.restrict_sites AS restrict_sites_11, c1_.time_created AS time_created_12, c1_.time_published AS time_published_13, c1_.time_deleted AS time_deleted_14, c0_.content_entry_id AS content_entry_id_15, c0_.author_id AS author_id_16, c1_.published_revision_id AS published_revision_id_17, c1_.draft_revision_id AS draft_revision_id_18, c1_.parent_id AS parent_id_19 FROM cms_content_entry_revision c0_ LEFT JOIN cms_content_entry c1_ ON c0_.content_entry_id = c1_.id LEFT JOIN cms_content_entry_revision_translation c2_ ON c0_.id = c2_.content_entry_revision_id WHERE c0_.is_published_revision = 1 AND c1_.type = 'cms.custom_content_type.2' AND c2_.locale = 'nl' AND c1_.parent_id = 4 ORDER BY c1_.`left` ASC, c1_.sort_order ASC;

SELECT
  c0_.id AS id_0,
  c0_.locale AS locale_1,
  c0_.name AS name_2,
  c0_.permalink AS permalink_3,
  c0_.search_text AS search_text_4,
  c1_.id AS id_5,
  c2_.id AS id_6,
  c0_.content_entry_revision_id AS content_entry_revision_id_7
FROM
  cms_content_entry_revision_translation c0_
  LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id
  LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id
WHERE
  c0_.content_entry_revision_id IN (?, ?)
  AND c0_.locale = ?

SELECT c0_.id AS id_0, c0_.locale AS locale_1, c0_.name AS name_2, c0_.permalink AS permalink_3, c0_.search_text AS search_text_4, c1_.id AS id_5, c2_.id AS id_6, c0_.content_entry_revision_id AS content_entry_revision_id_7 FROM cms_content_entry_revision_translation c0_ LEFT JOIN cms_content_entry_revision c1_ ON c0_.content_entry_revision_id = c1_.id LEFT JOIN cms_content_entry c2_ ON c1_.content_entry_id = c2_.id WHERE c0_.content_entry_revision_id IN (671, 670) AND c0_.locale = 'nl';

SELECT
  c0_.id AS id_0,
  c1_.`values` AS values_1
FROM
  cms_custom_content_entry_revision c1_
  LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id
WHERE
  c0_.id IN (?, ?)

SELECT c0_.id AS id_0, c1_.`values` AS values_1 FROM cms_custom_content_entry_revision c1_ LEFT JOIN cms_content_entry_revision c0_ ON c1_.content_entry_revision_id = c0_.id WHERE c0_.id IN (671, 670);

SELECT
  t0.id AS id_1,
  t0.type AS type_2,
  t0.sort_order AS sort_order_3,
  t0.depth AS depth_4,
  t0.`left` AS left_5,
  t0.`right` AS right_6,
  t0.is_deleted AS is_deleted_7,
  t0.restrict_sites AS restrict_sites_8,
  t0.time_created AS time_created_9,
  t0.time_published AS time_published_10,
  t0.time_deleted AS time_deleted_11,
  t0.published_revision_id AS published_revision_id_12,
  t0.draft_revision_id AS draft_revision_id_13,
  t0.parent_id AS parent_id_14
FROM
  cms_content_entry t0
WHERE
  t0.id = ?