https://wcsd.fallhaven.org/files/images/secondary%20logo.png

Query Metrics

20 Database Queries
14 Different statements
40.87 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.72 ms
(21.33%)
2
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:
[]
8.64 ms
(21.13%)
1
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.65 ms
(8.93%)
1
SELECT t0.name AS name_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.rt AS rt_7, t0.lvl AS lvl_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.description AS description_11, t0.parent AS parent_12, t0.container AS container_13, t0.tenant AS tenant_14, t0.createdBy AS createdBy_15, t0.updatedBy AS updatedBy_16, t0.touchedBy AS touchedBy_17, t0._discr FROM cms__file__node t0 WHERE t0.container = ? AND t0.parent IS NULL AND t0.name = ? AND t0._discr IN ('folder') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
  "images"
]
3.18 ms
(7.77%)
2
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.uid = ? AND ((t0.tenant = 1))
Parameters:
[
  "886fe8ea-b838-11e7-9094-080027873a16"
]
2.96 ms
(7.25%)
3
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"
]
2.73 ms
(6.67%)
1
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.60 ms
(6.36%)
2
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
]
2.18 ms
(5.33%)
2
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
  "files"
]
1.40 ms
(3.42%)
1
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
]
1.36 ms
(3.33%)
1
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
  "/files/images/secondary%20logo.png"
  "/files/images/secondary%20logo.png/"
]
1.01 ms
(2.48%)
1
SELECT t0.name AS name_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.rt AS rt_7, t0.lvl AS lvl_8, t0.lft AS lft_9, t0.rgt AS rgt_10, t0.status AS status_11, t0.extension AS extension_12, t0.mime AS mime_13, t0.description AS description_14, t0.size AS size_15, t0.uploadedAt AS uploadedAt_16, t0.note AS note_17, t0.flags AS flags_18, t0.parent AS parent_19, t0.container AS container_20, t0.tenant AS tenant_21, t0.createdBy AS createdBy_22, t0.updatedBy AS updatedBy_23, t0.touchedBy AS touchedBy_24, t0.uploadedBy AS uploadedBy_25, t0._discr, t0.optimization_cropSquare AS optimization_cropSquare_26, t0.optimization_cropRectangle AS optimization_cropRectangle_27, t0.optimization_cropWide AS optimization_cropWide_28, t0.optimization_processing AS optimization_processing_29, t0.documentMeta_pages AS documentMeta_pages_30 FROM cms__file__node t0 WHERE t0.container = ? AND t0.parent = ? AND t0.name = ? AND t0.extension = ? AND t0._discr IN ('file', 'generic', 'image', 'document') AND ((t0.tenant = 1)) LIMIT 1
Parameters:
[
  149
  756
  "secondary logo"
  "png"
]
0.97 ms
(2.38%)
1
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 = ? OR c0_.source = ? OR c0_.source = ? OR c0_.source = ?)) AND (c0_.tenant = 1)
Parameters:
[
  12
  "/*"
  "/files/*"
  "/files/images/*"
  "/files/images/secondary%20logo.png/*"
]
0.79 ms
(1.92%)
1
SELECT t0.name AS name_1, t0.slug AS slug_2, t0.status AS status_3, t0.emailsDisplay AS emailsDisplay_4, t0.policy AS policy_5, t0.disqusId AS disqusId_6, t0.googleToken AS googleToken_7, t0.stage AS stage_8, t0.teamworkTasklist AS teamworkTasklist_9, t0.latitude AS latitude_10, t0.longitude AS longitude_11, t0.redirects AS redirects_12, t0.redirectCodes AS redirectCodes_13, t0.debugging AS debugging_14, t0.products AS products_15, t0.hubspotId AS hubspotId_16, t0.weglotId AS weglotId_17, t0.id AS id_18, t0.uid AS uid_19, t0.createdAt AS createdAt_20, t0.updatedAt AS updatedAt_21, t0.touchedAt AS touchedAt_22, t0.data_custom0 AS data_custom0_23, t0.data_custom1 AS data_custom1_24, t0.data_custom2 AS data_custom2_25, t0.data_custom3 AS data_custom3_26, t0.authenticationTypes AS authenticationTypes_27, t0.classlinkCustomerId AS classlinkCustomerId_28, t0.cleverCustomerId AS cleverCustomerId_29, t0.gg4lCustomerId AS gg4lCustomerId_30, t0.googleCustomerId AS googleCustomerId_31, t0.microsoftCustomerId AS microsoftCustomerId_32, t0.ulid AS ulid_33, t0.locale_timezone AS locale_timezone_34, t0.ada_reportsFolder AS ada_reportsFolder_35, t0.ada_reportsPrimary AS ada_reportsPrimary_36, t0.ada_reportsDocuments AS ada_reportsDocuments_37, t0.type_primary AS type_primary_38, t0.type_secondary AS type_secondary_39 FROM cms__tenant__tenant t0 WHERE t0.id = ?
Parameters:
[
  1
]
0.69 ms
(1.70%)
1
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
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
Cms\DomainBundle\Entity\Domain No errors.
Cms\DomainBundle\Entity\Apex No errors.
Cms\DomainBundle\Entity\SslCertificate No errors.
Cms\TenantBundle\Entity\Tenant No errors.
Platform\SecurityBundle\Entity\Identity\Account No errors.
Cms\DomainBundle\Entity\SslCertificates\CustomSslCertificate No errors.
Cms\DomainBundle\Entity\SslCertificates\LetsEncryptSslCertificate No errors.
Cms\RedirectBundle\Entity\Redirect No errors.
Cms\ContainerBundle\Entity\Containers\GenericContainer No errors.
Cms\ContainerBundle\Entity\Container No errors.
Cms\ThemeBundle\Entity\Template No errors.
Cms\ThemeBundle\Entity\OuterLayout No errors.
Cms\ThemeBundle\Entity\InnerLayout No errors.
Cms\ContainerBundle\Entity\Containers\PersonalContainer No errors.
Cms\ImportBundle\Entity\Import No errors.
Cms\ContainerBundle\Entity\Containers\IntranetContainer No errors.
Cms\ContainerBundle\Entity\Containers\StorageContainer No errors.
Platform\SecurityBundle\Entity\Access\RoleAssociation\AccountRoleAssociation No errors.
App\Entity\OAuth2\Admin\AbstractAdminToken No errors.
Products\SocialBundle\Entity\SocialAccount No errors.
Products\SocialBundle\Entity\SocialAccounts\FacebookSocialAccount No errors.
Products\SocialBundle\Entity\SocialAccounts\TwitterSocialAccount No errors.
Cms\FileBundle\Entity\Nodes\Folder No errors.
Cms\FileBundle\Entity\Node No errors.
Cms\FileBundle\Entity\Nodes\File No errors.
Cms\FileBundle\Entity\Nodes\Files\GenericFile No errors.
Cms\FileBundle\Entity\Nodes\Files\ImageFile No errors.
Cms\FileBundle\Entity\Nodes\Files\DocumentFile No errors.