{"host":"OmerPC","timestamp":"2015-11-17T15:50:39.932Z","payload":["0: PRAGMA main.cache_size = 20000;"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:39.933Z","payload":["0: PRAGMA main.synchronous = NORMAL;"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:39.933Z","payload":["0: PRAGMA main.page_size = 8192;"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:39.933Z","payload":["0: PRAGMA journal_mode = WAL;"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:39.933Z","payload":["2: PRAGMA user_version"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:39.942Z","payload":["0: SELECT `Label`.`data` FROM `Label` WHERE `Label`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.071Z","payload":["0: SELECT `Label`.`data` FROM `Label` WHERE `Label`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.090Z","payload":["0: SELECT `data` FROM `JSONObject` WHERE key = ? LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.092Z","payload":["0: SELECT `data` FROM `JSONObject` WHERE key = ? LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.126Z","payload":["0: SELECT `data` FROM `JSONObject` WHERE key = ? LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.127Z","payload":["1: SELECT COUNT(*) as count FROM `Message` WHERE `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `Message`.`draft` = 1 "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.132Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `Message`.`draft` = 1 ORDER BY `Message`.`date` DESC LIMIT 100"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.142Z","payload":["0: SELECT COUNT(*) as count FROM `Message` WHERE `Message`.`draft` = 1 AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.144Z","payload":["2: SELECT COUNT(*) as count FROM `Thread` INNER JOIN `Thread-Label` AS `M7` ON `M7`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `M7`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.192Z","payload":["1: SELECT `Thread`.`data` FROM `Thread` INNER JOIN `Thread-Label` AS `M7` ON `M7`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `M7`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' ORDER BY `Thread`.`last_message_received_timestamp` DESC LIMIT 100"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.195Z","payload":["0: SELECT `Label`.`data` FROM `Label` WHERE `Label`.`name` = 'inbox' AND `Label`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.219Z","payload":["1: SELECT `Contact`.`data` FROM `Contact` WHERE `Contact`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.326Z","payload":["2: SELECT `Message`.`data` FROM `Message` WHERE `Message`.`thread_id` in ('5a2stoja258uvztdv9fd5o131','ceag25p3w6nollc9rj51v72yf','4hygobcpgz2nnh9qpf0j3lcki','cnza9lw6htmkkgpomia2rbicp','d8rqr3jxep19y5tyiejxv9c1c','kgmh3smcqg1m1z6icbk8m5i6','94t92mhmrm22l7z7fzgle62vc','4uyirifafsvk2i3zoub5lxvy7','9pk1knzojygr3mceisuwzet15','e8ljz8brlll7a870wdrhcu4o6','a8vgnv1vecfjc4unvrqc256a8','erv0ryx3aoiil6uzu9jr8uqxk','a8kosjesiwuxh4jf04qx6qn6q','e4r06ya5iex0hckgh1qq7f8rf','6ajp1fegqn51mbc5nouw5xlzn','4i6uvmi6bb9kut1iit9d1uyur','f05d46fjq8zr4zerhwtf8y91','43lcyggi9tcdt7vbl4k3wurk7','65vouwayle7dr0moafpxgs0c6','ojpyk9t6sdgsr7mv23p0d57y','ewijwvkv781gn6izagcdxabge','852d13d8n4cddoudp5ynr9v53','a6cpmcok744puibj1118ngk8s','5bd8s4fhmzxfomsjw3p6t9ffn','bjw6w4hhix04rie600rdcf0iu','45x31bb8v202l266k9oirc7iz','1i5pnpanou84617xjqzr33r1q','c1cfimalztx8rlkdz4l0fqsm0','d25mszqz2pkb6ipd2g34ndosl','evck2z853z8m5wz65p911ze77','88u40iv1orriwi0k4pfxg10p7','3yoo215yh0cz74dy9cbfhfc1a','94v37ddtd9cqwhp5316618fdd','63vsj2to8uvm4kuo541pqnwrf','bl7qb1u6ygd1f873j39zz3ctc','4huusb1dyd97lv3hjhtc6a7rt','8d484g69drq3ymnw1k5tb9v54','2snlfdwa2co4xwf0suat4gcf3','bdbf1nyjzlxic8vcs80d1ti5s','2qvhu22nfi3cfdvse6hten3yc','8byzob1t3rfnz2p9uxg5yodal','5iu4aghc8be1h0vlbo1fyy7gz','7urdtxirqmtujqdrxb53k9u7x','9845a1vvaexdgxzqtwjxipa4','74al955de6oi19qzatnnou95f','dbwvzjtrn5zk5emzp4lifzf9k','9cssvj4lqzbkn08uzbi1ai3rj','f0zr4btzm37fddke3ig87rfq5','3and0mu7q6nu6m5li3ave6lpv','7iqhd5utw2vst5mmks8os4u0a','9g3qkme9aoc59aqy45tpvsh94','5w16rpiwimo041b4edaz51hdb','3yb0pml9a1z084bx5kokun9y1','8ayiofi2648txsm3at7y6rvfq','dbgo5ycv40h2sacw66o00m0p8','dab1vvbrkw0iuprn1lnh1h4p1','5ok8i7lwv0ylm7mnj65n5utj1','8rbi6ya0w3aotv59cptd9dflw','dpcn7q2h434ln9mxfz3amz91','71z10u4j709jg2kbk2vwb58sv','eygg3j0l87ncm3jyg6fw0fbgw','6yk81iq5skvoqymj6uzgdyv9k','d11ci8gj8jgyfbhdqtx5zbdxl','dq2ond6ghwqfplhg1isoghv2','55wbncsifabd6wlehi2cam0i2','acst0oyy8b9ui66l0rx8lihf3','6ofr472u1796svqyv1iyfyx8a','rylf14wpq86azmsp7du3p6y8','awjue0p4cigv3sfzz50pv1lfw','9z3w8vjpxyfpqhj5fqakozzjr','d2b87wvkrvv1zpcome2h8v0rp','42j2fapzg1vvhafa6r00fc2ik','n6ang3bi9ygm4qriwcsmm0ng','eiy24rbzrebf2xsedxrgohzo6','arpy1d0khoig0yhfl9see2aah','5aj35u16vwphai60qo3qzmo07','8ebm3xpqjkxvjhopot2s08f3m','2zoiqplqu0l8w532ehi80q9k0','1s7frhsok7h4ukdnbre92j1jp','d6cfjiamcmyfmrtoubtrb1pjx','3kyno66uqclsfxsam8qe6xkq6','dy36qss7q67lve5d2v932xn3f','ei9pkesyl09r07iy15kn2lb8m','ew57t6ky45lq07w5q3azc2vgk','yqo372i6blyv7toroxv0hcs7','807potx0rutgc7q2f16s2w72q','u1owmn79rt5jt8tabbxyuj05','btyxhitdj1cmtz9lau2uibkni','b05u1rsgmw3s7tep1qo9bwcgx','cwzorqualkgutm94c87lv46md','92aa7eqjrmwoz86d9r6qb4kds','6g7navansztqu4q4atwx3tx4v','abr6rq6mvmmhvx4h13fug4ib9','795b2h6rcek77o6lxlldl292i','dwfw06h5pd5glm6zidtfx2n5o','bih9yjfcioxeixt0mvogfjefd','7p6ruqbmq9if33wholp2xtoa0','1n019lxyjgkx3yhd0vr1ugjn5','ol7dphdejnq7ybuhh8kr51ai','4bbohc5kdymgmmmdt22wltulz') AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.531Z","payload":["3: SELECT COUNT(*) as count FROM `Thread` INNER JOIN `Thread-Label` AS `M23` ON `M23`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `Thread`.`unread` = 1 AND `M23`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.623Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:40.815Z","payload":["0: SELECT `Contact`.`data` FROM `Contact` WHERE `Contact`.`email` = 'notifications@github.com' AND `Contact`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.140Z","payload":["ActionBridge: default Action Bridge Received: longPollReceivedRawDeltasPing"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.166Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.170Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.181Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.199Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.204Z","payload":["ActionBridge: default Action Bridge Received: didPassivelyReceiveNewModels"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.206Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.208Z","payload":["1: SELECT COUNT(*) as count FROM `Thread` INNER JOIN `Thread-Label` AS `M7` ON `M7`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `M7`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:43.210Z","payload":["1: SELECT `Thread`.`data` FROM `Thread` INNER JOIN `Thread-Label` AS `M7` ON `M7`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `M7`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' ORDER BY `Thread`.`last_message_received_timestamp` DESC LIMIT 100"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:46.515Z","payload":["0: SELECT `Message`.`data` FROM `Message` WHERE `Message`.`thread_id` in ('5a2stoja258uvztdv9fd5o131') AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:46.549Z","payload":["1: SELECT `Contact`.`data` FROM `Contact` WHERE `Contact`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.103Z","payload":["ActionBridge: default Action Bridge Broadcasting: queueTask"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.104Z","payload":["ActionBridge: default Action Bridge Broadcasting: queueTask"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.114Z","payload":[{"eventName":"ChangeUnreadTask","eventArgs":{"item_count":1,"platform":"win32","version":"0.3.20","distinct_id":"dcs0dzbbb7irbr1qktjd079vc","accountId":"dcs0dzbbb7irbr1qktjd079vc","token":"9a2137b80c098b3d594e39b776ebe085","mp_lib":"node"}}]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.115Z","payload":[{"eventName":"ChangeUnreadTask","eventArgs":{"item_count":1,"platform":"win32","version":"0.3.20","distinct_id":"dcs0dzbbb7irbr1qktjd079vc","accountId":"dcs0dzbbb7irbr1qktjd079vc","token":"9a2137b80c098b3d594e39b776ebe085","mp_lib":"node"}}]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.130Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.168Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.192Z","payload":["1: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.205Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.206Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.211Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:47.225Z","payload":["0: SELECT `Message`.`data` FROM `Message` WHERE `Message`.`thread_id` in ('5a2stoja258uvztdv9fd5o131') AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:51.541Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:52.153Z","payload":["0: SELECT `Label`.`data` FROM `Label` WHERE `Label`.`name` = 'inbox' AND `Label`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:52.155Z","payload":["1: SELECT COUNT(*) as count FROM `Thread` INNER JOIN `Thread-Label` AS `M45` ON `M45`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `Thread`.`unread` = 1 AND `M45`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.457Z","payload":["ActionBridge: default Action Bridge Received: longPollReceivedRawDeltasPing"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.474Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.480Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.490Z","payload":["0: SELECT `Message`.`data` FROM `Message` WHERE `Message`.`thread_id` in ('5a2stoja258uvztdv9fd5o131') AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.550Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.567Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:53.595Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:58.579Z","payload":["0: SELECT `Label`.`data` FROM `Label` WHERE `Label`.`name` = 'inbox' AND `Label`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:58.581Z","payload":["2: SELECT COUNT(*) as count FROM `Thread` INNER JOIN `Thread-Label` AS `M6` ON `M6`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `Thread`.`unread` = 1 AND `M6`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' "]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:59.795Z","payload":["ActionBridge: default Action Bridge Received: longPollReceivedRawDeltasPing"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:59.809Z","payload":["ActionBridge: default Action Bridge Received: db-store-trigger"]} {"host":"OmerPC","timestamp":"2015-11-17T15:50:59.838Z","payload":["0: SELECT `Message`.`data`, IFNULL(`MessageBody`.`value`, '!NULLVALUE!') AS `body` FROM `Message` LEFT OUTER JOIN `MessageBody` ON `MessageBody`.`id` = `Message`.`id` WHERE `Message`.`thread_id` = '5a2stoja258uvztdv9fd5o131' AND `Message`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' ORDER BY `Message`.`date` ASC "]} {"host":"OmerPC","timestamp":"2015-11-17T15:51:04.826Z","payload":["0: SELECT `Label`.`data` FROM `Label` WHERE `Label`.`name` = 'inbox' AND `Label`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' LIMIT 1"]} {"host":"OmerPC","timestamp":"2015-11-17T15:51:04.828Z","payload":["2: SELECT COUNT(*) as count FROM `Thread` INNER JOIN `Thread-Label` AS `M13` ON `M13`.`id` = `Thread`.`id` WHERE `Thread`.`account_id` = 'dcs0dzbbb7irbr1qktjd079vc' AND `Thread`.`unread` = 1 AND `M13`.`value` = 'buwu699l5k6f7jqcc8m0l4y0s' "]}