Skip to content

Instantly share code, notes, and snippets.

@volkanunsal

volkanunsal/click1.txt

Last active September 30, 2019 11:31
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save volkanunsal/ae6799029b6d7dd120b3b12531256827 to your computer and use it in GitHub Desktop.
Save volkanunsal/ae6799029b6d7dd120b3b12531256827 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
click1.txt
web.1 | Started POST "/graphql" for 127.0.0.1 at 2019-09-30 07:26:26 -0400
web.1 | Processing by GraphqlController#execute as */*
web.1 | Parameters: {"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>nil, "before"=>nil}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n", "graphql"=>{"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>nil, "before"=>nil}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n"}}
web.1 | User Load (2.8ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 1], ["LIMIT", 1]]
web.1 | ###############################
web.1 | Got cached document #<GraphQL::Language::Nodes::Document:0x00007f88f36de150>
web.1 | ###############################
web.1 | Dashboard Exists (11.2ms) SELECT 1 AS one FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | Dashboard Load (3.7ms) SELECT "dashboards".* FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | (116.1ms) SELECT COUNT(*) FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"]]
web.1 | Project Load (86.6ms) SELECT "projects".* FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 ORDER BY "projects"."updated_at" DESC, "projects"."name" ASC LIMIT $4 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["LIMIT", 10]]
web.1 | CACHE (0.0ms) SELECT COUNT(*) FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"]]
web.1 | Company Load (1.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = $1 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 11]]
web.1 | Completed 200 OK in 497ms (Views: 1.4ms | ActiveRecord: 222.2ms)
web.1 |
web.1 |
Raw
click2.txt
web.1 | Started POST "/graphql" for 127.0.0.1 at 2019-09-30 07:27:22 -0400
web.1 | Processing by GraphqlController#execute as */*
web.1 | Parameters: {"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>"MTA", "before"=>nil}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n", "graphql"=>{"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>"MTA", "before"=>nil}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n"}}
web.1 | User Load (1.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 1], ["LIMIT", 1]]
web.1 | ###############################
web.1 | Got cached document #<GraphQL::Language::Nodes::Document:0x00007f88dfc9ac88>
web.1 | ###############################
web.1 | Dashboard Exists (10.4ms) SELECT 1 AS one FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | Dashboard Load (2.5ms) SELECT "dashboards".* FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | (61.5ms) SELECT COUNT(*) FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"]]
web.1 | Project Load (54.7ms) SELECT "projects".* FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 ORDER BY "projects"."updated_at" DESC, "projects"."name" ASC LIMIT $4 OFFSET $5 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["LIMIT", 10], ["OFFSET", 10]]
web.1 | (46.2ms) SELECT COUNT(*) FROM (SELECT 1 AS one FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 OFFSET $4) subquery_for_count /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["OFFSET", 10]]
web.1 | Company Load (4.8ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = $1 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 11]]
web.1 | Completed 200 OK in 433ms (Views: 1.4ms | ActiveRecord: 181.7ms)
web.1 |
web.1 |
Raw
click3.txt
web.1 | Started POST "/graphql" for 127.0.0.1 at 2019-09-30 07:27:37 -0400
web.1 | Processing by GraphqlController#execute as */*
web.1 | Parameters: {"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>"MjA", "before"=>nil}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n", "graphql"=>{"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>"MjA", "before"=>nil}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n"}}
web.1 | User Load (1.6ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 1], ["LIMIT", 1]]
web.1 | ###############################
web.1 | Got cached document #<GraphQL::Language::Nodes::Document:0x00007f88f86db4a0>
web.1 | ###############################
web.1 | Dashboard Exists (16.3ms) SELECT 1 AS one FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | Dashboard Load (4.9ms) SELECT "dashboards".* FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | (72.2ms) SELECT COUNT(*) FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"]]
web.1 | Project Load (62.4ms) SELECT "projects".* FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 ORDER BY "projects"."updated_at" DESC, "projects"."name" ASC LIMIT $4 OFFSET $5 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["LIMIT", 10], ["OFFSET", 20]]
web.1 | (62.8ms) SELECT COUNT(*) FROM (SELECT 1 AS one FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 OFFSET $4) subquery_for_count /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["OFFSET", 20]]
web.1 | Company Load (4.1ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = $1 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 11]]
web.1 | Completed 200 OK in 459ms (Views: 1.4ms | ActiveRecord: 224.3ms)
web.1 |
web.1 |
Raw
click4.txt
web.1 | Started POST "/graphql" for 127.0.0.1 at 2019-09-30 07:28:10 -0400
web.1 | Processing by GraphqlController#execute as */*
web.1 | Parameters: {"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>nil, "before"=>"MjE"}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n", "graphql"=>{"operationName"=>"getListPanelProjects", "variables"=>{"filters"=>{"type"=>["Tenant"], "bbox"=>"-74.00665283203126,40.694956309550584,-73.87516021728517,40.79873682494156", "dashboardId"=>"lic-development-map", "isAtParcel"=>nil}, "first"=>10, "after"=>nil, "before"=>"MjE"}, "query"=>"query getListPanelProjects($filters: FiltersInput!, $first: Int!, $before: String, $after: String) {\n projectList(filters: $filters, first: $first, before: $before, after: $after) {\n totalCount\n pageInfo {\n hasNextPage\n hasPreviousPage\n startCursor\n endCursor\n __typename\n }\n nodes {\n id\n resourceId\n type\n name\n latlon\n category\n status\n fillColor\n __typename\n }\n __typename\n }\n}\n"}}
web.1 | User Load (2.0ms) SELECT "users".* FROM "users" WHERE "users"."id" = $1 ORDER BY "users"."id" ASC LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 1], ["LIMIT", 1]]
web.1 | ###############################
web.1 | Got cached document #<GraphQL::Language::Nodes::Document:0x00007f88fb86fb88>
web.1 | ###############################
web.1 | Dashboard Exists (9.4ms) SELECT 1 AS one FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | Dashboard Load (3.7ms) SELECT "dashboards".* FROM "dashboards" WHERE "dashboards"."slug" = $1 LIMIT $2 /*application:Citiesense,controller:graphql,action:execute*/ [["slug", "lic-development-map"], ["LIMIT", 1]]
web.1 | (67.0ms) SELECT COUNT(*) FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"]]
web.1 | Project Load (70.5ms) SELECT "projects".* FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 ORDER BY "projects"."updated_at" DESC, "projects"."name" ASC LIMIT $4 /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["LIMIT", 10]]
web.1 | (53.2ms) SELECT COUNT(*) FROM (SELECT 1 AS one FROM "projects" WHERE "projects"."visibility" = $1 AND (ST_intersects(st_makeenvelope('-74.00665283203126','40.694956309550584','-73.87516021728517','40.79873682494156',4326), projects.the_geom)) AND (ST_Intersects((SELECT the_geom FROM dashboards WHERE id = 22), projects.the_geom)) AND "projects"."company_id" = $2 AND "projects"."type" = $3 LIMIT $4) subquery_for_count /*application:Citiesense,controller:graphql,action:execute*/ [["visibility", "Public"], ["company_id", 11], ["type", "Tenant"], ["LIMIT", 20]]
web.1 | Company Load (2.5ms) SELECT "companies".* FROM "companies" WHERE "companies"."id" = $1 /*application:Citiesense,controller:graphql,action:execute*/ [["id", 11]]
web.1 | Completed 200 OK in 474ms (Views: 1.7ms | ActiveRecord: 208.3ms)
web.1 |
web.1 |
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment