ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6879a1b5cbe71: POST https://beta.jinchangxiao.com/v2/calendar/save-synchronize at 2025-07-18 09:21:57 am by 114.246.239.146

Database Queries

总计20条数据
TimeDurationTypeQuery
  
09:21:57.8383.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH'

[+] Explain
09:21:57.8421.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
09:21:57.8452.1 msSELECTSELECT "system_calendar_id" FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18')) AND ("is_remind"=TRUE)

[+] Explain
09:21:57.8472.1 msDELETEDELETE FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18')) AND ("system_calendar_id" NOT IN ('8f27be1e-8632-4c3d-8d61-a5d651f7113e_65', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_67', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_258', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_259', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_262', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_264', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_268', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_269', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_270', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_271', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_274', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_275', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_301'))

[+] Explain
09:21:57.8491.6 msDELETEDELETE FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND ("is_system"=TRUE) AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8511.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_65') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8531.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_67') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8551.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_258') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8561.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_259') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8581.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_262') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8601.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_264') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8611.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_268') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8631.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_269') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8651.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_270') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8661.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_271') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8681.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_274') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8701.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_275') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8711.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='8f27be1e-8632-4c3d-8d61-a5d651f7113e_301') AND (("start_at" >= '2025-07-18') OR ("end_at" >= '2025-07-18'))

[+] Explain
09:21:57.8738.0 msINSERTINSERT INTO "a57be577deb434"."tbl_calendars" ("title", "start_at", "end_at", "alarm_before", "system_calendar_id", "is_public", "is_sync", "is_system", "is_remind", "created_by") VALUES ('哈哈哈哈', '2024-09-19 09:00:00', '2024-09-19 18:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_65', 0, TRUE, TRUE, FALSE, 1000), ('test', '2024-09-24 09:00:00', '2024-09-24 18:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_67', 0, TRUE, TRUE, FALSE, 1000), ('', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_258', 0, TRUE, TRUE, FALSE, 1000), ('测试鸿蒙日程同步', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_259', 0, TRUE, TRUE, FALSE, 1000), ('test again', '2024-10-31 14:00:00', '2024-10-31 15:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_262', 0, TRUE, TRUE, FALSE, 1000), ('测试鸿蒙日程同步', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_264', 0, TRUE, TRUE, FALSE, 1000), ('技术方案-一级文档:hfjfjnf', '2024-12-13 14:00:00', '2024-12-13 16:00:00', '1800', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_268', 0, TRUE, TRUE, FALSE, 1000), ('技术方案-二级文档:xvsdfsdfdsfdsfdsf', '2024-12-31 00:00:00', '2024-12-31 01:00:00', '900', '8f27be1e-8632-4c3d-8d61-a5d651f7113e_269', 0, TRUE, TRUE, FALSE, 1000), ('咨询服务:发送范德萨', '2024-12-30 14:00:00', '2024-12-30 15:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_270', 0, TRUE, TRUE, FALSE, 1000), ('好吧宝贝', '2025-03-02 09:00:00', '2025-03-02 18:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_271', 0, TRUE, TRUE, FALSE, 1000), ('电话沟通项目进展', '2025-03-25 09:00:00', '2025-03-25 10:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_274', 0, TRUE, TRUE, FALSE, 1000), ('综合服务大半天:经常你从哪你', '2025-03-25 10:00:00', '2025-03-25 13:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_275', 0, TRUE, TRUE, FALSE, 1000), ('gvvh', '2025-04-21 09:00:00', '2025-04-21 18:00:00', NULL, '8f27be1e-8632-4c3d-8d61-a5d651f7113e_301', 0, TRUE, TRUE, FALSE, 1000)

[+] Explain
09:21:57.8821.1 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 168, 'v2/calendar/save-synchronize', '{"SynchronizeData":["{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_65\", \"Calendars[title]\": \"\u54c8\u54c8\u54c8\u54c8\",\n \"Calendars[start_at]\": \"2024-09-19 09:00:00\", \"Calendars[end_at]\": \"2024-09-19 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_67\", \"Calendars[title]\": \"test\",\n \"Calendars[start_at]\": \"2024-09-24 09:00:00\", \"Calendars[end_at]\": \"2024-09-24 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_258\", \"Calendars[title]\": \"\",\n \"Calendars[start_at]\": \"2024-10-25 08:00:00\", \"Calendars[end_at]\": \"2024-10-25 09:00:00\",\n \"Calendars[alarm_before]\": \"0\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_259\", \"Calendars[title]\": \"\u6d4b\u8bd5\u9e3f\u8499\u65e5\u7a0b\u540c\u6b65\",\n \"Calendars[start_at]\": \"2024-10-25 08:00:00\", \"Calendars[end_at]\": \"2024-10-25 09:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_262\", \"Calendars[title]\": \"test again\",\n \"Calendars[start_at]\": \"2024-10-31 14:00:00\", \"Calendars[end_at]\": \"2024-10-31 15:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_264\", \"Calendars[title]\": \"\u6d4b\u8bd5\u9e3f\u8499\u65e5\u7a0b\u540c\u6b65\",\n \"Calendars[start_at]\": \"2024-10-25 08:00:00\", \"Calendars[end_at]\": \"2024-10-25 09:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_268\", \"Calendars[title]\": \"\u6280\u672f\u65b9\u6848-\u4e00\u7ea7\u6587\u6863:hfjfjnf\",\n \"Calendars[start_at]\": \"2024-12-13 14:00:00\", \"Calendars[end_at]\": \"2024-12-13 16:00:00\",\n \"Calendars[alarm_before]\": \"1800\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_269\", \"Calendars[title]\": \"\u6280\u672f\u65b9\u6848-\u4e8c\u7ea7\u6587\u6863:xvsdfsdfdsfdsfdsf\",\n \"Calendars[start_at]\": \"2024-12-31 00:00:00\", \"Calendars[end_at]\": \"2024-12-31 01:00:00\",\n \"Calendars[alarm_before]\": \"900\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_270\", \"Calendars[title]\": \"\u54a8\u8be2\u670d\u52a1:\u53d1\u9001\u8303\u5fb7\u8428\",\n \"Calendars[start_at]\": \"2024-12-30 14:00:00\", \"Calendars[end_at]\": \"2024-12-30 15:00:00\",\n \"Calendars[alarm_before]\": \"0\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_271\", \"Calendars[title]\": \"\u597d\u5427\u5b9d\u8d1d\",\n \"Calendars[start_at]\": \"2025-03-02 09:00:00\", \"Calendars[end_at]\": \"2025-03-02 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_274\", \"Calendars[title]\": \"\u7535\u8bdd\u6c9f\u901a\u9879\u76ee\u8fdb\u5c55\",\n \"Calendars[start_at]\": \"2025-03-25 09:00:00\", \"Calendars[end_at]\": \"2025-03-25 10:00:00\",\n \"Calendars[alarm_before]\": \"\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_275\", \"Calendars[title]\": \"\u7efc\u5408\u670d\u52a1\u5927\u534a\u5929:\u7ecf\u5e38\u4f60\u4ece\u54ea\u4f60\",\n \"Calendars[start_at]\": \"2025-03-25 10:00:00\", \"Calendars[end_at]\": \"2025-03-25 13:00:00\",\n \"Calendars[alarm_before]\": \"0\"}","{\"Calendars[system_calendar_id]\": \"8f27be1e-8632-4c3d-8d61-a5d651f7113e_301\", \"Calendars[title]\": \"gvvh\",\n \"Calendars[start_at]\": \"2025-04-21 09:00:00\", \"Calendars[end_at]\": \"2025-04-21 18:00:00\",\n \"Calendars[alarm_before]\": \"\"}"],"posttime":"1752801719","access_token":"oTtlK_p5ZOBpvQJd1tf5AoUbRaTdQ7qH","device_type":"6","version_code":"168","token":"d3cb0a7e6ff11b26fdaf81d8d16579a5"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u65e5\u7a0b\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-07-18 09:21:57') RETURNING "id"

[+] Explain