Query Metrics
62
Database Queries
38
Different statements
464.56 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.83 ms |
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id WHERE (c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?) LIMIT 1
Parameters:
[ "" "wcsd.fallhaven.org" "wcsd" "fallhaven.org" ] |
2 | 4.28 ms |
SELECT t0.expiration AS expiration_1, t0.ready AS ready_2, t0.error AS error_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.data_privateKey AS data_privateKey_9, t0.data_intermediateCertificates AS data_intermediateCertificates_10, t0.data_certficate AS data_certficate_11, t0.data_certificateSigningRequest AS data_certificateSigningRequest_12, t0.domain AS domain_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr, t0.csr_email AS csr_email_18, t0.csr_organization AS csr_organization_19, t0.csr_unit AS csr_unit_20, t0.csr_country AS csr_country_21, t0.csr_province AS csr_province_22, t0.csr_locality AS csr_locality_23, t0.le_challenge AS le_challenge_24, t0.le_token AS le_token_25, t0.le_payload AS le_payload_26 FROM cms__domain__ssl_certificate t0 WHERE t0.id = ? AND t0._discr IN ('custom', 'lets-encrypt')
Parameters:
[
39
]
|
3 | 0.65 ms |
SELECT t0.host AS host_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.dnsLookupAt AS dnsLookupAt_7, t0.dnsLookupResult AS dnsLookupResult_8, t0.verification_code AS verification_code_9, t0.verification_date AS verification_date_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM cms__domain__apex t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
1
]
|
4 | 0.74 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.id = ?
Parameters:
[
1
]
|
5 | 2.96 ms |
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id AND (c1_.tenant = 1) WHERE ((c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?)) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[ "" "wcsd.fallhaven.org" "wcsd" "fallhaven.org" ] |
6 | 1.50 ms |
SELECT c0_.code AS code_0, c0_.status AS status_1, c0_.description AS description_2, c0_.source AS source_3, c0_.destination AS destination_4, c0_.id AS id_5, c0_.uid AS uid_6, c0_.createdAt AS createdAt_7, c0_.updatedAt AS updatedAt_8, c0_.touchedAt AS touchedAt_9, c0_.importIndex AS importIndex_10, c0_.domain AS domain_11, c0_.tenant AS tenant_12, c0_.createdBy AS createdBy_13, c0_.updatedBy AS updatedBy_14, c0_.touchedBy AS touchedBy_15, c0_.import AS import_16 FROM cms__redirect__redirect c0_ WHERE (c0_.domain = ? AND c0_.source IN (?)) AND (c0_.tenant = 1)
Parameters:
[ 12 "/" ] |
7 | 0.77 ms |
SELECT c0_.code AS code_0, c0_.status AS status_1, c0_.description AS description_2, c0_.source AS source_3, c0_.destination AS destination_4, c0_.id AS id_5, c0_.uid AS uid_6, c0_.createdAt AS createdAt_7, c0_.updatedAt AS updatedAt_8, c0_.touchedAt AS touchedAt_9, c0_.importIndex AS importIndex_10, c0_.domain AS domain_11, c0_.tenant AS tenant_12, c0_.createdBy AS createdBy_13, c0_.updatedBy AS updatedBy_14, c0_.touchedBy AS touchedBy_15, c0_.import AS import_16 FROM cms__redirect__redirect c0_ WHERE (c0_.domain = ? AND c0_.source = ?) AND (c0_.tenant = 1)
Parameters:
[ 12 "/*" ] |
8 | 0.72 ms |
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id AND (c1_.tenant = 1) WHERE ((c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?)) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[ "" "wcsd.fallhaven.org" "wcsd" "fallhaven.org" ] |
9 | 3.14 ms |
SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_._discr AS _discr_31, c0_.parent AS parent_32, c0_.domain AS domain_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.defaultTheme AS defaultTheme_38, c0_.defaultOuterLayout AS defaultOuterLayout_39, c0_.defaultInnerLayout AS defaultInnerLayout_40 FROM cms__container__container c0_ WHERE ((c0_.parent IS NULL AND c0_.domain = ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic') LIMIT 1
Parameters:
[
12
]
|
10 | 2.46 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.parent AS parent_31, t0.domain AS domain_32, t0.tenant AS tenant_33, t0.createdBy AS createdBy_34, t0.updatedBy AS updatedBy_35, t0.touchedBy AS touchedBy_36, t0.defaultTheme AS defaultTheme_37, t0.defaultOuterLayout AS defaultOuterLayout_38, t0.defaultInnerLayout AS defaultInnerLayout_39, t0._discr, t0.preferred AS preferred_40, t0.importIndex AS importIndex_41, t0.account AS account_42, t0.container AS container_43, t0.import AS import_44, t0.feedSetting_blog AS feedSetting_blog_45, t0.feedSetting_calendar AS feedSetting_calendar_46, t0.feedSetting_news AS feedSetting_news_47, t0.feedSetting_alert AS feedSetting_alert_48, t0.preferred AS preferred_49 FROM cms__container__container t0 WHERE t0.parent = ? AND t0.slug = ? AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
""
]
|
11 | 2.40 ms |
SELECT t0.theme AS theme_1, t0.name AS name_2, t0.fonts AS fonts_3, t0.bust AS bust_4, t0.id AS id_5, t0.uid AS uid_6, t0.createdAt AS createdAt_7, t0.updatedAt AS updatedAt_8, t0.touchedAt AS touchedAt_9, t0.variables AS variables_10, t0.source AS source_11, t0.configs AS configs_12, t0.outerLayout AS outerLayout_13, t0.innerLayout AS innerLayout_14, t0.tenant AS tenant_15, t0.createdBy AS createdBy_16, t0.updatedBy AS updatedBy_17, t0.touchedBy AS touchedBy_18 FROM cms__theme__template t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
2
]
|
12 | 1.48 ms |
SELECT c0_.id AS id_0, c0_.uid AS uid_1, c0_.createdAt AS createdAt_2, c0_.updatedAt AS updatedAt_3, c0_.touchedAt AS touchedAt_4, c0_.container AS container_5, c0_.tenant AS tenant_6, c0_.createdBy AS createdBy_7, c0_.updatedBy AS updatedBy_8, c0_.touchedBy AS touchedBy_9 FROM cms__modules__page__module_settings c0_ WHERE (c0_.container = ?) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[
149
]
|
13 | 6.54 ms |
SELECT t0.name AS name_1, t0.auto AS auto_2, t0.id AS id_3, t0.uid AS uid_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.touchedAt AS touchedAt_7, t0.tenant AS tenant_8, t0.createdBy AS createdBy_9, t0.updatedBy AS updatedBy_10, t0.touchedBy AS touchedBy_11, t0._discr, t0.facebookPageId AS facebookPageId_12, t0.facebookUserId AS facebookUserId_13, t0.facebookUserName AS facebookUserName_14, t0.facebookAccessToken AS facebookAccessToken_15, t0.twitterUserId AS twitterUserId_16, t0.twitterUserName AS twitterUserName_17, t0.twitterAccessToken AS twitterAccessToken_18, t0.twitterTokenSecret AS twitterTokenSecret_19 FROM smm__account t0 WHERE t0._discr IN ('facebook', 'twitter') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[] |
14 | 19.86 ms |
SELECT t0.placeholder AS placeholder_1, t0.id AS id_2, t0.uid AS uid_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.touchedAt AS touchedAt_6, t0.lockedAt AS lockedAt_7, t0.lockRefreshedAt AS lockRefreshedAt_8, t0.data_title AS data_title_9, t0.data_slug AS data_slug_10, t0.data_content AS data_content_11, t0.data_source AS data_source_12, t0.data_appendToNav AS data_appendToNav_13, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_14, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_15, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_16, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_17, t0.data_social_socialImage AS data_social_socialImage_18, t0.data_social_facebookImage AS data_social_facebookImage_19, t0.data_social_twitterImage AS data_social_twitterImage_20, t0.data_standardMetadata_title AS data_standardMetadata_title_21, t0.data_standardMetadata_description AS data_standardMetadata_description_22, t0.data_standardMetadata_keywords AS data_standardMetadata_keywords_23, t0.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_24, t0.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_25, t0.data_standardMetadata_robots AS data_standardMetadata_robots_26, t0.container AS container_27, t0.tenant AS tenant_28, t0.createdBy AS createdBy_29, t0.updatedBy AS updatedBy_30, t0.touchedBy AS touchedBy_31, t0.lockedBy AS lockedBy_32, t0.data_defaultOuterLayout AS data_defaultOuterLayout_33, t0.data_defaultInnerLayout AS data_defaultInnerLayout_34, t0.socialImage AS socialImage_35, t0.history AS history_36, t0.draft AS draft_37 FROM cms__modules__page__page__proxy t0 WHERE t0.container = ? AND t0.data_slug = ? AND ((t0.placeholder = 0) AND (t0.tenant = 1)) LIMIT 1
Parameters:
[ 149 "index" ] |
15 | 9.20 ms |
SELECT c0_.id AS id_0, c0_.uid AS uid_1, c0_.name AS name_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4 FROM cms__theme__twig_source c0_ WHERE (c0_.template = ?) AND (c0_.tenant = 1)
Parameters:
[
2
]
|
16 | 86.04 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE ((t0.tenant = 1)) ORDER BY t0.type ASC, t0.name ASC
Parameters:
[] |
17 | 4.06 ms |
SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_.importIndex AS importIndex_31, c0_.feedSetting_blog AS feedSetting_blog_32, c0_.feedSetting_calendar AS feedSetting_calendar_33, c0_.feedSetting_news AS feedSetting_news_34, c0_.feedSetting_alert AS feedSetting_alert_35, c0_.preferred AS preferred_36, c0_._discr AS _discr_37, c0_.parent AS parent_38, c0_.domain AS domain_39, c0_.tenant AS tenant_40, c0_.createdBy AS createdBy_41, c0_.updatedBy AS updatedBy_42, c0_.touchedBy AS touchedBy_43, c0_.defaultTheme AS defaultTheme_44, c0_.defaultOuterLayout AS defaultOuterLayout_45, c0_.defaultInnerLayout AS defaultInnerLayout_46, c0_.account AS account_47, c0_.container AS container_48, c0_.import AS import_49 FROM cms__container__container c0_ WHERE ((c0_.rt = ? AND c0_.lft < ? AND c0_.rgt > ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY c0_.lft ASC
Parameters:
[ 149 1 24 ] |
18 | 57.95 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s1_.schoolType AS schoolType_43, s1_.timestamp AS timestamp_44, s1_.label AS label_45, s1_.preview AS preview_46, s1_.media AS media_47, s1_.visibility AS visibility_48, s1_.boosted AS boosted_49, s1_.pinned AS pinned_50, s1_.pinnedAt AS pinnedAt_51, s1_.link AS link_52, s1_.id AS id_53, s1_.createdAt AS createdAt_54, s1_.updatedAt AS updatedAt_55, s1_.touchedAt AS touchedAt_56, c2_.name AS name_57, c2_.slug AS slug_58, c2_.hidden AS hidden_59, c2_.color AS color_60, c2_.code AS code_61, c2_.schoolNowMigrated AS schoolNowMigrated_62, c2_.id AS id_63, c2_.uid AS uid_64, c2_.createdAt AS createdAt_65, c2_.updatedAt AS updatedAt_66, c2_.touchedAt AS touchedAt_67, c2_.rt AS rt_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c2_.navigation AS navigation_72, c2_.moduleFlags_alert AS moduleFlags_alert_73, c2_.moduleFlags_blog AS moduleFlags_blog_74, c2_.moduleFlags_calendar AS moduleFlags_calendar_75, c2_.moduleFlags_gallery AS moduleFlags_gallery_76, c2_.moduleFlags_news AS moduleFlags_news_77, c2_.moduleFlags_page AS moduleFlags_page_78, c2_.moduleFlags_people AS moduleFlags_people_79, c2_.moduleFlags_question AS moduleFlags_question_80, c2_.moduleFlags_snippet AS moduleFlags_snippet_81, c2_.moduleFlags_feed AS moduleFlags_feed_82, c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83, c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84, c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85, c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86, c2_.preferred AS preferred_87, c2_.importIndex AS importIndex_88, c2_.feedSetting_blog AS feedSetting_blog_89, c2_.feedSetting_calendar AS feedSetting_calendar_90, c2_.feedSetting_news AS feedSetting_news_91, c2_.feedSetting_alert AS feedSetting_alert_92, c2_.preferred AS preferred_93, s0_.discr AS discr_94, s1_.discr AS discr_95, c2_._discr AS _discr_96 FROM sn__content__object s0_ LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object AND s1_.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND (s1_.tenant = 1) LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 1) WHERE ((c2_.rt = ? AND ((s1_.schoolType & ?) > 0 OR s1_.department IN (?)) AND s1_.boosted = ? AND s1_.visibility = ? AND s1_.timestamp <= ? AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s1_.pinned DESC, s1_.timestamp DESC, s1_.label ASC) dctrn_result) dctrn_table
Parameters:
[ 149 1 149 1 4 "2024-11-16 14:47:03" 8 8 ] |
19 | 4.50 ms |
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, pinned_50, timestamp_44, label_45 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s1_.schoolType AS schoolType_43, s1_.timestamp AS timestamp_44, s1_.label AS label_45, s1_.preview AS preview_46, s1_.media AS media_47, s1_.visibility AS visibility_48, s1_.boosted AS boosted_49, s1_.pinned AS pinned_50, s1_.pinnedAt AS pinnedAt_51, s1_.link AS link_52, s1_.id AS id_53, s1_.createdAt AS createdAt_54, s1_.updatedAt AS updatedAt_55, s1_.touchedAt AS touchedAt_56, c2_.name AS name_57, c2_.slug AS slug_58, c2_.hidden AS hidden_59, c2_.color AS color_60, c2_.code AS code_61, c2_.schoolNowMigrated AS schoolNowMigrated_62, c2_.id AS id_63, c2_.uid AS uid_64, c2_.createdAt AS createdAt_65, c2_.updatedAt AS updatedAt_66, c2_.touchedAt AS touchedAt_67, c2_.rt AS rt_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c2_.navigation AS navigation_72, c2_.moduleFlags_alert AS moduleFlags_alert_73, c2_.moduleFlags_blog AS moduleFlags_blog_74, c2_.moduleFlags_calendar AS moduleFlags_calendar_75, c2_.moduleFlags_gallery AS moduleFlags_gallery_76, c2_.moduleFlags_news AS moduleFlags_news_77, c2_.moduleFlags_page AS moduleFlags_page_78, c2_.moduleFlags_people AS moduleFlags_people_79, c2_.moduleFlags_question AS moduleFlags_question_80, c2_.moduleFlags_snippet AS moduleFlags_snippet_81, c2_.moduleFlags_feed AS moduleFlags_feed_82, c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83, c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84, c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85, c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86, c2_.preferred AS preferred_87, c2_.importIndex AS importIndex_88, c2_.feedSetting_blog AS feedSetting_blog_89, c2_.feedSetting_calendar AS feedSetting_calendar_90, c2_.feedSetting_news AS feedSetting_news_91, c2_.feedSetting_alert AS feedSetting_alert_92, c2_.preferred AS preferred_93, s0_.discr AS discr_94, s1_.discr AS discr_95, c2_._discr AS _discr_96 FROM sn__content__object s0_ LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object AND s1_.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND (s1_.tenant = 1) LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 1) WHERE ((c2_.rt = ? AND ((s1_.schoolType & ?) > 0 OR s1_.department IN (?)) AND s1_.boosted = ? AND s1_.visibility = ? AND s1_.timestamp <= ? AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post')) dctrn_result_inner ORDER BY pinned_50 DESC, timestamp_44 DESC, label_45 ASC) dctrn_result LIMIT 4
Parameters:
[ 149 1 149 1 4 "2024-11-16 14:47:03" 8 8 ] |
20 | 5.57 ms |
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s1_.schoolType AS schoolType_43, s1_.timestamp AS timestamp_44, s1_.label AS label_45, s1_.preview AS preview_46, s1_.media AS media_47, s1_.visibility AS visibility_48, s1_.boosted AS boosted_49, s1_.pinned AS pinned_50, s1_.pinnedAt AS pinnedAt_51, s1_.link AS link_52, s1_.id AS id_53, s1_.createdAt AS createdAt_54, s1_.updatedAt AS updatedAt_55, s1_.touchedAt AS touchedAt_56, c2_.name AS name_57, c2_.slug AS slug_58, c2_.hidden AS hidden_59, c2_.color AS color_60, c2_.code AS code_61, c2_.schoolNowMigrated AS schoolNowMigrated_62, c2_.id AS id_63, c2_.uid AS uid_64, c2_.createdAt AS createdAt_65, c2_.updatedAt AS updatedAt_66, c2_.touchedAt AS touchedAt_67, c2_.rt AS rt_68, c2_.lvl AS lvl_69, c2_.lft AS lft_70, c2_.rgt AS rgt_71, c2_.navigation AS navigation_72, c2_.moduleFlags_alert AS moduleFlags_alert_73, c2_.moduleFlags_blog AS moduleFlags_blog_74, c2_.moduleFlags_calendar AS moduleFlags_calendar_75, c2_.moduleFlags_gallery AS moduleFlags_gallery_76, c2_.moduleFlags_news AS moduleFlags_news_77, c2_.moduleFlags_page AS moduleFlags_page_78, c2_.moduleFlags_people AS moduleFlags_people_79, c2_.moduleFlags_question AS moduleFlags_question_80, c2_.moduleFlags_snippet AS moduleFlags_snippet_81, c2_.moduleFlags_feed AS moduleFlags_feed_82, c2_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_83, c2_.htmlOverrides_headScripts AS htmlOverrides_headScripts_84, c2_.htmlOverrides_topScripts AS htmlOverrides_topScripts_85, c2_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_86, c2_.preferred AS preferred_87, c2_.importIndex AS importIndex_88, c2_.feedSetting_blog AS feedSetting_blog_89, c2_.feedSetting_calendar AS feedSetting_calendar_90, c2_.feedSetting_news AS feedSetting_news_91, c2_.feedSetting_alert AS feedSetting_alert_92, c2_.preferred AS preferred_93, s0_.discr AS discr_94, s0_.school_id AS school_id_95, s0_.department_id AS department_id_96, s0_.tenant AS tenant_97, s0_.createdBy AS createdBy_98, s0_.updatedBy AS updatedBy_99, s0_.touchedBy AS touchedBy_100, s1_.discr AS discr_101, s1_.school AS school_102, s1_.department AS department_103, s1_.tenant AS tenant_104, s1_.createdBy AS createdBy_105, s1_.updatedBy AS updatedBy_106, s1_.touchedBy AS touchedBy_107, s1_.object AS object_108, s1_.draft AS draft_109, c2_._discr AS _discr_110, c2_.parent AS parent_111, c2_.domain AS domain_112, c2_.tenant AS tenant_113, c2_.createdBy AS createdBy_114, c2_.updatedBy AS updatedBy_115, c2_.touchedBy AS touchedBy_116, c2_.defaultTheme AS defaultTheme_117, c2_.defaultOuterLayout AS defaultOuterLayout_118, c2_.defaultInnerLayout AS defaultInnerLayout_119, c2_.account AS account_120, c2_.container AS container_121, c2_.import AS import_122 FROM sn__content__object s0_ LEFT JOIN sys__feed__entry s1_ ON s0_.id = s1_.object AND s1_.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND (s1_.tenant = 1) LEFT JOIN cms__container__container c2_ ON s1_.department = c2_.id AND c2_._discr IN ('generic', 'personal', 'intranet', 'storage') AND (c2_.tenant = 1) WHERE ((c2_.rt = ? AND ((s1_.schoolType & ?) > 0 OR s1_.department IN (?)) AND s1_.boosted = ? AND s1_.visibility = ? AND s1_.timestamp <= ? AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s1_.pinned DESC, s1_.timestamp DESC, s1_.label ASC
Parameters:
[ 149 1 149 1 4 "2024-11-16 14:47:03" 8 8 "01j4w7mp90khzxd91rtmeaxfe3" "01j4vr8m60wt2jb3pznfnbsj9h" "01hygygv3rkf596hw1f4d633ys" "01hydyczc84smz4yht40cnr7nj" ] |
21 | 10.35 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01j4w7mjc085xh2rxjgy8asb7w"
]
|
22 | 0.60 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01hydyby5rpvb9fs2nhwdx9naq"
]
|
23 | 12.31 ms |
SELECT t0.title AS title_1, t0.listHtml AS listHtml_2, t0.viewMode AS viewMode_3, t0.shares AS shares_4, t0.selections AS selections_5, t0.id AS id_6, t0.uid AS uid_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.touchedAt AS touchedAt_10, t0.innerLayout AS innerLayout_11, t0.container AS container_12, t0.tenant AS tenant_13, t0.createdBy AS createdBy_14, t0.updatedBy AS updatedBy_15, t0.touchedBy AS touchedBy_16 FROM cms__modules__calendar__module_settings t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
24 | 35.35 ms |
SELECT c0_.placeholder AS placeholder_0, c0_.id AS id_1, c0_.uid AS uid_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4, c0_.touchedAt AS touchedAt_5, c0_.lockedAt AS lockedAt_6, c0_.lockRefreshedAt AS lockRefreshedAt_7, c0_.data_title AS data_title_8, c0_.data_slug AS data_slug_9, c0_.data_startDate AS data_startDate_10, c0_.data_startDateDisplay AS data_startDateDisplay_11, c0_.data_endDate AS data_endDate_12, c0_.data_endDateDisplay AS data_endDateDisplay_13, c0_.data_abstract AS data_abstract_14, c0_.data_description AS data_description_15, c0_.data_location AS data_location_16, c0_.data_locationLink AS data_locationLink_17, c0_.data_allDay AS data_allDay_18, c0_.data_attachments AS data_attachments_19, c0_.sharedChecksum AS sharedChecksum_20, c0_.syncUid AS syncUid_21, c0_.syncToken AS syncToken_22, c0_.importIndex AS importIndex_23, c0_.data_standardMetadata_title AS data_standardMetadata_title_24, c0_.data_standardMetadata_description AS data_standardMetadata_description_25, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_26, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_27, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_28, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_29, c0_.data_social_socialImage AS data_social_socialImage_30, c0_.data_social_facebookImage AS data_social_facebookImage_31, c0_.data_social_twitterImage AS data_social_twitterImage_32, c0_.container AS container_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.lockedBy AS lockedBy_38, c0_.socialImage AS socialImage_39, c0_.data_tag0 AS data_tag0_40, c0_.data_tag1 AS data_tag1_41, c0_.data_tag2 AS data_tag2_42, c0_.data_tag3 AS data_tag3_43, c0_.data_tag4 AS data_tag4_44, c0_.data_tag5 AS data_tag5_45, c0_.data_tag6 AS data_tag6_46, c0_.data_tag7 AS data_tag7_47, c0_.data_tag8 AS data_tag8_48, c0_.data_tag9 AS data_tag9_49, c0_.data_tag10 AS data_tag10_50, c0_.data_tag11 AS data_tag11_51, c0_.sync AS sync_52, c0_.import AS import_53, c0_.history AS history_54, c0_.draft AS draft_55, c0_.sharedProxy AS sharedProxy_56 FROM cms__modules__calendar__event__proxy c0_ WHERE (c0_.container IN (?) AND (((c0_.data_startDate >= ? AND c0_.data_startDate < ?) OR (c0_.data_endDate > ? AND c0_.data_endDate < ?) OR (c0_.data_startDate < ? AND c0_.data_endDate >= ?)))) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_startDate ASC, c0_.data_endDate ASC
Parameters:
[ 149 "2024-11-01 04:00:00" "2024-12-01 05:00:00" "2024-11-01 04:00:00" "2024-12-01 05:00:00" "2024-11-01 04:00:00" "2024-12-01 05:00:00" ] |
25 | 0.73 ms |
SELECT t0.title AS title_1, t0.listHtml AS listHtml_2, t0.viewMode AS viewMode_3, t0.shares AS shares_4, t0.selections AS selections_5, t0.id AS id_6, t0.uid AS uid_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.touchedAt AS touchedAt_10, t0.innerLayout AS innerLayout_11, t0.container AS container_12, t0.tenant AS tenant_13, t0.createdBy AS createdBy_14, t0.updatedBy AS updatedBy_15, t0.touchedBy AS touchedBy_16 FROM cms__modules__calendar__module_settings t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
26 | 2.84 ms |
SELECT c0_.placeholder AS placeholder_0, c0_.id AS id_1, c0_.uid AS uid_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4, c0_.touchedAt AS touchedAt_5, c0_.lockedAt AS lockedAt_6, c0_.lockRefreshedAt AS lockRefreshedAt_7, c0_.data_title AS data_title_8, c0_.data_slug AS data_slug_9, c0_.data_startDate AS data_startDate_10, c0_.data_startDateDisplay AS data_startDateDisplay_11, c0_.data_endDate AS data_endDate_12, c0_.data_endDateDisplay AS data_endDateDisplay_13, c0_.data_abstract AS data_abstract_14, c0_.data_description AS data_description_15, c0_.data_location AS data_location_16, c0_.data_locationLink AS data_locationLink_17, c0_.data_allDay AS data_allDay_18, c0_.data_attachments AS data_attachments_19, c0_.sharedChecksum AS sharedChecksum_20, c0_.syncUid AS syncUid_21, c0_.syncToken AS syncToken_22, c0_.importIndex AS importIndex_23, c0_.data_standardMetadata_title AS data_standardMetadata_title_24, c0_.data_standardMetadata_description AS data_standardMetadata_description_25, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_26, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_27, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_28, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_29, c0_.data_social_socialImage AS data_social_socialImage_30, c0_.data_social_facebookImage AS data_social_facebookImage_31, c0_.data_social_twitterImage AS data_social_twitterImage_32, c0_.container AS container_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.lockedBy AS lockedBy_38, c0_.socialImage AS socialImage_39, c0_.data_tag0 AS data_tag0_40, c0_.data_tag1 AS data_tag1_41, c0_.data_tag2 AS data_tag2_42, c0_.data_tag3 AS data_tag3_43, c0_.data_tag4 AS data_tag4_44, c0_.data_tag5 AS data_tag5_45, c0_.data_tag6 AS data_tag6_46, c0_.data_tag7 AS data_tag7_47, c0_.data_tag8 AS data_tag8_48, c0_.data_tag9 AS data_tag9_49, c0_.data_tag10 AS data_tag10_50, c0_.data_tag11 AS data_tag11_51, c0_.sync AS sync_52, c0_.import AS import_53, c0_.history AS history_54, c0_.draft AS draft_55, c0_.sharedProxy AS sharedProxy_56 FROM cms__modules__calendar__event__proxy c0_ WHERE (c0_.container IN (?) AND (c0_.data_startDate >= ? OR c0_.data_endDate > ?)) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_startDate ASC, c0_.data_endDate ASC LIMIT 3
Parameters:
[ 149 "2024-11-16 05:00:00" "2024-11-16 05:00:00" ] |
27 | 0.84 ms |
SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_.importIndex AS importIndex_31, c0_.feedSetting_blog AS feedSetting_blog_32, c0_.feedSetting_calendar AS feedSetting_calendar_33, c0_.feedSetting_news AS feedSetting_news_34, c0_.feedSetting_alert AS feedSetting_alert_35, c0_.preferred AS preferred_36, c0_._discr AS _discr_37, c0_.parent AS parent_38, c0_.domain AS domain_39, c0_.tenant AS tenant_40, c0_.createdBy AS createdBy_41, c0_.updatedBy AS updatedBy_42, c0_.touchedBy AS touchedBy_43, c0_.defaultTheme AS defaultTheme_44, c0_.defaultOuterLayout AS defaultOuterLayout_45, c0_.defaultInnerLayout AS defaultInnerLayout_46, c0_.account AS account_47, c0_.container AS container_48, c0_.import AS import_49 FROM cms__container__container c0_ WHERE ((c0_.rt = ? AND c0_.lft < ? AND c0_.rgt > ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic', 'personal', 'intranet', 'storage') ORDER BY c0_.lft ASC
Parameters:
[ 149 1 24 ] |
28 | 2.23 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.department = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
29 | 3.61 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s0_.discr AS discr_43 FROM sn__content__object s0_ WHERE ((s0_.discr IN ('exhibits.gallery', 'exhibits.video') AND s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC) dctrn_result) dctrn_table
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 ] |
30 | 3.56 ms |
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, touchedAt_13, headline_14 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s0_.discr AS discr_43 FROM sn__content__object s0_ WHERE ((s0_.discr IN ('exhibits.gallery', 'exhibits.video') AND s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post')) dctrn_result_inner ORDER BY touchedAt_13 DESC, headline_14 ASC) dctrn_result LIMIT 3
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 ] |
31 | 1.12 ms |
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.startsAt AS startsAt_17, s0_.stopsAt AS stopsAt_18, s0_.blurb AS blurb_19, s0_.details AS details_20, s0_.html AS html_21, s0_.slug AS slug_22, s0_.startsAt AS startsAt_23, s0_.stopsAt AS stopsAt_24, s0_.blurb AS blurb_25, s0_.details AS details_26, s0_.html AS html_27, s0_.slug AS slug_28, s0_.media AS media_29, s0_.blurb AS blurb_30, s0_.slug AS slug_31, s0_.media AS media_32, s0_.html AS html_33, s0_.blurb AS blurb_34, s0_.slug AS slug_35, s0_.media AS media_36, s0_.blurb AS blurb_37, s0_.details AS details_38, s0_.html AS html_39, s0_.slug AS slug_40, s0_.media AS media_41, s0_.link AS link_42, s0_.discr AS discr_43, s0_.school_id AS school_id_44, s0_.department_id AS department_id_45, s0_.tenant AS tenant_46, s0_.createdBy AS createdBy_47, s0_.updatedBy AS updatedBy_48, s0_.touchedBy AS touchedBy_49 FROM sn__content__object s0_ WHERE ((s0_.discr IN ('exhibits.gallery', 'exhibits.video') AND s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('alerts.alert', 'events.event', 'exhibits.gallery', 'exhibits.video', 'posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 "01h7zv35t0h5sadrk5pj0xx8jv" "01h66xzv8gny8s8b30aybrj6br" "01h66y5ns8jydpex6ta0cgk723" ] |
32 | 0.73 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01h7zv35t0h5sadrk5pj0xx8jv"
]
|
33 | 0.76 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01h66xzv8gny8s8b30aybrj6br"
]
|
34 | 0.67 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01h66y5ns8jydpex6ta0cgk723"
]
|
35 | 5.74 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01h7zv21nrbn3j8kcm0jaa5ejr"
]
|
36 | 0.62 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01h66xydbr49z6d2pya59sm1wp"
]
|
37 | 0.84 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.department = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
38 | 1.83 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC) dctrn_result) dctrn_table
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 ] |
39 | 1.93 ms |
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, touchedAt_13, headline_14 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post')) dctrn_result_inner ORDER BY touchedAt_13 DESC, headline_14 ASC) dctrn_result LIMIT 3
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 ] |
40 | 1.01 ms |
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23, s0_.school_id AS school_id_24, s0_.department_id AS department_id_25, s0_.tenant AS tenant_26, s0_.createdBy AS createdBy_27, s0_.updatedBy AS updatedBy_28, s0_.touchedBy AS touchedBy_29 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 "01j4w7mp90khzxd91rtmeaxfe3" "01j4vr8m60wt2jb3pznfnbsj9h" "01hygygv3rkf596hw1f4d633ys" ] |
41 | 2.09 ms |
SELECT t0.name AS name_1, t0.type AS type_2, t0.oneRosterOrg AS oneRosterOrg_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.ulid AS ulid_9, t0.details_phone AS details_phone_10, t0.details_fax AS details_fax_11, t0.details_links AS details_links_12, t0.details_inquiryEmails AS details_inquiryEmails_13, t0.details_checkupEmails AS details_checkupEmails_14, t0.details_sisUrl AS details_sisUrl_15, t0.details_contactManagement AS details_contactManagement_16, t0.details_address_recipient AS details_address_recipient_17, t0.details_address_organization AS details_address_organization_18, t0.details_address_street AS details_address_street_19, t0.details_address_unit AS details_address_unit_20, t0.details_address_city AS details_address_city_21, t0.details_address_state AS details_address_state_22, t0.details_address_postalCode AS details_address_postalCode_23, t0.details_address_country AS details_address_country_24, t0.branding_bust AS branding_bust_25, t0.branding_images AS branding_images_26, t0.branding_colorPrimary AS branding_colorPrimary_27, t0.branding_colorSecondary AS branding_colorSecondary_28, t0.branding_colorTertiary AS branding_colorTertiary_29, t0.branding_colorMobileHeader AS branding_colorMobileHeader_30, t0.branding_colorMobileText AS branding_colorMobileText_31, t0.mobile_shortcuts AS mobile_shortcuts_32, t0.mobile_directoryUrl AS mobile_directoryUrl_33, t0.department AS department_34, t0.tenant AS tenant_35, t0.createdBy AS createdBy_36, t0.updatedBy AS updatedBy_37, t0.touchedBy AS touchedBy_38 FROM sys__school t0 WHERE t0.department = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
42 | 1.67 ms |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_10 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC) dctrn_result) dctrn_table
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 ] |
43 | 1.87 ms |
SELECT DISTINCT id_10 FROM (SELECT DISTINCT id_10, touchedAt_13, headline_14 FROM (SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ?) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post')) dctrn_result_inner ORDER BY touchedAt_13 DESC, headline_14 ASC) dctrn_result LIMIT 9
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 ] |
44 | 1.09 ms |
SELECT s0_.schoolTypes AS schoolTypes_0, s0_.visibility AS visibility_1, s0_.migrationId AS migrationId_2, s0_.migrationUid AS migrationUid_3, s0_.scheduledAt AS scheduledAt_4, s0_.channels AS channels_5, s0_.websiteBehavior AS websiteBehavior_6, s0_.websiteLevel AS websiteLevel_7, s0_.websiteEndDateTime AS websiteEndDateTime_8, s0_.socialPosts AS socialPosts_9, s0_.id AS id_10, s0_.createdAt AS createdAt_11, s0_.updatedAt AS updatedAt_12, s0_.touchedAt AS touchedAt_13, s0_.headline AS headline_14, s0_.timestamp AS timestamp_15, s0_.semaphore AS semaphore_16, s0_.blurb AS blurb_17, s0_.details AS details_18, s0_.html AS html_19, s0_.slug AS slug_20, s0_.media AS media_21, s0_.link AS link_22, s0_.discr AS discr_23, s0_.school_id AS school_id_24, s0_.department_id AS department_id_25, s0_.tenant AS tenant_26, s0_.createdBy AS createdBy_27, s0_.updatedBy AS updatedBy_28, s0_.touchedBy AS touchedBy_29 FROM sn__content__object s0_ WHERE ((s0_.visibility = ? AND s0_.createdAt <= ? AND (s0_.department_id = ? OR (s0_.schoolTypes & ?) > 0) AND (s0_.channels & ?) = ? AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (s0_.tenant = 1)) AND s0_.discr IN ('posts.post') ORDER BY s0_.touchedAt DESC, s0_.headline ASC
Parameters:
[ 4 "2024-11-16 14:47:04" 149 1 8 8 "01j4w7mp90khzxd91rtmeaxfe3" "01j4vr8m60wt2jb3pznfnbsj9h" "01hygygv3rkf596hw1f4d633ys" "01hydyczc84smz4yht40cnr7nj" "01hybk94h0at5dsdq9rj40jx61" "01hvs6m6y0qt3hgfdn0vfsgfqx" "01hvmc98203ax37g84zd1wyj3r" "01hkdjyexr13z2k460hzwe7qke" "01hke15gegykf2g34bkvnwj751" ] |
45 | 0.65 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01hybk94h0at5dsdq9rj40jx61"
]
|
46 | 0.64 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01hvs6m6y0qt3hgfdn0vfsgfqx"
]
|
47 | 0.84 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01hvmc98203ax37g84zd1wyj3r"
]
|
48 | 0.72 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01hkdjyexr13z2k460hzwe7qke"
]
|
49 | 0.66 ms |
SELECT t0.schoolType AS schoolType_1, t0.timestamp AS timestamp_2, t0.label AS label_3, t0.preview AS preview_4, t0.media AS media_5, t0.visibility AS visibility_6, t0.boosted AS boosted_7, t0.pinned AS pinned_8, t0.pinnedAt AS pinnedAt_9, t0.link AS link_10, t0.id AS id_11, t0.createdAt AS createdAt_12, t0.updatedAt AS updatedAt_13, t0.touchedAt AS touchedAt_14, t0.school AS school_15, t0.department AS department_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20, t0.object AS object_21, t0.draft AS draft_22, t0.discr FROM sys__feed__entry t0 WHERE t0.object = ? AND t0.discr IN ('content', 'content.events.event', 'content.exhibits.gallery', 'content.posts.post', 'content.exhibits.video') AND ((t0.tenant = 1))
Parameters:
[
"01hke15gegykf2g34bkvnwj751"
]
|
50 | 0.66 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01hybk7zdg4cmfgws16nfqp3k2"
]
|
51 | 0.56 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01hvs6kmc8x1c5n6yp8vnrp7fr"
]
|
52 | 0.52 ms |
SELECT t0.type AS type_1, t0.status AS status_2, t0.name AS name_3, t0.fileName AS fileName_4, t0.fileExtension AS fileExtension_5, t0.migrationId AS migrationId_6, t0.migrationUid AS migrationUid_7, t0.remoteJobId AS remoteJobId_8, t0.id AS id_9, t0.createdAt AS createdAt_10, t0.updatedAt AS updatedAt_11, t0.touchedAt AS touchedAt_12, t0.folder AS folder_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17 FROM sys__filesystem__temp_file t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
"01hvmc8fmr6grzek4t4bjx9s4n"
]
|
53 | 14.55 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.intranet AS intranet_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.contents AS contents_9, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_10, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_11, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_12, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_13, t0.theme AS theme_14, t0.tenant AS tenant_15, t0.createdBy AS createdBy_16, t0.updatedBy AS updatedBy_17, t0.touchedBy AS touchedBy_18 FROM cms__theme__inner_layout t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
2
]
|
54 | 18.85 ms |
SELECT t0.name AS name_1, t0.description AS description_2, t0.base AS base_3, t0.intranet AS intranet_4, t0.adaFooter AS adaFooter_5, t0.id AS id_6, t0.uid AS uid_7, t0.createdAt AS createdAt_8, t0.updatedAt AS updatedAt_9, t0.touchedAt AS touchedAt_10, t0.contents AS contents_11, t0.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_12, t0.htmlOverrides_headScripts AS htmlOverrides_headScripts_13, t0.htmlOverrides_topScripts AS htmlOverrides_topScripts_14, t0.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_15, t0.template AS template_16, t0.tenant AS tenant_17, t0.createdBy AS createdBy_18, t0.updatedBy AS updatedBy_19, t0.touchedBy AS touchedBy_20 FROM cms__theme__outer_layout t0 WHERE t0.id = ? AND ((t0.tenant = 1))
Parameters:
[
1
]
|
55 | 0.84 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.parent AS parent_31, t0.domain AS domain_32, t0.tenant AS tenant_33, t0.createdBy AS createdBy_34, t0.updatedBy AS updatedBy_35, t0.touchedBy AS touchedBy_36, t0.defaultTheme AS defaultTheme_37, t0.defaultOuterLayout AS defaultOuterLayout_38, t0.defaultInnerLayout AS defaultInnerLayout_39, t0._discr, t0.preferred AS preferred_40, t0.importIndex AS importIndex_41, t0.account AS account_42, t0.container AS container_43, t0.import AS import_44, t0.feedSetting_blog AS feedSetting_blog_45, t0.feedSetting_calendar AS feedSetting_calendar_46, t0.feedSetting_news AS feedSetting_news_47, t0.feedSetting_alert AS feedSetting_alert_48, t0.preferred AS preferred_49 FROM cms__container__container t0 WHERE t0.id = ? AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1))
Parameters:
[
10814
]
|
56 | 12.11 ms |
SELECT t0.title AS title_1, t0.listHtml AS listHtml_2, t0.shares AS shares_3, t0.id AS id_4, t0.uid AS uid_5, t0.createdAt AS createdAt_6, t0.updatedAt AS updatedAt_7, t0.touchedAt AS touchedAt_8, t0.innerLayout AS innerLayout_9, t0.container AS container_10, t0.tenant AS tenant_11, t0.createdBy AS createdBy_12, t0.updatedBy AS updatedBy_13, t0.touchedBy AS touchedBy_14 FROM cms__modules__alert__module_settings t0 WHERE t0.container = ? AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
]
|
57 | 33.76 ms |
SELECT c0_.placeholder AS placeholder_0, c0_.id AS id_1, c0_.uid AS uid_2, c0_.createdAt AS createdAt_3, c0_.updatedAt AS updatedAt_4, c0_.touchedAt AS touchedAt_5, c0_.lockedAt AS lockedAt_6, c0_.lockRefreshedAt AS lockRefreshedAt_7, c0_.data_title AS data_title_8, c0_.data_slug AS data_slug_9, c0_.data_startDate AS data_startDate_10, c0_.data_expiryDate AS data_expiryDate_11, c0_.data_abstract AS data_abstract_12, c0_.data_content AS data_content_13, c0_.data_externalLink AS data_externalLink_14, c0_.data_level AS data_level_15, c0_.data_behavior AS data_behavior_16, c0_.sharedChecksum AS sharedChecksum_17, c0_.importIndex AS importIndex_18, c0_.data_standardMetadata_title AS data_standardMetadata_title_19, c0_.data_standardMetadata_description AS data_standardMetadata_description_20, c0_.data_standardMetadata_keywords AS data_standardMetadata_keywords_21, c0_.data_standardMetadata_noIndex AS data_standardMetadata_noIndex_22, c0_.data_standardMetadata_noFollow AS data_standardMetadata_noFollow_23, c0_.data_standardMetadata_robots AS data_standardMetadata_robots_24, c0_.data_social_socialImage AS data_social_socialImage_25, c0_.data_social_facebookImage AS data_social_facebookImage_26, c0_.data_social_twitterImage AS data_social_twitterImage_27, c0_.container AS container_28, c0_.tenant AS tenant_29, c0_.createdBy AS createdBy_30, c0_.updatedBy AS updatedBy_31, c0_.touchedBy AS touchedBy_32, c0_.lockedBy AS lockedBy_33, c0_.socialImage AS socialImage_34, c0_.data_tag0 AS data_tag0_35, c0_.data_tag1 AS data_tag1_36, c0_.data_tag2 AS data_tag2_37, c0_.data_tag3 AS data_tag3_38, c0_.data_tag4 AS data_tag4_39, c0_.data_tag5 AS data_tag5_40, c0_.data_tag6 AS data_tag6_41, c0_.data_tag7 AS data_tag7_42, c0_.data_tag8 AS data_tag8_43, c0_.data_tag9 AS data_tag9_44, c0_.data_tag10 AS data_tag10_45, c0_.data_tag11 AS data_tag11_46, c0_.import AS import_47, c0_.history AS history_48, c0_.draft AS draft_49, c0_.sharedProxy AS sharedProxy_50 FROM cms__modules__alert__alert__proxy c0_ WHERE (c0_.container IN (?) AND c0_.data_startDate <= ? AND c0_.data_expiryDate >= ?) AND (c0_.placeholder = 0) AND (c0_.tenant = 1) ORDER BY c0_.data_level ASC, c0_.data_startDate ASC, c0_.data_expiryDate ASC LIMIT 6
Parameters:
[ 149 "2024-11-16 14:47:04" "2024-11-16 14:47:04" ] |
58 | 7.29 ms |
SELECT c0_.name AS name_0, c0_.httpsUpgrade AS httpsUpgrade_1, c0_.id AS id_2, c0_.uid AS uid_3, c0_.createdAt AS createdAt_4, c0_.updatedAt AS updatedAt_5, c0_.touchedAt AS touchedAt_6, c0_.dnsLookupAt AS dnsLookupAt_7, c0_.dnsLookupResult AS dnsLookupResult_8, c0_.redirection_enabled AS redirection_enabled_9, c0_.redirection_host AS redirection_host_10, c0_.redirection_path AS redirection_path_11, c0_.redirection_appendPath AS redirection_appendPath_12, c0_.redirection_query AS redirection_query_13, c0_.redirection_appendQuery AS redirection_appendQuery_14, c0_.redirection_code AS redirection_code_15, c0_.apex AS apex_16, c0_.certificate AS certificate_17, c0_.tenant AS tenant_18, c0_.createdBy AS createdBy_19, c0_.updatedBy AS updatedBy_20, c0_.touchedBy AS touchedBy_21 FROM cms__domain__domain c0_ LEFT JOIN cms__domain__apex c1_ ON c0_.apex = c1_.id AND (c1_.tenant = 1) WHERE ((c0_.name = ? AND c1_.host = ?) OR (c0_.name = ? AND c1_.host = ?)) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[ "" "wcsd.fallhaven.org" "wcsd" "fallhaven.org" ] |
59 | 1.23 ms |
SELECT c0_.name AS name_0, c0_.slug AS slug_1, c0_.hidden AS hidden_2, c0_.color AS color_3, c0_.code AS code_4, c0_.schoolNowMigrated AS schoolNowMigrated_5, c0_.id AS id_6, c0_.uid AS uid_7, c0_.createdAt AS createdAt_8, c0_.updatedAt AS updatedAt_9, c0_.touchedAt AS touchedAt_10, c0_.rt AS rt_11, c0_.lvl AS lvl_12, c0_.lft AS lft_13, c0_.rgt AS rgt_14, c0_.navigation AS navigation_15, c0_.moduleFlags_alert AS moduleFlags_alert_16, c0_.moduleFlags_blog AS moduleFlags_blog_17, c0_.moduleFlags_calendar AS moduleFlags_calendar_18, c0_.moduleFlags_gallery AS moduleFlags_gallery_19, c0_.moduleFlags_news AS moduleFlags_news_20, c0_.moduleFlags_page AS moduleFlags_page_21, c0_.moduleFlags_people AS moduleFlags_people_22, c0_.moduleFlags_question AS moduleFlags_question_23, c0_.moduleFlags_snippet AS moduleFlags_snippet_24, c0_.moduleFlags_feed AS moduleFlags_feed_25, c0_.htmlOverrides_bodyClass AS htmlOverrides_bodyClass_26, c0_.htmlOverrides_headScripts AS htmlOverrides_headScripts_27, c0_.htmlOverrides_topScripts AS htmlOverrides_topScripts_28, c0_.htmlOverrides_bottomScripts AS htmlOverrides_bottomScripts_29, c0_.preferred AS preferred_30, c0_._discr AS _discr_31, c0_.parent AS parent_32, c0_.domain AS domain_33, c0_.tenant AS tenant_34, c0_.createdBy AS createdBy_35, c0_.updatedBy AS updatedBy_36, c0_.touchedBy AS touchedBy_37, c0_.defaultTheme AS defaultTheme_38, c0_.defaultOuterLayout AS defaultOuterLayout_39, c0_.defaultInnerLayout AS defaultInnerLayout_40 FROM cms__container__container c0_ WHERE ((c0_.parent IS NULL AND c0_.domain = ?) AND (c0_.tenant = 1)) AND c0_._discr IN ('generic') LIMIT 1
Parameters:
[
12
]
|
60 | 1.11 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.parent AS parent_31, t0.domain AS domain_32, t0.tenant AS tenant_33, t0.createdBy AS createdBy_34, t0.updatedBy AS updatedBy_35, t0.touchedBy AS touchedBy_36, t0.defaultTheme AS defaultTheme_37, t0.defaultOuterLayout AS defaultOuterLayout_38, t0.defaultInnerLayout AS defaultInnerLayout_39, t0._discr, t0.preferred AS preferred_40, t0.importIndex AS importIndex_41, t0.account AS account_42, t0.container AS container_43, t0.import AS import_44, t0.feedSetting_blog AS feedSetting_blog_45, t0.feedSetting_calendar AS feedSetting_calendar_46, t0.feedSetting_news AS feedSetting_news_47, t0.feedSetting_alert AS feedSetting_alert_48, t0.preferred AS preferred_49 FROM cms__container__container t0 WHERE t0.parent = ? AND t0.slug = ? AND t0._discr IN ('generic', 'personal', 'intranet', 'storage') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
149
""
]
|
61 | 0.78 ms |
SELECT c0_.id AS id_0, c0_.uid AS uid_1, c0_.createdAt AS createdAt_2, c0_.updatedAt AS updatedAt_3, c0_.touchedAt AS touchedAt_4, c0_.container AS container_5, c0_.tenant AS tenant_6, c0_.createdBy AS createdBy_7, c0_.updatedBy AS updatedBy_8, c0_.touchedBy AS touchedBy_9 FROM cms__modules__page__module_settings c0_ WHERE (c0_.container = ?) AND (c0_.tenant = 1) LIMIT 1
Parameters:
[
149
]
|
62 | 58.76 ms |
SELECT t0.name AS name_1, t0.auto AS auto_2, t0.id AS id_3, t0.uid AS uid_4, t0.createdAt AS createdAt_5, t0.updatedAt AS updatedAt_6, t0.touchedAt AS touchedAt_7, t0.tenant AS tenant_8, t0.createdBy AS createdBy_9, t0.updatedBy AS updatedBy_10, t0.touchedBy AS touchedBy_11, t0._discr, t0.facebookPageId AS facebookPageId_12, t0.facebookUserId AS facebookUserId_13, t0.facebookUserName AS facebookUserName_14, t0.facebookAccessToken AS facebookAccessToken_15, t0.twitterUserId AS twitterUserId_16, t0.twitterUserName AS twitterUserName_17, t0.twitterAccessToken AS twitterAccessToken_18, t0.twitterTokenSecret AS twitterTokenSecret_19 FROM smm__account t0 WHERE t0._discr IN ('facebook', 'twitter') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[] |
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.