1n7cDzQH

1[2019-05-01 05:44:09] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","migrations"] 
2[2019-05-01 05:44:09] local.INFO: create table `migrations` (`id` int unsigned not null auto_increment primary key, `migration` varchar(255) not null, `batch` int not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
3[2019-05-01 05:44:09] local.INFO: select `migration` from `migrations` order by `batch` asc, `migration` asc  
4[2019-05-01 05:44:09] local.INFO: select max(`batch`) as aggregate from `migrations`  
5[2019-05-01 05:44:09] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","users"] 
6[2019-05-01 05:44:09] local.INFO: create table `users` (`id` int unsigned not null auto_increment primary key, `username` varchar(100) not null, `password` varchar(100) not null, `upload` tinyint(1) not null default '0', `lock` tinyint(1) not null default '0', `remember_token` varchar(100) null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
7[2019-05-01 05:44:09] local.INFO: alter table `users` add unique `users_username_unique`(`username`)  
8[2019-05-01 05:44:09] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2014_10_12_000000_create_users_table",1] 
9[2019-05-01 05:44:09] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2014_10_12_100000_create_password_resets_table",1] 
10[2019-05-01 05:44:09] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","albums"] 
11[2019-05-01 05:44:10] local.INFO: create table `albums` (`id` bigint unsigned not null auto_increment primary key, `title` varchar(100) not null default '', `owner_id` int not null default '0', `parent_id` bigint unsigned null, `description` text not null, `min_takestamp` timestamp null, `max_takestamp` timestamp null, `public` tinyint(1) not null default '0', `visible_hidden` tinyint(1) not null default '1', `downloadable` tinyint(1) not null default '0', `password` varchar(100) null, `license` varchar(20) not null default 'none', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
12[2019-05-01 05:44:10] local.INFO: alter table `albums` add constraint `albums_parent_id_foreign` foreign key (`parent_id`) references `albums` (`id`)  
13[2019-05-01 05:44:10] local.INFO: alter table `albums` add index `albums_parent_id_index`(`parent_id`)  
14[2019-05-01 05:44:10] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_08_03_110935_create_albums_table",1] 
15[2019-05-01 05:44:10] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","photos"] 
16[2019-05-01 05:44:10] local.INFO: create table `photos` (`id` bigint unsigned not null auto_increment primary key, `title` varchar(100) not null, `description` text null, `url` varchar(100) not null, `tags` text not null, `public` tinyint(1) not null, `owner_id` int not null default '0', `type` varchar(15) not null default '', `width` int null, `height` int null, `size` varchar(20) not null default '', `iso` varchar(15) not null default '', `aperture` varchar(20) not null default '', `make` varchar(50) not null default '', `model` varchar(50) not null default '', `lens` varchar(100) not null default '', `shutter` varchar(30) not null default '', `focal` varchar(20) not null default '', `latitude` decimal(10, 8) null, `longitude` decimal(11, 8) null, `altitude` decimal(10, 4) null, `takestamp` timestamp null, `star` tinyint(1) not null default '0', `thumbUrl` varchar(37) not null default '', `album_id` bigint unsigned null, `checksum` varchar(40) not null default '', `medium` tinyint(1) not null default '0', `small` tinyint(1) not null default '0', `license` varchar(20) not null default 'none', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
17[2019-05-01 05:44:10] local.INFO: alter table `photos` add constraint `photos_album_id_foreign` foreign key (`album_id`) references `albums` (`id`) on delete cascade  
18[2019-05-01 05:44:10] local.INFO: alter table `photos` add index `photos_album_id_index`(`album_id`)  
19[2019-05-01 05:44:10] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_08_03_110936_create_photos_table",1] 
20[2019-05-01 05:44:10] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
21[2019-05-01 05:44:10] local.INFO: create table `configs` (`id` int unsigned not null auto_increment primary key, `key` varchar(50) not null, `value` varchar(200) null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
22[2019-05-01 05:44:10] local.INFO: insert into `configs` (`key`, `value`) values (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) ["version","040000","username","","password","","checkForUpdates","1","sortingPhotos_col","takestamp","sortingPhotos_order","ASC","sortingAlbums_col","description","sortingAlbums_order","DESC","imagick","1","dropboxKey","","skipDuplicates","0","small_max_width","0","small_max_height","360","medium_max_width","1920","medium_max_height","1080","lang","en","layout","1","image_overlay","1","image_overlay_type","exif","default_license","none","compression_quality","90","full_photo","1","deleteImported","1","Mod_Frame","0","Mod_Frame_refresh","30000"] 
23[2019-05-01 05:44:10] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_08_03_110942_create_configs_table",1] 
24[2019-05-01 05:44:10] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","logs"] 
25[2019-05-01 05:44:10] local.INFO: create table `logs` (`id` bigint unsigned not null auto_increment primary key, `type` varchar(11) not null, `function` varchar(100) not null, `line` int not null, `text` text not null, `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
26[2019-05-01 05:44:10] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_08_03_111324_create_logs_table",1] 
27[2019-05-01 05:44:10] local.INFO: select * from `albums`  
28[2019-05-01 05:44:10] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","lychee_albums"] 
29[2019-05-01 05:44:10] local.INFO: select * from `albums`  
30[2019-05-01 05:44:10] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_08_15_102039_move_albums",1] 
31[2019-05-01 05:44:10] local.INFO: select * from `photos`  
32[2019-05-01 05:44:10] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","lychee_photos"] 
33[2019-05-01 05:44:10] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_08_15_103716_move_photos",1] 
34[2019-05-01 05:44:10] local.INFO: drop table if exists `user_album`  
35[2019-05-01 05:44:10] local.INFO: create table `user_album` (`id` bigint unsigned not null auto_increment primary key, `album_id` bigint unsigned null, `user_id` int unsigned not null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
36[2019-05-01 05:44:11] local.INFO: alter table `user_album` add constraint `user_album_album_id_foreign` foreign key (`album_id`) references `albums` (`id`) on delete cascade  
37[2019-05-01 05:44:11] local.INFO: alter table `user_album` add constraint `user_album_user_id_foreign` foreign key (`user_id`) references `users` (`id`) on delete cascade  
38[2019-05-01 05:44:11] local.INFO: alter table `user_album` add index `user_album_album_id_index`(`album_id`)  
39[2019-05-01 05:44:11] local.INFO: alter table `user_album` add index `user_album_user_id_index`(`user_id`)  
40[2019-05-01 05:44:11] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2018_10_30_135411_sharing",1] 
41[2019-05-01 05:44:11] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_01_12_001320_add_disable_full_photo",1] 
42[2019-05-01 05:44:11] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_01_20_210150_add_delete_imported_setting",1] 
43[2019-05-01 05:44:11] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_01_27_020236_add__mod__frame",1] 
44[2019-05-01 05:44:11] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_01_122800_add_overlay_type",1] 
45[2019-05-01 05:44:11] local.INFO: alter table `user_album` add `album_id_save` bigint unsigned null after `album_id`  
46[2019-05-01 05:44:11] local.INFO: alter table `photos` add `album_id_save` bigint unsigned null after `album_id`  
47[2019-05-01 05:44:11] local.INFO: alter table `photos` add index `photos_album_id_save_index`(`album_id_save`)  
48[2019-05-01 05:44:11] local.INFO: alter table `albums` add `parent_id_save` bigint unsigned null after `parent_id`  
49[2019-05-01 05:44:11] local.INFO: update `photos` set `album_id_save` = album_id, `photos`.`updated_at` = ? where `album_id_save` is null ["2019-05-01 05:44:11"] 
50[2019-05-01 05:44:11] local.INFO: update `albums` set `parent_id_save` = parent_id, `albums`.`updated_at` = ? where `parent_id_save` is null ["2019-05-01 05:44:11"] 
51[2019-05-01 05:44:11] local.INFO: update `user_album` set `album_id_save` = album_id where `album_id_save` is null  
52[2019-05-01 05:44:11] local.INFO: alter table `user_album` drop foreign key `user_album_album_id_foreign`  
53[2019-05-01 05:44:11] local.INFO: alter table `user_album` drop `album_id`  
54[2019-05-01 05:44:11] local.INFO: alter table `photos` drop foreign key `photos_album_id_foreign`  
55[2019-05-01 05:44:11] local.INFO: alter table `photos` drop `album_id`  
56[2019-05-01 05:44:11] local.INFO: alter table `albums` drop foreign key `albums_parent_id_foreign`  
57[2019-05-01 05:44:11] local.INFO: alter table `albums` drop `parent_id`  
58[2019-05-01 05:44:11] local.INFO: alter table `albums` add `parent_id` bigint unsigned null after `parent_id_save`  
59[2019-05-01 05:44:11] local.INFO: alter table `albums` add index `albums_parent_id_index`(`parent_id`)  
60[2019-05-01 05:44:11] local.INFO: alter table `albums` add constraint `albums_parent_id_foreign` foreign key (`parent_id`) references `albums` (`id`)  
61[2019-05-01 05:44:11] local.INFO: alter table `user_album` add `album_id` bigint unsigned null after `album_id_save`  
62[2019-05-01 05:44:11] local.INFO: alter table `user_album` add constraint `user_album_album_id_foreign` foreign key (`album_id`) references `albums` (`id`) on delete cascade  
63[2019-05-01 05:44:11] local.INFO: alter table `user_album` add index `user_album_album_id_index`(`album_id`)  
64[2019-05-01 05:44:11] local.INFO: alter table `photos` add `album_id` bigint unsigned null after `album_id_save`  
65[2019-05-01 05:44:12] local.INFO: alter table `photos` add constraint `photos_album_id_foreign` foreign key (`album_id`) references `albums` (`id`) on delete cascade  
66[2019-05-01 05:44:12] local.INFO: alter table `photos` add index `photos_album_id_index`(`album_id`)  
67[2019-05-01 05:44:12] local.INFO: update `photos` set `album_id` = album_id_save, `photos`.`updated_at` = ? where `album_id` is null ["2019-05-01 05:44:12"] 
68[2019-05-01 05:44:12] local.INFO: update `albums` set `parent_id` = parent_id_save, `albums`.`updated_at` = ? where `parent_id` is null ["2019-05-01 05:44:12"] 
69[2019-05-01 05:44:12] local.INFO: update `user_album` set `album_id` = album_id_save where `album_id` is null  
70[2019-05-01 05:44:12] local.INFO: alter table `photos` drop `album_id_save`  
71[2019-05-01 05:44:12] local.INFO: alter table `user_album` drop `album_id_save`  
72[2019-05-01 05:44:12] local.INFO: alter table `albums` drop `parent_id_save`  
73[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_03_133007_change_id_type",1] 
74[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_06_175656_add_compression_quality",1] 
75[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_07_102359_remove_plugins",1] 
76[2019-05-01 05:44:12] local.INFO: update `configs` set `key` = ? where `key` = ? ["layout","justified_layout"] 
77[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_19_193500_rename_justified_layout",1] 
78[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
79[2019-05-01 05:44:12] local.INFO: insert into `configs` (`key`, `value`) values (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?), (?, ?) ["landing_page_enable","0","landing_owner","John Smith","landing_title","John Smith","landing_subtitle","Cat, Dogs & Humans Photography","landing_facebook","https://www.facebook.com/JohnSmith","landing_flickr","https://www.flickr.com/JohnSmith","landing_twitter","https://www.twitter.com/JohnSmith","landing_instagram","https://instagram.com/JohnSmith","landing_youtube","https://www.youtube.com/JohnSmith","landing_background","dist/cat.jpg"] 
80[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_21_010324_add_landing_page",1] 
81[2019-05-01 05:44:12] local.INFO: create table `pages` (`id` int unsigned not null auto_increment primary key, `title` varchar(150) not null default '', `menu_title` varchar(100) not null default '', `in_menu` tinyint(1) not null default '0', `enabled` tinyint(1) not null default '0', `link` varchar(150) not null default '', `order` int not null default '0', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
82[2019-05-01 05:44:12] local.INFO: insert into `pages` (`enabled`, `in_menu`, `link`, `menu_title`, `order`, `title`) values (?, ?, ?, ?, ?, ?) [true,true,"/gallery","gallery",2,"gallery"] 
83[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_21_114356_create_pages_table",1] 
84[2019-05-01 05:44:12] local.INFO: create table `page_contents` (`id` int unsigned not null auto_increment primary key, `page_id` int unsigned not null, `content` text not null, `class` varchar(150) not null, `type` enum('div', 'img') not null, `order` int not null default '0', `created_at` timestamp null, `updated_at` timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci' engine = InnoDB ROW_FORMAT=DYNAMIC  
85[2019-05-01 05:44:12] local.INFO: alter table `page_contents` add constraint `page_contents_page_id_foreign` foreign key (`page_id`) references `pages` (`id`) on delete cascade  
86[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_21_114408_create_page_contents_table",1] 
87[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
88[2019-05-01 05:44:12] local.INFO: alter table `configs` add `cat` varchar(50) not null default 'Config' after `value`  
89[2019-05-01 05:44:12] local.INFO: update `configs` set `cat` = ? where `key` like ? ["Mod Frame","Mod_Frame%"] 
90[2019-05-01 05:44:12] local.INFO: update `configs` set `cat` = ? where `key` like ? ["Landing Page","landing_%"] 
91[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_21_222316_add_config_category",1] 
92[2019-05-01 05:44:12] local.INFO: select column_name as `column_name` from information_schema.columns where table_schema = ? and table_name = ? ["lychee_db","photos"] 
93[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
94[2019-05-01 05:44:12] local.INFO: insert into `configs` (`key`, `value`) values (?, ?), (?, ?), (?, ?) ["thumb_2x","1","small_2x","0","medium_2x","0"] 
95[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","photos"] 
96[2019-05-01 05:44:12] local.INFO: ALTER TABLE photos CHANGE medium medium_old TINYINT(1) DEFAULT '0' NOT NULL  
97[2019-05-01 05:44:12] local.INFO: ALTER TABLE photos CHANGE small small_old TINYINT(1) DEFAULT '0' NOT NULL  
98[2019-05-01 05:44:12] local.INFO: alter table `photos` add `medium` varchar(20) not null default '', add `medium2x` varchar(20) not null default '', add `small` varchar(20) not null default '', add `small2x` varchar(20) not null default '', add `thumb2x` tinyint(1) not null default '1'  
99[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","photos"] 
100[2019-05-01 05:44:12] local.INFO: select * from `photos`  
101[2019-05-01 05:44:12] local.INFO: alter table `photos` drop `medium_old`, drop `small_old`  
102[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_23_222617_add_hidpi",1] 
103[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
104[2019-05-01 05:44:12] local.INFO: insert into `configs` (`key`, `value`) values (?, ?) ["site_title","Lychee v4"] 
105[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_02_28_160025_add_website_title",1] 
106[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
107[2019-05-01 05:44:12] local.INFO: insert into `configs` (`key`, `value`) values (?, ?), (?, ?), (?, ?) ["site_copyright_enable","1","site_copyright_begin","2019","site_copyright_end","2019"] 
108[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_03_06_160454_add_website_copyrightyear",1] 
109[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
110[2019-05-01 05:44:12] local.INFO: alter table `configs` add `confidentiality` tinyint not null default '0' after `cat`  
111[2019-05-01 05:44:12] local.INFO: update `configs` set `confidentiality` = ? where `key` = ? or `key` = ? [4,"username","password"] 
112[2019-05-01 05:44:12] local.INFO: update `configs` set `confidentiality` = ? where `key` = ? [3,"dropboxKey"] 
113[2019-05-01 05:44:12] local.INFO: update `configs` set `confidentiality` = ? where `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? or `key` = ? [2,"lang_available","imagick","compression_quality","skipDuplicates","sortingAlbums","sortingAlbums_col","sortingAlbums_order","sortingPhotos","sortingPhotos_col","sortingPhotos_order","default_license","thumb_2x","small_max_width","small_max_height","small_2x","medium_max_width","medium_max_height","medium_2x","landing_title","landing_background","landing_facebook","landing_flickr","landing_twitter","landing_youtube","landing_instagram","landing_owner","landing_subtitle","site_copyright_enable","site_copyright_begin","site_copyright_end","deleteImported"] 
114[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_03_08_135817_private_config_fields",1] 
115[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
116[2019-05-01 05:44:12] local.INFO: insert into `configs` (`key`, `value`) values (?, ?) ["api_key",""] 
117[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_03_29_185414_add_api_key",1] 
118[2019-05-01 05:44:12] local.INFO: select * from `configs` where `key` = ? limit 1 ["api_key"] 
119[2019-05-01 05:44:12] local.INFO: update `configs` set `confidentiality` = ? where `id` = ? [3,43] 
120[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_04_02_124115_api_key_security_level",1] 
121[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
122[2019-05-01 05:44:12] local.INFO: insert into `configs` (`confidentiality`, `key`, `value`) values (?, ?, ?) [3,"php_script_limit","0"] 
123[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_04_03_141031_php_script_limit",1] 
124[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_04_07_193345_fix_32bit",1] 
125[2019-05-01 05:44:12] local.INFO: update `configs` set `key` = ? where `key` = ? ["php_script_no_limit","php_script_limit"] 
126[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_04_10_150400_rename_php_script_limit",1] 
127[2019-05-01 05:44:12] local.INFO: select * from information_schema.tables where table_schema = ? and table_name = ? ["lychee_db","configs"] 
128[2019-05-01 05:44:12] local.INFO: insert into `configs` (`confidentiality`, `key`, `value`) values (?, ?, ?), (?, ?, ?) [3,"allow_online_git_pull","0",3,"force_migration_in_production","0"] 
129[2019-05-01 05:44:12] local.INFO: insert into `migrations` (`migration`, `batch`) values (?, ?) ["2019_04_15_105540_config_allow_update",1] 
130[2019-05-01 05:45:38] local.INFO: select `key`, `value` from `configs`  
131[2019-05-01 05:45:38] local.INFO: select `key`, `value` from `configs`  
132[2019-05-01 05:45:38] local.INFO: select `key`, `value` from `configs`  
133[2019-05-01 05:45:38] local.INFO: select `value`, `key` from `configs` where `confidentiality` <= ? [3] 
134[2019-05-01 05:45:39] local.INFO: select `key`, `value` from `configs`  
135[2019-05-01 05:45:39] local.INFO: select * from `users` where `users`.`id` = ? limit 1 [0] 
136[2019-05-01 05:45:39] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `album_id` is null order by `takestamp` asc, `photos`.`id` asc limit 3  
137[2019-05-01 05:45:39] local.INFO: select count(*) as aggregate from `photos` where `album_id` is null limit 3  
138[2019-05-01 05:45:39] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `star` = ? order by `takestamp` asc, `photos`.`id` asc limit 3 [1] 
139[2019-05-01 05:45:39] local.INFO: select count(*) as aggregate from `photos` where `star` = ? limit 3 [1] 
140[2019-05-01 05:45:39] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `public` = ? order by `takestamp` asc, `photos`.`id` asc limit 3 [1] 
141[2019-05-01 05:45:39] local.INFO: select count(*) as aggregate from `photos` where `public` = ? limit 3 [1] 
142[2019-05-01 05:45:39] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `created_at` >= ? order by `takestamp` asc, `photos`.`id` asc limit 3 ["2019-04-30 05:45:39"] 
143[2019-05-01 05:45:39] local.INFO: select count(*) as aggregate from `photos` where `created_at` >= ? limit 3 ["2019-04-30 05:45:39"] 
144[2019-05-01 05:45:39] local.INFO: select * from `albums` where `owner_id` = ? order by `description` desc [0] 
145[2019-05-01 05:45:39] local.INFO: select * from `albums` where `owner_id` <> ? and `parent_id` is null order by `owner_id` asc [0] 
146[2019-05-01 05:45:42] local.INFO: select `key`, `value` from `configs`  
147[2019-05-01 05:45:43] local.INFO: select * from `configs` where `key` = ? limit 1 ["username"] 
148[2019-05-01 05:45:43] local.INFO: update `configs` set `value` = ? where `id` = ? ["$2y$10$1HJV.vQtz4Yfei.q72frJunYMs3RAcjOoD52thqdOfrRgUdQrZ/V6",2] 
149[2019-05-01 05:45:43] local.INFO: select * from `configs` where `key` = ? limit 1 ["password"] 
150[2019-05-01 05:45:43] local.INFO: update `configs` set `value` = ? where `id` = ? ["$2y$10$9hcDZ24zkaRYbmC2HS5a.OKK77tr/lmIBF4ovXv/z2acVdjfvqe8e",3] 
151[2019-05-01 05:45:49] local.INFO: select * from `users` where `users`.`id` = ? limit 1 [0] 
152[2019-05-01 05:45:49] local.INFO: select count(*) as aggregate from `albums` where `id` = ? [0] 
153[2019-05-01 05:45:49] local.INFO: insert into `albums` (`id`, `title`, `description`, `owner_id`, `parent_id`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?) ["15566895497666","test","",0,null,"2019-05-01 05:45:49","2019-05-01 05:45:49"] 
154[2019-05-01 05:45:49] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 ["15566895497666"] 
155[2019-05-01 05:45:49] local.INFO: select * from `users` where `users`.`id` in (0)  
156[2019-05-01 05:45:49] local.INFO: select * from `albums` where `albums`.`parent_id` in (15566895497666)  
157[2019-05-01 05:45:50] local.INFO: select `key`, `value` from `configs`  
158[2019-05-01 05:45:50] local.INFO: select * from `photos` where `album_id` = ? order by `takestamp` asc, `photos`.`id` asc ["15566895497666"] 
159[2019-05-01 05:46:08] local.INFO: select `key`, `value` from `configs`  
160[2019-05-01 05:46:08] local.INFO: select * from `users` where `users`.`id` = ? limit 1 [0] 
161[2019-05-01 05:46:08] local.INFO: select count(*) as aggregate from `photos` where `checksum` = ? ["3ee0d360dc12003c0d43e3579295b52b64906e85"] 
162[2019-05-01 05:46:08] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\ModelFunctions\\PhotoFunctions::createThumb","101","Photo URL is 80b78428ac4eb2aa3a4e7ab79cb41802.png","2019-05-01 05:46:08","2019-05-01 05:46:08"] 
163[2019-05-01 05:46:08] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\Image\\ImagickHandler::crop","87","Saving thumb to /usr/share/nginx/html/Lychee-Laravel/public/uploads/thumb/80b78428ac4eb2aa3a4e7ab79cb41802.jpeg","2019-05-01 05:46:08","2019-05-01 05:46:08"] 
164[2019-05-01 05:46:08] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\Image\\ImagickHandler::crop","87","Saving thumb to /usr/share/nginx/html/Lychee-Laravel/public/uploads/thumb/80b78428ac4eb2aa3a4e7ab79cb41802@2x.jpeg","2019-05-01 05:46:08","2019-05-01 05:46:08"] 
165[2019-05-01 05:46:08] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\ModelFunctions\\PhotoFunctions::resizePhoto","430","No resize (image is too small)!","2019-05-01 05:46:08","2019-05-01 05:46:08"] 
166[2019-05-01 05:46:08] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\Image\\ImagickHandler::scale","50","Saving thumb to /usr/share/nginx/html/Lychee-Laravel/public/uploads/small/80b78428ac4eb2aa3a4e7ab79cb41802.png","2019-05-01 05:46:08","2019-05-01 05:46:08"] 
167[2019-05-01 05:46:08] local.INFO: insert into `photos` (`id`, `title`, `url`, `description`, `tags`, `width`, `height`, `type`, `size`, `iso`, `aperture`, `make`, `model`, `lens`, `shutter`, `focal`, `takestamp`, `latitude`, `longitude`, `altitude`, `public`, `owner_id`, `star`, `checksum`, `album_id`, `thumb2x`, `thumbUrl`, `small`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ["15566895681147","Lenna_(test_image)","80b78428ac4eb2aa3a4e7ab79cb41802.png","","",512,512,"image/png","462.7 KB","","","","","","","",null,null,null,null,0,0,0,"3ee0d360dc12003c0d43e3579295b52b64906e85","15566895497666",1,"80b78428ac4eb2aa3a4e7ab79cb41802.jpeg","360x360","2019-05-01 05:46:08","2019-05-01 05:46:08"] 
168[2019-05-01 05:46:08] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 ["15566895497666"] 
169[2019-05-01 05:46:08] local.INFO: select * from `albums` where `albums`.`parent_id` = ? and `albums`.`parent_id` is not null [15566895497666] 
170[2019-05-01 05:46:08] local.INFO: select min(`takestamp`) as aggregate from `photos` where `album_id` in (?) [15566895497666] 
171[2019-05-01 05:46:08] local.INFO: select max(`takestamp`) as aggregate from `photos` where `album_id` in (?) [15566895497666] 
172[2019-05-01 05:46:08] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 ["15566895497666"] 
173[2019-05-01 05:46:08] local.INFO: select * from `users` where `users`.`id` in (0)  
174[2019-05-01 05:46:08] local.INFO: select * from `albums` where `albums`.`parent_id` in (15566895497666)  
175[2019-05-01 05:46:08] local.INFO: select `key`, `value` from `configs`  
176[2019-05-01 05:46:09] local.INFO: select * from `photos` where `album_id` = ? order by `takestamp` asc, `photos`.`id` asc ["15566895497666"] 
177[2019-05-01 05:46:09] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 [15566895497666] 
178[2019-05-01 05:46:24] local.INFO: select `key`, `value` from `configs`  
179[2019-05-01 05:46:24] local.INFO: select * from `users` where `users`.`id` = ? limit 1 [0] 
180[2019-05-01 05:46:24] local.INFO: select count(*) as aggregate from `photos` where `checksum` = ? ["682963a12b9b0742651e486a5f697fa949f9daf2"] 
181[2019-05-01 05:46:25] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\ModelFunctions\\PhotoFunctions::extractVideoFrame","86","Saving frame to /tmp/lycheekCBDFD","2019-05-01 05:46:25","2019-05-01 05:46:25"] 
182[2019-05-01 05:46:25] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\ModelFunctions\\PhotoFunctions::createThumb","101","Photo URL is e92d87b741d0ae64a9fca7c904b9ef5a.mov","2019-05-01 05:46:25","2019-05-01 05:46:25"] 
183[2019-05-01 05:46:25] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\Image\\ImagickHandler::crop","87","Saving thumb to /usr/share/nginx/html/Lychee-Laravel/public/uploads/thumb/e92d87b741d0ae64a9fca7c904b9ef5a.jpeg","2019-05-01 05:46:25","2019-05-01 05:46:25"] 
184[2019-05-01 05:46:25] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\ModelFunctions\\PhotoFunctions::resizePhoto","430","No resize (image is too small)!","2019-05-01 05:46:25","2019-05-01 05:46:25"] 
185[2019-05-01 05:46:25] local.INFO: insert into `photos` (`id`, `title`, `url`, `description`, `tags`, `width`, `height`, `type`, `size`, `iso`, `aperture`, `make`, `model`, `lens`, `shutter`, `focal`, `takestamp`, `latitude`, `longitude`, `altitude`, `public`, `owner_id`, `star`, `checksum`, `album_id`, `thumb2x`, `thumbUrl`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ["15566895848201","file_example_MOV_480_700kB","e92d87b741d0ae64a9fca7c904b9ef5a.mov","","",480,270,"video/quicktime","693.1 KB","","30.571","","","","","30.000",null,null,null,null,0,0,0,"682963a12b9b0742651e486a5f697fa949f9daf2","15566895497666",0,"e92d87b741d0ae64a9fca7c904b9ef5a.jpeg","2019-05-01 05:46:25","2019-05-01 05:46:25"] 
186[2019-05-01 05:46:25] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 ["15566895497666"] 
187[2019-05-01 05:46:25] local.INFO: select * from `albums` where `albums`.`parent_id` = ? and `albums`.`parent_id` is not null [15566895497666] 
188[2019-05-01 05:46:25] local.INFO: select min(`takestamp`) as aggregate from `photos` where `album_id` in (?) [15566895497666] 
189[2019-05-01 05:46:25] local.INFO: select max(`takestamp`) as aggregate from `photos` where `album_id` in (?) [15566895497666] 
190[2019-05-01 05:46:25] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 ["15566895497666"] 
191[2019-05-01 05:46:25] local.INFO: select * from `users` where `users`.`id` in (0)  
192[2019-05-01 05:46:25] local.INFO: select * from `albums` where `albums`.`parent_id` in (15566895497666)  
193[2019-05-01 05:46:25] local.INFO: select `key`, `value` from `configs`  
194[2019-05-01 05:46:25] local.INFO: select * from `photos` where `album_id` = ? order by `takestamp` asc, `photos`.`id` asc ["15566895497666"] 
195[2019-05-01 05:46:25] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 [15566895497666] 
196[2019-05-01 05:46:25] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 [15566895497666] 
197[2019-05-01 05:46:45] local.INFO: select `key`, `value` from `configs`  
198[2019-05-01 05:46:46] local.INFO: select `key`, `value` from `configs`  
199[2019-05-01 05:46:46] local.INFO: select `value`, `key` from `configs` where `confidentiality` = ? [0] 
200[2019-05-01 05:46:46] local.INFO: select `key`, `value` from `configs`  
201[2019-05-01 05:46:46] local.INFO: select * from `albums` where `public` = ? and `visible_hidden` = ? and `parent_id` is null order by `description` desc ["1","1"] 
202[2019-05-01 05:46:50] local.INFO: select `key`, `value` from `configs`  
203[2019-05-01 05:46:50] local.INFO: select * from `users` where `username` = ? limit 1 ["root"] 
204[2019-05-01 05:46:51] local.INFO: insert into `logs` (`type`, `function`, `line`, `text`, `updated_at`, `created_at`) values (?, ?, ?, ?, ?, ?) ["notice","App\\Http\\Controllers\\SessionController::login","154","User (root) has logged in from 172.20.0.1","2019-05-01 05:46:51","2019-05-01 05:46:51"] 
205[2019-05-01 05:46:51] local.INFO: select `key`, `value` from `configs`  
206[2019-05-01 05:46:52] local.INFO: select `key`, `value` from `configs`  
207[2019-05-01 05:46:52] local.INFO: select `value`, `key` from `configs` where `confidentiality` <= ? [3] 
208[2019-05-01 05:46:53] local.INFO: select `key`, `value` from `configs`  
209[2019-05-01 05:46:53] local.INFO: select * from `users` where `users`.`id` = ? limit 1 [0] 
210[2019-05-01 05:46:53] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `album_id` is null order by `takestamp` asc, `photos`.`id` asc limit 3  
211[2019-05-01 05:46:53] local.INFO: select count(*) as aggregate from `photos` where `album_id` is null limit 3  
212[2019-05-01 05:46:53] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `star` = ? order by `takestamp` asc, `photos`.`id` asc limit 3 [1] 
213[2019-05-01 05:46:53] local.INFO: select count(*) as aggregate from `photos` where `star` = ? limit 3 [1] 
214[2019-05-01 05:46:53] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `public` = ? order by `takestamp` asc, `photos`.`id` asc limit 3 [1] 
215[2019-05-01 05:46:53] local.INFO: select count(*) as aggregate from `photos` where `public` = ? limit 3 [1] 
216[2019-05-01 05:46:53] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `created_at` >= ? order by `takestamp` asc, `photos`.`id` asc limit 3 ["2019-04-30 05:46:53"] 
217[2019-05-01 05:46:53] local.INFO: select count(*) as aggregate from `photos` where `created_at` >= ? limit 3 ["2019-04-30 05:46:53"] 
218[2019-05-01 05:46:53] local.INFO: select * from `albums` where `owner_id` = ? order by `description` desc [0] 
219[2019-05-01 05:46:53] local.INFO: select * from `albums` where `owner_id` <> ? and `parent_id` is null order by `owner_id` asc [0] 
220[2019-05-01 05:46:53] local.INFO: select * from `users` where `users`.`id` = ? limit 1 [0] 
221[2019-05-01 05:46:53] local.INFO: select * from `albums` where `albums`.`parent_id` = ? and `albums`.`parent_id` is not null [15566895497666] 
222[2019-05-01 05:46:53] local.INFO: select `thumbUrl`, `thumb2x`, `type` from `photos` where `album_id` in (?) order by `star` desc, `takestamp` asc limit 3 [15566895497666] 
223[2019-05-01 05:46:54] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 ["15566895497666"] 
224[2019-05-01 05:46:54] local.INFO: select * from `users` where `users`.`id` in (0)  
225[2019-05-01 05:46:54] local.INFO: select * from `albums` where `albums`.`parent_id` in (15566895497666)  
226[2019-05-01 05:46:54] local.INFO: select `key`, `value` from `configs`  
227[2019-05-01 05:46:54] local.INFO: select * from `photos` where `album_id` = ? order by `takestamp` asc, `photos`.`id` asc ["15566895497666"] 
228[2019-05-01 05:46:54] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 [15566895497666] 
229[2019-05-01 05:46:54] local.INFO: select * from `albums` where `albums`.`id` = ? limit 1 [15566895497666] 
230[2019-05-01 05:47:59] local.INFO: select `key`, `value` from `configs`  
231[2019-05-01 05:48:00] local.INFO: select `key`, `value` from `configs`  
232[2019-05-01 05:48:00] local.INFO: select `value`, `key` from `configs` where `confidentiality` = ? [0] 
233[2019-05-01 05:48:01] local.INFO: select `key`, `value` from `configs`  
234[2019-05-01 05:48:01] local.INFO: select * from `albums` where `public` = ? and `visible_hidden` = ? and `parent_id` is null order by `description` desc ["1","1"]