Home

Landing Page 1

(default) 7 queries took 2 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_pages', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_pages'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_pages'661
2SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_page_groups', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_page_groups'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_page_groups'220
3SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_page_modules', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_page_modules'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_page_modules'15151
4SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_page_module_types', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_page_module_types'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_page_module_types'660
5SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_page_module_products', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_page_module_products'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_page_module_products'660
6SELECT [Page].[id] AS [Page__0], [Page].[title] AS [Page__1], [Page].[page_group_id] AS [Page__2], CONVERT(VARCHAR(20), [Page].[lastedit_dtm], 20) AS [Page__3], [Page].[lastedit_user_id] AS [Page__4], [Page].[active] AS [Page__5], [Page].[id] AS [Page__6], [PageGroup].[id] AS [PageGroup__7], [PageGroup].[title] AS [PageGroup__8], [Page].[id] AS [Page__9], [Page].[id] AS [Page__26] FROM [CMS_pages] AS [Page] LEFT JOIN [CMS_page_groups] AS [PageGroup] ON ([Page].[page_group_id] = [PageGroup].[id]) WHERE 1 = 1 220
7SELECT [PageModule].[id] AS [PageModule__48], [PageModule].[page_id] AS [PageModule__49], [PageModule].[title] AS [PageModule__50], [PageModule].[page_module_type_id] AS [PageModule__51], [PageModule].[column_start] AS [PageModule__52], [PageModule].[row_num] AS [PageModule__53], [PageModule].[text] AS [PageModule__54], [PageModule].[link_page_id] AS [PageModule__55], [PageModule].[assoc_searchquery] AS [PageModule__56], [PageModule].[assoc_coupon_id] AS [PageModule__57], [PageModule].[assoc_bundle_id] AS [PageModule__58], [PageModule].[assoc_format] AS [PageModule__59], [PageModule].[assoc_aa_id] AS [PageModule__60], CONVERT(VARCHAR(20), [PageModule].[lastedit_dtm], 20) AS [PageModule__61], [PageModule].[lastedit_user_id] AS [PageModule__62], [PageModule].[page_id] AS [PageModule__63] FROM [CMS_page_modules] AS [PageModule] WHERE [PageModule].[page_id] IN (1, 2) 11110