BROWSE OUR VISUAL CONTENT PROVIDER DIRECTORY

 

CLICK THE BANNER TO LEARN MORE
 



 
WE ARE THE PREMIER ONE-STOP WEBSITE
CILC BENEFITS
FOR UNIQUE INTERACTIVE OFFERINGS
 

VirtualExpeditionAd1134by162_August2017-(1).jpg

 
CLICK THE BANNER TO LEARN MORE
 

Connected North • Canada


Newest Programs

 


QUICK START PROGRAM SEARCH


  

 

 

FOLLOW US
ADDRESS
Center for Interactive Learning and Collaboration
2075 Lookout Drive
North Mankato, MN 56003
SUPPORT MENU
© 2016 Center for Interactive Learning and Collaboration Privacy Policy
SQL queries called by this request / thread:
 (Query name)
Query text
Parameters: @name (value)
Results: tablename (rows [columns], size)
ContextDuration
1
(SELECT * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (DocumentUrlPath = N'/Detail-Master/Home') AND (DocumentUrlPath <> NodeAliasPath)))
UNION ALL
(SELECT TOP 2 * FROM View_PageInfo WHERE ((NodeSiteID = 1) AND (NodeAliasPath = N'/Detail-Master/Home') AND ([DocumentCulture] = N'en-US')))
Table (1 [67], 8 kB)
 
SimpleHandler`2.StartEvent 0.016
 
2
(cms.document.selectdocuments)
SELECT * FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Detail-Master', N'/')) AND [DocumentCulture] = @DocumentCulture ORDER BY NodeLevel DESC
@NodeSiteID (1)
@DocumentCulture ("en-US")
192 B
 
Table (2 [172], 8.7 kB)
 
SimpleHandler`2.StartEvent 0.000
 
3
(cms.menuitem.selectdocuments)
SELECT * FROM View_CONTENT_MenuItem_Joined WHERE ([DocumentCulture] = N'en-US') AND (NodeID = 582)
Table (1 [176], 8.8 kB)
 
SimpleHandler`2.StartEvent 0.000
 
4
(cms.class.selectrequiredroles)
SELECT * FROM CMS_Role WHERE RoleID IN (SELECT RoleID FROM CMS_RolePermission WHERE PermissionID IN (SELECT PermissionID FROM CMS_Permission WHERE ClassID=@ClassID AND PermissionName=@PermissionName)) AND (SiteID=@SiteID OR SiteID IS NULL)
@ClassID (4609)
@PermissionName ("read")
@SiteID (1)
251 B
 
Table (1 [10], 112 B)
 
SimpleHandler`2.StartEvent 0.000
 
5
(cms.user.isauthorizedpernode)
Proc_CMS_User_IsAuthorizedPerNode
@UserID (65)
@NodeID (582)
@PermissionName ("read")
@GenericRoles ("'_everyone_', '_notauthenticated_'")
@SiteID (1)
@Date (7/19/2018 12:34:59 PM)
91 B
 
SimpleHandler`2.StartEvent 0.000
 
6
(cms.acl.generalselect)
SELECT * FROM CMS_ACL WHERE [ACLID] = @ACLID
@ACLID (1)
48 B
 
Table (1 [6], 56 B)
 
SimpleHandler`2.StartEvent 0.000
 
7
(cms.aclitem.selectaclitemsbyaclidanduserid)
SELECT DISTINCT X.Allowed,X.Denied,X.ValidTo,X.ACLID
FROM (
SELECT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, null AS 'ValidTo',CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
WHERE
--User
(CMS_ACLItem.UserID IN (SELECT CMS_User.UserID FROM CMS_User JOIN CMS_UserSite ON CMS_User.UserID = CMS_UserSite.UserID
WHERE CMS_User.UserID = @UserID AND CMS_UserSite.SiteID = @SiteID )
-- Specific roles
OR CMS_ACLItem.RoleID IN (SELECT RoleID FROM CMS_Role WHERE RoleName IN ('_everyone_','_notauthenticated_'))
)
-- Membership
UNION ALL
SELECT DISTINCT CMS_ACLItem.Allowed,CMS_ACLItem.Denied, UserRole.ValidTo, CMS_ACL.ACLID
FROM CMS_ACL INNER JOIN CMS_ACLItem ON CMS_ACLItem.ACLID = CMS_ACL.ACLID
INNER JOIN [View_CMS_UserRoleMembershipRole] AS UserRole ON UserRole.RoleID = CMS_ACLItem.RoleID
WHERE (UserRole.ValidTo > @Date OR UserRole.ValidTo IS NULL)
AND (UserRole.SiteID = @SiteID OR UserRole.SiteID IS NULL)
AND UserRole.UserID = @UserID
) AS X
WHERE ACLID IN (1)

@UserID (65)
@SiteID (1)
@Date (7/19/2018 12:34:59 PM)
1.2 kB
 
Table (1 [4], 16 B)
 
SimpleHandler`2.StartEvent 0.000
 
8
(cms.tree.selectpageinfo)
SELECT * FROM View_PageInfo WHERE (NodeID = 940) AND ([DocumentCulture] = N'en-US')
Table (1 [67], 3.4 kB)
 
PageContext.CurrentPage_InitComplete 0.000
 
9
(cms.document.selectdocuments)
SELECT [ClassName], [DocumentCulture], [DocumentGUID], [DocumentModifiedWhen], [DocumentMenuCaption], [DocumentMenuClass], [DocumentMenuClassHighLighted], [DocumentMenuClassOver], [DocumentShowInSiteMap], [DocumentMenuItemHideInNavigation], [DocumentMenuItemImage], [DocumentMenuItemImageHighlighted], [DocumentMenuItemImageOver], [DocumentMenuItemInactive], [DocumentMenuItemLeftImage], [DocumentMenuItemLeftImageHighlighted], [DocumentMenuItemLeftImageOver], [DocumentMenuItemRightImage], [DocumentMenuItemRightImageHighlighted], [DocumentMenuItemRightImageOver], [DocumentMenuJavascript], [DocumentMenuRedirectUrl], [DocumentMenuRedirectToFirstChild], [DocumentMenuStyle], [DocumentMenuStyleHighlighted], [DocumentMenuStyleOver], [DocumentName], [DocumentUrlPath], [NodeAliasPath], [NodeID], [NodeHasChildren], [NodeClassID], [NodeLevel], [NodeLinkedNodeID], [NodeParentID], [SiteName], [NodeACLID], [NodeSiteID], [NodeOwner], [NodeOrder], [NodeName], [DocumentSitemapSettings] FROM View_CMS_Tree_Joined WHERE [NodeSiteID] = @NodeSiteID AND (NodeAliasPath IN (N'/Detail-Master/Home', N'/Detail-Master', N'/')) AND ([Published] = @Published AND [NodeLevel] <= @NodeLevel AND [DocumentCulture] = @DocumentCulture) ORDER BY NodeAliasPath DESC
@NodeSiteID (1)
@Published (True)
@NodeLevel (2)
@DocumentCulture ("en-US")
1.2 kB
 
Table (3 [42], 382 B)
 
CMSAbstractMenuProperties.OnLoad 0.000
 
10
(media.file.generalselect)
SELECT * FROM Media_File WHERE ((FileLibraryID = 27) AND (FileLibraryID IN (SELECT LibraryID FROM Media_Library WHERE ((LibraryAccess < 1000000)) AND (LibraryGroupID IS NULL))))
Table (2 [18], 690 B)
 
CMSRepeaterWithEffect.OnLoad 0.000
 
  10 queries, 3.6 kB write, 30 kB read   0.016