https://anytownschdist2024.test.campussuite.com/_login/?redirect=https%3A%2F%2Fanytownschdist2024.test.campussuite.com%2F_dashboard%2Fcontrol-panel%2Ftenants%2F46%2Foneroster Return to referer URL

Method
POST
HTTP Status
302
IP
50.5.181.156
Profiled on
Token
85e9b3

Query Metrics

7 Database Queries
7 Different statements
128.14 ms Query time
0 Invalid entities

Queries

Group similar statements

#▲ Time Info
1 3.57 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: 
[
  "anytownschdist2024"
]
View formatted query    View runnable query    Explain query
2 8.69 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.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.email = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters: 
[
  "csadmin@innersync.com"
]
View formatted query    View runnable query    Explain query
3 0.35 ms 
"START TRANSACTION"
Parameters: 
[]
View formatted query    View runnable query    Explain query
4 12.20 ms 
INSERT INTO cms__security__login__attempt (status, message, ip, redirect, debugging, authType, uid, createdAt, updatedAt, touchedAt, account, tenant) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: 
[
  1
  null
  "50.5.181.156"
  null
  null
  1
  "9cd56d28-81da-11ef-89ff-02dbd7d98eb9"
  "2024-10-03 22:55:40"
  null
  "2024-10-03 22:55:40"
  7304
  46
]
View formatted query    View runnable query    Explain query
5 3.62 ms 
"COMMIT"
Parameters: 
[]
View formatted query    View runnable query    Explain query
6 99.10 ms 
UPDATE cms__security__identity__account SET lastLoggedInAt = ? WHERE (id = ?) AND (cms__security__identity__account.tenant = 46)
Parameters: 
[
  "2024-10-03 22:55:40"
  7304
]
View formatted query    View runnable query    Explain query
7 0.61 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.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 = 46))
Parameters: 
[
  7304
]
View formatted query    View runnable query    Explain query

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\Login\Attempt No errors.