Database Queries

总计27条数据
TimeDurationTypeQuery
  
19:36:08.4552.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

19:36:08.4581.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

19:36:08.4623.5 msSELECTSELECT sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then 1 else 0 end) count1new, sum(case when minpsl.new_status = 1 AND minpsl.old_status IS NULL then p.budget else 0 end) count1newsum, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then 1 else 0 end) count1in, sum(case when (minpsl.old_status != 1 OR (minpsl.old_status IS NULL AND minpsl.new_status != 1)) and maxpsl.new_status = 1 then p.budget else 0 end) count1insum, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then 1 else 0 end) count1out, sum(case when (minpsl.old_status = 1 OR (minpsl.old_status IS NULL AND minpsl.new_status = 1)) and maxpsl.new_status != 1 then p.budget else 0 end) count1outsum, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then 1 else 0 end) count2new, sum(case when minpsl.new_status = 2 AND minpsl.old_status IS NULL then p.budget else 0 end) count2newsum, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then 1 else 0 end) count2in, sum(case when (minpsl.old_status != 2 OR (minpsl.old_status IS NULL AND minpsl.new_status != 2)) and maxpsl.new_status = 2 then p.budget else 0 end) count2insum, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then 1 else 0 end) count2out, sum(case when (minpsl.old_status = 2 OR (minpsl.old_status IS NULL AND minpsl.new_status = 2)) and maxpsl.new_status != 2 then p.budget else 0 end) count2outsum, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then 1 else 0 end) count3new, sum(case when minpsl.new_status = 3 AND minpsl.old_status IS NULL then p.budget else 0 end) count3newsum, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then 1 else 0 end) count3in, sum(case when (minpsl.old_status != 3 OR (minpsl.old_status IS NULL AND minpsl.new_status != 3)) and maxpsl.new_status = 3 then p.budget else 0 end) count3insum, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then 1 else 0 end) count3out, sum(case when (minpsl.old_status = 3 OR (minpsl.old_status IS NULL AND minpsl.new_status = 3)) and maxpsl.new_status != 3 then p.budget else 0 end) count3outsum, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then 1 else 0 end) count4new, sum(case when minpsl.new_status = 4 AND minpsl.old_status IS NULL then p.budget else 0 end) count4newsum, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then 1 else 0 end) count4in, sum(case when (minpsl.old_status != 4 OR (minpsl.old_status IS NULL AND minpsl.new_status != 4)) and maxpsl.new_status = 4 then p.budget else 0 end) count4insum, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then 1 else 0 end) count4out, sum(case when (minpsl.old_status = 4 OR (minpsl.old_status IS NULL AND minpsl.new_status = 4)) and maxpsl.new_status != 4 then p.budget else 0 end) count4outsum, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then 1 else 0 end) count5new, sum(case when minpsl.new_status = 5 AND minpsl.old_status IS NULL then p.budget else 0 end) count5newsum, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then 1 else 0 end) count5in, sum(case when (minpsl.old_status != 5 OR (minpsl.old_status IS NULL AND minpsl.new_status != 5)) and maxpsl.new_status = 5 then p.budget else 0 end) count5insum, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then 1 else 0 end) count5out, sum(case when (minpsl.old_status = 5 OR (minpsl.old_status IS NULL AND minpsl.new_status = 5)) and maxpsl.new_status != 5 then p.budget else 0 end) count5outsum, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then 1 else 0 end) count0new, sum(case when minpsl.new_status = 0 AND minpsl.old_status IS NULL then p.budget else 0 end) count0newsum, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then 1 else 0 end) count0in, sum(case when (minpsl.old_status != 0 OR (minpsl.old_status IS NULL AND minpsl.new_status != 0)) and maxpsl.new_status = 0 then p.budget else 0 end) count0insum, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then 1 else 0 end) count0out, sum(case when (minpsl.old_status = 0 OR (minpsl.old_status IS NULL AND minpsl.new_status = 0)) and maxpsl.new_status != 0 then p.budget else 0 end) count0outsum FROM "a57be577deb434"."tbl_projects" "p" LEFT JOIN (SELECT min(subpsl.id) AS min_id, max(subpsl.id) AS max_id, project_id FROM "a57be577deb434"."tbl_project_status_logs" "subpsl" WHERE subpsl.created_at >= '2025-08-04 00:00:00' AND subpsl.created_at < timestamp '2025-08-10 23:59:59' + interval '1 second' GROUP BY "subpsl"."project_id") "sub" ON sub.project_id = p.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "minpsl" ON sub.min_id = minpsl.id LEFT JOIN "a57be577deb434"."tbl_project_status_logs" "maxpsl" ON sub.max_id = maxpsl.id WHERE (0=1) AND (sub.min_id is not null and sub.max_id is not null)

19:36:08.4671.5 msSELECTSELECT "user_id" FROM "a57be577deb434"."tbl_user_role_change_logs" "urcl" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='AccountManager') AND (daterange(start_from::date, end_at::date, '[)') && '[2025-08-04 00:00:00, 2025-08-10 23:59:59]'::daterange) AND ("user_id" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5412, 5409, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first

19:36:08.4693.9 msSELECTSELECT d.nspname AS table_schema, c.relname AS table_name, a.attname AS column_name, t.typname AS data_type, a.attlen AS character_maximum_length, pg_catalog.col_description(c.oid, a.attnum) AS column_comment, a.atttypmod AS modifier, a.attnotnull = false AS is_nullable, CAST(pg_get_expr(ad.adbin, ad.adrelid) AS varchar) AS column_default, coalesce(pg_get_expr(ad.adbin, ad.adrelid) ~ 'nextval',false) AS is_autoinc, array_to_string((select array_agg(enumlabel) from pg_enum where enumtypid=a.atttypid)::varchar[],',') as enum_values, CASE atttypid WHEN 21 /*int2*/ THEN 16 WHEN 23 /*int4*/ THEN 32 WHEN 20 /*int8*/ THEN 64 WHEN 1700 /*numeric*/ THEN CASE WHEN atttypmod = -1 THEN null ELSE ((atttypmod - 4) >> 16) & 65535 END WHEN 700 /*float4*/ THEN 24 /*FLT_MANT_DIG*/ WHEN 701 /*float8*/ THEN 53 /*DBL_MANT_DIG*/ ELSE null END AS numeric_precision, CASE WHEN atttypid IN (21, 23, 20) THEN 0 WHEN atttypid IN (1700) THEN CASE WHEN atttypmod = -1 THEN null ELSE (atttypmod - 4) & 65535 END ELSE null END AS numeric_scale, CAST( information_schema._pg_char_max_length(information_schema._pg_truetypid(a, t), information_schema._pg_truetypmod(a, t)) AS numeric ) AS size, a.attnum = any (ct.conkey) as is_pkey FROM pg_class c LEFT JOIN pg_attribute a ON a.attrelid = c.oid LEFT JOIN pg_attrdef ad ON a.attrelid = ad.adrelid AND a.attnum = ad.adnum LEFT JOIN pg_type t ON a.atttypid = t.oid LEFT JOIN pg_namespace d ON d.oid = c.relnamespace LEFT join pg_constraint ct on ct.conrelid=c.oid and ct.contype='p' WHERE a.attnum > 0 and t.typname != '' and c.relname = 'tbl_user_role_change_logs' and d.nspname = 'a57be577deb434' ORDER BY a.attnum;

19:36:08.47310.0 msSELECTselect ct.conname as constraint_name, a.attname as column_name, fc.relname as foreign_table_name, fns.nspname as foreign_table_schema, fa.attname as foreign_column_name from (SELECT ct.conname, ct.conrelid, ct.confrelid, ct.conkey, ct.contype, ct.confkey, generate_subscripts(ct.conkey, 1) AS s FROM pg_constraint ct ) AS ct inner join pg_class c on c.oid=ct.conrelid inner join pg_namespace ns on c.relnamespace=ns.oid inner join pg_attribute a on a.attrelid=ct.conrelid and a.attnum = ct.conkey[ct.s] left join pg_class fc on fc.oid=ct.confrelid left join pg_namespace fns on fc.relnamespace=fns.oid left join pg_attribute fa on fa.attrelid=ct.confrelid and fa.attnum = ct.confkey[ct.s] where ct.contype='f' and c.relname='tbl_user_role_change_logs' and ns.nspname='a57be577deb434' order by fns.nspname, fc.relname, a.attnum

19:36:08.4831.1 msSELECTSELECT "created_by" FROM "a57be577deb434"."tbl_projects" WHERE ("bargain_date" >= '2025-08-04 00:00:00') AND ("bargain_date" <= '2025-08-10 23:59:59') AND ("project_status"=3) AND ("created_by" NOT IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) GROUP BY "created_by"

19:36:08.4850.5 msSELECTSELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-08-04 00:00:00') AND (start_at < timestamp '2025-08-10 23:59:59' + interval '1 second') AND (0=1) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)

19:36:08.4857.9 msSELECTSELECT sum(end_at - start_at) AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (start_at >= '2025-08-04 00:00:00') AND (start_at < timestamp '2025-08-10 23:59:59' + interval '1 second') AND ("w"."created_by" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("w"."location_in_id" IS NOT NULL) AND ("w"."location_out_id" IS NOT NULL) AND ("w"."client_id" IS NOT NULL)

19:36:08.4941.0 msSELECTSELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE (0=1) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-10 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE (0=1) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-10 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"

19:36:08.4952.4 msSELECTSELECT sum(sub.spent) as hours FROM ((SELECT ir.left_at - ir.arrived_at as spent FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-10 23:59:59') AND ("ir"."is_draft"=FALSE)) UNION ALL ( SELECT ps.end_at - ps.start_at as spent FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-10 23:59:59') AND ("ps"."is_draft"=FALSE) )) "sub"

19:36:08.4970.3 msSELECTSELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE (0=1) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-10 23:59:59') AND ("ir"."is_draft"=FALSE)

19:36:08.4981.3 msSELECTSELECT count(ir.id) as times FROM "a57be577deb434"."tbl_implement_records" "ir" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ir.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ir"."arrived_at" >= '2025-08-04 00:00:00') AND ("ir"."arrived_at" <= '2025-08-10 23:59:59') AND ("ir"."is_draft"=FALSE)

19:36:08.4990.3 msSELECTSELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE (0=1) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-10 23:59:59') AND ("ps"."is_draft"=FALSE)

19:36:08.5000.7 msSELECTSELECT count(ps.id) as times FROM "a57be577deb434"."tbl_pre_sales" "ps" LEFT JOIN "a57be577deb434"."tbl_cases" "c" ON ps.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("ps"."start_at" >= '2025-08-04 00:00:00') AND ("ps"."start_at" <= '2025-08-10 23:59:59') AND ("ps"."is_draft"=FALSE)

19:36:08.5010.4 msSELECTSELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE (0=1) AND ("c"."closed_at" >= '2025-08-04 00:00:00') AND ("c"."closed_at" <= '2025-08-10 23:59:59')

19:36:08.5011.2 msSELECTSELECT sum(ca.points) as value FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN "a57be577deb434"."tbl_case_assignments" "ca" ON ca.case_id = c.id WHERE ("c"."deduct_points_from" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("c"."closed_at" >= '2025-08-04 00:00:00') AND ("c"."closed_at" <= '2025-08-10 23:59:59')

19:36:08.5042.4 msSELECTSELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE (0=1) AND ("otc"."complete_at" >= '2025-08-04 00:00:00') AND ("otc"."complete_at" <= '2025-08-10 23:59:59')

19:36:08.5073.5 msSELECTSELECT count(otc.id) as count FROM "a57be577deb434"."tbl_operation_task_contacts" "otc" LEFT JOIN "a57be577deb434"."tbl_operation_tasks" "ot" ON otc.operation_task_id = ot.id WHERE ("ot"."head_of" IN (5332, 1001, 5087, 5300, 5311, 5295, 1013, 1004, 1005, 5449)) AND ("otc"."complete_at" >= '2025-08-04 00:00:00') AND ("otc"."complete_at" <= '2025-08-10 23:59:59')

19:36:08.5100.5 msSELECTSELECT w.scenario_option_id as key, wso.name, count(w.id) as value FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wso" ON w.scenario_option_id = wso.id WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND (0=1) AND (("w"."start_at" >= '2025-08-04 00:00:00') AND ("w"."start_at" <= '2025-08-10 23:59:59')) GROUP BY "w"."scenario_option_id", "wso"."name"

19:36:08.5110.2 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_work_logs" "w" WHERE ("w"."is_draft"=FALSE) AND (w.scenario_option_id is not null) AND ("w"."scenario_id"=1) AND (0=1) AND (("w"."start_at" >= '2025-08-04 00:00:00') AND ("w"."start_at" <= '2025-08-10 23:59:59'))

19:36:08.5110.6 msSELECTSELECT sub.status, count(sub.id) as value FROM (SELECT id, created_by, CASE WHEN complete_at IS NOT NULL THEN complete_at ELSE end_at END as day_at, CASE WHEN is_complete = TRUE THEN 1 WHEN ( ( ( "is_complete" = FALSE ) AND ( "end_at" < '2025-08-09 19:36:08' ) ) ) THEN 2 ELSE 0 END as status FROM "a57be577deb434"."tbl_schedules" WHERE "is_public"=1) "sub" WHERE (0=1) AND ("sub"."status" IN (0, 2)) GROUP BY "sub"."status"

19:36:08.5120.2 msSELECTSELECT COUNT(*) FROM "a57be577deb434"."tbl_schedules" WHERE (0=1) AND ("is_public"=1) AND ("is_complete"=FALSE)

19:36:08.5120.2 msSELECTSELECT sub.project_status as key, count('sub.id') as projects FROM (SELECT p.id, p.project_status FROM "a57be577deb434"."tbl_projects" "p" WHERE (0=1) AND (project_status != 1) AND ("p"."bargain_date" >= '2025-08-04 00:00:00') AND ("p"."bargain_date" <= '2025-08-10 23:59:59')) "sub" GROUP BY "sub"."project_status"

19:36:08.5133.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=23) AND ("visit_date"='2025-08-09')

19:36:08.5170.8 msUPDATEUPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=69, "last_visit_at"='now()' WHERE "id"=54996

19:36:08.5181.2 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/analysis/sales-status-counts', '[]', '{"code":2000,"result":{"statusCounts":[{"id":"1","key":"\u9690\u6027\u9700\u6c42","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"2","key":"\u660e\u786e\u9700\u6c42","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"3","key":"\u5546\u673a\u6210\u4ea4","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"0","key":"\u6536\u6b3e\u5b8c\u6210","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"4","key":"\u5546\u673a\u5931\u8d25","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}},{"id":"5","key":"\u5546\u673a\u6401\u7f6e","value":{"new":"","new_sum":"","in":"","in_sum":"","out":"","out_sum":""}}],"workCount":{"workTimeList":{"sum":0,"avg":0},"clientVisitList":{"sum":0,"avg":0},"engineerSpentList":{"sum":0,"avg":0},"implementTimes":{"sum":0,"avg":0},"preSalesTimes":{"sum":0,"avg":0},"deductedPoint":{"sum":0,"avg":0},"operationDatas":{"sum":0,"avg":0}},"chart":{"salesTimes":[],"salesTimesCounts":0,"schedules":[],"schedulesCounts":0,"statusCounts":[],"projectCounts":0}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-08-09 19:36:08') RETURNING "id"