Query Metrics
8
Database Queries
8
Different statements
368.25 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 4.30 ms |
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
Parameters:
[
"staging"
]
|
2 | 10.70 ms |
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))
Parameters:
[
"1"
]
|
3 | 7.07 ms |
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)
Parameters:
[
1
]
|
4 | 76.00 ms |
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')
Parameters:
[
1
]
|
5 | 79.95 ms |
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')
Parameters:
[ 20 93 97 103 107 108 112 143 147 148 156 158 162 168 172 173 177 183 187 251 ] |
6 | 100.37 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_8 FROM (SELECT c0_.email AS email_0, c0_.active AS active_1, c0_.policyAcceptedOn AS policyAcceptedOn_2, c0_.termsAcceptedOn AS termsAcceptedOn_3, c0_.password AS password_4, c0_.passwordChangedAt AS passwordChangedAt_5, c0_.lastLoggedInAt AS lastLoggedInAt_6, c0_.metadata AS metadata_7, c0_.id AS id_8, c0_.uid AS uid_9, c0_.createdAt AS createdAt_10, c0_.updatedAt AS updatedAt_11, c0_.touchedAt AS touchedAt_12, c0_.onerosterId AS onerosterId_13, c0_.onerosterArchived AS onerosterArchived_14, c0_.importIndex AS importIndex_15, c0_.specialPermissions_superUser AS specialPermissions_superUser_16, c0_.systemProfile_displayName AS systemProfile_displayName_17, c0_.systemProfile_firstName AS systemProfile_firstName_18, c0_.systemProfile_lastName AS systemProfile_lastName_19, c0_.systemProfile_avatar AS systemProfile_avatar_20, c0_.systemProfile_mobilePhone AS systemProfile_mobilePhone_21, CASE WHEN c0_.systemProfile_displayName IS NOT NULL THEN c0_.systemProfile_displayName WHEN c0_.systemProfile_firstName IS NOT NULL AND c0_.systemProfile_lastName IS NOT NULL THEN CONCAT(c0_.systemProfile_firstName, ' ', c0_.systemProfile_lastName) ELSE c0_.email END AS sclr_22, CASE WHEN c0_.onerosterId IS NOT NULL THEN 1 ELSE 0 END AS sclr_23 FROM cms__security__identity__account c0_ WHERE (c0_.active = 1) AND (c0_.tenant = 1) ORDER BY sclr_22 ASC) dctrn_result) dctrn_table
Parameters:
[] |
7 | 87.45 ms |
SELECT DISTINCT id_8 FROM (SELECT DISTINCT id_8, sclr_22 FROM (SELECT c0_.email AS email_0, c0_.active AS active_1, c0_.policyAcceptedOn AS policyAcceptedOn_2, c0_.termsAcceptedOn AS termsAcceptedOn_3, c0_.password AS password_4, c0_.passwordChangedAt AS passwordChangedAt_5, c0_.lastLoggedInAt AS lastLoggedInAt_6, c0_.metadata AS metadata_7, c0_.id AS id_8, c0_.uid AS uid_9, c0_.createdAt AS createdAt_10, c0_.updatedAt AS updatedAt_11, c0_.touchedAt AS touchedAt_12, c0_.onerosterId AS onerosterId_13, c0_.onerosterArchived AS onerosterArchived_14, c0_.importIndex AS importIndex_15, c0_.specialPermissions_superUser AS specialPermissions_superUser_16, c0_.systemProfile_displayName AS systemProfile_displayName_17, c0_.systemProfile_firstName AS systemProfile_firstName_18, c0_.systemProfile_lastName AS systemProfile_lastName_19, c0_.systemProfile_avatar AS systemProfile_avatar_20, c0_.systemProfile_mobilePhone AS systemProfile_mobilePhone_21, CASE WHEN c0_.systemProfile_displayName IS NOT NULL THEN c0_.systemProfile_displayName WHEN c0_.systemProfile_firstName IS NOT NULL AND c0_.systemProfile_lastName IS NOT NULL THEN CONCAT(c0_.systemProfile_firstName, ' ', c0_.systemProfile_lastName) ELSE c0_.email END AS sclr_22, CASE WHEN c0_.onerosterId IS NOT NULL THEN 1 ELSE 0 END AS sclr_23 FROM cms__security__identity__account c0_ WHERE (c0_.active = 1) AND (c0_.tenant = 1)) dctrn_result_inner ORDER BY sclr_22 ASC) dctrn_result LIMIT 12
Parameters:
[] |
8 | 2.41 ms |
SELECT c0_.email AS email_0, c0_.active AS active_1, c0_.policyAcceptedOn AS policyAcceptedOn_2, c0_.termsAcceptedOn AS termsAcceptedOn_3, c0_.password AS password_4, c0_.passwordChangedAt AS passwordChangedAt_5, c0_.lastLoggedInAt AS lastLoggedInAt_6, c0_.metadata AS metadata_7, c0_.id AS id_8, c0_.uid AS uid_9, c0_.createdAt AS createdAt_10, c0_.updatedAt AS updatedAt_11, c0_.touchedAt AS touchedAt_12, c0_.onerosterId AS onerosterId_13, c0_.onerosterArchived AS onerosterArchived_14, c0_.importIndex AS importIndex_15, c0_.specialPermissions_superUser AS specialPermissions_superUser_16, c0_.systemProfile_displayName AS systemProfile_displayName_17, c0_.systemProfile_firstName AS systemProfile_firstName_18, c0_.systemProfile_lastName AS systemProfile_lastName_19, c0_.systemProfile_avatar AS systemProfile_avatar_20, c0_.systemProfile_mobilePhone AS systemProfile_mobilePhone_21, CASE WHEN c0_.systemProfile_displayName IS NOT NULL THEN c0_.systemProfile_displayName WHEN c0_.systemProfile_firstName IS NOT NULL AND c0_.systemProfile_lastName IS NOT NULL THEN CONCAT(c0_.systemProfile_firstName, ' ', c0_.systemProfile_lastName) ELSE c0_.email END AS sclr_22, CASE WHEN c0_.onerosterId IS NOT NULL THEN 1 ELSE 0 END AS sclr_23, c0_.tenant AS tenant_24, c0_.createdBy AS createdBy_25, c0_.updatedBy AS updatedBy_26, c0_.touchedBy AS touchedBy_27, c0_.import AS import_28 FROM cms__security__identity__account c0_ WHERE (c0_.active = 1 AND c0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (c0_.tenant = 1) ORDER BY sclr_22 ASC
Parameters:
[ 7287 8 7291 7301 215 2 7302 7298 7282 7300 7303 5905 ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
Name | Service |
---|---|
default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
Class | Mapping errors |
---|---|
Cms\TenantBundle\Entity\Tenant | No errors. |
Platform\SecurityBundle\Entity\Identity\Account | No errors. |
Cms\ImportBundle\Entity\Import | No errors. |
Platform\SecurityBundle\Entity\Access\RoleAssociation\AccountRoleAssociation | No errors. |
Cms\ContainerBundle\Entity\Container | No errors. |
App\Entity\OAuth2\Admin\AbstractAdminToken | No errors. |
Platform\SecurityBundle\Entity\Access\GroupAccount | No errors. |
Platform\SecurityBundle\Entity\Identity\Group | No errors. |
Platform\SecurityBundle\Entity\Access\Role | No errors. |
Platform\SecurityBundle\Entity\Access\RoleAssociation | No errors. |
App\Entity\System\School | No errors. |
Products\NotificationsBundle\Entity\AbstractList | No errors. |
Platform\SecurityBundle\Entity\Access\RoleAssociation\GroupRoleAssociation | No errors. |