ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6868b8779464d: POST https://beta.jinchangxiao.com/v2/user/get-index at 2025-07-05 01:30:31 pm by 120.244.156.159

Performance Profiling

Total processing time: 522 ms; Peak memory: 4.568 MB. Show Profiling Timeline

总计19条数据
TimeDurationCategoryInfo
  
13:30:31.734381.7 msyii\db\Command::querySELECT DISTINCT date(dt) AS edate,CASE WHEN count(cl.alarm_before) !=0 or count(sh.alarm_before) !=0 THEN true ELSE false END AS is_alarm FROM generate_series(date_trunc('day', to_date('20250701', 'yyyymmdd')), date_trunc('day', to_date('20250731', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN "a57be577deb434"."tbl_calendars" "cl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at ) ) AND cl.created_by = 1005 LEFT JOIN "a57be577deb434"."tbl_schedules" "sh" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= sh.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= sh.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.end_at ) ) AND sh.created_by = 1005 WHERE (cl.start_at - cl.alarm_before > '2025-07-05 01:30:31') OR (sh.start_at - sh.alarm_before > '2025-07-05 01:30:31') GROUP BY "tt"."dt", "cl"."id" ORDER BY "edate" DESC
13:30:31.66268.7 msyii\db\Command::querySELECT DISTINCT date(dt) AS edate, CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_used, CASE WHEN count(cl.id) !=0 THEN true ELSE false END AS is_calendar_used, CASE WHEN count(sh.id) !=0 THEN true ELSE false END AS is_schedule_used, CASE WHEN count(wl.id) !=0 THEN true ELSE false END AS is_work_log_used FROM generate_series(date_trunc('day', to_date('20250701', 'yyyymmdd')), date_trunc('day', to_date('20250731', 'yyyymmdd')), '1 day') tt(dt) LEFT JOIN (SELECT * FROM "a57be577deb434"."tbl_calendars" "c" WHERE (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by"=1005)) "cl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= cl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= cl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= cl.end_at ) ) LEFT JOIN (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE ((start_at is not null) OR (end_at is not null)) AND (0 = 1)) "sh" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= sh.s_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= sh.e_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.s_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.s_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= sh.e_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= sh.e_at ) ) AND sh.created_by = 1005 LEFT JOIN (SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1005) AND (0 = 1)) "wl" ON ( ( (date(dt) || ' 00:00:00')::timestamp without time zone >= wl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone <= wl.end_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= wl.start_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= wl.start_at ) OR ( (date(dt) || ' 00:00:00')::timestamp without time zone <= wl.end_at AND (date(dt) || ' 23:59:59')::timestamp without time zone >= wl.end_at ) ) GROUP BY "tt"."dt" ORDER BY "edate" DESC
13:30:31.63418.7 msyii\db\Command::querySELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1005) AND (is_read = false) GROUP BY "object_type"
13:30:31.61815.7 msyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1005) AND ("is_read"=FALSE)
13:30:32.1163.8 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT * FROM ((SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ((("w"."start_at" >= '2025-07-05 00:00:00') AND ("w"."end_at" < '2025-07-05 23:59:59')) OR (("w"."start_at" <= '2025-07-05 00:00:00') AND ("w"."end_at" > '2025-07-05 00:00:00')) OR (("w"."start_at" <= '2025-07-05 23:59:59') AND ("w"."end_at" > '2025-07-05 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1005) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445)) AND (0 = 1)) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE ((start_at is not null) OR (end_at is not null)) AND (0 = 1)) "s" WHERE ((("s"."s_at" >= '2025-07-05 00:00:00') AND ("s"."e_at" < '2025-07-05 23:59:59')) OR (("s"."s_at" <= '2025-07-05 00:00:00') AND ("s"."e_at" > '2025-07-05 00:00:00')) OR (("s"."s_at" <= '2025-07-05 23:59:59') AND ("s"."e_at" > '2025-07-05 23:59:59'))) AND ("s"."created_by"=1005) AND ("s"."created_by" IN (1004, 1001, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."start_at" >= '2025-07-05 00:00:00') AND ("c"."end_at" < '2025-07-05 23:59:59')) OR (("c"."start_at" <= '2025-07-05 00:00:00') AND ("c"."end_at" > '2025-07-05 00:00:00')) OR (("c"."start_at" <= '2025-07-05 23:59:59') AND ("c"."end_at" > '2025-07-05 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1004, 1001, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295)) AND ("c"."created_by"=1005) ) )) "w" ORDER BY "start_at") "c"
13:30:32.1213.3 msyii\db\Command::querySELECT * FROM ((SELECT w.id, wlso.name as title, w.client_id, w.created_by, start_at, end_at, 3 as type, false AS is_alarm FROM "a57be577deb434"."tbl_work_logs" "w" LEFT JOIN "a57be577deb434"."tbl_work_log_scenario_options" "wlso" ON wlso.id = w.scenario_option_id WHERE ((("w"."start_at" >= '2025-07-05 00:00:00') AND ("w"."end_at" < '2025-07-05 23:59:59')) OR (("w"."start_at" <= '2025-07-05 00:00:00') AND ("w"."end_at" > '2025-07-05 00:00:00')) OR (("w"."start_at" <= '2025-07-05 23:59:59') AND ("w"."end_at" > '2025-07-05 23:59:59'))) AND (w.start_at IS NOT NULL) AND (w.end_at IS NOT NULL) AND ("w"."is_draft"=FALSE) AND ("w"."created_by"=1005) AND ("w"."created_by" IN (1000, 1001, 1004, 1005, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5296, 5300, 5311, 5329, 5332, 5360, 5388, 5404, 5420, 5440, 5445)) AND (0 = 1)) UNION ALL ( (SELECT s.id, schedule_title as title, s.client_id, created_by, s_at as start_at, e_at as end_at, 2 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM (SELECT *, CASE WHEN end_at IS NULL THEN ( CASE WHEN start_at > now() THEN start_at ELSE ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) END ) ELSE ( CASE WHEN start_at IS NULL AND end_at < now() THEN ( CASE WHEN is_complete = true THEN complete_at ELSE now() END ) ELSE end_at END ) END AS e_at, CASE WHEN start_at IS NULL THEN ( CASE WHEN end_at < now() THEN ( CASE WHEN is_complete = true THEN created_at ELSE end_at END ) ELSE ( CASE WHEN is_complete = true THEN created_at ELSE now() END ) END ) ELSE start_at END AS s_at FROM "a57be577deb434"."tbl_schedules" WHERE ((start_at is not null) OR (end_at is not null)) AND (0 = 1)) "s" WHERE ((("s"."s_at" >= '2025-07-05 00:00:00') AND ("s"."e_at" < '2025-07-05 23:59:59')) OR (("s"."s_at" <= '2025-07-05 00:00:00') AND ("s"."e_at" > '2025-07-05 00:00:00')) OR (("s"."s_at" <= '2025-07-05 23:59:59') AND ("s"."e_at" > '2025-07-05 23:59:59'))) AND ("s"."created_by"=1005) AND ("s"."created_by" IN (1004, 1001, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295))) UNION ALL ( SELECT c.id, title, c.client_id, created_by, start_at, end_at, 1 as type, CASE WHEN alarm_before IS NOT NULL THEN true ELSE false END AS is_alarm FROM "a57be577deb434"."tbl_calendars" "c" WHERE ((("c"."start_at" >= '2025-07-05 00:00:00') AND ("c"."end_at" < '2025-07-05 23:59:59')) OR (("c"."start_at" <= '2025-07-05 00:00:00') AND ("c"."end_at" > '2025-07-05 00:00:00')) OR (("c"."start_at" <= '2025-07-05 23:59:59') AND ("c"."end_at" > '2025-07-05 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1004, 1001, 5087, 1015, 1023, 5064, 5440, 5360, 1022, 5311, 5248, 1000, 5420, 5445, 5388, 5404, 5252, 1013, 5300, 5250, 5296, 1005, 1005, 1017, 5085, 5332, 1011, 5329, 5016, 5295)) AND ("c"."created_by"=1005) ) )) "w" ORDER BY "start_at"
13:30:31.6112.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF'
13:30:31.6091.8 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:30:31.6561.5 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_calendars" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1005) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
13:30:32.1271.4 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1005, 0, 263, 'v2/user/get-index', '{"access_token":"ASQnB-D3-GFkoD_J72arWnfEDMo3RFnF","device_type":"0","version_code":"263","token":"4e3e9de056a51f9726b5d839760cb68b","posttime":"1751693432"}', '{"code":200,"data":{"announcementUnread":{"count":433},"unread":[{"key":"1","value":22},{"key":"10","value":20},{"key":"18","value":131},{"key":"19","value":1},{"key":"20","value":37},{"key":"34","value":59},{"key":"37","value":36},{"key":"5","value":52},{"key":"7","value":74},{"key":999,"value":1}],"calendar":{"list":[],"point":[{"edate":"2025-07-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-21","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-15","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-13","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-12","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-11","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-10","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-09","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-08","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-07","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-06","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-05","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-04","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-03","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-02","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2025-07-01","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[],"pagenation":{"totalcount":0,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-05 13:30:32') RETURNING "id"
13:30:31.6141.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
13:30:31.6591.0 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_schedules" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1005) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
13:30:31.6171.0 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT "a".* FROM "global"."tbl_announcements" "a" LEFT JOIN "global"."tbl_read_announcement" "r" ON a.id = r.announcement_id AND r.user_id = 1005 LEFT JOIN "global"."tbl_logins" "l" ON l.id = r.user_id WHERE (l.id IS NULL) AND ("a"."created_at" > '2017-02-06 13:08:05') ORDER BY "a"."created_at" DESC) "c"
13:30:32.1240.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)
13:30:31.6600.8 msyii\db\Command::querySELECT "s"."accessible_user" FROM "a57be577deb434"."tbl_visible_work_logs" "s" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON u.id = s.accessible_user WHERE ("s"."user_id"=1005) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id"
13:30:31.6580.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1005
13:30:31.6160.3 msyii\db\Command::querySELECT * FROM "global"."tbl_logins" WHERE "id"=1005
13:30:32.1260.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)
13:30:32.1250.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND (0=1)