(0.3ms) SELECT DISTINCT class_name FROM pages WHERE class_name <> '' AND class_name IS NOT NULL TrustyCms::Config Load (4.0ms) SELECT `config`.* FROM `config` TrustyCms::Config Load (0.9ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'admin.title' LIMIT 1 TRANSACTION (0.4ms) BEGIN TrustyCms::Config Load (0.6ms) SELECT `config`.* FROM `config` TRANSACTION (0.2ms) COMMIT TrustyCms::Config Load (0.9ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'admin.subtitle' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` TRANSACTION (0.2ms) COMMIT TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'defaults.page.parts' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` TRANSACTION (0.2ms) COMMIT TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'defaults.page.status' LIMIT 1 TRANSACTION (0.3ms) BEGIN TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` TRANSACTION (0.3ms) COMMIT TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'defaults.page.filter' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` TRANSACTION (0.2ms) COMMIT TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'defaults.page.fields' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` TRANSACTION (0.5ms) COMMIT TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'defaults.snippet.filter' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` TRANSACTION (0.3ms) COMMIT TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'session_timeout' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` TRANSACTION (0.2ms) COMMIT TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'default_locale' LIMIT 1 TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.3ms) SELECT `config`.* FROM `config` TRANSACTION (0.3ms) COMMIT TRANSACTION (0.2ms) BEGIN Layout Exists? (0.3ms) SELECT 1 AS one FROM `layouts` WHERE `layouts`.`name` = 'Normal' LIMIT 1 Layout Create (3.0ms) INSERT INTO `layouts` (`name`, `content`, `created_at`, `updated_at`, `lock_version`) VALUES ('Normal', 'Content!', '2025-01-14 19:13:47', '2025-01-14 19:13:47', 0) TRANSACTION (0.7ms) COMMIT TRANSACTION (0.4ms) BEGIN Layout Exists? (0.3ms) SELECT 1 AS one FROM `layouts` WHERE `layouts`.`name` = 'Normal' LIMIT 1 TRANSACTION (0.9ms) ROLLBACK  (0.8ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (2.1ms) select table_name from information_schema.views where table_schema = 'trusty_cms_test'  (17.2ms) TRUNCATE TABLE `extension_meta`  (5.8ms) TRUNCATE TABLE `page_parts`  (5.2ms) TRUNCATE TABLE `sites`  (5.4ms) TRUNCATE TABLE `users`  (3.6ms) TRUNCATE TABLE `layouts`  (3.7ms) TRUNCATE TABLE `pages`  (4.0ms) TRUNCATE TABLE `sessions`  (3.7ms) TRUNCATE TABLE `snippets`  (0.3ms) SET FOREIGN_KEY_CHECKS = 1 Layout Exists? (0.3ms) SELECT 1 AS one FROM `layouts` WHERE `layouts`.`name` = '' LIMIT 1  (0.5ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (4.4ms) TRUNCATE TABLE `extension_meta`  (7.5ms) TRUNCATE TABLE `page_parts`  (4.9ms) TRUNCATE TABLE `sites`  (4.1ms) TRUNCATE TABLE `users`  (5.2ms) TRUNCATE TABLE `layouts`  (4.3ms) TRUNCATE TABLE `pages`  (3.3ms) TRUNCATE TABLE `sessions`  (4.2ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) BEGIN Layout Exists? (0.2ms) SELECT 1 AS one FROM `layouts` WHERE `layouts`.`name` = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' LIMIT 1 TRANSACTION (0.1ms) ROLLBACK  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (4.3ms) TRUNCATE TABLE `extension_meta`  (4.0ms) TRUNCATE TABLE `page_parts`  (4.1ms) TRUNCATE TABLE `sites`  (3.9ms) TRUNCATE TABLE `users`  (4.1ms) TRUNCATE TABLE `layouts`  (3.8ms) TRUNCATE TABLE `pages`  (4.6ms) TRUNCATE TABLE `sessions`  (4.3ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.3ms) BEGIN Snippet Exists? (0.4ms) SELECT 1 AS one FROM `snippets` WHERE `snippets`.`name` = 'test_snippet' LIMIT 1 Snippet Create (0.4ms) INSERT INTO `snippets` (`name`, `content`, `created_at`, `updated_at`, `lock_version`) VALUES ('test_snippet', 'Content!', '2025-01-14 19:13:48', '2025-01-14 19:13:48', 0) TRANSACTION (0.6ms) COMMIT TRANSACTION (0.2ms) BEGIN Snippet Exists? (0.3ms) SELECT 1 AS one FROM `snippets` WHERE `snippets`.`name` = 'test_snippet' LIMIT 1 TRANSACTION (0.3ms) ROLLBACK  (0.5ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (5.1ms) TRUNCATE TABLE `extension_meta`  (4.4ms) TRUNCATE TABLE `page_parts`  (5.4ms) TRUNCATE TABLE `sites`  (4.3ms) TRUNCATE TABLE `users`  (3.7ms) TRUNCATE TABLE `layouts`  (3.6ms) TRUNCATE TABLE `pages`  (3.2ms) TRUNCATE TABLE `sessions`  (3.9ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) BEGIN Snippet Exists? (0.3ms) SELECT 1 AS one FROM `snippets` WHERE `snippets`.`name` = 'xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx' LIMIT 1 TRANSACTION (0.2ms) ROLLBACK  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (3.3ms) TRUNCATE TABLE `extension_meta`  (3.0ms) TRUNCATE TABLE `page_parts`  (3.4ms) TRUNCATE TABLE `sites`  (3.5ms) TRUNCATE TABLE `users`  (4.6ms) TRUNCATE TABLE `layouts`  (3.7ms) TRUNCATE TABLE `pages`  (4.3ms) TRUNCATE TABLE `sessions`  (3.8ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 Snippet Exists? (0.3ms) SELECT 1 AS one FROM `snippets` WHERE `snippets`.`name` = '' LIMIT 1  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (3.3ms) TRUNCATE TABLE `extension_meta`  (4.4ms) TRUNCATE TABLE `page_parts`  (3.5ms) TRUNCATE TABLE `sites`  (4.1ms) TRUNCATE TABLE `users`  (4.3ms) TRUNCATE TABLE `layouts`  (4.3ms) TRUNCATE TABLE `pages`  (3.0ms) TRUNCATE TABLE `sessions`  (5.1ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1  (0.3ms) SELECT @@FOREIGN_KEY_CHECKS  (0.6ms) SET FOREIGN_KEY_CHECKS = 0  (3.6ms) TRUNCATE TABLE `extension_meta`  (3.1ms) TRUNCATE TABLE `page_parts`  (3.5ms) TRUNCATE TABLE `sites`  (4.2ms) TRUNCATE TABLE `users`  (4.1ms) TRUNCATE TABLE `layouts`  (3.8ms) TRUNCATE TABLE `pages`  (4.2ms) TRUNCATE TABLE `sessions`  (3.8ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (3.6ms) TRUNCATE TABLE `extension_meta`  (3.8ms) TRUNCATE TABLE `page_parts`  (6.2ms) TRUNCATE TABLE `sites`  (3.5ms) TRUNCATE TABLE `users`  (8.2ms) TRUNCATE TABLE `layouts`  (6.7ms) TRUNCATE TABLE `pages`  (4.2ms) TRUNCATE TABLE `sessions`  (3.7ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (5.0ms) TRUNCATE TABLE `extension_meta`  (3.6ms) TRUNCATE TABLE `page_parts`  (4.2ms) TRUNCATE TABLE `sites`  (3.4ms) TRUNCATE TABLE `users`  (5.2ms) TRUNCATE TABLE `layouts`  (4.1ms) TRUNCATE TABLE `pages`  (2.8ms) TRUNCATE TABLE `sessions`  (4.2ms) TRUNCATE TABLE `snippets`  (0.3ms) SET FOREIGN_KEY_CHECKS = 1  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (3.3ms) TRUNCATE TABLE `extension_meta`  (4.8ms) TRUNCATE TABLE `page_parts`  (3.5ms) TRUNCATE TABLE `sites`  (4.6ms) TRUNCATE TABLE `users`  (5.3ms) TRUNCATE TABLE `layouts`  (4.0ms) TRUNCATE TABLE `pages`  (3.9ms) TRUNCATE TABLE `sessions`  (5.9ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (3.7ms) TRUNCATE TABLE `extension_meta`  (4.6ms) TRUNCATE TABLE `page_parts`  (7.4ms) TRUNCATE TABLE `sites`  (3.5ms) TRUNCATE TABLE `users`  (4.8ms) TRUNCATE TABLE `layouts`  (18.5ms) TRUNCATE TABLE `pages`  (11.4ms) TRUNCATE TABLE `sessions`  (24.6ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (6.3ms) TRUNCATE TABLE `extension_meta`  (4.7ms) TRUNCATE TABLE `page_parts`  (10.3ms) TRUNCATE TABLE `sites`  (3.7ms) TRUNCATE TABLE `users`  (21.8ms) TRUNCATE TABLE `layouts`  (11.8ms) TRUNCATE TABLE `pages`  (11.0ms) TRUNCATE TABLE `sessions`  (39.3ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) BEGIN  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (14.9ms) TRUNCATE TABLE `extension_meta`  (27.3ms) TRUNCATE TABLE `page_parts`  (8.1ms) TRUNCATE TABLE `sites`  (6.1ms) TRUNCATE TABLE `users`  (4.5ms) TRUNCATE TABLE `layouts`  (43.2ms) TRUNCATE TABLE `pages`  (114.4ms) TRUNCATE TABLE `sessions`  (197.3ms) TRUNCATE TABLE `snippets`  (0.1ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.1ms) ROLLBACK TRANSACTION (0.1ms) BEGIN  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (72.8ms) TRUNCATE TABLE `extension_meta`  (6.0ms) TRUNCATE TABLE `page_parts`  (5.2ms) TRUNCATE TABLE `sites`  (4.9ms) TRUNCATE TABLE `users`  (4.8ms) TRUNCATE TABLE `layouts`  (4.2ms) TRUNCATE TABLE `pages`  (4.5ms) TRUNCATE TABLE `sessions`  (4.5ms) TRUNCATE TABLE `snippets`  (0.3ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) ROLLBACK TRANSACTION (0.2ms) BEGIN  (0.3ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (6.8ms) TRUNCATE TABLE `extension_meta`  (7.1ms) TRUNCATE TABLE `page_parts`  (26.5ms) TRUNCATE TABLE `sites`  (3.7ms) TRUNCATE TABLE `users`  (4.3ms) TRUNCATE TABLE `layouts`  (4.4ms) TRUNCATE TABLE `pages`  (6.0ms) TRUNCATE TABLE `sessions`  (3.5ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.1ms) ROLLBACK TRANSACTION (0.1ms) BEGIN  (1.1ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (4.3ms) TRUNCATE TABLE `extension_meta`  (4.8ms) TRUNCATE TABLE `page_parts`  (4.5ms) TRUNCATE TABLE `sites`  (5.2ms) TRUNCATE TABLE `users`  (10.6ms) TRUNCATE TABLE `layouts`  (28.0ms) TRUNCATE TABLE `pages`  (11.9ms) TRUNCATE TABLE `sessions`  (4.5ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) ROLLBACK TRANSACTION (0.2ms) BEGIN  (1.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (10.9ms) TRUNCATE TABLE `extension_meta`  (3.7ms) TRUNCATE TABLE `page_parts`  (4.1ms) TRUNCATE TABLE `sites`  (4.3ms) TRUNCATE TABLE `users`  (3.8ms) TRUNCATE TABLE `layouts`  (4.2ms) TRUNCATE TABLE `pages`  (4.1ms) TRUNCATE TABLE `sessions`  (3.3ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) ROLLBACK TRANSACTION (0.1ms) BEGIN  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (10.4ms) TRUNCATE TABLE `extension_meta`  (33.9ms) TRUNCATE TABLE `page_parts`  (6.5ms) TRUNCATE TABLE `sites`  (11.0ms) TRUNCATE TABLE `users`  (7.3ms) TRUNCATE TABLE `layouts`  (7.8ms) TRUNCATE TABLE `pages`  (3.9ms) TRUNCATE TABLE `sessions`  (3.5ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.1ms) ROLLBACK TRANSACTION (0.1ms) BEGIN  (0.4ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (5.3ms) TRUNCATE TABLE `extension_meta`  (3.8ms) TRUNCATE TABLE `page_parts`  (3.2ms) TRUNCATE TABLE `sites`  (3.5ms) TRUNCATE TABLE `users`  (4.3ms) TRUNCATE TABLE `layouts`  (4.5ms) TRUNCATE TABLE `pages`  (4.0ms) TRUNCATE TABLE `sessions`  (4.0ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.1ms) ROLLBACK TRANSACTION (0.2ms) BEGIN  (0.4ms) SELECT @@FOREIGN_KEY_CHECKS  (0.2ms) SET FOREIGN_KEY_CHECKS = 0  (3.9ms) TRUNCATE TABLE `extension_meta`  (4.6ms) TRUNCATE TABLE `page_parts`  (3.6ms) TRUNCATE TABLE `sites`  (4.0ms) TRUNCATE TABLE `users`  (58.3ms) TRUNCATE TABLE `layouts`  (12.5ms) TRUNCATE TABLE `pages`  (3.4ms) TRUNCATE TABLE `sessions`  (3.2ms) TRUNCATE TABLE `snippets`  (0.1ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.1ms) ROLLBACK TRANSACTION (0.1ms) BEGIN  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (5.2ms) TRUNCATE TABLE `extension_meta`  (4.4ms) TRUNCATE TABLE `page_parts`  (4.5ms) TRUNCATE TABLE `sites`  (4.3ms) TRUNCATE TABLE `users`  (5.3ms) TRUNCATE TABLE `layouts`  (4.5ms) TRUNCATE TABLE `pages`  (5.3ms) TRUNCATE TABLE `sessions`  (3.9ms) TRUNCATE TABLE `snippets`  (0.3ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) ROLLBACK TRANSACTION (0.1ms) BEGIN  (0.2ms) SELECT @@FOREIGN_KEY_CHECKS  (0.1ms) SET FOREIGN_KEY_CHECKS = 0  (4.3ms) TRUNCATE TABLE `extension_meta`  (3.1ms) TRUNCATE TABLE `page_parts`  (3.3ms) TRUNCATE TABLE `sites`  (4.0ms) TRUNCATE TABLE `users`  (4.0ms) TRUNCATE TABLE `layouts`  (5.2ms) TRUNCATE TABLE `pages`  (4.5ms) TRUNCATE TABLE `sessions`  (4.7ms) TRUNCATE TABLE `snippets`  (0.3ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.3ms) ROLLBACK TRANSACTION (0.2ms) BEGIN TrustyCms::Config Load (0.4ms) SELECT `config`.* FROM `config`  (0.4ms) SELECT @@FOREIGN_KEY_CHECKS  (0.3ms) SET FOREIGN_KEY_CHECKS = 0  (4.6ms) TRUNCATE TABLE `extension_meta`  (4.3ms) TRUNCATE TABLE `page_parts`  (4.5ms) TRUNCATE TABLE `sites`  (4.8ms) TRUNCATE TABLE `users`  (5.2ms) TRUNCATE TABLE `layouts`  (5.2ms) TRUNCATE TABLE `pages`  (4.4ms) TRUNCATE TABLE `sessions`  (5.3ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.2ms) ROLLBACK TRANSACTION (0.3ms) BEGIN TrustyCms::Config Load (0.5ms) SELECT `config`.* FROM `config` WHERE `config`.`key` = 'local.timezone' ORDER BY `config`.`id` ASC LIMIT 1  (0.4ms) SELECT @@FOREIGN_KEY_CHECKS  (1.2ms) SET FOREIGN_KEY_CHECKS = 0  (94.5ms) TRUNCATE TABLE `extension_meta`  (3.4ms) TRUNCATE TABLE `page_parts`  (3.3ms) TRUNCATE TABLE `sites`  (3.6ms) TRUNCATE TABLE `users`  (4.1ms) TRUNCATE TABLE `layouts`  (3.5ms) TRUNCATE TABLE `pages`  (3.3ms) TRUNCATE TABLE `sessions`  (3.5ms) TRUNCATE TABLE `snippets`  (0.2ms) SET FOREIGN_KEY_CHECKS = 1 TRANSACTION (0.1ms) ROLLBACK