ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a58e1e7742ef: POST https://beta.jinchangxiao.com/v2/user/get-index at 2026-07-16 09:51:35 pm by 117.133.84.85

Log Messages

总计46条数据
TimeLevelCategoryMessage
 
21:51:35.475traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
21:51:35.475traceyii\base\Module::getModuleLoading module: debug
21:51:35.475traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
21:51:35.476traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
21:51:35.476traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
21:51:35.476traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.476infotime tracing start1784209895476977152
21:51:35.477traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
21:51:35.477traceyii\web\Application::handleRequestRoute requested: 'v2/user/get-index'
21:51:35.477traceyii\base\Module::getModuleLoading module: v2
21:51:35.478infoyii\web\Session::openSession started
21:51:35.479infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
21:51:35.479infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ'
21:51:35.480traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.481traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:51:35.481traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.481traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:51:35.482infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
21:51:35.482traceyii\base\Controller::runActionRoute to run: v2/user/get-index
21:51:35.483traceyii\base\InlineAction::runWithParamsRunning action: app\modules\v2\controllers\UserController::actionGetIndex()
21:51:35.483infoyii\db\Command::querySELECT COUNT(*) FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1015) AND ("is_read"=FALSE) AND ("object_type" <> 20030)
21:51:35.502infoyii\db\Command::querySELECT count(*) as count, object_type FROM "a57be577deb434"."tbl_unread_comments" WHERE ("remind_user_id"=1015) AND (is_read = false) GROUP BY "object_type"
21:51:35.524traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.527traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewCalendarMng
21:51:35.527traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
21:51:35.527traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: TechDirector
21:51:35.527traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
21:51:35.527traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.529traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.531infoyii\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"=1015) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
21:51:35.533infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1015
21:51:35.534infoyii\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"=1015) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."name"
21:51:35.536infoyii\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"=1015) AND (s.accessible_user IS NOT NULL) AND ("u"."user_status"='1') GROUP BY "s"."id", "u"."id" ORDER BY "u"."id"
21:51:35.537infoyii\db\Command::querySELECT DISTINCT date_trunc('day', generate_series( GREATEST(start_at::date, '2026-07-01'::date), LEAST(end_at::date, '2026-07-31'::date), '1 day' ))::date AS used_date FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1015) AND (NOT ("start_at" IS NULL)) AND (NOT ("end_at" IS NULL)) AND ("start_at" <= '2026-07-31') AND ("end_at" >= '2026-07-01')
21:51:35.542infoyii\db\Command::querySELECT DISTINCT date_trunc('day', generate_series( GREATEST(s_at::date, '2026-07-01'::date), LEAST(e_at::date, '2026-07-31'::date), '1 day' ))::date AS used_date 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)) "s" WHERE ("created_by"=1015) AND ("s_at" <= '2026-07-31') AND ("e_at" >= '2026-07-01')
21:51:35.543infoyii\db\Command::querySELECT DISTINCT date_trunc('day', generate_series( GREATEST(start_at::date, '2026-07-01'::date), LEAST(end_at::date, '2026-07-31'::date), '1 day' ))::date AS used_date FROM "a57be577deb434"."tbl_work_logs" WHERE ("created_by"=1015) AND (NOT ("start_at" IS NULL)) AND (NOT ("end_at" IS NULL)) AND ("is_draft"=FALSE) AND ("start_at" <= '2026-07-31') AND ("end_at" >= '2026-07-01')
21:51:35.544infoyii\db\Command::querySELECT DISTINCT date_trunc('day', generate_series( GREATEST(start_at::date, '2026-07-01'::date), LEAST(end_at::date, '2026-07-31'::date), '1 day' ))::date AS alarm_date FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1015) AND (NOT ("start_at" IS NULL)) AND (NOT ("alarm_before" IS NULL)) AND ("start_at" <= '2026-07-31') AND ("end_at" >= '2026-07-01') AND (start_at - alarm_before > now())
21:51:35.548infoyii\db\Command::querySELECT DISTINCT date_trunc('day', generate_series( GREATEST(s_at::date, '2026-07-01'::date), LEAST(e_at::date, '2026-07-31'::date), '1 day' ))::date AS alarm_date 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)) "s" WHERE ("created_by"=1015) AND (NOT ("alarm_before" IS NULL)) AND ("s_at" <= '2026-07-31') AND ("e_at" >= '2026-07-01') AND (s_at - alarm_before > now())
21:51:35.550infoyii\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" >= '2026-07-16 00:00:00') AND ("w"."end_at" < '2026-07-16 23:59:59')) OR (("w"."start_at" <= '2026-07-16 00:00:00') AND ("w"."end_at" > '2026-07-16 00:00:00')) OR (("w"."start_at" <= '2026-07-16 23:59:59') AND ("w"."end_at" > '2026-07-16 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"=1015) AND ("w"."created_by" IN (1015, 1015, 1022, 1023, 5248))) 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)) "s" WHERE ((("s"."s_at" >= '2026-07-16 00:00:00') AND ("s"."e_at" < '2026-07-16 23:59:59')) OR (("s"."s_at" <= '2026-07-16 00:00:00') AND ("s"."e_at" > '2026-07-16 00:00:00')) OR (("s"."s_at" <= '2026-07-16 23:59:59') AND ("s"."e_at" > '2026-07-16 23:59:59'))) AND ("s"."created_by"=1015) AND ("s"."created_by" IN (1004, 1001, 5087, 1015, 1015, 1023, 5360, 1022, 5311, 5311, 5248, 5476, 5500, 5252, 1013, 5300, 1005, 5499, 5332, 1011, 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" >= '2026-07-16 00:00:00') AND ("c"."end_at" < '2026-07-16 23:59:59')) OR (("c"."start_at" <= '2026-07-16 00:00:00') AND ("c"."end_at" > '2026-07-16 00:00:00')) OR (("c"."start_at" <= '2026-07-16 23:59:59') AND ("c"."end_at" > '2026-07-16 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1015, 1015, 1023, 1022, 5248)) AND ("c"."created_by"=1015) ) )) "w" ORDER BY "start_at") "c"
21:51:35.556infoyii\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" >= '2026-07-16 00:00:00') AND ("w"."end_at" < '2026-07-16 23:59:59')) OR (("w"."start_at" <= '2026-07-16 00:00:00') AND ("w"."end_at" > '2026-07-16 00:00:00')) OR (("w"."start_at" <= '2026-07-16 23:59:59') AND ("w"."end_at" > '2026-07-16 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"=1015) AND ("w"."created_by" IN (1015, 1015, 1022, 1023, 5248))) 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)) "s" WHERE ((("s"."s_at" >= '2026-07-16 00:00:00') AND ("s"."e_at" < '2026-07-16 23:59:59')) OR (("s"."s_at" <= '2026-07-16 00:00:00') AND ("s"."e_at" > '2026-07-16 00:00:00')) OR (("s"."s_at" <= '2026-07-16 23:59:59') AND ("s"."e_at" > '2026-07-16 23:59:59'))) AND ("s"."created_by"=1015) AND ("s"."created_by" IN (1004, 1001, 5087, 1015, 1015, 1023, 5360, 1022, 5311, 5311, 5248, 5476, 5500, 5252, 1013, 5300, 1005, 5499, 5332, 1011, 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" >= '2026-07-16 00:00:00') AND ("c"."end_at" < '2026-07-16 23:59:59')) OR (("c"."start_at" <= '2026-07-16 00:00:00') AND ("c"."end_at" > '2026-07-16 00:00:00')) OR (("c"."start_at" <= '2026-07-16 23:59:59') AND ("c"."end_at" > '2026-07-16 23:59:59'))) AND (c.start_at IS NOT NULL) AND (c.end_at IS NOT NULL) AND ("c"."created_by" IN (1015, 1015, 1023, 1022, 5248)) AND ("c"."created_by"=1015) ) )) "w" ORDER BY "start_at"
21:51:35.561infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=26) AND (0=1)
21:51:35.561infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=9) AND (0=1)
21:51:35.562infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND (0=1)
21:51:35.563traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
21:51:35.564traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
21:51:35.564infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1015, 2, 1161, 'v2/user/get-index', '{"access_token":"Q_7DD5LA0njCol9o5skCibRkap3ZqeYZ","device_type":"2","posttime":"1784209920","token":"71e71ef19f04f4994582152cd5ce757d","version_code":"1161"}', '{"code":200,"data":{"announcementUnread":{"count":0},"unread":[],"calendar":{"list":[],"point":[{"edate":"2026-07-31","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-30","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-29","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-28","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-27","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-26","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-25","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-24","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-23","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-22","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-21","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-20","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-19","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-18","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-17","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-16","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-15","is_used":true,"is_calendar_used":true,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-14","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-13","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-12","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-11","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-10","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-09","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-08","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-07","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-06","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-05","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-04","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-03","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-02","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false},{"edate":"2026-07-01","is_used":false,"is_calendar_used":false,"is_schedule_used":false,"is_work_log_used":false}],"free":[],"alarm":[{"edate":"2026-07-31","is_alarm":false},{"edate":"2026-07-30","is_alarm":false},{"edate":"2026-07-29","is_alarm":false},{"edate":"2026-07-28","is_alarm":false},{"edate":"2026-07-27","is_alarm":false},{"edate":"2026-07-26","is_alarm":false},{"edate":"2026-07-25","is_alarm":false},{"edate":"2026-07-24","is_alarm":false},{"edate":"2026-07-23","is_alarm":false},{"edate":"2026-07-22","is_alarm":false},{"edate":"2026-07-21","is_alarm":false},{"edate":"2026-07-20","is_alarm":false},{"edate":"2026-07-19","is_alarm":false},{"edate":"2026-07-18","is_alarm":false},{"edate":"2026-07-17","is_alarm":false},{"edate":"2026-07-16","is_alarm":false},{"edate":"2026-07-15","is_alarm":false},{"edate":"2026-07-14","is_alarm":false},{"edate":"2026-07-13","is_alarm":false},{"edate":"2026-07-12","is_alarm":false},{"edate":"2026-07-11","is_alarm":false},{"edate":"2026-07-10","is_alarm":false},{"edate":"2026-07-09","is_alarm":false},{"edate":"2026-07-08","is_alarm":false},{"edate":"2026-07-07","is_alarm":false},{"edate":"2026-07-06","is_alarm":false},{"edate":"2026-07-05","is_alarm":false},{"edate":"2026-07-04","is_alarm":false},{"edate":"2026-07-03","is_alarm":false},{"edate":"2026-07-02","is_alarm":false},{"edate":"2026-07-01","is_alarm":false}],"pagenation":{"totalcount":0,"thispage":1,"pagesize":-1}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"117.133.84.85","ua":"jinchangxiao\/2.3.158 (iPhone 12; iOS 26.5.2; Scale\/3.00)"}', FALSE, '2026-07-16 21:51:35', 87392768) RETURNING "id"