Home

Vinyl

(default) 11 queries took 301 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES72072070
2SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_aros', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_aros'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_aros'7782
3SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_acos', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_acos'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_acos'7730
4SELECT COLUMN_NAME as Field, DATA_TYPE as Type, COL_LENGTH('CMS_aros_acos', COLUMN_NAME) as Length, IS_NULLABLE As [Null], COLUMN_DEFAULT as [Default], COLUMNPROPERTY(OBJECT_ID('CMS_aros_acos'), COLUMN_NAME, 'IsIdentity') as [Key], NUMERIC_SCALE as Size FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'CMS_aros_acos'7724
5SELECT 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'6628
6SELECT 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'447
7SELECT 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'161614
8SELECT 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'663
9SELECT 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'661
10SELECT [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], [PageGroup].[assoc_keyword_module_id] AS [PageGroup__9], [PageGroup].[isLanding] AS [PageGroup__10], [Page].[id] AS [Page__11], [Page].[id] AS [Page__29] FROM [CMS_pages] AS [Page] LEFT JOIN [CMS_page_groups] AS [PageGroup] ON ([Page].[page_group_id] = [PageGroup].[id]) WHERE 1 = 1 2222
11SELECT [PageModule].[id] AS [PageModule__52], [PageModule].[page_id] AS [PageModule__53], [PageModule].[title] AS [PageModule__54], [PageModule].[page_module_type_id] AS [PageModule__55], [PageModule].[column_start] AS [PageModule__56], [PageModule].[row_num] AS [PageModule__57], [PageModule].[text] AS [PageModule__58], [PageModule].[link_page_id] AS [PageModule__59], [PageModule].[assoc_searchquery] AS [PageModule__60], [PageModule].[assoc_coupon_id] AS [PageModule__61], [PageModule].[assoc_bundle_id] AS [PageModule__62], [PageModule].[assoc_format] AS [PageModule__63], [PageModule].[assoc_aa_id] AS [PageModule__64], CONVERT(VARCHAR(20), [PageModule].[lastedit_dtm], 20) AS [PageModule__65], [PageModule].[lastedit_user_id] AS [PageModule__66], [PageModule].[keyword_id] AS [PageModule__67], [PageModule].[page_id] AS [PageModule__68] FROM [CMS_page_modules] AS [PageModule] WHERE [PageModule].[page_id] IN (3, 9) 6620