Query Metrics
36
Database Queries
23
Different statements
51.07 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.44 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"
]
|
2 | 1.62 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"
]
|
3 | 1.29 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 = 46)
Parameters:
[
7304
]
|
4 | 1.12 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 = 46)) AND c0_._discr IN ('account')
Parameters:
[
7304
]
|
5 | 1.49 ms |
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.slug = ? AND t0._discr IN ('storage') AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
"notifications"
]
|
6 | 0.55 ms |
SELECT n0_.urgent AS urgent_0, n0_.templateChannels AS templateChannels_1, n0_.status AS status_2, n0_.facades AS facades_3, n0_.scheduledAt AS scheduledAt_4, n0_.id AS id_5, n0_.uid AS uid_6, n0_.createdAt AS createdAt_7, n0_.updatedAt AS updatedAt_8, n0_.touchedAt AS touchedAt_9, n0_.channels AS channels_10, n0_.locale AS locale_11, n0_.title AS title_12, n0_.description AS description_13, n0_.script AS script_14, n0_.html AS html_15, n0_.media AS media_16, n0_.emailName AS emailName_17, n0_.emailFrom AS emailFrom_18, n0_.smsUrl AS smsUrl_19, n0_.facebookNote AS facebookNote_20, n0_.twitterNote AS twitterNote_21, n0_.websiteBehavior AS websiteBehavior_22, n0_.websiteLevel AS websiteLevel_23, n0_.websiteEndDateTime AS websiteEndDateTime_24, n0_.flags AS flags_25, n0_.semaphore AS semaphore_26, n0_.discr AS discr_27, n0_.branding AS branding_28, n0_.tenant AS tenant_29, n0_.createdBy AS createdBy_30, n0_.updatedBy AS updatedBy_31, n0_.touchedBy AS touchedBy_32, n0_.recording AS recording_33, n0_.voiceCallerId AS voiceCallerId_34 FROM notis__notification n0_ WHERE ((n0_.status <> ?) AND (n0_.tenant = 46)) AND n0_.discr IN ('message') ORDER BY n0_.touchedAt DESC LIMIT 6
Parameters:
[
0
]
|
7 | 1.00 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
8 | 0.45 ms |
SELECT COUNT(*) FROM notis__checkup t0 WHERE t0.ok = ? AND t0.fixedAt IS NULL AND ((t0.tenant = 46))
Parameters:
[
0
]
|
9 | 0.42 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__notification n0_ WHERE ((n0_.status IN (?, ?) AND n0_.touchedAt >= ?) AND (n0_.tenant = 46)) AND n0_.discr IN ('message')
Parameters:
[ 2 4 "2024-09-03 15:40:14" ] |
10 | 2.45 ms |
SELECT COUNT(*) FROM sys__school t0 WHERE ((t0.tenant = 46))
Parameters:
[] |
11 | 2.50 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[] |
12 | 1.94 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE ((n0_.reachability & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
6
]
|
13 | 0.39 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE ((n0_.reachability & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
1
]
|
14 | 0.44 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__student n0_ WHERE (n0_.reachability = ?) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
0
]
|
15 | 3.17 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[] |
16 | 2.77 ms |
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 46) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('email') AND (n2_.tenant = 46) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
4
]
|
17 | 1.53 ms |
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 46) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('phone') AND (n2_.tenant = 46) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & ?) > 0 AND n2_.method IN (?, ?)) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[ 2 1 4 ] |
18 | 0.83 ms |
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 46) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('phone') AND (n2_.tenant = 46) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & ?) > 0 AND n2_.method IN (?, ?)) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[ 1 2 4 ] |
19 | 0.62 ms |
SELECT COUNT(DISTINCT n0_.id) AS sclr_0 FROM notis__profile n0_ LEFT JOIN notis__profile_contact n1_ ON n0_.id = n1_.profile AND (n1_.discarded = 0) AND (n1_.tenant = 46) LEFT JOIN notis__recipient n2_ ON (n1_.recipient = n2_.id) AND n2_.discr IN ('app') AND (n2_.tenant = 46) WHERE (n2_.id IS NOT NULL AND (n1_.primaryPreferences & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
8
]
|
20 | 0.65 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[] |
21 | 0.43 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE ((n0_.reachability & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
6
]
|
22 | 0.42 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE ((n0_.reachability & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
1
]
|
23 | 0.37 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.reachability = ?) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[
0
]
|
24 | 1.38 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
25 | 0.42 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
26 | 4.59 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN (?, ?, ?, ?, ?)) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[ "administrator" "aide" "proctor" "teacher" "staff" ] |
27 | 5.81 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN (?, ?, ?, ?, ?) AND (n0_.reachability & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[ "administrator" "aide" "proctor" "teacher" "staff" 6 ] |
28 | 0.83 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN (?, ?, ?, ?, ?) AND (n0_.reachability & ?) > 0) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[ "administrator" "aide" "proctor" "teacher" "staff" 1 ] |
29 | 3.46 ms |
SELECT COUNT(n0_.id) AS sclr_0 FROM notis__profile n0_ WHERE (n0_.role IN (?, ?, ?, ?, ?) AND n0_.reachability = ?) AND (n0_.discarded = 0) AND (n0_.tenant = 46)
Parameters:
[ "administrator" "aide" "proctor" "teacher" "staff" 0 ] |
30 | 4.24 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
31 | 0.54 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
32 | 0.75 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
33 | 0.51 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
34 | 0.49 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
35 | 0.46 ms |
SELECT t0.strategies AS strategies_1, t0.vendor AS vendor_2, t0.apiClientId AS apiClientId_3, t0.apiClientSecret AS apiClientSecret_4, t0.apiAppName AS apiAppName_5, t0.apiToken AS apiToken_6, t0.districtId AS districtId_7, t0.baseUri AS baseUri_8, t0.active AS active_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.flags AS flags_15, t0.semaphore AS semaphore_16, t0.schedule AS schedule_17, t0.lastRunAt AS lastRunAt_18, t0.nextRunAt AS nextRunAt_19, t0.tenant AS tenant_20, t0.createdBy AS createdBy_21, t0.updatedBy AS updatedBy_22, t0.touchedBy AS touchedBy_23 FROM cms__one_roster__sync t0 WHERE t0.tenant = ? AND ((t0.tenant = 46)) LIMIT 1
Parameters:
[
46
]
|
36 | 0.69 ms |
SELECT t0.status AS status_1, t0.startPhase AS startPhase_2, t0.phasesReady AS phasesReady_3, t0.phasesRunning AS phasesRunning_4, t0.phasesComplete AS phasesComplete_5, t0.firstActivityAt AS firstActivityAt_6, t0.lastActivityAt AS lastActivityAt_7, t0.semaphore AS semaphore_8, t0.error AS error_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.sync AS sync_15, t0.tenant AS tenant_16, t0.createdBy AS createdBy_17, t0.updatedBy AS updatedBy_18, t0.touchedBy AS touchedBy_19 FROM cms__one_roster__job t0 WHERE t0.sync = ? AND ((t0.tenant = 46)) ORDER BY t0.createdAt DESC
Parameters:
[
38
]
|
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.