zverok

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_')

zverok

I, [2013-10-24T15:51:39.548194 #20420]  INFO -- : (0.190697s) SELECT * FROM `clients` WHERE (`id` = 493) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:51:39.649928 #20420]  INFO -- : (0.100140s) SELECT * FROM `seeds` WHERE (`id` = 6454) LIMIT 1
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/api/common_helpers.rb:47:in `guarded_find' */
I, [2013-10-24T15:51:39.752148 #20420]  INFO -- : (0.100764s) SELECT * FROM `fetches` WHERE (`id` = 105767189) 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:51:39.855099 #20420]  INFO -- : (0.100289s) DESCRIBE `mentions_client_493`
/* /media/storage/work/brandspotter/mnemosyne/lib/mnemosyne/models/mention2.rb:34:in `block in make_class' */
I, [2013-10-24T15:51:39.957995 #20420]  INFO -- : (0.093005s) SELECT * FROM `mentions_client_493` WHERE (`url` = 'http://facebook.com/640

zverok

1. Popular ethnic cuisines

Columns: Indian; Chinese; Japan; Mexican; Italian; Jewish
Rows: Most prominent dishes; Main ingredients; Spices; Cooking methods; Healthness; Spread outside origin country

2. Fiction human futures

Columns: Space; Robotic; New Middle Age; Alien Invasion; The Matrix; Post-Apocaliptic
Rows: First described by; Most prominent novels; Social structure; Races and ethnoses; Civilisation problems; Real possibilities

zverok

mysql> explain SELECT `mentions_client_549`.* FROM `mentions_client_549` INNER JOIN `mention_details` ON ((`mention_details`.`mention_id` = `mentions_client_549`.`id`) AND (`mention_details`.`client_id` = 549)) WHERE ((`created_at` >= '2013-01-24 20:00:00') AND (`url` LIKE BINARY '%vk.com%' ESCAPE '\\')) ORDER BY `created_at` DESC LIMIT 10 OFFSET 0\G
*************************** 1. row ***************************
           id: 1
  select_type: SIMPLE
        table: mention_details
         type: ref
possible_keys: client_id,mention_details_client_id_label_id_index
          key: mention_details_client_id_label_id_index
      key_len: 4
          ref: const

zverok

<?xml version="1.0" encoding="windows-1251"?>
<xs:schema attributeFormDefault="unqualified" elementFormDefault="qualified" xmlns:xs="http://www.w3.org/2001/XMLSchema">
	<xs:element name="message">
		<xs:complexType>
			<xs:sequence>
				<xs:element name="author">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="nickname" type="xs:string" />
							<xs:element name="fullname" type="xs:string" />

zverok

0,1,10,100,1000002,1000010,1000028,1000030,1000032,1000037,1000038,1000040,1000046,1000049,1000050,1000057,1000062,1000066,1000069,1000071,1000076,1000080,1000083,1000086,1000093,1000103,1000105,1000106,1000113,1000115,1000125,1000126,1000148,1000149,1000154,1000160,1000166,1000169,1000170,1000182,1000195,1000199,1000207,1000215,1000219,1000231,1000234,1000247,1000256,1000257,1000281,1000294,1000306,1000322,1000329,1000350,1000354,1000390,1000432,1000438,1000442,1000496,1000510,1000525,1000527,1000541,1000553,1000566,1000569,1000622,1000652,1000681,1000686,1000731,1000735,1000769,1000771,1000773,1000846,10009,1000924,1000934,1000970,1000987,1001007,1001012,1001054,1001066,1001082,1001091,1001095,1001153,1001201,1001266,1001270,1001326,1001340,1001393,10014,1001414,1001437,1001438,1001468,1001482,1001507,1001535,1001585,1001607,1001723,1001748,1001754,1001761,1001763,1001806,1001884,1001931,1001995,1002,1002088,1002139,1002153,1002180,1002181,1002195,1002196,10022,1002200,1002244,1002245,1002248,1002251,100229

zverok

0,1,10,100,100500,101,102,103,104,105,106,107,108,109,11,110,111,112,113,115,116,117,118,119,12,120,121,122,123,124,125,126,127,128,129,13,130,131,132,133,134,135,136,137,138,139,14,140,141,142,143,144,145,146,147,148,149,15,150,152,153,154,155,156,157,158,159,16,160,161,162,163,165,166,167,168,17,170,172,173,174,175,176,178,179,18,181,182,183,184,185,186,187,188,19,190,191,192,193,194,195,196,197,198,199,2,20,200,201,202,203,204,205,206,207,208,209,21,210,211,212,213,214,215,216,217,218,219,22,220,221,222,223,224,225,226,227,228,229,23,230,231,24,25,27,28,29,3,30,31,32,33,34,35,36,37,38,39,4,40,41,42,43,44,45,46,47,48,49,5,50,51,52,53,54,55,56,57,59,6,60,61,62,63,64,65,67,68,69,7,70,71,72,73,74,75,76,77,777,78,79,8,80,81,82,83,84,85,86,87,88,89,9,91,92,93,94,95,96,97,98,99

zverok

profile: {
  country: "Россия",
  gender: "f",
  name: "Марина Лючжинян",
  photo: "http://cs4155.vk.me/v4155732/34/8JC8ht2GOP4.jpg",
  schools: [
    {
      city: "Саган-Нур",
      class: "в",
      country: "Россия",

zverok

// This is a manifest file that'll be compiled into application.js, which will include all the files
// listed below.
//
// Any JavaScript/Coffee file within this directory, lib/assets/javascripts, vendor/assets/javascripts,
// or vendor/assets/javascripts of plugins, if any, can be referenced here using a relative path.
//
// It's not advisable to add code directly here, but if you do, it'll appear at the bottom of the
// the compiled file.
//
// WARNING: THE FIRST BLANK LINE MARKS THE END OF WHAT'S TO BE PROCESSED, ANY BLANK LINE SHOULD

zverok

log4r:
    loggers:
        - name: api
          outputters: [api, gelf]
        - name: api_v2
          outputters: [api_v2, gelf]
        - name: sql
          outputters: [sql, gelf]
          level: ERROR
        - name: amqp