API tools faq
paste
dcmul

Untitled

dcmul
Oct 6th, 2016
123
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 29.20 KB | None | 0 0
raw download clone embed print report
  1. 2016-10-06 06:55:30 UTC [20680-1] geonode@geonode LOG: statement: BEGIN
  2. 2016-10-06 06:55:30 UTC [20680-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  3. 2016-10-06 06:55:30 UTC [20680-3] geonode@geonode LOG: statement: COMMIT
  4. 2016-10-06 06:55:30 UTC [20680-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  5. 2016-10-06 06:55:30 UTC [20680-5] geonode@geonode LOG: statement: SELECT "announcements_announcement"."id", "announcements_announcement"."title", "announcements_announcement"."level", "announcements_announcement"."content", "announcements_announcement"."creator_id", "announcements_announcement"."creation_date", "announcements_announcement"."site_wide", "announcements_announcement"."members_only", "announcements_announcement"."dismissal_type", "announcements_announcement"."publish_start", "announcements_announcement"."publish_end" FROM "announcements_announcement" WHERE ("announcements_announcement"."publish_start" <= '2016-10-06 01:55:30.771156' AND ("announcements_announcement"."publish_end" IS NULL OR "announcements_announcement"."publish_end" > '2016-10-06 01:55:30.772244' ) AND "announcements_announcement"."site_wide" = true AND NOT ("announcements_announcement"."members_only" = true ))
  6. 2016-10-06 06:55:30 UTC [20680-6] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" INNER JOIN "auth_permission" ON ( "django_content_type"."id" = "auth_permission"."content_type_id" ) WHERE ("auth_permission"."codename" = 'view_resourcebase' AND "django_content_type"."app_label" = 'base' )
  7. 2016-10-06 06:55:30 UTC [20680-7] geonode@geonode LOG: statement: SELECT "people_profile"."id", "people_profile"."password", "people_profile"."last_login", "people_profile"."is_superuser", "people_profile"."username", "people_profile"."first_name", "people_profile"."last_name", "people_profile"."email", "people_profile"."is_staff", "people_profile"."is_active", "people_profile"."date_joined", "people_profile"."organization", "people_profile"."profile", "people_profile"."position", "people_profile"."voice", "people_profile"."fax", "people_profile"."delivery", "people_profile"."city", "people_profile"."area", "people_profile"."zipcode", "people_profile"."country" FROM "people_profile" WHERE "people_profile"."id" = -1
  8. 2016-10-06 06:55:30 UTC [20680-8] geonode@geonode LOG: statement: SELECT "guardian_userobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_userobjectpermission" INNER JOIN "auth_permission" ON ( "guardian_userobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("guardian_userobjectpermission"."user_id" = -1 AND "auth_permission"."content_type_id" = 38 AND "auth_permission"."codename" IN ('view_resourcebase'))
  9. 2016-10-06 06:55:30 UTC [20680-9] geonode@geonode LOG: statement: SELECT "guardian_groupobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_groupobjectpermission" INNER JOIN "auth_group" ON ( "guardian_groupobjectpermission"."group_id" = "auth_group"."id" ) INNER JOIN "people_profile_groups" ON ( "auth_group"."id" = "people_profile_groups"."group_id" ) INNER JOIN "auth_permission" ON ( "guardian_groupobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("people_profile_groups"."profile_id" = -1 AND "auth_permission"."codename" IN ('view_resourcebase') AND "auth_permission"."content_type_id" = 38 )
  10. 2016-10-06 06:55:30 UTC [20680-10] geonode@geonode LOG: statement: SELECT "layers_layer"."storeType", COUNT("layers_layer"."storeType") AS "count" FROM "layers_layer" WHERE (UPPER("layers_layer"."title_en"::text) LIKE UPPER('%%') AND "layers_layer"."resourcebase_ptr_id" IN (SELECT U0."id" FROM "base_resourcebase" U0 WHERE U0."id" IN (1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, 113, 114, 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, 139, 14, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 15, 150, 151, 152, 153, 154, 155, 156, 158, 159, 16, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 4, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 6, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 70, 71, 72, 74, 75, 76, 77, 78, 79, 8, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 9, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99))) GROUP BY "layers_layer"."storeType"
  11. 2016-10-06 06:55:36 UTC [21202-1] geonode@geonode LOG: statement: BEGIN
  12. 2016-10-06 06:55:36 UTC [21202-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  13. 2016-10-06 06:55:36 UTC [21202-3] geonode@geonode LOG: statement: COMMIT
  14. 2016-10-06 06:55:36 UTC [21202-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  15. 2016-10-06 06:55:36 UTC [21202-5] geonode@geonode LOG: statement: SELECT COUNT(*) FROM "base_topiccategory"
  16. 2016-10-06 06:55:36 UTC [21202-6] geonode@geonode LOG: statement: SELECT "base_topiccategory"."id", "base_topiccategory"."identifier", "base_topiccategory"."description", "base_topiccategory"."description_en", "base_topiccategory"."gn_description", "base_topiccategory"."gn_description_en", "base_topiccategory"."is_choice" FROM "base_topiccategory" ORDER BY "base_topiccategory"."identifier" ASC LIMIT 1000
  17. 2016-10-06 06:55:36 UTC [21203-1] geonode@geonode LOG: statement: BEGIN
  18. 2016-10-06 06:55:36 UTC [21203-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  19. 2016-10-06 06:55:36 UTC [21204-1] geonode@geonode LOG: statement: BEGIN
  20. 2016-10-06 06:55:36 UTC [21203-3] geonode@geonode LOG: statement: COMMIT
  21. 2016-10-06 06:55:36 UTC [21204-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  22. 2016-10-06 06:55:36 UTC [21204-3] geonode@geonode LOG: statement: COMMIT
  23. 2016-10-06 06:55:36 UTC [21205-1] geonode@geonode LOG: statement: BEGIN
  24. 2016-10-06 06:55:36 UTC [21204-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  25. 2016-10-06 06:55:36 UTC [21205-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  26. 2016-10-06 06:55:36 UTC [21203-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  27. 2016-10-06 06:55:36 UTC [21204-5] geonode@geonode LOG: statement: SELECT COUNT(*) FROM "taggit_tag"
  28. 2016-10-06 06:55:36 UTC [21205-3] geonode@geonode LOG: statement: COMMIT
  29. 2016-10-06 06:55:36 UTC [21205-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  30. 2016-10-06 06:55:36 UTC [21203-5] geonode@geonode LOG: statement: SELECT COUNT(*) FROM "people_profile" WHERE NOT ("people_profile"."username" = 'AnonymousUser' )
  31. 2016-10-06 06:55:36 UTC [21205-5] geonode@geonode LOG: statement: SELECT COUNT(*) FROM "base_region"
  32. 2016-10-06 06:55:36 UTC [21203-6] geonode@geonode LOG: statement: SELECT "people_profile"."id", "people_profile"."password", "people_profile"."last_login", "people_profile"."is_superuser", "people_profile"."username", "people_profile"."first_name", "people_profile"."last_name", "people_profile"."email", "people_profile"."is_staff", "people_profile"."is_active", "people_profile"."date_joined", "people_profile"."organization", "people_profile"."profile", "people_profile"."position", "people_profile"."voice", "people_profile"."fax", "people_profile"."delivery", "people_profile"."city", "people_profile"."area", "people_profile"."zipcode", "people_profile"."country" FROM "people_profile" WHERE NOT ("people_profile"."username" = 'AnonymousUser' ) LIMIT 1000
  33. 2016-10-06 06:55:36 UTC [21205-6] geonode@geonode LOG: statement: SELECT "base_region"."id", "base_region"."code", "base_region"."name", "base_region"."name_en", "base_region"."parent_id", "base_region"."lft", "base_region"."rght", "base_region"."tree_id", "base_region"."level" FROM "base_region" ORDER BY "base_region"."name_en" ASC LIMIT 1000
  34. 2016-10-06 06:55:36 UTC [21202-7] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" INNER JOIN "auth_permission" ON ( "django_content_type"."id" = "auth_permission"."content_type_id" ) WHERE ("auth_permission"."codename" = 'view_resourcebase' AND "django_content_type"."app_label" = 'base' )
  35. 2016-10-06 06:55:36 UTC [21202-8] geonode@geonode LOG: statement: SELECT "people_profile"."id", "people_profile"."password", "people_profile"."last_login", "people_profile"."is_superuser", "people_profile"."username", "people_profile"."first_name", "people_profile"."last_name", "people_profile"."email", "people_profile"."is_staff", "people_profile"."is_active", "people_profile"."date_joined", "people_profile"."organization", "people_profile"."profile", "people_profile"."position", "people_profile"."voice", "people_profile"."fax", "people_profile"."delivery", "people_profile"."city", "people_profile"."area", "people_profile"."zipcode", "people_profile"."country" FROM "people_profile" WHERE "people_profile"."id" = -1
  36. 2016-10-06 06:55:36 UTC [21202-9] geonode@geonode LOG: statement: SELECT "guardian_userobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_userobjectpermission" INNER JOIN "auth_permission" ON ( "guardian_userobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("guardian_userobjectpermission"."user_id" = -1 AND "auth_permission"."content_type_id" = 38 AND "auth_permission"."codename" IN ('view_resourcebase'))
  37. 2016-10-06 06:55:36 UTC [21203-7] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" INNER JOIN "auth_permission" ON ( "django_content_type"."id" = "auth_permission"."content_type_id" ) WHERE ("auth_permission"."codename" = 'view_resourcebase' AND "django_content_type"."app_label" = 'base' )
  38. 2016-10-06 06:55:36 UTC [21206-1] geonode@geonode LOG: statement: BEGIN
  39. 2016-10-06 06:55:36 UTC [21206-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  40. 2016-10-06 06:55:36 UTC [21206-3] geonode@geonode LOG: statement: COMMIT
  41. 2016-10-06 06:55:36 UTC [21206-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  42. 2016-10-06 06:55:36 UTC [21203-8] geonode@geonode LOG: statement: SELECT "people_profile"."id", "people_profile"."password", "people_profile"."last_login", "people_profile"."is_superuser", "people_profile"."username", "people_profile"."first_name", "people_profile"."last_name", "people_profile"."email", "people_profile"."is_staff", "people_profile"."is_active", "people_profile"."date_joined", "people_profile"."organization", "people_profile"."profile", "people_profile"."position", "people_profile"."voice", "people_profile"."fax", "people_profile"."delivery", "people_profile"."city", "people_profile"."area", "people_profile"."zipcode", "people_profile"."country" FROM "people_profile" WHERE "people_profile"."id" = -1
  43. 2016-10-06 06:55:36 UTC [21206-5] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" INNER JOIN "auth_permission" ON ( "django_content_type"."id" = "auth_permission"."content_type_id" ) WHERE ("auth_permission"."codename" = 'view_resourcebase' AND "django_content_type"."app_label" = 'base' )
  44. 2016-10-06 06:55:36 UTC [21203-9] geonode@geonode LOG: statement: SELECT "guardian_userobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_userobjectpermission" INNER JOIN "auth_permission" ON ( "guardian_userobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("guardian_userobjectpermission"."user_id" = -1 AND "auth_permission"."content_type_id" = 38 AND "auth_permission"."codename" IN ('view_resourcebase'))
  45. 2016-10-06 06:55:36 UTC [21203-10] geonode@geonode LOG: statement: SELECT "guardian_groupobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_groupobjectpermission" INNER JOIN "auth_group" ON ( "guardian_groupobjectpermission"."group_id" = "auth_group"."id" ) INNER JOIN "people_profile_groups" ON ( "auth_group"."id" = "people_profile_groups"."group_id" ) INNER JOIN "auth_permission" ON ( "guardian_groupobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("people_profile_groups"."profile_id" = -1 AND "auth_permission"."codename" IN ('view_resourcebase') AND "auth_permission"."content_type_id" = 38 )
  46. 2016-10-06 06:55:36 UTC [21206-6] geonode@geonode LOG: statement: SELECT "people_profile"."id", "people_profile"."password", "people_profile"."last_login", "people_profile"."is_superuser", "people_profile"."username", "people_profile"."first_name", "people_profile"."last_name", "people_profile"."email", "people_profile"."is_staff", "people_profile"."is_active", "people_profile"."date_joined", "people_profile"."organization", "people_profile"."profile", "people_profile"."position", "people_profile"."voice", "people_profile"."fax", "people_profile"."delivery", "people_profile"."city", "people_profile"."area", "people_profile"."zipcode", "people_profile"."country" FROM "people_profile" WHERE "people_profile"."id" = -1
  47. 2016-10-06 06:55:36 UTC [21202-10] geonode@geonode LOG: statement: SELECT "guardian_groupobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_groupobjectpermission" INNER JOIN "auth_group" ON ( "guardian_groupobjectpermission"."group_id" = "auth_group"."id" ) INNER JOIN "people_profile_groups" ON ( "auth_group"."id" = "people_profile_groups"."group_id" ) INNER JOIN "auth_permission" ON ( "guardian_groupobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("people_profile_groups"."profile_id" = -1 AND "auth_permission"."codename" IN ('view_resourcebase') AND "auth_permission"."content_type_id" = 38 )
  48. 2016-10-06 06:55:36 UTC [21203-11] geonode@geonode LOG: statement: SELECT "base_resourcebase"."owner_id", COUNT("base_resourcebase"."owner_id") AS "count" FROM "base_resourcebase" WHERE ("base_resourcebase"."id" IN (1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, 113, 114, 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, 139, 14, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 15, 150, 151, 152, 153, 154, 155, 156, 158, 159, 16, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 4, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 6, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 70, 71, 72, 74, 75, 76, 77, 78, 79, 8, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 9, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99) AND "base_resourcebase"."polymorphic_ctype_id" = 41 ) GROUP BY "base_resourcebase"."owner_id"
  49. 2016-10-06 06:55:36 UTC [21206-7] geonode@geonode LOG: statement: SELECT "guardian_userobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_userobjectpermission" INNER JOIN "auth_permission" ON ( "guardian_userobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("guardian_userobjectpermission"."user_id" = -1 AND "auth_permission"."content_type_id" = 38 AND "auth_permission"."codename" IN ('view_resourcebase'))
  50. 2016-10-06 06:55:36 UTC [21206-8] geonode@geonode LOG: statement: SELECT "guardian_groupobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_groupobjectpermission" INNER JOIN "auth_group" ON ( "guardian_groupobjectpermission"."group_id" = "auth_group"."id" ) INNER JOIN "people_profile_groups" ON ( "auth_group"."id" = "people_profile_groups"."group_id" ) INNER JOIN "auth_permission" ON ( "guardian_groupobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("people_profile_groups"."profile_id" = -1 AND "auth_permission"."codename" IN ('view_resourcebase') AND "auth_permission"."content_type_id" = 38 )
  51. 2016-10-06 06:55:36 UTC [21202-11] geonode@geonode LOG: statement: SELECT "base_resourcebase"."category_id", COUNT("base_resourcebase"."category_id") AS "count" FROM "base_resourcebase" WHERE ("base_resourcebase"."id" IN (1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, 113, 114, 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, 139, 14, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 15, 150, 151, 152, 153, 154, 155, 156, 158, 159, 16, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 4, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 6, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 70, 71, 72, 74, 75, 76, 77, 78, 79, 8, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 9, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99) AND "base_resourcebase"."polymorphic_ctype_id" = 41 ) GROUP BY "base_resourcebase"."category_id"
  52. 2016-10-06 06:55:36 UTC [21206-9] geonode@geonode LOG: statement: SELECT COUNT(DISTINCT "layers_layer"."resourcebase_ptr_id") FROM "layers_layer" WHERE "layers_layer"."resourcebase_ptr_id" IN (SELECT U0."id" FROM "base_resourcebase" U0 WHERE U0."id" IN (1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, 113, 114, 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, 139, 14, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 15, 150, 151, 152, 153, 154, 155, 156, 158, 159, 16, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 4, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 6, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 70, 71, 72, 74, 75, 76, 77, 78, 79, 8, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 9, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99))
  53. 2016-10-06 06:55:36 UTC [21206-10] geonode@geonode LOG: statement: SELECT DISTINCT "base_resourcebase"."rating", "base_topiccategory"."gn_description", "base_resourcebase"."popular_count", "layers_layer"."title_en", "base_resourcebase"."srid", "base_resourcebase"."date", "layers_layer"."supplemental_information_en", "base_resourcebase"."detail_url", "layers_layer"."resourcebase_ptr_id", "base_resourcebase"."distribution_url", "base_resourcebase"."uuid", "layers_layer"."abstract_en", "base_resourcebase"."thumbnail_url", "base_resourcebase"."csw_type", "base_resourcebase"."csw_wkt_geometry", "base_resourcebase"."share_count", "people_profile"."username", "layers_layer"."distribution_description_en" FROM "layers_layer" INNER JOIN "base_resourcebase" ON ( "layers_layer"."resourcebase_ptr_id" = "base_resourcebase"."id" ) LEFT OUTER JOIN "base_topiccategory" ON ( "base_resourcebase"."category_id" = "base_topiccategory"."id" ) LEFT OUTER JOIN "people_profile" ON ( "base_resourcebase"."owner_id" = "people_profile"."id" ) WHERE "layers_layer"."resourcebase_ptr_id" IN (SELECT U0."id" FROM "base_resourcebase" U0 WHERE U0."id" IN (1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, 113, 114, 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, 139, 14, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 15, 150, 151, 152, 153, 154, 155, 156, 158, 159, 16, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 4, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 6, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 70, 71, 72, 74, 75, 76, 77, 78, 79, 8, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 9, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99)) ORDER BY "base_resourcebase"."date" DESC LIMIT 100
  54. 2016-10-06 06:55:36 UTC [21204-6] geonode@geonode LOG: statement: SELECT "taggit_tag"."id", "taggit_tag"."name", "taggit_tag"."slug" FROM "taggit_tag" ORDER BY "taggit_tag"."name" ASC LIMIT 1000
  55. 2016-10-06 06:55:36 UTC [21204-7] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" INNER JOIN "auth_permission" ON ( "django_content_type"."id" = "auth_permission"."content_type_id" ) WHERE ("auth_permission"."codename" = 'view_resourcebase' AND "django_content_type"."app_label" = 'base' )
  56. 2016-10-06 06:55:36 UTC [21204-8] geonode@geonode LOG: statement: SELECT "people_profile"."id", "people_profile"."password", "people_profile"."last_login", "people_profile"."is_superuser", "people_profile"."username", "people_profile"."first_name", "people_profile"."last_name", "people_profile"."email", "people_profile"."is_staff", "people_profile"."is_active", "people_profile"."date_joined", "people_profile"."organization", "people_profile"."profile", "people_profile"."position", "people_profile"."voice", "people_profile"."fax", "people_profile"."delivery", "people_profile"."city", "people_profile"."area", "people_profile"."zipcode", "people_profile"."country" FROM "people_profile" WHERE "people_profile"."id" = -1
  57. 2016-10-06 06:55:36 UTC [21204-9] geonode@geonode LOG: statement: SELECT "guardian_userobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_userobjectpermission" INNER JOIN "auth_permission" ON ( "guardian_userobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("guardian_userobjectpermission"."user_id" = -1 AND "auth_permission"."content_type_id" = 38 AND "auth_permission"."codename" IN ('view_resourcebase'))
  58. 2016-10-06 06:55:36 UTC [21204-10] geonode@geonode LOG: statement: SELECT "guardian_groupobjectpermission"."object_pk", "auth_permission"."codename" FROM "guardian_groupobjectpermission" INNER JOIN "auth_group" ON ( "guardian_groupobjectpermission"."group_id" = "auth_group"."id" ) INNER JOIN "people_profile_groups" ON ( "auth_group"."id" = "people_profile_groups"."group_id" ) INNER JOIN "auth_permission" ON ( "guardian_groupobjectpermission"."permission_id" = "auth_permission"."id" ) WHERE ("people_profile_groups"."profile_id" = -1 AND "auth_permission"."codename" IN ('view_resourcebase') AND "auth_permission"."content_type_id" = 38 )
  59. 2016-10-06 06:55:36 UTC [21204-11] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."model" = 'document' AND "django_content_type"."app_label" = 'documents' )
  60. 2016-10-06 06:55:36 UTC [21204-12] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."model" = 'map' AND "django_content_type"."app_label" = 'maps' )
  61. 2016-10-06 06:55:36 UTC [21204-13] geonode@geonode LOG: statement: SELECT "django_content_type"."id", "django_content_type"."name", "django_content_type"."app_label", "django_content_type"."model" FROM "django_content_type" WHERE ("django_content_type"."model" = 'service' AND "django_content_type"."app_label" = 'services' )
  62. 2016-10-06 06:55:36 UTC [21204-14] geonode@geonode LOG: statement: SELECT "taggit_taggeditem"."tag_id", COUNT("taggit_taggeditem"."tag_id") AS "count" FROM "base_resourcebase" LEFT OUTER JOIN "taggit_taggeditem" ON ( "base_resourcebase"."id" = "taggit_taggeditem"."object_id" AND ("taggit_taggeditem"."content_type_id" IN (38,48,41,45,52))) WHERE ("base_resourcebase"."id" IN (1, 10, 100, 101, 102, 103, 104, 105, 106, 107, 108, 109, 11, 110, 111, 112, 113, 114, 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, 139, 14, 140, 141, 142, 143, 144, 145, 146, 147, 148, 149, 15, 150, 151, 152, 153, 154, 155, 156, 158, 159, 16, 160, 161, 162, 163, 164, 165, 166, 167, 168, 169, 17, 18, 19, 2, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 3, 30, 31, 32, 33, 34, 35, 36, 37, 38, 39, 4, 40, 41, 42, 44, 45, 46, 47, 48, 49, 50, 51, 52, 53, 54, 55, 56, 57, 58, 59, 6, 60, 61, 62, 63, 64, 65, 66, 67, 68, 69, 7, 70, 71, 72, 74, 75, 76, 77, 78, 79, 8, 80, 81, 82, 83, 84, 85, 86, 87, 88, 89, 9, 90, 91, 92, 93, 94, 95, 96, 97, 98, 99) AND "base_resourcebase"."polymorphic_ctype_id" = 41 ) GROUP BY "taggit_taggeditem"."tag_id"
  63. 2016-10-06 06:55:37 UTC [21323-1] geonode@geonode LOG: statement: BEGIN
  64. 2016-10-06 06:55:37 UTC [21323-2] geonode@geonode LOG: statement: SET TIME ZONE 'America/Chicago'
  65. 2016-10-06 06:55:37 UTC [21323-3] geonode@geonode LOG: statement: COMMIT
  66. 2016-10-06 06:55:37 UTC [21323-4] geonode@geonode LOG: statement: SHOW default_transaction_isolation
  67. 2016-10-06 06:55:37 UTC [21323-5] geonode@geonode LOG: statement: SELECT "base_resourcebase"."id", "base_resourcebase"."polymorphic_ctype_id", "base_resourcebase"."uuid", "base_resourcebase"."owner_id", "base_resourcebase"."title", "base_resourcebase"."date", "base_resourcebase"."date_type", "base_resourcebase"."edition", "base_resourcebase"."abstract", "base_resourcebase"."purpose", "base_resourcebase"."maintenance_frequency", "base_resourcebase"."restriction_code_type_id", "base_resourcebase"."constraints_other", "base_resourcebase"."license_id", "base_resourcebase"."language", "base_resourcebase"."category_id", "base_resourcebase"."spatial_representation_type_id", "base_resourcebase"."temporal_extent_start", "base_resourcebase"."temporal_extent_end", "base_resourcebase"."supplemental_information", "base_resourcebase"."distribution_url", "base_resourcebase"."distribution_description", "base_resourcebase"."data_quality_statement", "base_resourcebase"."bbox_x0", "base_resourcebase"."bbox_x1", "base_resourcebase"."bbox_y0", "base_resourcebase"."bbox_y1", "base_resourcebase"."srid", "base_resourcebase"."csw_typename", "base_resourcebase"."csw_schema", "base_resourcebase"."csw_mdsource", "base_resourcebase"."csw_insert_date", "base_resourcebase"."csw_type", "base_resourcebase"."csw_anytext", "base_resourcebase"."csw_wkt_geometry", "base_resourcebase"."metadata_uploaded", "base_resourcebase"."metadata_xml", "base_resourcebase"."popular_count", "base_resourcebase"."share_count", "base_resourcebase"."featured", "base_resourcebase"."is_published", "base_resourcebase"."thumbnail_url", "base_resourcebase"."detail_url", "base_resourcebase"."rating" FROM "base_resourcebase" WHERE "base_resourcebase"."uuid" IN ('296e1bf2-9e13-11e3-9770-ab849cd0de74')
  68. 2016-10-06 06:55:37 UTC [21323-6] geonode@geonode LOG: statement: SELECT "base_resourcebase"."id", "base_resourcebase"."polymorphic_ctype_id", "base_resourcebase"."uuid", "base_resourcebase"."owner_id", "base_resourcebase"."title", "base_resourcebase"."date", "base_resourcebase"."date_type", "base_resourcebase"."edition", "base_resourcebase"."abstract", "base_resourcebase"."purpose", "base_resourcebase"."maintenance_frequency", "base_resourcebase"."restriction_code_type_id", "base_resourcebase"."constraints_other", "base_resourcebase"."license_id", "base_resourcebase"."language", "base_resourcebase"."category_id", "base_resourcebase"."spatial_representation_type_id", "base_resourcebase"."temporal_extent_start", "base_resourcebase"."temporal_extent_end", "base_resourcebase"."supplemental_information", "base_resourcebase"."distribution_url", "base_resourcebase"."distribution_description", "base_resourcebase"."data_quality_statement", "base_resourcebase"."bbox_x0", "base_resourcebase"."bbox_x1", "base_resourcebase"."bbox_y0", "base_resourcebase"."bbox_y1", "base_resourcebase"."srid", "base_resourcebase"."csw_typename", "base_resourcebase"."csw_schema", "base_resourcebase"."csw_mdsource", "base_resourcebase"."csw_insert_date", "base_resourcebase"."csw_type", "base_resourcebase"."csw_anytext", "base_resourcebase"."csw_wkt_geometry", "base_resourcebase"."metadata_uploaded", "base_resourcebase"."metadata_xml", "base_resourcebase"."popular_count", "base_resourcebase"."share_count", "base_resourcebase"."featured", "base_resourcebase"."is_published", "base_resourcebase"."thumbnail_url", "base_resourcebase"."detail_url", "base_resourcebase"."rating", "layers_layer"."resourcebase_ptr_id", "layers_layer"."title_en", "layers_layer"."abstract_en", "layers_layer"."purpose_en", "layers_layer"."constraints_other_en", "layers_layer"."supplemental_information_en", "layers_layer"."distribution_description_en", "layers_layer"."data_quality_statement_en", "layers_layer"."workspace", "layers_layer"."store", "layers_layer"."storeType", "layers_layer"."name", "layers_layer"."typename", "layers_layer"."default_style_id", "layers_layer"."charset", "layers_layer"."upload_session_id", "layers_layer"."service_id" FROM "layers_layer" INNER JOIN "base_resourcebase" ON ( "layers_layer"."resourcebase_ptr_id" = "base_resourcebase"."id" ) WHERE "layers_layer"."resourcebase_ptr_id" = 66
  69. 2016-10-06 06:55:37 UTC [21323-7] geonode@geonode LOG: statement: SELECT DISTINCT "taggit_tag"."id", "taggit_tag"."name", "taggit_tag"."slug" FROM "taggit_tag" INNER JOIN "taggit_taggeditem" ON ( "taggit_tag"."id" = "taggit_taggeditem"."tag_id" ) WHERE ("taggit_taggeditem"."object_id" = 66 AND "taggit_taggeditem"."content_type_id" = 41 )
  70. 2016-10-06 06:55:37 UTC [21323-8] geonode@geonode LOG: statement: SELECT "base_link"."id", "base_link"."resource_id", "base_link"."extension", "base_link"."link_type", "base_link"."name", "base_link"."mime", "base_link"."url" FROM "base_link" WHERE "base_link"."resource_id" = 66
Advertisement
Add Comment
Please, Sign In to add comment
Public Pastes
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!