Symfony Profiler

SELECT
  id,
  cls
FROM
  (
    SELECT
      id,
      0 AS cls,
      data_title
    FROM
      cms__modules__alert__alert__draft entity0
    WHERE
      entity0.tenant = 1
      AND entity0.status = ?
      AND entity0.createdBy = ?
    UNION ALL
    SELECT
      id,
      1 AS cls,
      data_title
    FROM
      cms__modules__blog__post__draft entity1
    WHERE
      entity1.tenant = 1
      AND entity1.status = ?
      AND entity1.createdBy = ?
    UNION ALL
    SELECT
      id,
      2 AS cls,
      data_title
    FROM
      cms__modules__calendar__event__draft entity2
    WHERE
      entity2.tenant = 1
      AND entity2.status = ?
      AND entity2.createdBy = ?
    UNION ALL
    SELECT
      id,
      3 AS cls,
      data_title
    FROM
      cms__modules__gallery__gallery__draft entity3
    WHERE
      entity3.tenant = 1
      AND entity3.status = ?
      AND entity3.createdBy = ?
    UNION ALL
    SELECT
      id,
      4 AS cls,
      data_title
    FROM
      cms__modules__news__article__draft entity4
    WHERE
      entity4.tenant = 1
      AND entity4.status = ?
      AND entity4.createdBy = ?
    UNION ALL
    SELECT
      id,
      5 AS cls,
      data_title
    FROM
      cms__modules__page__page__draft entity5
    WHERE
      entity5.tenant = 1
      AND entity5.status = ?
      AND entity5.createdBy = ?
    UNION ALL
    SELECT
      id,
      6 AS cls,
      data_lastName
    FROM
      cms__modules__people__profile__draft entity6
    WHERE
      entity6.tenant = 1
      AND entity6.status = ?
      AND entity6.createdBy = ?
    UNION ALL
    SELECT
      id,
      7 AS cls,
      data_title
    FROM
      cms__modules__question__entry__draft entity7
    WHERE
      entity7.tenant = 1
      AND entity7.status = ?
      AND entity7.createdBy = ?
    UNION ALL
    SELECT
      id,
      8 AS cls,
      data_title
    FROM
      cms__modules__snippet__snippet__draft entity8
    WHERE
      entity8.tenant = 1
      AND entity8.status = ?
      AND entity8.createdBy = ?
  ) unioned
ORDER BY
  unioned.data_title ASC
LIMIT
  25 OFFSET 0

SELECT id, cls FROM (SELECT id, 0 AS cls, data_title FROM cms__modules__alert__alert__draft entity0 WHERE entity0.tenant = 1 AND entity0.status = 'open' AND entity0.createdBy = 1 UNION ALL SELECT id, 1 AS cls, data_title FROM cms__modules__blog__post__draft entity1 WHERE entity1.tenant = 1 AND entity1.status = 'open' AND entity1.createdBy = 1 UNION ALL SELECT id, 2 AS cls, data_title FROM cms__modules__calendar__event__draft entity2 WHERE entity2.tenant = 1 AND entity2.status = 'open' AND entity2.createdBy = 1 UNION ALL SELECT id, 3 AS cls, data_title FROM cms__modules__gallery__gallery__draft entity3 WHERE entity3.tenant = 1 AND entity3.status = 'open' AND entity3.createdBy = 1 UNION ALL SELECT id, 4 AS cls, data_title FROM cms__modules__news__article__draft entity4 WHERE entity4.tenant = 1 AND entity4.status = 'open' AND entity4.createdBy = 1 UNION ALL SELECT id, 5 AS cls, data_title FROM cms__modules__page__page__draft entity5 WHERE entity5.tenant = 1 AND entity5.status = 'open' AND entity5.createdBy = 1 UNION ALL SELECT id, 6 AS cls, data_lastName FROM cms__modules__people__profile__draft entity6 WHERE entity6.tenant = 1 AND entity6.status = 'open' AND entity6.createdBy = 1 UNION ALL SELECT id, 7 AS cls, data_title FROM cms__modules__question__entry__draft entity7 WHERE entity7.tenant = 1 AND entity7.status = 'open' AND entity7.createdBy = 1 UNION ALL SELECT id, 8 AS cls, data_title FROM cms__modules__snippet__snippet__draft entity8 WHERE entity8.tenant = 1 AND entity8.status = 'open' AND entity8.createdBy = 1) unioned ORDER BY unioned.data_title ASC LIMIT 25 OFFSET 0;

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.id AS id_9,
  t0.uid AS uid_10,
  t0.createdAt AS createdAt_11,
  t0.updatedAt AS updatedAt_12,
  t0.touchedAt AS touchedAt_13,
  t0.onerosterId AS onerosterId_14,
  t0.onerosterArchived AS onerosterArchived_15,
  t0.importIndex AS importIndex_16,
  t0.specialPermissions_superUser AS specialPermissions_superUser_17,
  t0.systemProfile_displayName AS systemProfile_displayName_18,
  t0.systemProfile_firstName AS systemProfile_firstName_19,
  t0.systemProfile_lastName AS systemProfile_lastName_20,
  t0.systemProfile_avatar AS systemProfile_avatar_21,
  t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_22,
  t0.tenant AS tenant_23,
  t0.createdBy AS createdBy_24,
  t0.updatedBy AS updatedBy_25,
  t0.touchedBy AS touchedBy_26,
  t0.import AS import_27
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.id AS id_9, t0.uid AS uid_10, t0.createdAt AS createdAt_11, t0.updatedAt AS updatedAt_12, t0.touchedAt AS touchedAt_13, t0.onerosterId AS onerosterId_14, t0.onerosterArchived AS onerosterArchived_15, t0.importIndex AS importIndex_16, t0.specialPermissions_superUser AS specialPermissions_superUser_17, t0.systemProfile_displayName AS systemProfile_displayName_18, t0.systemProfile_firstName AS systemProfile_firstName_19, t0.systemProfile_lastName AS systemProfile_lastName_20, t0.systemProfile_avatar AS systemProfile_avatar_21, t0.systemProfile_mobilePhone AS systemProfile_mobilePhone_22, t0.tenant AS tenant_23, t0.createdBy AS createdBy_24, t0.updatedBy AS updatedBy_25, t0.touchedBy AS touchedBy_26, t0.import AS import_27 FROM cms__security__identity__account t0 WHERE t0.id = '1' AND ((t0.tenant = 1));

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_.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_.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');