[DEBUG - root] # BEGIN SQL QUERY #
SELECT id
FROM event_view NATURAL
JOIN
  (SELECT subj_id, max(timestamp) AS timestamp
   FROM event_view
   WHERE (((subj_uri = 'http://www.google.com/ig'
            AND subj_current_uri = 'http://www.google.com/ig')
           OR (subj_uri = 'https://mail.google.com/mail/ca/#inbox'
               AND subj_current_uri = 'https://mail.google.com/mail/ca/#inbox')
           OR (subj_uri = 'http://git.gnome.org/browse/vala/log/'
               AND subj_current_uri = 'http://git.gnome.org/browse/vala/log/')
           OR (subj_uri = 'http://twitter.com/'
               AND subj_current_uri = 'http://twitter.com/')
           OR (subj_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird'
               AND subj_current_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird')
           OR (subj_uri = 'http://www.facebook.com/'
               AND subj_current_uri = 'http://www.facebook.com/')
           OR (subj_uri = 'application://dfeet.desktop'
               AND subj_current_uri = 'application://dfeet.desktop')
           OR (subj_uri = 'http://jizdnirady.idnes.cz/brno/spojeni/'
               AND subj_current_uri = 'http://jizdnirady.idnes.cz/brno/spojeni/')
           OR (subj_uri = 'http://fpaste.org/fomk/'
               AND subj_current_uri = 'http://fpaste.org/fomk/')
           OR (subj_uri = 'http://dbus.freedesktop.org/doc/dbus-specification.html#introspection-format'
               AND subj_current_uri = 'http://dbus.freedesktop.org/doc/dbus-specification.html#introspection-format')
           OR (subj_uri = 'http://www.youtube.com/watch?v=JWiwuiT58Yc'
               AND subj_current_uri = 'http://www.youtube.com/watch?v=JWiwuiT58Yc')
           OR (subj_uri = 'file:///home/miso/projects/gsoc/bluebird/src/zeitgeist-daemon.vala'
               AND subj_current_uri = 'file:///home/miso/projects/gsoc/bluebird/src/zeitgeist-daemon.vala')
           OR (subj_uri = 'https://plus.google.com/'
               AND subj_current_uri = 'https://plus.google.com/')
           OR (subj_uri = 'application://totem.desktop'
               AND subj_current_uri = 'application://totem.desktop')
           OR (subj_uri = 'application://devhelp.desktop'
               AND subj_current_uri = 'application://devhelp.desktop')
           OR (subj_uri = 'http://www.google.com/reader/view/#stream/feed%2Fhttp%3A%2F%2Fplanet.gnome.org%2Fatom.xml'
               AND subj_current_uri = 'http://www.google.com/reader/view/#stream/feed%2Fhttp%3A%2F%2Fplanet.gnome.org%2Fatom.xml')
           OR (subj_uri = 'https://mail.google.com/mail/?hl=en&tab=wm#inbox'
               AND subj_current_uri = 'https://mail.google.com/mail/?hl=en&tab=wm#inbox')
           OR (subj_uri = 'application://gnome-system-monitor.desktop'
               AND subj_current_uri = 'application://gnome-system-monitor.desktop')
           OR (subj_uri = 'https://launchpad.net/synapse-project/+milestone/0.2.8'
               AND subj_current_uri = 'https://launchpad.net/synapse-project/+milestone/0.2.8')
           OR (subj_uri = 'http://git.gnome.org/browse/librest/log'
               AND subj_current_uri = 'http://git.gnome.org/browse/librest/log')
           OR (subj_uri = 'http://synapse.zeitgeist-project.com/wiki/index.php?title=Main_Page'
               AND subj_current_uri = 'http://synapse.zeitgeist-project.com/wiki/index.php?title=Main_Page')
           OR (subj_uri = 'application://skype.desktop'
               AND subj_current_uri = 'application://skype.desktop')
           OR (subj_uri = 'http://www.youtube.com/watch?v=Egi9GsgEvRw'
               AND subj_current_uri = 'http://www.youtube.com/watch?v=Egi9GsgEvRw')
           OR (subj_uri = 'file:///usr/local/share/vala-0.14/vapi/glib-2.0.vapi'
               AND subj_current_uri = 'file:///usr/local/share/vala-0.14/vapi/glib-2.0.vapi')
           OR (subj_uri = 'file:///home/miso/projects/gsoc/bluebird/src/datamodel.vala'
               AND subj_current_uri = 'file:///home/miso/projects/gsoc/bluebird/src/datamodel.vala')
           OR (subj_uri = 'http://www.google.com/reader/view/#stream/feed%2Fhttp%3A%2F%2Fwww.cdr.cz%2Fcdrrss.php'
               AND subj_current_uri = 'http://www.google.com/reader/view/#stream/feed%2Fhttp%3A%2F%2Fwww.cdr.cz%2Fcdrrss.php')
           OR (subj_uri = 'https://launchpad.net/~synapse-core/+archive/ppa'
               AND subj_current_uri = 'https://launchpad.net/~synapse-core/+archive/ppa')
           OR (subj_uri = 'http://www.google.com/ig?refresh=1'
               AND subj_current_uri = 'http://www.google.com/ig?refresh=1')
           OR (subj_uri = 'application://gnome-terminal.desktop'
               AND subj_current_uri = 'application://gnome-terminal.desktop')
           OR (subj_uri = 'file:///home/miso/projects/synapse/src/plugins/test/launchpad.vala'
               AND subj_current_uri = 'file:///home/miso/projects/synapse/src/plugins/test/launchpad.vala')
           OR (subj_uri = 'application://FUN radio.desktop'
               AND subj_current_uri = 'application://FUN radio.desktop')
           OR (subj_uri = 'https://www.facebook.com/permalink.php?story_fbid=10150238024153057&id=622193056'
               AND subj_current_uri = 'https://www.facebook.com/permalink.php?story_fbid=10150238024153057&id=622193056')
           OR (subj_uri = 'https://mail.google.com/mail/?shva=1#inbox'
               AND subj_current_uri = 'https://mail.google.com/mail/?shva=1#inbox')
           OR (subj_uri = 'http://en.wikipedia.org/wiki/List_of_Eureka_episodes'
               AND subj_current_uri = 'http://en.wikipedia.org/wiki/List_of_Eureka_episodes')
           OR (subj_uri = 'https://code.launchpad.net/zeitgeist'
               AND subj_current_uri = 'https://code.launchpad.net/zeitgeist')
           OR (subj_uri = 'file:///home/miso/projects/gsoc/bluebird/src/engine.vala'
               AND subj_current_uri = 'file:///home/miso/projects/gsoc/bluebird/src/engine.vala')
           OR (subj_uri = 'application://firefox.desktop'
               AND subj_current_uri = 'application://firefox.desktop')
           OR (subj_uri = 'http://twitter.com/#!/'
               AND subj_current_uri = 'http://twitter.com/#!/')
           OR (subj_uri = 'http://www.google.com/reader/view/#overview-page'
               AND subj_current_uri = 'http://www.google.com/reader/view/#overview-page')
           OR (subj_uri = 'http://www.sgalaxy.cz/forum/43-firmware'
               AND subj_current_uri = 'http://www.sgalaxy.cz/forum/43-firmware')
           OR (subj_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/symbols/+merge/69927'
               AND subj_current_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/symbols/+merge/69927')
           OR (subj_uri = 'https://mail.google.com/mail/?tab=ym#inbox'
               AND subj_current_uri = 'https://mail.google.com/mail/?tab=ym#inbox')
           OR (subj_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/some-fixes/+merge/74927'
               AND subj_current_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/some-fixes/+merge/74927')
           OR (subj_uri = 'http://3duard.deviantart.com/art/Pantheon-Desktop-Ubuntu-11-04-216455653'
               AND subj_current_uri = 'http://3duard.deviantart.com/art/Pantheon-Desktop-Ubuntu-11-04-216455653')
           OR (subj_uri = 'http://en.wikipedia.org/wiki/List_of_How_I_Met_Your_Mother_episodes'
               AND subj_current_uri = 'http://en.wikipedia.org/wiki/List_of_How_I_Met_Your_Mother_episodes')
           OR (subj_uri = 'https://code.launchpad.net/libzeitgeist'
               AND subj_current_uri = 'https://code.launchpad.net/libzeitgeist')
           OR (subj_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird_basedir/+merge/69658'
               AND subj_current_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird_basedir/+merge/69658')
           OR (subj_uri = 'http://6.asset.soup.io/asset/2102/6566_d36e.jpeg'
               AND subj_current_uri = 'http://6.asset.soup.io/asset/2102/6566_d36e.jpeg')
           OR (subj_uri = 'http://git.gnome.org/browse/libpeas/log/'
               AND subj_current_uri = 'http://git.gnome.org/browse/libpeas/log/')
           OR (subj_uri = 'http://pastebin.ubuntu.com/632965/'
               AND subj_current_uri = 'http://pastebin.ubuntu.com/632965/')
           OR (subj_uri = 'http://pastebin.com/Z7mK5dFN'
               AND subj_current_uri = 'http://pastebin.com/Z7mK5dFN')
           OR (subj_uri = 'http://paste.ubuntu.com/639393/'
               AND subj_current_uri = 'http://paste.ubuntu.com/639393/')
           OR (subj_uri = 'https://bugs.launchpad.net/zeitgeist/+bug/807076'
               AND subj_current_uri = 'https://bugs.launchpad.net/zeitgeist/+bug/807076')
           OR (subj_uri = 'http://0wx.de/e2b4f1b5902313dadb11a940041cc22f/'
               AND subj_current_uri = 'http://0wx.de/e2b4f1b5902313dadb11a940041cc22f/')
           OR (subj_uri = 'http://thepiratebay.org/'
               AND subj_current_uri = 'http://thepiratebay.org/')
           OR (subj_uri = 'http://comixed.memebase.com/2011/07/08/koma-comic-strip-this-is-sparta/'
               AND subj_current_uri = 'http://comixed.memebase.com/2011/07/08/koma-comic-strip-this-is-sparta/')
           OR (subj_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bb-payload/+merge/75826'
               AND subj_current_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bb-payload/+merge/75826')
           OR (subj_uri = 'http://fpaste.org/LOOT/'
               AND subj_current_uri = 'http://fpaste.org/LOOT/')
           OR (subj_uri = 'https://launchpad.net/synapse-project'
               AND subj_current_uri = 'https://launchpad.net/synapse-project')
           OR (subj_uri = 'https://live.gnome.org/Vala/DBusServerSample'
               AND subj_current_uri = 'https://live.gnome.org/Vala/DBusServerSample')
           OR (subj_uri = 'file:///home/miso/projects/ppastats.py'
               AND subj_current_uri = 'file:///home/miso/projects/ppastats.py')
           OR (subj_uri = 'https://live.gnome.org/Vala/Manual/Attributes'
               AND subj_current_uri = 'https://live.gnome.org/Vala/Manual/Attributes')
           OR (subj_uri = 'https://mail.google.com/mail/?tab=Xm#inbox'
               AND subj_current_uri = 'https://mail.google.com/mail/?tab=Xm#inbox')
           OR (subj_uri = 'http://www.youtube.com/watch?v=9QBv2CFTSWU'
               AND subj_current_uri = 'http://www.youtube.com/watch?v=9QBv2CFTSWU')
           OR (subj_uri = 'http://www.youtube.com/watch?v=UyG1FG3H6rY&feature=list_related&playnext=1&list=AV4oVf-d_DwKAx0t95xumNPUwlhb7Rv6-f'
               AND subj_current_uri = 'http://www.youtube.com/watch?v=UyG1FG3H6rY&feature=list_related&playnext=1&list=AV4oVf-d_DwKAx0t95xumNPUwlhb7Rv6-f')
           OR (subj_uri = 'http://lists.freedesktop.org/archives/xdg/2011-May/thread.html#11947'
               AND subj_current_uri = 'http://lists.freedesktop.org/archives/xdg/2011-May/thread.html#11947')
           OR (subj_uri = 'http://pastebin.com/GwWPKKyd'
               AND subj_current_uri = 'http://pastebin.com/GwWPKKyd')
           OR (subj_uri = 'http://samtate.deviantart.com/art/Ergo-elementary-ToDo-app-215051833?#comments-'
               AND subj_current_uri = 'http://samtate.deviantart.com/art/Ergo-elementary-ToDo-app-215051833?#comments-')
           OR (subj_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird-symbol2/+merge/69833'
               AND subj_current_uri = 'https://code.launchpad.net/~zeitgeist/zeitgeist/bluebird-symbol2/+merge/69833')
           OR (subj_uri = 'https://live.gnome.org/Vala/Manual/Attributes#Description_Attribute'
               AND subj_current_uri = 'https://live.gnome.org/Vala/Manual/Attributes#Description_Attribute')
           OR (subj_uri = 'http://www.lczajkowski.com/2011/06/22/ubuntu-ie-and-canonical-meet-up-in-dublin/'
               AND subj_current_uri = 'http://www.lczajkowski.com/2011/06/22/ubuntu-ie-and-canonical-meet-up-in-dublin/')
           OR (subj_uri = 'https://developer.mozilla.org/en/Gecko_DOM_Reference'
               AND subj_current_uri = 'https://developer.mozilla.org/en/Gecko_DOM_Reference')
           OR (subj_uri = 'file:///home/miso/Rest-0.7.metadata'
               AND subj_current_uri = 'file:///home/miso/Rest-0.7.metadata')
           OR (subj_uri = 'http://software.intel.com/en-us/forums/intel-opencl-sdk/'
               AND subj_current_uri = 'http://software.intel.com/en-us/forums/intel-opencl-sdk/')
           OR (subj_uri = 'http://people.ubuntu.com/~ricotz/plank-docs/gtk-doc/'
               AND subj_current_uri = 'http://people.ubuntu.com/~ricotz/plank-docs/gtk-doc/')
           OR (subj_uri = 'application://synaptic.desktop'
               AND subj_current_uri = 'application://synaptic.desktop')
           OR (subj_uri = 'http://stackoverflow.com/questions/7184154/how-do-you-use-gdkrectangle-to-determine-whether-you-size-allocate-is-growing-or/7206262#7206262'
               AND subj_current_uri = 'http://stackoverflow.com/questions/7184154/how-do-you-use-gdkrectangle-to-determine-whether-you-size-allocate-is-growing-or/7206262#7206262')
           OR (subj_uri = 'http://paste.ubuntu.com/654442/'
               AND subj_current_uri = 'http://paste.ubuntu.com/654442/')
           OR (subj_uri = 'http://pastebin.com/KEprj5qY'
               AND subj_current_uri = 'http://pastebin.com/KEprj5qY')
           OR (subj_uri = 'http://wiki.go-docky.com/?title=Plank:Introduction'
               AND subj_current_uri = 'http://wiki.go-docky.com/?title=Plank:Introduction')
           OR (subj_uri = 'http://paste.debian.net/124224/'
               AND subj_current_uri = 'http://paste.debian.net/124224/')
           OR (subj_uri = 'http://gitorious.org/libpeas-vapi'
               AND subj_current_uri = 'http://gitorious.org/libpeas-vapi')
           OR (subj_uri = 'https://mail.google.com/mail/ca/#inbox/1323a64bd139a211'
               AND subj_current_uri = 'https://mail.google.com/mail/ca/#inbox/1323a64bd139a211')
           OR (subj_uri = 'http://fpaste.org/5NaQ/'
               AND subj_current_uri = 'http://fpaste.org/5NaQ/')
           OR (subj_uri = 'file:///home/miso/projects/synapse/src/core/volume-service.vala'
               AND subj_current_uri = 'file:///home/miso/projects/synapse/src/core/volume-service.vala')
           OR (subj_uri = 'http://paste.ubuntu.com/636788/'
               AND subj_current_uri = 'http://paste.ubuntu.com/636788/')
           OR (subj_uri = 'https://bugzilla.gnome.org/show_bug.cgi?id=624624'
               AND subj_current_uri = 'https://bugzilla.gnome.org/show_bug.cgi?id=624624')
           OR (subj_uri = 'http://www.fib.upc.edu/en/estudiar-enginyeria-informatica/especialitats-grau/enginyeria-del-software.html'
               AND subj_current_uri = 'http://www.fib.upc.edu/en/estudiar-enginyeria-informatica/especialitats-grau/enginyeria-del-software.html')
           OR (subj_uri = 'https://launchpad.net/~zeitgeist/+archive/ppa/+build/2029142'
               AND subj_current_uri = 'https://launchpad.net/~zeitgeist/+archive/ppa/+build/2029142')
           OR (subj_uri = 'http://dbus.freedesktop.org/doc/dbus-specification.html#bus-messages-name-owner-changed'
               AND subj_current_uri = 'http://dbus.freedesktop.org/doc/dbus-specification.html#bus-messages-name-owner-changed')
           OR (subj_uri = 'http://www.gtk.org/introspection/core/1.0'
               AND subj_current_uri = 'http://www.gtk.org/introspection/core/1.0')
           OR (subj_uri = 'http://sourceforge.net/projects/pdfcreator/'
               AND subj_current_uri = 'http://sourceforge.net/projects/pdfcreator/')
           OR (subj_uri = 'file:///opt/gnome/share/gir-1.0/Peas-1.0.gir'
               AND subj_current_uri = 'file:///opt/gnome/share/gir-1.0/Peas-1.0.gir')
           OR (subj_uri = 'https://code.launchpad.net/dockmanager'
               AND subj_current_uri = 'https://code.launchpad.net/dockmanager')
           OR (subj_uri = 'http://twitter.com/#!/mentions'
               AND subj_current_uri = 'http://twitter.com/#!/mentions')
           OR (subj_uri = 'http://www.androidcentral.com/'
               AND subj_current_uri = 'http://www.androidcentral.com/')))
   GROUP BY subj_id)
GROUP BY subj_id
ORDER BY timestamp DESC LIMIT 96;
took 25.518158s
# END SQL QUERY
[DEBUG - zeitgeist.engine] Found 96 events IDs in 25.939492s
[DEBUG - root] # BEGIN SQL QUERY #

SELECT *
FROM event_view
WHERE id IN (214259,
             214247,
             214237,
             214223,
             214128,
             214111,
             214101,
             214075,
             214013,
             214006,
             214004,
             213964,
             213958,
             213835,
             213510,
             213507,
             213396,
             213285,
             213129,
             213110,
             212767,
             212498,
             212496,
             212490,
             212262,
             210868,
             210611,
             210318,
             209539,
             209454,
             209309,
             209206,
             208612,
             208580,
             208231,
             208079,
             207180,
             206077,
             205348,
             204018,
             203568,
             203554,
             202465,
             201632,
             197669,
             197573,
             197547,
             196649,
             195640,
             193092,
             192539,
             192045,
             191499,
             191060,
             190921,
             190760,
             189503,
             189362,
             188537,
             188522,
             188234,
             187080,
             187038,
             186613,
             186600,
             186509,
             182382,
             182360,
             181201,
             181194,
             181185,
             180981,
             180507,
             179617,
             179273,
             178899,
             178253,
             178086,
             178080,
             178045,
             177415,
             176058,
             175875,
             175567,
             175365,
             175172,
             147193) ;
took 0.000641s
# END SQL QUERY
[DEBUG - zeitgeist.engine] Got 87 raw events in 0.022756s
[DEBUG - zeitgeist.engine] Got 96 events in 0.006053s
[DEBUG - zeitgeist.engine]     Where time spent in _get_event_from_row in 0.001950s
[DEBUG - zeitgeist.engine]     Where time spent in _get_subject_from_row in 0.001707s
[DEBUG - zeitgeist.engine]     Where time spent in apply_get_hooks in 0.000504s
[DEBUG - root] GOT 96 events in 25.969458s