API tools faq
paste
Advertisement
Guest User

GET user details

a guest
Oct 23rd, 2014
120
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
Bash 25.40 KB | None | 0 0
raw download clone embed print report
  1. Started GET "/api/v1/users/6" for 127.0.0.1 at 2014-10-23 15:44:05 +0100
  2. Processing by Api::V1::UsersController#show as JSON
  3.   Parameters: {"id"=>"6"}
  4.   Customer Load (0.2ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."api_key" = '509a46db38365' LIMIT 1
  5.   User Load (0.5ms)  SELECT  "users".* FROM "users"  WHERE "users"."authentication_token" = 'd66649d9ef85b235106e5f8aa0aaf4bc'  ORDER BY "users"."id" ASC LIMIT 1
  6.   SocialAccount Load (0.1ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."id" = ? LIMIT 1  [["id", 8]]
  7.   SocialMediaType Load (0.1ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  8.   SocialAccount Load (0.1ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  9.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  10.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  11.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  12.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  13.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  14.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  15.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  16.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  17.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  18.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  19.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  20.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  21.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  22.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  23.   SocialMediaType Load (0.1ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 1]]
  24.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  25.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  26.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  27.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  28.   Statistic Load (0.1ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 9]]
  29.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  30.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  31.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  32.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  33.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 9]]
  34.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 1]]
  35.    (0.1ms)  begin transaction
  36.    (0.1ms)  commit transaction
  37.    (0.1ms)  SELECT COUNT(*) FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ?  [["social_account_id", 9]]
  38.    (0.1ms)  SELECT COUNT(*) AS count_all, social_account_id AS social_account_id FROM "associated_social_accounts"  GROUP BY social_account_id
  39.    (0.1ms)  SELECT "statistics"."posts_last_year" FROM "statistics"
  40.   LastScore Load (0.1ms)  SELECT  "last_scores".* FROM "last_scores"  WHERE "last_scores"."social_account_id" = 9 LIMIT 1
  41.    (0.1ms)  begin transaction
  42.    (0.0ms)  commit transaction
  43.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  44.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  45.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  46.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  47.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 9]]
  48.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 1]]
  49.    (0.1ms)  begin transaction
  50.    (0.1ms)  commit transaction
  51.   CACHE (0.0ms)  SELECT COUNT(*) FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ?  [["social_account_id", 9]]
  52.   CACHE (0.0ms)  SELECT COUNT(*) AS count_all, social_account_id AS social_account_id FROM "associated_social_accounts"  GROUP BY social_account_id
  53.   CACHE (0.0ms)  SELECT "statistics"."posts_last_year" FROM "statistics"
  54.   CACHE (0.0ms)  SELECT  "last_scores".* FROM "last_scores"  WHERE "last_scores"."social_account_id" = 9 LIMIT 1
  55.    (0.1ms)  begin transaction
  56.    (0.1ms)  commit transaction
  57.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  58.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  59.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  60.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  61.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 9]]
  62.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 1]]
  63.    (0.1ms)  begin transaction
  64.    (0.1ms)  commit transaction
  65.   CACHE (0.0ms)  SELECT COUNT(*) FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ?  [["social_account_id", 9]]
  66.   CACHE (0.0ms)  SELECT COUNT(*) AS count_all, social_account_id AS social_account_id FROM "associated_social_accounts"  GROUP BY social_account_id
  67.   CACHE (0.0ms)  SELECT "statistics"."posts_last_year" FROM "statistics"
  68.   CACHE (0.0ms)  SELECT  "last_scores".* FROM "last_scores"  WHERE "last_scores"."social_account_id" = 9 LIMIT 1
  69.    (0.1ms)  begin transaction
  70.    (0.0ms)  commit transaction
  71.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  72.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  73.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Facebook'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  74.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 1 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  75.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 9]]
  76.   FeedItem Load (0.1ms)  SELECT "feed_items".* FROM "feed_items"  WHERE "feed_items"."social_account_id" = ?  [["social_account_id", 9]]
  77.   SocialMediaType Load (0.1ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  78.   SocialAccount Load (0.1ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  79.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  80.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  81.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  82.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  83.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  84.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  85.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  86.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  87.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  88.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  89.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  90.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  91.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  92.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  93.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  94.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  95.   SocialMediaType Load (0.1ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 2]]
  96.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  97.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  98.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  99.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  100.   Statistic Load (0.1ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 8]]
  101.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  102.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  103.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  104.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  105.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 8]]
  106.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 2]]
  107.    (0.3ms)  begin transaction
  108.    (0.0ms)  commit transaction
  109.    (0.1ms)  SELECT "associated_social_accounts"."social_account_id" FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ? AND "associated_social_accounts"."relation_type" = 'Following'  [["social_account_id", 8]]
  110.    (0.1ms)  SELECT "associated_social_accounts"."social_account_id" FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ? AND "associated_social_accounts"."relation_type" = 'Follower'  [["social_account_id", 8]]
  111.   CACHE (0.0ms)  SELECT COUNT(*) AS count_all, social_account_id AS social_account_id FROM "associated_social_accounts"  GROUP BY social_account_id
  112.   CACHE (0.0ms)  SELECT "statistics"."posts_last_year" FROM "statistics"
  113.    (0.1ms)  SELECT "statistics"."engagement_score" FROM "statistics"
  114.    (0.1ms)  SELECT MAX("statistics"."engagement_score") AS max_id FROM "statistics"
  115.   LastScore Load (0.1ms)  SELECT  "last_scores".* FROM "last_scores"  WHERE "last_scores"."social_account_id" = 8 LIMIT 1
  116.    (0.1ms)  begin transaction
  117.    (0.0ms)  commit transaction
  118.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  119.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  120.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  121.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  122.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 8]]
  123.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 2]]
  124.    (0.1ms)  begin transaction
  125.    (0.1ms)  commit transaction
  126.   CACHE (0.0ms)  SELECT "associated_social_accounts"."social_account_id" FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ? AND "associated_social_accounts"."relation_type" = 'Following'  [["social_account_id", 8]]
  127.   CACHE (0.0ms)  SELECT "associated_social_accounts"."social_account_id" FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ? AND "associated_social_accounts"."relation_type" = 'Follower'  [["social_account_id", 8]]
  128.   CACHE (0.0ms)  SELECT COUNT(*) AS count_all, social_account_id AS social_account_id FROM "associated_social_accounts"  GROUP BY social_account_id
  129.   CACHE (0.0ms)  SELECT "statistics"."posts_last_year" FROM "statistics"
  130.   CACHE (0.0ms)  SELECT "statistics"."engagement_score" FROM "statistics"
  131.   CACHE (0.0ms)  SELECT MAX("statistics"."engagement_score") AS max_id FROM "statistics"
  132.   CACHE (0.0ms)  SELECT  "last_scores".* FROM "last_scores"  WHERE "last_scores"."social_account_id" = 8 LIMIT 1
  133.    (0.1ms)  begin transaction
  134.    (0.0ms)  commit transaction
  135.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  136.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  137.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  138.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  139.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 8]]
  140.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."id" = ? LIMIT 1  [["id", 2]]
  141.    (0.1ms)  begin transaction
  142.    (0.0ms)  commit transaction
  143.   CACHE (0.0ms)  SELECT "associated_social_accounts"."social_account_id" FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ? AND "associated_social_accounts"."relation_type" = 'Following'  [["social_account_id", 8]]
  144.   CACHE (0.0ms)  SELECT "associated_social_accounts"."social_account_id" FROM "associated_social_accounts"  WHERE "associated_social_accounts"."social_account_id" = ? AND "associated_social_accounts"."relation_type" = 'Follower'  [["social_account_id", 8]]
  145.   CACHE (0.0ms)  SELECT COUNT(*) AS count_all, social_account_id AS social_account_id FROM "associated_social_accounts"  GROUP BY social_account_id
  146.   CACHE (0.0ms)  SELECT "statistics"."posts_last_year" FROM "statistics"
  147.   CACHE (0.0ms)  SELECT "statistics"."engagement_score" FROM "statistics"
  148.   CACHE (0.0ms)  SELECT MAX("statistics"."engagement_score") AS max_id FROM "statistics"
  149.   CACHE (0.0ms)  SELECT  "last_scores".* FROM "last_scores"  WHERE "last_scores"."social_account_id" = 8 LIMIT 1
  150.    (0.1ms)  begin transaction
  151.    (0.0ms)  commit transaction
  152.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  153.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  154.   CACHE (0.0ms)  SELECT  "social_media_types".* FROM "social_media_types"  WHERE "social_media_types"."name" = 'Twitter'  ORDER BY "social_media_types"."id" ASC LIMIT 1
  155.   CACHE (0.0ms)  SELECT  "social_accounts".* FROM "social_accounts"  WHERE "social_accounts"."social_media_type_id" = 2 AND "social_accounts"."user_id" = 6  ORDER BY "social_accounts"."id" ASC LIMIT 1
  156.   CACHE (0.0ms)  SELECT  "statistics".* FROM "statistics"  WHERE "statistics"."social_account_id" = ? LIMIT 1  [["social_account_id", 8]]
  157.   FeedItem Load (0.1ms)  SELECT "feed_items".* FROM "feed_items"  WHERE "feed_items"."social_account_id" = ?  [["social_account_id", 8]]
  158.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 94]]
  159.   Brand Load (0.1ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  160.   Customer Load (0.1ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  161.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 95]]
  162.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  163.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  164.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 96]]
  165.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  166.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  167.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 97]]
  168.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  169.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  170.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 98]]
  171.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  172.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  173.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 99]]
  174.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  175.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  176.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 100]]
  177.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  178.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  179.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 101]]
  180.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 102]]
  181.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 103]]
  182.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 104]]
  183.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 105]]
  184.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 106]]
  185.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 107]]
  186.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 108]]
  187.   Request Load (0.1ms)  SELECT  "requests".* FROM "requests"  WHERE "requests"."id" = ? LIMIT 1  [["id", 109]]
  188.   CACHE (0.0ms)  SELECT  "brands".* FROM "brands"  WHERE "brands"."id" = ? LIMIT 1  [["id", 1]]
  189.   CACHE (0.0ms)  SELECT  "customers".* FROM "customers"  WHERE "customers"."id" = ? LIMIT 1  [["id", 1]]
  190.   Rendered api/v1/users/show.json.jbuilder (12806.0ms)
  191. Completed 200 OK in 12819ms (Views: 12801.9ms | ActiveRecord: 7.7ms)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!