API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Dec 1st, 2015
273
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.17 KB | None | 0 0
raw download clone embed print report
  1. < 2015-12-01 12:13:56.792 EST >LOG: execute <unnamed>: SELECT 1
  2. < 2015-12-01 12:13:56.792 EST >LOG: execute <unnamed>: BEGIN
  3. < 2015-12-01 12:13:56.793 EST >LOG: execute <unnamed>: select ARRAY(select ID from USERS LIMIT 30 OFFSET 0) as IDS
  4. < 2015-12-01 12:13:56.794 EST >LOG: execute <unnamed>: SELECT 1
  5. < 2015-12-01 12:13:56.795 EST >LOG: execute <unnamed>: BEGIN
  6. < 2015-12-01 12:13:56.796 EST >LOG: execute <unnamed>: SELECT 1
  7. < 2015-12-01 12:13:56.797 EST >LOG: execute <unnamed>: select * from APPS WHERE appid='1o7r2598w77d0w13' LIMIT 1 OFFSET 0
  8. < 2015-12-01 12:13:56.797 EST >LOG: execute <unnamed>: BEGIN
  9. < 2015-12-01 12:13:56.797 EST >LOG: execute S_2: COMMIT
  10. < 2015-12-01 12:13:56.799 EST >LOG: execute <unnamed>: SELECT 1
  11. < 2015-12-01 12:13:56.799 EST >LOG: execute <unnamed>: select ID, USERNAME, PRIMARYREGDATE, REGDATE, LOGIN, EMAIL, ISSUPERVISOR, PWD, PWDHASH, DBPWD, LOGINHASH, VERIFYCODE, STATUS, AVATARNAME, APPS, ROLES, GROUPS FROM (SELECT unnest(ARRAY[1, 2]::integer[]) as u_id) as ids inner join users on ids.u_id = ID
  12. < 2015-12-01 12:13:56.799 EST >LOG: execute <unnamed>: BEGIN
  13. < 2015-12-01 12:13:56.800 EST >LOG: execute <unnamed>: select ID from users where login = $1 limit 1
  14. < 2015-12-01 12:13:56.800 EST >DETAIL: parameters: $1 = 'user1@domain.com'
  15. < 2015-12-01 12:13:56.801 EST >LOG: execute <unnamed>: SELECT 1
  16. < 2015-12-01 12:13:56.802 EST >LOG: execute <unnamed>: BEGIN
  17. < 2015-12-01 12:13:56.804 EST >LOG: execute <unnamed>: select ID, USERNAME, PRIMARYREGDATE, REGDATE, LOGIN, EMAIL, ISSUPERVISOR, PWD, PWDHASH, DBPWD, LOGINHASH, VERIFYCODE, STATUS, AVATARNAME, APPS, ROLES, GROUPS FROM (SELECT unnest(ARRAY[2]::integer[]) as u_id) as ids inner join users on ids.u_id = ID
  18. < 2015-12-01 12:13:56.811 EST >LOG: execute <unnamed>: SET extra_float_digits = 3
  19. < 2015-12-01 12:13:56.813 EST >LOG: execute <unnamed>: SELECT 1
  20. < 2015-12-01 12:13:56.813 EST >LOG: execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
  21. < 2015-12-01 12:13:56.813 EST >DETAIL: parameters: $1 = '1007'
  22. < 2015-12-01 12:13:56.813 EST >LOG: execute <unnamed>: BEGIN
  23. < 2015-12-01 12:13:56.817 EST >LOG: execute <unnamed>: select id, name, description, roles_id from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join groups on ids.g_id = ID
  24. < 2015-12-01 12:13:56.817 EST >LOG: execute S_1: COMMIT
  25. < 2015-12-01 12:13:56.818 EST >LOG: execute <unnamed>: SELECT 1
  26. < 2015-12-01 12:13:56.820 EST >LOG: execute <unnamed>: BEGIN
  27. < 2015-12-01 12:13:56.820 EST >LOG: execute <unnamed>: SET extra_float_digits = 3
  28. < 2015-12-01 12:13:56.821 EST >LOG: execute <unnamed>: select id, name, description, app_id, is_on from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join roles on ids.g_id = ID
  29. < 2015-12-01 12:13:56.822 EST >LOG: execute S_1: COMMIT
  30. < 2015-12-01 12:13:56.822 EST >LOG: execute <unnamed>: SELECT 1
  31. < 2015-12-01 12:13:56.823 EST >LOG: execute <unnamed>: BEGIN
  32. < 2015-12-01 12:13:56.824 EST >LOG: execute <unnamed>: SELECT 1
  33. < 2015-12-01 12:13:56.824 EST >LOG: execute <unnamed>: BEGIN
  34. < 2015-12-01 12:13:56.825 EST >LOG: execute <unnamed>: select id, name, description, roles_id from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join groups on ids.g_id = ID
  35. < 2015-12-01 12:13:56.825 EST >LOG: execute S_1: COMMIT
  36. < 2015-12-01 12:13:56.826 EST >LOG: execute <unnamed>: SELECT 1
  37. < 2015-12-01 12:13:56.827 EST >LOG: execute <unnamed>: select ID, APPTYPE, APPID, APPNAME, OWNER, DBTYPE, DBHOST, DBNAME, STATUS, STATUSDATE, regdate, description, lasterror, visibility, ARRAY(select id FROM roles where app_id = apps.ID) as roles_id from (select unnest(ARRAY[1]::integer[]) as app_id) as ids inner join apps on ids.app_id = ID
  38. < 2015-12-01 12:13:56.827 EST >LOG: execute <unnamed>: BEGIN
  39. < 2015-12-01 12:13:56.828 EST >LOG: execute <unnamed>: select id, name, description, app_id, is_on from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join roles on ids.g_id = ID
  40. < 2015-12-01 12:13:56.829 EST >LOG: execute S_1: COMMIT
  41. < 2015-12-01 12:13:56.829 EST >LOG: execute <unnamed>: SELECT 1
  42. < 2015-12-01 12:13:56.830 EST >LOG: execute <unnamed>: BEGIN
  43. < 2015-12-01 12:13:56.831 EST >LOG: execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
  44. < 2015-12-01 12:13:56.831 EST >DETAIL: parameters: $1 = '1007'
  45. < 2015-12-01 12:13:56.832 EST >LOG: execute <unnamed>: select ID, APPTYPE, APPID, APPNAME, OWNER, DBTYPE, DBHOST, DBNAME, STATUS, STATUSDATE, regdate, description, lasterror, visibility, ARRAY(select id FROM roles where app_id = apps.ID) as roles_id from (select unnest(ARRAY[1]::integer[]) as app_id) as ids inner join apps on ids.app_id = ID
  46. < 2015-12-01 12:13:56.835 EST >LOG: execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
  47. < 2015-12-01 12:13:56.835 EST >DETAIL: parameters: $1 = '1007'
  48. < 2015-12-01 12:13:56.839 EST >LOG: execute <unnamed>: SET extra_float_digits = 3
  49. < 2015-12-01 12:13:56.841 EST >LOG: execute <unnamed>: SELECT 1
  50. < 2015-12-01 12:13:56.842 EST >LOG: execute <unnamed>: BEGIN
  51. < 2015-12-01 12:13:56.844 EST >LOG: execute <unnamed>: SET extra_float_digits = 3
  52. < 2015-12-01 12:13:56.845 EST >LOG: execute <unnamed>: select id, name, description, app_id, is_on from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join roles on ids.g_id = ID
  53. < 2015-12-01 12:13:56.845 EST >LOG: execute S_1: COMMIT
  54. < 2015-12-01 12:13:56.845 EST >LOG: execute <unnamed>: SELECT 1
  55. < 2015-12-01 12:13:56.846 EST >LOG: execute <unnamed>: BEGIN
  56. < 2015-12-01 12:13:56.846 EST >LOG: execute S_1: COMMIT
  57. < 2015-12-01 12:13:56.847 EST >LOG: execute <unnamed>: SELECT 1
  58. < 2015-12-01 12:13:56.848 EST >LOG: execute <unnamed>: BEGIN
  59. < 2015-12-01 12:13:56.849 EST >LOG: execute <unnamed>: select id, name, description, app_id, is_on from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join roles on ids.g_id = ID
  60. < 2015-12-01 12:13:56.849 EST >LOG: execute <unnamed>: select id, name, description, roles_id from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join groups on ids.g_id = ID
  61. < 2015-12-01 12:13:56.849 EST >LOG: execute S_1: COMMIT
  62. < 2015-12-01 12:13:56.849 EST >LOG: execute S_1: COMMIT
  63. < 2015-12-01 12:13:56.850 EST >LOG: execute S_1: COMMIT
  64. < 2015-12-01 12:13:56.850 EST >LOG: execute S_1: COMMIT
  65. < 2015-12-01 12:13:56.851 EST >LOG: execute <unnamed>: SELECT 1
  66. < 2015-12-01 12:13:56.851 EST >LOG: execute S_1: ROLLBACK
  67. < 2015-12-01 12:13:56.853 EST >LOG: execute <unnamed>: BEGIN
  68. < 2015-12-01 12:13:56.854 EST >LOG: execute <unnamed>: select id, name, description, app_id, is_on from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join roles on ids.g_id = ID
  69. < 2015-12-01 12:13:56.855 EST >LOG: execute S_1: COMMIT
  70. < 2015-12-01 12:13:56.856 EST >LOG: execute <unnamed>: SELECT 1
  71. < 2015-12-01 12:13:56.857 EST >LOG: execute <unnamed>: BEGIN
  72. < 2015-12-01 12:13:56.858 EST >LOG: execute <unnamed>: select ID, APPTYPE, APPID, APPNAME, OWNER, DBTYPE, DBHOST, DBNAME, STATUS, STATUSDATE, regdate, description, lasterror, visibility, ARRAY(select id FROM roles where app_id = apps.ID) as roles_id from (select unnest(ARRAY[1]::integer[]) as app_id) as ids inner join apps on ids.app_id = ID
  73. < 2015-12-01 12:13:56.862 EST >LOG: execute <unnamed>: SELECT e.typdelim FROM pg_catalog.pg_type t, pg_catalog.pg_type e WHERE t.oid = $1 and t.typelem = e.oid
  74. < 2015-12-01 12:13:56.862 EST >DETAIL: parameters: $1 = '1007'
  75. < 2015-12-01 12:13:56.867 EST >LOG: execute <unnamed>: SELECT 1
  76. < 2015-12-01 12:13:56.867 EST >LOG: execute <unnamed>: BEGIN
  77. < 2015-12-01 12:13:56.869 EST >LOG: execute <unnamed>: select id, name, description, app_id, is_on from (select unnest(ARRAY[]::integer[]) as g_id) as ids inner join roles on ids.g_id = ID
  78. < 2015-12-01 12:13:56.869 EST >LOG: execute <unnamed>: SET extra_float_digits = 3
  79. < 2015-12-01 12:13:56.869 EST >LOG: execute S_2: COMMIT
  80. < 2015-12-01 12:13:56.870 EST >LOG: execute S_1: COMMIT
  81. < 2015-12-01 12:13:56.870 EST >LOG: execute S_1: COMMIT
  82. < 2015-12-01 12:13:56.871 EST >LOG: execute <unnamed>: SELECT 1
  83. < 2015-12-01 12:13:56.871 EST >LOG: execute S_1: COMMIT
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!