0.0006301 |
16.96% |
SELECT "me"."id", "me"."email", "me"."email_verified", "me"."name", "me"."phone", "me"."phone_verified", "me"."password", "me"."from_body", "me"."flagged", "me"."is_superuser", "me"."created", "me"."last_active", "me"."title", "me"."twitter_id", "me"."facebook_id", "me"."oidc_ids", "me"."area_ids", "me"."extra"
FROM "users" "me"
WHERE "me"."id" = '8' |
0.0006130 |
16.50% |
SELECT "me"."id", "me"."problem_id", "me"."comment_id", "me"."title", "me"."detail", "me"."photo", "me"."anonymous", "me"."created", "me"."extra", "me"."category", "me"."latitude", "me"."longitude"
FROM "moderation_original_data" "me"
WHERE "comment_id" IS NULL AND "me"."problem_id" = '2'
ORDER BY "id" DESC
LIMIT '1' |
0.0004921 |
13.25% |
SELECT "me"."id", "me"."cobrand", "me"."name", "me"."short_name", "me"."background_colour", "me"."theme_colour", "me"."images", "me"."wasteworks_name", "me"."wasteworks_short_name"
FROM "manifest_theme" "me"
WHERE "me"."cobrand" = 'olacobrand' |
0.0004160 |
11.20% |
SELECT "me"."id", "me"."postcode", "me"."latitude", "me"."longitude", "me"."bodies_str", "me"."bodies_missing", "me"."areas", "me"."category", "me"."title", "me"."detail", "me"."photo", "me"."used_map", "me"."user_id", "me"."name", "me"."anonymous", "me"."external_id", "me"."external_body", "me"."external_team", "me"."created", "me"."confirmed", "me"."state", "me"."lang", "me"."service", "me"."cobrand", "me"."cobrand_data", "me"."lastupdate", "me"."whensent", "me"."send_questionnaire", "me"."extra", "me"."flagged", "me"."geocode", "me"."response_priority_id", "me"."send_state", "me"."send_fail_count", "me"."send_fail_reason", "me"."send_fail_timestamp", "me"."send_fail_body_ids", "me"."send_method_used", "me"."non_public", "me"."external_source", "me"."external_source_id", "me"."interest_count", "me"."subcategory", "me"."defect_type_id", "contact"."id", "contact"."body_id", "contact"."category", "contact"."email", "contact"."state", "contact"."editor", "contact"."whenedited", "contact"."note", "contact"."extra", "contact"."non_public", "contact"."endpoint", "contact"."jurisdiction", "contact"."api_key", "contact"."send_method"
FROM "problem" "me"
LEFT JOIN "contacts" "contact"
ON CAST( contact.body_id AS text ) = regexp_split_to_array( me.bodies_str, ', ' ) [1] AND "contact"."category" = "me"."category"
WHERE "me"."id" = '2' |
0.0003979 |
10.71% |
SELECT "me"."id", "me"."problem_id", "me"."comment_id", "me"."title", "me"."detail", "me"."photo", "me"."anonymous", "me"."created", "me"."extra", "me"."category", "me"."latitude", "me"."longitude"
FROM "moderation_original_data" "me"
WHERE "me"."comment_id" = '1' AND "problem_id" = '2'
ORDER BY "id" DESC
LIMIT '1' |
0.0003328 |
8.96% |
SELECT "me"."secret"
FROM "secret" "me" |
0.0003052 |
8.21% |
SELECT "me"."id", "me"."problem_id", "me"."whensent", "me"."whenanswered", "me"."ever_reported", "me"."old_state", "me"."new_state"
FROM "questionnaire" "me"
WHERE ( ( "old_state" IN ( 'closed', 'cancelled', 'duplicate', 'internal referral', 'not responsible', 'unable to fix', 'confirmed', 'action scheduled', 'in progress', 'investigating', 'planned' ) AND "old_state" = new_state ) OR "new_state" = 'confirmed' ) AND "problem_id" = '2' AND "whenanswered" IS NOT NULL
ORDER BY "whenanswered" |
0.0002780 |
7.48% |
SELECT "me"."id", "me"."problem_id", "me"."user_id", "me"."anonymous", "me"."name", "me"."website", "me"."created", "me"."confirmed", "me"."text", "me"."photo", "me"."state", "me"."cobrand", "me"."lang", "me"."cobrand_data", "me"."mark_fixed", "me"."mark_open", "me"."problem_state", "me"."external_id", "me"."extra", "me"."send_state", "me"."send_fail_count", "me"."send_fail_reason", "me"."send_fail_timestamp", "me"."whensent", "me"."private_email_text"
FROM "comment" "me"
WHERE "me"."state" = 'confirmed' AND "problem_id" = '2'
ORDER BY "me"."confirmed", "me"."id" |
0.0002499 |
6.73% |
SELECT "me"."id", "me"."problem_id", "me"."whensent", "me"."whenanswered", "me"."ever_reported", "me"."old_state", "me"."new_state"
FROM "questionnaire" "me"
WHERE "new_state" IN ( 'fixed', 'fixed - user', 'fixed - council' ) AND "old_state" NOT IN ( 'fixed', 'fixed - user', 'fixed - council' ) AND "problem_id" = '2' AND "whenanswered" IS NOT NULL
ORDER BY "whenanswered" |