Skip to content

Instantly share code, notes, and snippets.

@zverok
Created October 24, 2013 12:36
Show Gist options
  • Save zverok/7136440 to your computer and use it in GitHub Desktop.
Save zverok/7136440 to your computer and use it in GitHub Desktop.
I, [2013-10-24T15:35:15.907842 #19391] INFO -- : (0.167803s) SELECT * FROM `clients` WHERE (`id` = 4) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:35:16.111724 #19391] INFO -- : (0.202800s) SELECT * FROM `seeds` WHERE (`id` = 7) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:35:16.316790 #19391] INFO -- : (0.203984s) SELECT * FROM `fetches` WHERE (`id` = 3556821) ORDER BY `fetched_at` LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:35:16.522125 #19391] INFO -- : (0.203088s) DESCRIBE `mentions_client_4`
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:34:in `block in make_class' */
I, [2013-10-24T15:35:16.727251 #19391] INFO -- : (0.196742s) SELECT * FROM `mentions_client_4` WHERE (`url` = 'http://vk.com/wall-341229_11455_') LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:20:in `block (2 levels) in <class:API_v2>' */
I, [2013-10-24T15:35:16.931066 #19391] INFO -- : (0.194160s) SELECT * FROM `users` WHERE ((`name` = 'Animatsuri 21-22 декабря Санкт-Петербург') AND (`url` = 'http://vk.com/club341229_')) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/decorators/helpers.rb:18:in `instance' */
I, [2013-10-24T15:35:17.135680 #19391] INFO -- : (0.202364s) BEGIN
I, [2013-10-24T15:35:17.341075 #19391] INFO -- : (0.204553s) INSERT INTO `users` (`name`, `url`, `guid`) VALUES ('Animatsuri 21-22 декабря Санкт-Петербург', 'http://vk.com/club341229_', 'http://vk.com/club341229_')
I, [2013-10-24T15:35:17.545518 #19391] INFO -- : (0.203373s) SELECT * FROM `users` WHERE (`id` = 3905398) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/decorators/helpers.rb:18:in `instance' */
I, [2013-10-24T15:35:17.684921 #19391] INFO -- : (0.139005s) COMMIT
I, [2013-10-24T15:35:17.852640 #19391] INFO -- : (0.166181s) SELECT * FROM `journals` WHERE ((`name` = 'Animatsuri 21-22 декабря Санкт-Петербург') AND (`url` = 'http://vk.com/club341229_') AND (`kind_class` = 'group')) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/decorators/helpers.rb:18:in `instance' */
I, [2013-10-24T15:35:18.057313 #19391] INFO -- : (0.203225s) BEGIN
I, [2013-10-24T15:35:18.262036 #19391] INFO -- : (0.204000s) INSERT INTO `journals` (`name`, `url`, `kind_class`, `guid`) VALUES ('Animatsuri 21-22 декабря Санкт-Петербург', 'http://vk.com/club341229_', 'group', 'http://vk.com/club341229_')
I, [2013-10-24T15:35:18.467137 #19391] INFO -- : (0.204179s) SELECT * FROM `journals` WHERE (`id` = 4025011) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/decorators/helpers.rb:18:in `instance' */
I, [2013-10-24T15:35:18.671681 #19391] INFO -- : (0.204021s) COMMIT
I, [2013-10-24T15:35:18.876504 #19391] INFO -- : (0.202359s) SELECT * FROM `platforms` WHERE (`url` = 'http://vk.com') LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/platform.rb:20:in `by_url' */
I, [2013-10-24T15:35:19.081298 #19391] INFO -- : (0.201415s) SELECT count(*) AS `count` FROM `mentions_client_4` WHERE (`url` = 'http://vk.com/wall-341229_11455_') LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:79:in `validate' */
I, [2013-10-24T15:35:19.286042 #19391] INFO -- : (0.204263s) BEGIN
I, [2013-10-24T15:35:20.207652 #19391] INFO -- : (0.196166s) INSERT INTO `mentions_client_4` (`kind_class`, `url`, `created_at`, `title`, `author_id`, `journal_id`, `platform_id`, `author_guid`, `author_name`, `author_readers_count`, `author_url`, `platform_guid`, `platform_name`, `platform_url`, `journal_kind_class`, `journal_guid`, `journal_name`, `journal_url`, `journal_is_client_journal`, `mongodb_fk`, `lingua_language`, `is_spam`) VALUES ('newsfeed', 'http://vk.com/wall-341229_11455_', '2013-10-24 07:30:46', '', 3905398, 4025011, 7, 'http://vk.com/club341229_', 'Animatsuri 21-22 декабря Санкт-Петербург', NULL, 'http://vk.com/club341229_', 'vk.com', 'vk.com', 'http://vk.com', 'group', 'http://vk.com/club341229_', 'Animatsuri 21-22 декабря Санкт-Петербург', 'http://vk.com/club341229_', 0, '52691407d293c94bbf000001', 'ru', 0)
I, [2013-10-24T15:35:20.413059 #19391] INFO -- : (0.204193s) SELECT * FROM `mentions_client_4` WHERE (`id` = 966674) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers/models_plugin.rb:36:in `save_without_notifications' */
I, [2013-10-24T15:35:20.555078 #19391] INFO -- : (0.141535s) COMMIT
I, [2013-10-24T15:35:20.719862 #19391] INFO -- : (0.162062s) SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 7))
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:31:in `block in <class:API_v2>' */
I, [2013-10-24T15:35:20.924647 #19391] INFO -- : (0.202071s) SELECT * FROM `mention_details` WHERE ((`client_id` = 4) AND (`mention_id` = 966674) AND (`label_id` = 5)) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:33:in `block (3 levels) in <class:API_v2>' */
I, [2013-10-24T15:35:21.129245 #19391] INFO -- : (0.201050s) SELECT count(*) AS `count` FROM `mention_details` WHERE ((`client_id` = 4) AND (`mention_id` = 966674) AND (`label_id` = 5)) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention_topic.rb:24:in `validate' */
I, [2013-10-24T15:35:21.334022 #19391] INFO -- : (0.204212s) BEGIN
I, [2013-10-24T15:35:21.538842 #19391] INFO -- : (0.203480s) INSERT INTO `mention_details` (`client_id`, `mention_id`, `label_id`, `fetch_id`, `seed_id`, `tonality`, `fetch_origin`, `stored_at`, `is_competitor`, `snippet`) VALUES (4, 966674, 5, 3556821, 7, 0, 'vk-corpus', '2013-10-24 12:35:21', 0, 'Магазин A.Sakura - первый мульти-фандомный магазин в России! Уникальный вещи для анимешников, фанатов комиксов и Sci-Fi.')
I, [2013-10-24T15:35:21.744391 #19391] INFO -- : (0.204995s) SELECT * FROM `mention_details` WHERE (`id` = 4036189) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:34:in `block (3 levels) in <class:API_v2>' */
I, [2013-10-24T15:35:21.948419 #19391] INFO -- : (0.203530s) COMMIT
I, [2013-10-24T15:35:22.256392 #19391] INFO -- : (0.306828s) SELECT * FROM `mention_details` WHERE (`id` = 4036189) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers.rb:23:in `notify' */
I, [2013-10-24T15:35:22.460676 #19391] INFO -- : (0.202648s) SELECT * FROM `labels` WHERE `id` = 5
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:22.767862 #19391] INFO -- : (0.305693s) SELECT * FROM `seeds` WHERE `id` = 7
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:22.972631 #19391] INFO -- : (0.202476s) SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 7))
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:23.279869 #19391] INFO -- : (0.305605s) SELECT * FROM `fetches` WHERE `id` = 3556821
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:23.485561 #19391] INFO -- : (0.157078s) SELECT * FROM `mentions_client_4` WHERE (`id` = 966674) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api_v2/mentions_by.rb:39:in `block in <class:API_v2>' */
I, [2013-10-24T15:35:23.630567 #19391] INFO -- : (0.143857s) SELECT * FROM `mentions_client_4` WHERE (`id` = 966674) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers.rb:23:in `notify' */
I, [2013-10-24T15:35:23.791814 #19391] INFO -- : (0.159657s) SELECT * FROM `platforms` WHERE `id` = 7
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:23.996592 #19391] INFO -- : (0.203552s) SELECT * FROM `users` WHERE `id` = 3905398
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:24.201398 #19391] INFO -- : (0.203560s) SELECT * FROM `journals` WHERE `id` = 4025011
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:24.394231 #19391] INFO -- : (0.190672s) SELECT * FROM `mention_details` WHERE ((`client_id` = 4) AND (`mention_details`.`mention_id` = 966674))
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:24.610813 #19391] INFO -- : (0.214235s) SELECT * FROM `labels` WHERE `id` = 5
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:24.815720 #19391] INFO -- : (0.203869s) SELECT * FROM `seeds` WHERE `id` = 7
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:25.020999 #19391] INFO -- : (0.203025s) SELECT `labels`.* FROM `labels` INNER JOIN `seeds2labels` ON ((`seeds2labels`.`label_id` = `labels`.`id`) AND (`seeds2labels`.`seed_id` = 7))
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:25.225255 #19391] INFO -- : (0.202674s) SELECT * FROM `fetches` WHERE `id` = 3556821
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
I, [2013-10-24T15:35:25.431005 #19391] INFO -- : (0.199477s) SELECT * FROM `clients` WHERE `id` = 4
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:21:in `client' */
I, [2013-10-24T15:35:25.635992 #19391] INFO -- : (0.200178s) SELECT * FROM `mentions_client_4` WHERE ((`url` = 'http://vk.com/wall-341229_11455_') AND (`seed_id` = 7)) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/compatibility/api_v2.rb:20:in `find_existing_mention' */
I, [2013-10-24T15:35:25.840870 #19391] INFO -- : (0.203732s) SELECT * FROM `mentions_client_4` WHERE `id` = 966674
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/compatibility/api_v2.rb:25:in `find_updatable_mention' */
I, [2013-10-24T15:35:25.993786 #19391] INFO -- : (0.151886s) UPDATE `mentions_client_4` SET `seed_id` = 7, `fetch_id` = 3556821, `lingua_excerpt` = '', `lingua_tonality` = 0, `manual_tonality` = NULL WHERE (`id` = 966674) LIMIT 1
I, [2013-10-24T15:35:26.148046 #19391] INFO -- : (0.153426s) SELECT * FROM `mentions_client_4` WHERE (`id` = 966674) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/notifiers.rb:23:in `notify' */
I, [2013-10-24T15:35:26.308011 #19391] INFO -- : (0.157975s) SELECT * FROM `clients` WHERE `id` = 4
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention.rb:21:in `client' */
I, [2013-10-24T15:35:26.454072 #19391] INFO -- : (0.145133s) SELECT * FROM `seeds` WHERE `id` = 7
/* /home/zverok/.rvm/gems/ruby-1.9.3-p429/gems/representable-1.7.0/lib/representable/binding.rb:79:in `block in get' */
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment