Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.slug = ?
  AND t0.parent_id IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.slug = 'documentation-en' AND t0.parent_id IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.slug = ?
  AND t0.parent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.slug = 'technology' AND t0.parent_id = 20 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.slug = ?
  AND t0.parent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.slug = 'articles' AND t0.parent_id = 44 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.slug = ?
  AND t0.parent_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.slug = 'create-article' AND t0.parent_id = 45 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created_at AS created_at_2,
  t0.modified_at AS modified_at_3,
  t0.modified_by AS modified_by_4,
  t0.content AS content_5,
  t6.id AS id_7,
  t6.entry_password AS entry_password_8,
  t6.content_id AS content_id_9,
  t6.structure_id AS structure_id_10
FROM
  content t0
  LEFT JOIN content_structure t6 ON t6.content_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.modified_at AS modified_at_3, t0.modified_by AS modified_by_4, t0.content AS content_5, t6.id AS id_7, t6.entry_password AS entry_password_8, t6.content_id AS content_id_9, t6.structure_id AS structure_id_10 FROM content t0 LEFT JOIN content_structure t6 ON t6.content_id = t0.id WHERE t0.id = 239;

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 20;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 26 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 26;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 27 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 27;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 260 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 260;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 284 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 284;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 287 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 287;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 288 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 288;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 427 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 427;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 285 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 285;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 294 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 294;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 625 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 625;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 485 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 485;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 605 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 605;

SELECT
  s0_.translation AS translation_0,
  s0_.entry_password AS entry_password_1
FROM
  structure_translation s0_
  INNER JOIN language l1_
  INNER JOIN structure s2_
WHERE
  l1_.id = s0_.language_id
  AND l1_.code = ?
  AND s0_.structure_id = ?
  AND s2_.slug <> ?

SELECT s0_.translation AS translation_0, s0_.entry_password AS entry_password_1 FROM structure_translation s0_ INNER JOIN language l1_ INNER JOIN structure s2_ WHERE l1_.id = s0_.language_id AND l1_.code = 'en' AND s0_.structure_id = 28 AND s2_.slug <> 'media';

SELECT
  t0.id AS id_1,
  t0.position AS position_2,
  t0.name AS name_3,
  t0.slug AS slug_4,
  t0.online_only AS online_only_5,
  t0.restricted_languages AS restricted_languages_6,
  t0.parent_id AS parent_id_7,
  t8.id AS id_9,
  t8.entry_password AS entry_password_10,
  t8.content_id AS content_id_11,
  t8.structure_id AS structure_id_12
FROM
  structure t0
  LEFT JOIN content_structure t8 ON t8.structure_id = t0.id
WHERE
  t0.parent_id = ?

SELECT t0.id AS id_1, t0.position AS position_2, t0.name AS name_3, t0.slug AS slug_4, t0.online_only AS online_only_5, t0.restricted_languages AS restricted_languages_6, t0.parent_id AS parent_id_7, t8.id AS id_9, t8.entry_password AS entry_password_10, t8.content_id AS content_id_11, t8.structure_id AS structure_id_12 FROM structure t0 LEFT JOIN content_structure t8 ON t8.structure_id = t0.id WHERE t0.parent_id = 28;