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 = 'settings' 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 = 'integrations' AND t0.parent_id = 97 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 = 'payment-terminal' AND t0.parent_id = 324 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 = 'softpos' AND t0.parent_id = 632 LIMIT 1;

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 = 'ch' AND s0_.structure_id = 666 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 = ?
ORDER BY
  t0.id ASC
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.parent_id = 666 ORDER BY t0.id ASC 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.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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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 = 'ch' 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;