Symfony Profiler

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.status AS status_3,
  t0.emailsDisplay AS emailsDisplay_4,
  t0.policy AS policy_5,
  t0.disqusId AS disqusId_6,
  t0.googleToken AS googleToken_7,
  t0.stage AS stage_8,
  t0.teamworkTasklist AS teamworkTasklist_9,
  t0.latitude AS latitude_10,
  t0.longitude AS longitude_11,
  t0.redirects AS redirects_12,
  t0.redirectCodes AS redirectCodes_13,
  t0.debugging AS debugging_14,
  t0.products AS products_15,
  t0.hubspotId AS hubspotId_16,
  t0.weglotId AS weglotId_17,
  t0.id AS id_18,
  t0.uid AS uid_19,
  t0.createdAt AS createdAt_20,
  t0.updatedAt AS updatedAt_21,
  t0.touchedAt AS touchedAt_22,
  t0.data_custom0 AS data_custom0_23,
  t0.data_custom1 AS data_custom1_24,
  t0.data_custom2 AS data_custom2_25,
  t0.data_custom3 AS data_custom3_26,
  t0.authenticationTypes AS authenticationTypes_27,
  t0.classlinkCustomerId AS classlinkCustomerId_28,
  t0.cleverCustomerId AS cleverCustomerId_29,
  t0.gg4lCustomerId AS gg4lCustomerId_30,
  t0.googleCustomerId AS googleCustomerId_31,
  t0.microsoftCustomerId AS microsoftCustomerId_32,
  t0.ulid AS ulid_33,
  t0.locale_timezone AS locale_timezone_34,
  t0.ada_reportsFolder AS ada_reportsFolder_35,
  t0.ada_reportsPrimary AS ada_reportsPrimary_36,
  t0.ada_reportsDocuments AS ada_reportsDocuments_37,
  t0.type_primary AS type_primary_38,
  t0.type_secondary AS type_secondary_39
FROM
  cms__tenant__tenant t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.status AS status_3, t0.emailsDisplay AS emailsDisplay_4, t0.policy AS policy_5, t0.disqusId AS disqusId_6, t0.googleToken AS googleToken_7, t0.stage AS stage_8, t0.teamworkTasklist AS teamworkTasklist_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.redirects AS redirects_12, t0.redirectCodes AS redirectCodes_13, t0.debugging AS debugging_14, t0.products AS products_15, t0.hubspotId AS hubspotId_16, t0.weglotId AS weglotId_17, t0.id AS id_18, t0.uid AS uid_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.touchedAt AS touchedAt_22, t0.data_custom0 AS data_custom0_23, t0.data_custom1 AS data_custom1_24, t0.data_custom2 AS data_custom2_25, t0.data_custom3 AS data_custom3_26, t0.authenticationTypes AS authenticationTypes_27, t0.classlinkCustomerId AS classlinkCustomerId_28, t0.cleverCustomerId AS cleverCustomerId_29, t0.gg4lCustomerId AS gg4lCustomerId_30, t0.googleCustomerId AS googleCustomerId_31, t0.microsoftCustomerId AS microsoftCustomerId_32, t0.ulid AS ulid_33, t0.locale_timezone AS locale_timezone_34, t0.ada_reportsFolder AS ada_reportsFolder_35, t0.ada_reportsPrimary AS ada_reportsPrimary_36, t0.ada_reportsDocuments AS ada_reportsDocuments_37, t0.type_primary AS type_primary_38, t0.type_secondary AS type_secondary_39 FROM cms__tenant__tenant t0 WHERE t0.slug = 'staging' LIMIT 1;

SELECT
  t0.email AS email_1,
  t0.active AS active_2,
  t0.policyAcceptedOn AS policyAcceptedOn_3,
  t0.termsAcceptedOn AS termsAcceptedOn_4,
  t0.password AS password_5,
  t0.passwordChangedAt AS passwordChangedAt_6,
  t0.lastLoggedInAt AS lastLoggedInAt_7,
  t0.metadata AS metadata_8,
  t0.internalUid AS internalUid_9,
  t0.id AS id_10,
  t0.uid AS uid_11,
  t0.createdAt AS createdAt_12,
  t0.updatedAt AS updatedAt_13,
  t0.touchedAt AS touchedAt_14,
  t0.onerosterId AS onerosterId_15,
  t0.onerosterArchived AS onerosterArchived_16,
  t0.importIndex AS importIndex_17,
  t0.specialPermissions_superUser AS specialPermissions_superUser_18,
  t0.systemProfile_displayName AS systemProfile_displayName_19,
  t0.systemProfile_firstName AS systemProfile_firstName_20,
  t0.systemProfile_lastName AS systemProfile_lastName_21,
  t0.systemProfile_avatar AS systemProfile_avatar_22,
  t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23,
  t0.tenant AS tenant_24,
  t0.createdBy AS createdBy_25,
  t0.updatedBy AS updatedBy_26,
  t0.touchedBy AS touchedBy_27,
  t0.import AS import_28
FROM
  cms__security__identity__account t0
WHERE
  t0.id = ?
  AND (
    (t0.tenant = 1)
  )

SELECT t0.email AS email_1, t0.active AS active_2, t0.policyAcceptedOn AS policyAcceptedOn_3, t0.termsAcceptedOn AS termsAcceptedOn_4, t0.password AS password_5, t0.passwordChangedAt AS passwordChangedAt_6, t0.lastLoggedInAt AS lastLoggedInAt_7, t0.metadata AS metadata_8, t0.internalUid AS internalUid_9, t0.id AS id_10, t0.uid AS uid_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.onerosterId AS onerosterId_15, t0.onerosterArchived AS onerosterArchived_16, t0.importIndex AS importIndex_17, t0.specialPermissions_superUser AS specialPermissions_superUser_18, t0.systemProfile_displayName AS systemProfile_displayName_19, t0.systemProfile_firstName AS systemProfile_firstName_20, t0.systemProfile_lastName AS systemProfile_lastName_21, t0.systemProfile_avatar AS systemProfile_avatar_22, t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_23, t0.tenant AS tenant_24, t0.createdBy AS createdBy_25, t0.updatedBy AS updatedBy_26, t0.touchedBy AS touchedBy_27, t0.import AS import_28 FROM cms__security__identity__account t0 WHERE t0.id = '1' AND ((t0.tenant = 1));

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.hidden AS hidden_3,
  t0.color AS color_4,
  t0.code AS code_5,
  t0.schoolNowMigrated AS schoolNowMigrated_6,
  t0.id AS id_7,
  t0.uid AS uid_8,
  t0.createdAt AS createdAt_9,
  t0.updatedAt AS updatedAt_10,
  t0.touchedAt AS touchedAt_11,
  t0.rt AS rt_12,
  t0.lvl AS lvl_13,
  t0.lft AS lft_14,
  t0.rgt AS rgt_15,
  t0.navigation AS navigation_16,
  t0.moduleFlags_alert AS moduleFlags_alert_17,
  t0.moduleFlags_blog AS moduleFlags_blog_18,
  t0.moduleFlags_calendar AS moduleFlags_calendar_19,
  t0.moduleFlags_gallery AS moduleFlags_gallery_20,
  t0.moduleFlags_news AS moduleFlags_news_21,
  t0.moduleFlags_page AS moduleFlags_page_22,
  t0.moduleFlags_people AS moduleFlags_people_23,
  t0.moduleFlags_question AS moduleFlags_question_24,
  t0.moduleFlags_snippet AS moduleFlags_snippet_25,
  t0.moduleFlags_feed AS moduleFlags_feed_26,
  t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27,
  t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28,
  t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29,
  t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30,
  t0.parent AS parent_31,
  t0.domain AS domain_32,
  t0.tenant AS tenant_33,
  t0.createdBy AS createdBy_34,
  t0.updatedBy AS updatedBy_35,
  t0.touchedBy AS touchedBy_36,
  t0.defaultTheme AS defaultTheme_37,
  t0.defaultOuterLayout AS defaultOuterLayout_38,
  t0.defaultInnerLayout AS defaultInnerLayout_39,
  t0._discr,
  t0.preferred AS preferred_40,
  t0.importIndex AS importIndex_41,
  t0.account AS account_42,
  t0.container AS container_43,
  t0.import AS import_44,
  t0.feedSetting_blog AS feedSetting_blog_45,
  t0.feedSetting_calendar AS feedSetting_calendar_46,
  t0.feedSetting_news AS feedSetting_news_47,
  t0.feedSetting_alert AS feedSetting_alert_48,
  t0.preferred AS preferred_49
FROM
  cms__container__container t0
WHERE
  t0.id = ?
  AND t0._discr IN (
    'generic', 'personal', 'intranet',
    'storage'
  )
  AND (
    (t0.tenant = 1)
  )

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.hidden AS hidden_3, t0.color AS color_4, t0.code AS code_5, t0.schoolNowMigrated AS schoolNowMigrated_6, t0.id AS id_7, t0.uid AS uid_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.touchedAt AS touchedAt_11, t0.rt AS rt_12, t0.lvl AS lvl_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.navigation AS navigation_16, t0.moduleFlags_alert AS moduleFlags_alert_17, t0.moduleFlags_blog AS moduleFlags_blog_18, t0.moduleFlags_calendar AS moduleFlags_calendar_19, t0.moduleFlags_gallery AS moduleFlags_gallery_20, t0.moduleFlags_news AS moduleFlags_news_21, t0.moduleFlags_page AS moduleFlags_page_22, t0.moduleFlags_people AS moduleFlags_people_23, t0.moduleFlags_question AS moduleFlags_question_24, t0.moduleFlags_snippet AS moduleFlags_snippet_25, t0.moduleFlags_feed AS moduleFlags_feed_26, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30, t0.parent AS parent_31, t0.domain AS domain_32, t0.tenant AS tenant_33, t0.createdBy AS createdBy_34, t0.updatedBy AS updatedBy_35, t0.touchedBy AS touchedBy_36, t0.defaultTheme AS defaultTheme_37, t0.defaultOuterLayout AS defaultOuterLayout_38, t0.defaultInnerLayout AS defaultInnerLayout_39, t0._discr, t0.preferred AS preferred_40, t0.importIndex AS importIndex_41, t0.account AS account_42, t0.container AS container_43, t0.import AS import_44, t0.feedSetting_blog AS feedSetting_blog_45, t0.feedSetting_calendar AS feedSetting_calendar_46, t0.feedSetting_news AS feedSetting_news_47, t0.feedSetting_alert AS feedSetting_alert_48, t0.preferred AS preferred_49 FROM cms__container__container t0 WHERE t0.id = '149' AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1));

SELECT
  t0.name AS name_1,
  t0.slug AS slug_2,
  t0.hidden AS hidden_3,
  t0.color AS color_4,
  t0.code AS code_5,
  t0.schoolNowMigrated AS schoolNowMigrated_6,
  t0.id AS id_7,
  t0.uid AS uid_8,
  t0.createdAt AS createdAt_9,
  t0.updatedAt AS updatedAt_10,
  t0.touchedAt AS touchedAt_11,
  t0.rt AS rt_12,
  t0.lvl AS lvl_13,
  t0.lft AS lft_14,
  t0.rgt AS rgt_15,
  t0.navigation AS navigation_16,
  t0.moduleFlags_alert AS moduleFlags_alert_17,
  t0.moduleFlags_blog AS moduleFlags_blog_18,
  t0.moduleFlags_calendar AS moduleFlags_calendar_19,
  t0.moduleFlags_gallery AS moduleFlags_gallery_20,
  t0.moduleFlags_news AS moduleFlags_news_21,
  t0.moduleFlags_page AS moduleFlags_page_22,
  t0.moduleFlags_people AS moduleFlags_people_23,
  t0.moduleFlags_question AS moduleFlags_question_24,
  t0.moduleFlags_snippet AS moduleFlags_snippet_25,
  t0.moduleFlags_feed AS moduleFlags_feed_26,
  t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27,
  t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28,
  t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29,
  t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30,
  t0.preferred AS preferred_31,
  t0.parent AS parent_32,
  t0.domain AS domain_33,
  t0.tenant AS tenant_34,
  t0.createdBy AS createdBy_35,
  t0.updatedBy AS updatedBy_36,
  t0.touchedBy AS touchedBy_37,
  t0.defaultTheme AS defaultTheme_38,
  t0.defaultOuterLayout AS defaultOuterLayout_39,
  t0.defaultInnerLayout AS defaultInnerLayout_40,
  t0._discr
FROM
  cms__container__container t0
WHERE
  t0._discr IN ('generic')
  AND (
    (t0.tenant = 1)
  )
ORDER BY
  t0.rt ASC,
  t0.lft ASC,
  t0.name ASC

SELECT t0.name AS name_1, t0.slug AS slug_2, t0.hidden AS hidden_3, t0.color AS color_4, t0.code AS code_5, t0.schoolNowMigrated AS schoolNowMigrated_6, t0.id AS id_7, t0.uid AS uid_8, t0.createdAt AS createdAt_9, t0.updatedAt AS updatedAt_10, t0.touchedAt AS touchedAt_11, t0.rt AS rt_12, t0.lvl AS lvl_13, t0.lft AS lft_14, t0.rgt AS rgt_15, t0.navigation AS navigation_16, t0.moduleFlags_alert AS moduleFlags_alert_17, t0.moduleFlags_blog AS moduleFlags_blog_18, t0.moduleFlags_calendar AS moduleFlags_calendar_19, t0.moduleFlags_gallery AS moduleFlags_gallery_20, t0.moduleFlags_news AS moduleFlags_news_21, t0.moduleFlags_page AS moduleFlags_page_22, t0.moduleFlags_people AS moduleFlags_people_23, t0.moduleFlags_question AS moduleFlags_question_24, t0.moduleFlags_snippet AS moduleFlags_snippet_25, t0.moduleFlags_feed AS moduleFlags_feed_26, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_27, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_28, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_29, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_30, t0.preferred AS preferred_31, t0.parent AS parent_32, t0.domain AS domain_33, t0.tenant AS tenant_34, t0.createdBy AS createdBy_35, t0.updatedBy AS updatedBy_36, t0.touchedBy AS touchedBy_37, t0.defaultTheme AS defaultTheme_38, t0.defaultOuterLayout AS defaultOuterLayout_39, t0.defaultInnerLayout AS defaultInnerLayout_40, t0._discr FROM cms__container__container t0 WHERE t0._discr IN ('generic') AND ((t0.tenant = 1)) ORDER BY t0.rt ASC, t0.lft ASC, t0.name ASC;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.uid AS uid_3,
  t0.createdAt AS createdAt_4,
  t0.updatedAt AS updatedAt_5,
  t0.touchedAt AS touchedAt_6,
  t0.rt AS rt_7,
  t0.lvl AS lvl_8,
  t0.lft AS lft_9,
  t0.rgt AS rgt_10,
  t0.description AS description_11,
  t0.parent AS parent_12,
  t0.container AS container_13,
  t0.tenant AS tenant_14,
  t0.createdBy AS createdBy_15,
  t0.updatedBy AS updatedBy_16,
  t0.touchedBy AS touchedBy_17,
  t0._discr
FROM
  cms__file__node t0
WHERE
  t0.id = ?
  AND t0._discr IN ('folder')
  AND (
    (t0.tenant = 1)
  )

SELECT t0.name AS name_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.rt AS rt_7, t0.lvl AS lvl_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.description AS description_11, t0.parent AS parent_12, t0.container AS container_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr FROM cms__file__node t0 WHERE t0.id = '756' AND t0._discr IN ('folder') AND ((t0.tenant = 1));

SELECT
  c0_.name AS name_0,
  c0_.id AS id_1,
  c0_.uid AS uid_2,
  c0_.createdAt AS createdAt_3,
  c0_.updatedAt AS updatedAt_4,
  c0_.touchedAt AS touchedAt_5,
  c0_.rt AS rt_6,
  c0_.lvl AS lvl_7,
  c0_.lft AS lft_8,
  c0_.rgt AS rgt_9,
  c0_.description AS description_10,
  c0_._discr AS _discr_11,
  c0_.parent AS parent_12,
  c0_.container AS container_13,
  c0_.tenant AS tenant_14,
  c0_.createdBy AS createdBy_15,
  c0_.updatedBy AS updatedBy_16,
  c0_.touchedBy AS touchedBy_17
FROM
  cms__file__node c0_
WHERE
  (
    (
      c0_.rt = ?
      AND c0_.lft < ?
      AND c0_.rgt > ?
      AND c0_.container IS NOT NULL
    )
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('folder')
ORDER BY
  c0_.lvl ASC

SELECT c0_.name AS name_0, c0_.id AS id_1, c0_.uid AS uid_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4, c0_.touchedAt AS touchedAt_5, c0_.rt AS rt_6, c0_.lvl AS lvl_7, c0_.lft AS lft_8, c0_.rgt AS rgt_9, c0_.description AS description_10, c0_._discr AS _discr_11, c0_.parent AS parent_12, c0_.container AS container_13, c0_.tenant AS tenant_14, c0_.createdBy AS createdBy_15, c0_.updatedBy AS updatedBy_16, c0_.touchedBy AS touchedBy_17 FROM cms__file__node c0_ WHERE ((c0_.rt = 756 AND c0_.lft < 1 AND c0_.rgt > 46 AND c0_.container IS NOT NULL) AND (c0_.tenant = 1)) AND c0_._discr IN ('folder') ORDER BY c0_.lvl ASC;

SELECT
  c0_.name AS name_0,
  c0_.id AS id_1,
  c0_.uid AS uid_2,
  c0_.createdAt AS createdAt_3,
  c0_.updatedAt AS updatedAt_4,
  c0_.touchedAt AS touchedAt_5,
  c0_.rt AS rt_6,
  c0_.lvl AS lvl_7,
  c0_.lft AS lft_8,
  c0_.rgt AS rgt_9,
  c0_.description AS description_10,
  CASE WHEN c0_._discr IN ('folder') THEN
    0
  ELSE
    1
  END AS sclr_11,
  c0_._discr AS _discr_12,
  c0_.parent AS parent_13,
  c0_.container AS container_14,
  c0_.tenant AS tenant_15,
  c0_.createdBy AS createdBy_16,
  c0_.updatedBy AS updatedBy_17,
  c0_.touchedBy AS touchedBy_18
FROM
  cms__file__node c0_
WHERE
  (
    (
      c0_.parent = ?
      AND c0_.container IS NOT NULL
    )
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('folder')
ORDER BY
  sclr_11 ASC,
  c0_.name ASC

SELECT c0_.name AS name_0, c0_.id AS id_1, c0_.uid AS uid_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4, c0_.touchedAt AS touchedAt_5, c0_.rt AS rt_6, c0_.lvl AS lvl_7, c0_.lft AS lft_8, c0_.rgt AS rgt_9, c0_.description AS description_10, CASE WHEN c0_._discr IN ('folder') THEN 0 ELSE 1 END AS sclr_11, c0_._discr AS _discr_12, c0_.parent AS parent_13, c0_.container AS container_14, c0_.tenant AS tenant_15, c0_.createdBy AS createdBy_16, c0_.updatedBy AS updatedBy_17, c0_.touchedBy AS touchedBy_18 FROM cms__file__node c0_ WHERE ((c0_.parent = 756 AND c0_.container IS NOT NULL) AND (c0_.tenant = 1)) AND c0_._discr IN ('folder') ORDER BY sclr_11 ASC, c0_.name ASC;

SELECT
  t0.name AS name_1,
  t0.id AS id_2,
  t0.uid AS uid_3,
  t0.createdAt AS createdAt_4,
  t0.updatedAt AS updatedAt_5,
  t0.touchedAt AS touchedAt_6,
  t0.rt AS rt_7,
  t0.lvl AS lvl_8,
  t0.lft AS lft_9,
  t0.rgt AS rgt_10,
  t0.status AS status_11,
  t0.extension AS extension_12,
  t0.mime AS mime_13,
  t0.description AS description_14,
  t0.size AS size_15,
  t0.uploadedAt AS uploadedAt_16,
  t0.note AS note_17,
  t0.flags AS flags_18,
  t0.parent AS parent_19,
  t0.container AS container_20,
  t0.tenant AS tenant_21,
  t0.createdBy AS createdBy_22,
  t0.updatedBy AS updatedBy_23,
  t0.touchedBy AS touchedBy_24,
  t0.uploadedBy AS uploadedBy_25,
  t0._discr,
  t0.optimization_cropSquare AS optimization_cropSquare_26,
  t0.optimization_cropRectangle AS optimization_cropRectangle_27,
  t0.optimization_cropWide AS optimization_cropWide_28,
  t0.optimization_processing AS optimization_processing_29,
  t0.documentMeta_pages AS documentMeta_pages_30
FROM
  cms__file__node t0
WHERE
  t0.parent = ?
  AND t0.container = ?
  AND t0._discr IN (
    'file', 'generic', 'image', 'document'
  )
  AND (
    (t0.tenant = 1)
  )
ORDER BY
  t0.name ASC,
  t0.extension ASC

SELECT t0.name AS name_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.rt AS rt_7, t0.lvl AS lvl_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.status AS status_11, t0.extension AS extension_12, t0.mime AS mime_13, t0.description AS description_14, t0.size AS size_15, t0.uploadedAt AS uploadedAt_16, t0.note AS note_17, t0.flags AS flags_18, t0.parent AS parent_19, t0.container AS container_20, t0.tenant AS tenant_21, t0.createdBy AS createdBy_22, t0.updatedBy AS updatedBy_23, t0.touchedBy AS touchedBy_24, t0.uploadedBy AS uploadedBy_25, t0._discr, t0.optimization_cropSquare AS optimization_cropSquare_26, t0.optimization_cropRectangle AS optimization_cropRectangle_27, t0.optimization_cropWide AS optimization_cropWide_28, t0.optimization_processing AS optimization_processing_29, t0.documentMeta_pages AS documentMeta_pages_30 FROM cms__file__node t0 WHERE t0.parent = 756 AND t0.container = 149 AND t0._discr IN ('file', 'generic', 'image', 'document') AND ((t0.tenant = 1)) ORDER BY t0.name ASC, t0.extension ASC;

SELECT
  c0_.account AS sclr_0,
  c0_.grp AS sclr_1
FROM
  cms__security__identity__group_account c0_
WHERE
  (c0_.account = ?)
  AND (c0_.tenant = 1)

SELECT c0_.account AS sclr_0, c0_.grp AS sclr_1 FROM cms__security__identity__group_account c0_ WHERE (c0_.account = 1) AND (c0_.tenant = 1);

SELECT
  c0_.account AS sclr_0,
  c0_.role AS sclr_1,
  c0_.container AS sclr_2,
  c0_.inheritance AS inheritance_3,
  c0_.school AS sclr_4,
  c0_.list AS sclr_5
FROM
  cms__security__access__role_association c0_
WHERE
  (
    (c0_.account = ?)
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('account')

SELECT c0_.account AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.account = 1) AND (c0_.tenant = 1)) AND c0_._discr IN ('account');

SELECT
  c0_.grp AS sclr_0,
  c0_.role AS sclr_1,
  c0_.container AS sclr_2,
  c0_.inheritance AS inheritance_3,
  c0_.school AS sclr_4,
  c0_.list AS sclr_5
FROM
  cms__security__access__role_association c0_
WHERE
  (
    (
      c0_.grp IN (
        ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
        ?, ?, ?, ?
      )
    )
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN ('group')

SELECT c0_.grp AS sclr_0, c0_.role AS sclr_1, c0_.container AS sclr_2, c0_.inheritance AS inheritance_3, c0_.school AS sclr_4, c0_.list AS sclr_5 FROM cms__security__access__role_association c0_ WHERE ((c0_.grp IN (20, 93, 97, 103, 107, 108, 112, 143, 147, 148, 156, 158, 162, 168, 172, 173, 177, 183, 187, 251)) AND (c0_.tenant = 1)) AND c0_._discr IN ('group');

SELECT
  c0_.id AS id_0,
  c0_.rt AS rt_1,
  c0_.lvl AS lvl_2,
  c0_.lft AS lft_3,
  c0_.rgt AS rgt_4
FROM
  cms__container__container c0_
WHERE
  (
    (c0_.rt = ?)
    AND (c0_.tenant = 1)
  )
  AND c0_._discr IN (
    'generic', 'personal', 'intranet',
    'storage'
  )
ORDER BY
  c0_.lft ASC

SELECT c0_.id AS id_0, c0_.rt AS rt_1, c0_.lvl AS lvl_2, c0_.lft AS lft_3, c0_.rgt AS rgt_4 FROM cms__container__container c0_ WHERE ((c0_.rt = 149) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY c0_.lft ASC;