2021-01-27T19:50:32.065875897Z: INFO ▶ [DATABASE] 001 [SQL] SELECT name FROM sqlite_master WHERE type='table' [] - 845.376µs 2021-01-27T19:50:32.066083917Z: INFO ▶ [DATABASE] 002 [SQL] SELECT sql FROM sqlite_master WHERE type='table' and name = ? [migration] - 29.495µs 2021-01-27T19:50:32.066182271Z: INFO ▶ [DATABASE] 003 [SQL] SELECT sql FROM sqlite_master WHERE type='index' and tbl_name = ? [migration] - 22.142µs 2021-01-27T19:50:32.066291196Z: INFO ▶ [DATABASE] 004 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [SCHEMA_INIT] - 25.058µs 2021-01-27T19:50:32.066384792Z: INFO ▶ [DATABASE] 005 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190324205606] - 23.504µs 2021-01-27T19:50:32.066464842Z: INFO ▶ [DATABASE] 006 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190328074430] - 21.681µs 2021-01-27T19:50:32.066539983Z: INFO ▶ [DATABASE] 007 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190430111111] - 21.5µs 2021-01-27T19:50:32.066615504Z: INFO ▶ [DATABASE] 008 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190511202210] - 21.871µs 2021-01-27T19:50:32.066705182Z: INFO ▶ [DATABASE] 009 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190514192749] - 22.562µs 2021-01-27T19:50:32.066796674Z: INFO ▶ [DATABASE] 00a [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190524205441] - 22.452µs 2021-01-27T19:50:32.06687447Z: INFO ▶ [DATABASE] 00b [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190718200716] - 20.619µs 2021-01-27T19:50:32.066959169Z: INFO ▶ [DATABASE] 00c [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190818210133] - 27.071µs 2021-01-27T19:50:32.067061642Z: INFO ▶ [DATABASE] 00d [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190920185205] - 22.843µs 2021-01-27T19:50:32.067139077Z: INFO ▶ [DATABASE] 00e [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20190922205826] - 21.511µs 2021-01-27T19:50:32.067213246Z: INFO ▶ [DATABASE] 00f [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20191008194238] - 20.929µs 2021-01-27T19:50:32.067285792Z: INFO ▶ [DATABASE] 010 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20191010131430] - 20.999µs 2021-01-27T19:50:32.067358789Z: INFO ▶ [DATABASE] 011 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20191207204427] - 20.92µs 2021-01-27T19:50:32.067431725Z: INFO ▶ [DATABASE] 012 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20191207220736] - 20.468µs 2021-01-27T19:50:32.06751421Z: INFO ▶ [DATABASE] 013 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200120201756] - 21.771µs 2021-01-27T19:50:32.06759921Z: INFO ▶ [DATABASE] 014 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200219183248] - 21.781µs 2021-01-27T19:50:32.067674061Z: INFO ▶ [DATABASE] 015 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200308205855] - 20.95µs 2021-01-27T19:50:32.067746516Z: INFO ▶ [DATABASE] 016 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200308210130] - 20.638µs 2021-01-27T19:50:32.067842015Z: INFO ▶ [DATABASE] 017 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200322214440] - 21.73µs 2021-01-27T19:50:32.067915253Z: INFO ▶ [DATABASE] 018 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200322214624] - 20.469µs 2021-01-27T19:50:32.068001625Z: INFO ▶ [DATABASE] 019 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200417175201] - 27.762µs 2021-01-27T19:50:32.068086193Z: INFO ▶ [DATABASE] 01a [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200418230432] - 22.803µs 2021-01-27T19:50:32.068162827Z: INFO ▶ [DATABASE] 01b [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200418230605] - 23.294µs 2021-01-27T19:50:32.068237037Z: INFO ▶ [DATABASE] 01c [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200420215928] - 20.539µs 2021-01-27T19:50:32.068310374Z: INFO ▶ [DATABASE] 01d [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200425182634] - 20.558µs 2021-01-27T19:50:32.068394201Z: INFO ▶ [DATABASE] 01e [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200509103709] - 21.891µs 2021-01-27T19:50:32.068476265Z: INFO ▶ [DATABASE] 01f [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200515172220] - 21.15µs 2021-01-27T19:50:32.068550454Z: INFO ▶ [DATABASE] 020 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200515195546] - 20.288µs 2021-01-27T19:50:32.068624213Z: INFO ▶ [DATABASE] 021 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200516123847] - 20.248µs 2021-01-27T19:50:32.068696909Z: INFO ▶ [DATABASE] 022 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200524221534] - 20.288µs 2021-01-27T19:50:32.068787358Z: INFO ▶ [DATABASE] 023 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200524224611] - 22.612µs 2021-01-27T19:50:32.068862801Z: INFO ▶ [DATABASE] 024 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200614113230] - 20.43µs 2021-01-27T19:50:32.068935878Z: INFO ▶ [DATABASE] 025 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200621214452] - 19.998µs 2021-01-27T19:50:32.069017872Z: INFO ▶ [DATABASE] 026 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200801183357] - 26.209µs 2021-01-27T19:50:32.06910231Z: INFO ▶ [DATABASE] 027 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200904101559] - 22.773µs 2021-01-27T19:50:32.069176118Z: INFO ▶ [DATABASE] 028 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200905151040] - 20.298µs 2021-01-27T19:50:32.069248624Z: INFO ▶ [DATABASE] 029 [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200905232458] - 20.409µs 2021-01-27T19:50:32.069340186Z: INFO ▶ [DATABASE] 02a [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20200906184746] - 39.944µs 2021-01-27T19:50:32.069426998Z: INFO ▶ [DATABASE] 02b [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20201025195822] - 24.135µs 2021-01-27T19:50:32.069501209Z: INFO ▶ [DATABASE] 02c [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20201121181647] - 20.389µs 2021-01-27T19:50:32.069574506Z: INFO ▶ [DATABASE] 02d [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20201218152741] - 20.298µs 2021-01-27T19:50:32.069647713Z: INFO ▶ [DATABASE] 02e [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20201218220204] - 20.368µs 2021-01-27T19:50:32.069720249Z: INFO ▶ [DATABASE] 02f [SQL] SELECT count(*) FROM `migration` WHERE `id` IN (?) [20201219145028] - 20.228µs 2021-01-27T19:50:39.49844346Z: INFO ▶ [DATABASE] 033 [SQL] SELECT `id`, `name`, `username`, `password`, `email`, `is_active`, `password_reset_token`, `email_confirm_token`, `avatar_provider`, `avatar_file_id`, `issuer`, `subject`, `email_reminders_enabled`, `created`, `updated` FROM `users` WHERE `username`=? LIMIT 1 [naleo] - 78.006µs 2021-01-27T19:50:39.49867287Z: DEBUG ▶ [DATABASE] 034 empty zone key[created] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.498711753Z: DEBUG ▶ [DATABASE] 035 empty zone key[updated] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.70443596Z: INFO ▶ [DATABASE] 038 [SQL] SELECT `id`, `name`, `username`, `password`, `email`, `is_active`, `password_reset_token`, `email_confirm_token`, `avatar_provider`, `avatar_file_id`, `issuer`, `subject`, `email_reminders_enabled`, `created`, `updated` FROM `users` WHERE `id`=? LIMIT 1 [1] - 82.244µs 2021-01-27T19:50:39.704724151Z: DEBUG ▶ [DATABASE] 039 empty zone key[created] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.704794172Z: DEBUG ▶ [DATABASE] 03a empty zone key[updated] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.722932781Z: INFO ▶ [DATABASE] 03c [SQL] SELECT namespaces.* FROM `namespaces` LEFT JOIN `team_namespaces` ON namespaces.id = team_namespaces.namespace_id LEFT JOIN `team_members` ON team_members.team_id = team_namespaces.team_id LEFT JOIN `users_namespace` ON users_namespace.namespace_id = namespaces.id WHERE (((team_members.user_id = ?)) OR (namespaces.owner_id = ?) OR (users_namespace.user_id = ?)) AND namespaces.title LIKE ? AND 1=? GROUP BY namespaces.id LIMIT 50 [1 1 1 %% 1] - 155.852µs 2021-01-27T19:50:39.723229447Z: DEBUG ▶ [DATABASE] 03d empty zone key[created] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.723272898Z: DEBUG ▶ [DATABASE] 03e empty zone key[updated] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.723466953Z: INFO ▶ [DATABASE] 03f [SQL] SELECT count(*) FROM `namespaces` LEFT JOIN `team_namespaces` ON namespaces.id = team_namespaces.namespace_id LEFT JOIN `team_members` ON team_members.team_id = team_namespaces.team_id LEFT JOIN `users_namespace` ON users_namespace.namespace_id = namespaces.id WHERE (((team_members.user_id = ?)) OR (namespaces.owner_id = ?) OR (users_namespace.user_id = ?)) AND (namespaces.is_archived = false) AND namespaces.title LIKE ? GROUP BY namespaces.id [1 1 1 %%] - 90.93µs 2021-01-27T19:50:39.723704859Z: INFO ▶ [DATABASE] 040 [SQL] SELECT `id`, `name`, `username`, `password`, `email`, `is_active`, `password_reset_token`, `email_confirm_token`, `avatar_provider`, `avatar_file_id`, `issuer`, `subject`, `email_reminders_enabled`, `created`, `updated` FROM `users` WHERE `id` IN (?) [1] - 57.598µs 2021-01-27T19:50:39.723854539Z: DEBUG ▶ [DATABASE] 041 empty zone key[created] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.723887181Z: DEBUG ▶ [DATABASE] 042 empty zone key[updated] : 2021-01-27 05:21:43 +0000 UTC | zone: UTC | location: {name:UTC zone:[] tx:[] extend: cacheStart:0 cacheEnd:0 cacheZone:} 2021-01-27T19:50:39.724060336Z: INFO ▶ [DATABASE] 043 [SQL] SELECT `id`, `title`, `description`, `identifier`, `hex_color`, `owner_id`, `namespace_id`, `is_archived`, `background_file_id`, `is_favorite`, `created`, `updated` FROM `list` WHERE `namespace_id` IN (?) [1] - 40.065µs 2021-01-27T19:50:39.724250453Z: INFO ▶ [DATABASE] 044 [SQL] SELECT l.* FROM `list` AS `l` LEFT JOIN `team_list` AS `tl` ON l.id = tl.list_id LEFT JOIN `team_members` AS `tm` ON tm.team_id = tl.team_id LEFT JOIN `users_list` AS `ul` ON ul.list_id = l.id WHERE (((tm.user_id = ?)) OR (ul.user_id = ?)) GROUP BY l.id [1 1] - 87.184µs 2021-01-27T19:50:39.724363875Z: INFO ▶ [DATABASE] 045 [SQL] SELECT `id`, `name`, `username`, `password`, `email`, `is_active`, `password_reset_token`, `email_confirm_token`, `avatar_provider`, `avatar_file_id`, `issuer`, `subject`, `email_reminders_enabled`, `created`, `updated` FROM `users` WHERE 0=1 [] - 36.639µs 2021-01-27T19:50:39.724487196Z: INFO ▶ [DATABASE] 046 [SQL] SELECT `id`, `file_id`, `unsplash_id`, `author`, `author_name` FROM `unsplash_photos` WHERE 0=1 [] - 26.399µs 2021-01-27T19:50:39.724815964Z: INFO ▶ [DATABASE] 047 [SQL] SELECT count(*) FROM `tasks` INNER JOIN `list` ON tasks.list_id = list.id INNER JOIN `namespaces` ON list.namespace_id = namespaces.id WHERE tasks.is_favorite=? AND namespaces.id IN (?) [true 1] - 84.669µs 2021-01-27T19:50:39.72497956Z: INFO ▶ [DATABASE] 048 [SQL] SELECT `id`, `filters`, `title`, `description`, `owner_id`, `created`, `updated` FROM `saved_filters` WHERE (owner_id = ?) [1] - 33.994µs 2021-01-27T19:50:39.725254135Z: INFO ▶ [DATABASE] 049 [SQL] SELECT `id`, `user_id`, `migrator_name`, `created` FROM `migration_status` WHERE (user_id = ? and migrator_name = ?) ORDER BY `id` DESC LIMIT 1 [1 todoist] - 1.734443ms