Symfony Profiler

SELECT
  COUNT(*) AS dctrn_count
FROM
  (
    SELECT
      DISTINCT id_17
    FROM
      (
        SELECT
          c0_.name AS name_0,
          c0_.slug AS slug_1,
          c0_.status AS status_2,
          c0_.emailsDisplay AS emailsDisplay_3,
          c0_.policy AS policy_4,
          c0_.disqusId AS disqusId_5,
          c0_.googleToken AS googleToken_6,
          c0_.stage AS stage_7,
          c0_.teamworkTasklist AS teamworkTasklist_8,
          c0_.latitude AS latitude_9,
          c0_.longitude AS longitude_10,
          c0_.redirects AS redirects_11,
          c0_.redirectCodes AS redirectCodes_12,
          c0_.debugging AS debugging_13,
          c0_.products AS products_14,
          c0_.hubspotId AS hubspotId_15,
          c0_.weglotId AS weglotId_16,
          c0_.id AS id_17,
          c0_.uid AS uid_18,
          c0_.createdAt AS createdAt_19,
          c0_.updatedAt AS updatedAt_20,
          c0_.touchedAt AS touchedAt_21,
          c0_.data_custom0 AS data_custom0_22,
          c0_.data_custom1 AS data_custom1_23,
          c0_.data_custom2 AS data_custom2_24,
          c0_.data_custom3 AS data_custom3_25,
          c0_.authenticationTypes AS authenticationTypes_26,
          c0_.classlinkCustomerId AS classlinkCustomerId_27,
          c0_.cleverCustomerId AS cleverCustomerId_28,
          c0_.gg4lCustomerId AS gg4lCustomerId_29,
          c0_.googleCustomerId AS googleCustomerId_30,
          c0_.microsoftCustomerId AS microsoftCustomerId_31,
          c0_.ulid AS ulid_32,
          c0_.locale_timezone AS locale_timezone_33,
          c0_.ada_reportsFolder AS ada_reportsFolder_34,
          c0_.ada_reportsPrimary AS ada_reportsPrimary_35,
          c0_.ada_reportsDocuments AS ada_reportsDocuments_36,
          c0_.type_primary AS type_primary_37,
          c0_.type_secondary AS type_secondary_38
        FROM
          cms__tenant__tenant c0_
        WHERE
          c0_.status IN (?, ?)
        ORDER BY
          c0_.name ASC
      ) dctrn_result
  ) dctrn_table

SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_17 FROM (SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.status AS status_2, c0_.emailsDisplay AS emailsDisplay_3, c0_.policy AS policy_4, c0_.disqusId AS disqusId_5, c0_.googleToken AS googleToken_6, c0_.stage AS stage_7, c0_.teamworkTasklist AS teamworkTasklist_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.redirects AS redirects_11, c0_.redirectCodes AS redirectCodes_12, c0_.debugging AS debugging_13, c0_.products AS products_14, c0_.hubspotId AS hubspotId_15, c0_.weglotId AS weglotId_16, c0_.id AS id_17, c0_.uid AS uid_18, c0_.createdAt AS createdAt_19, c0_.updatedAt AS updatedAt_20, c0_.touchedAt AS touchedAt_21, c0_.data_custom0 AS data_custom0_22, c0_.data_custom1 AS data_custom1_23, c0_.data_custom2 AS data_custom2_24, c0_.data_custom3 AS data_custom3_25, c0_.authenticationTypes AS authenticationTypes_26, c0_.classlinkCustomerId AS classlinkCustomerId_27, c0_.cleverCustomerId AS cleverCustomerId_28, c0_.gg4lCustomerId AS gg4lCustomerId_29, c0_.googleCustomerId AS googleCustomerId_30, c0_.microsoftCustomerId AS microsoftCustomerId_31, c0_.ulid AS ulid_32, c0_.locale_timezone AS locale_timezone_33, c0_.ada_reportsFolder AS ada_reportsFolder_34, c0_.ada_reportsPrimary AS ada_reportsPrimary_35, c0_.ada_reportsDocuments AS ada_reportsDocuments_36, c0_.type_primary AS type_primary_37, c0_.type_secondary AS type_secondary_38 FROM cms__tenant__tenant c0_ WHERE c0_.status IN ('OK', 'suspended') ORDER BY c0_.name ASC) dctrn_result) dctrn_table;

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 = 46)
  )

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 = '7304' AND ((t0.tenant = 46));

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 = 'anytown' LIMIT 1;

SELECT
  c0_.name AS name_0,
  c0_.slug AS slug_1,
  c0_.status AS status_2,
  c0_.emailsDisplay AS emailsDisplay_3,
  c0_.policy AS policy_4,
  c0_.disqusId AS disqusId_5,
  c0_.googleToken AS googleToken_6,
  c0_.stage AS stage_7,
  c0_.teamworkTasklist AS teamworkTasklist_8,
  c0_.latitude AS latitude_9,
  c0_.longitude AS longitude_10,
  c0_.redirects AS redirects_11,
  c0_.redirectCodes AS redirectCodes_12,
  c0_.debugging AS debugging_13,
  c0_.products AS products_14,
  c0_.hubspotId AS hubspotId_15,
  c0_.weglotId AS weglotId_16,
  c0_.id AS id_17,
  c0_.uid AS uid_18,
  c0_.createdAt AS createdAt_19,
  c0_.updatedAt AS updatedAt_20,
  c0_.touchedAt AS touchedAt_21,
  c0_.data_custom0 AS data_custom0_22,
  c0_.data_custom1 AS data_custom1_23,
  c0_.data_custom2 AS data_custom2_24,
  c0_.data_custom3 AS data_custom3_25,
  c0_.authenticationTypes AS authenticationTypes_26,
  c0_.classlinkCustomerId AS classlinkCustomerId_27,
  c0_.cleverCustomerId AS cleverCustomerId_28,
  c0_.gg4lCustomerId AS gg4lCustomerId_29,
  c0_.googleCustomerId AS googleCustomerId_30,
  c0_.microsoftCustomerId AS microsoftCustomerId_31,
  c0_.ulid AS ulid_32,
  c0_.locale_timezone AS locale_timezone_33,
  c0_.ada_reportsFolder AS ada_reportsFolder_34,
  c0_.ada_reportsPrimary AS ada_reportsPrimary_35,
  c0_.ada_reportsDocuments AS ada_reportsDocuments_36,
  c0_.type_primary AS type_primary_37,
  c0_.type_secondary AS type_secondary_38
FROM
  cms__tenant__tenant c0_
WHERE
  c0_.status IN (?, ?)
ORDER BY
  c0_.name ASC
LIMIT
  1000

SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.status AS status_2, c0_.emailsDisplay AS emailsDisplay_3, c0_.policy AS policy_4, c0_.disqusId AS disqusId_5, c0_.googleToken AS googleToken_6, c0_.stage AS stage_7, c0_.teamworkTasklist AS teamworkTasklist_8, c0_.latitude AS latitude_9, c0_.longitude AS longitude_10, c0_.redirects AS redirects_11, c0_.redirectCodes AS redirectCodes_12, c0_.debugging AS debugging_13, c0_.products AS products_14, c0_.hubspotId AS hubspotId_15, c0_.weglotId AS weglotId_16, c0_.id AS id_17, c0_.uid AS uid_18, c0_.createdAt AS createdAt_19, c0_.updatedAt AS updatedAt_20, c0_.touchedAt AS touchedAt_21, c0_.data_custom0 AS data_custom0_22, c0_.data_custom1 AS data_custom1_23, c0_.data_custom2 AS data_custom2_24, c0_.data_custom3 AS data_custom3_25, c0_.authenticationTypes AS authenticationTypes_26, c0_.classlinkCustomerId AS classlinkCustomerId_27, c0_.cleverCustomerId AS cleverCustomerId_28, c0_.gg4lCustomerId AS gg4lCustomerId_29, c0_.googleCustomerId AS googleCustomerId_30, c0_.microsoftCustomerId AS microsoftCustomerId_31, c0_.ulid AS ulid_32, c0_.locale_timezone AS locale_timezone_33, c0_.ada_reportsFolder AS ada_reportsFolder_34, c0_.ada_reportsPrimary AS ada_reportsPrimary_35, c0_.ada_reportsDocuments AS ada_reportsDocuments_36, c0_.type_primary AS type_primary_37, c0_.type_secondary AS type_secondary_38 FROM cms__tenant__tenant c0_ WHERE c0_.status IN ('OK', 'suspended') ORDER BY c0_.name ASC LIMIT 1000;