Performance Profiling

Total processing time: 104 ms; Peak memory: 2.957 MB. Show Profiling Timeline

总计21条数据

Time	Duration	Category	Info

14:47:10.813	21.1 ms	yii\db\Command::execute	INSERT 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, '2774b13f-91ff-4813-87d5-a7d62d22d87d_65', 0, TRUE, TRUE, FALSE, 1000), ('test', '2024-09-24 09:00:00', '2024-09-24 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_67', 0, TRUE, TRUE, FALSE, 1000), ('', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_258', 0, TRUE, TRUE, FALSE, 1000), ('测试鸿蒙日程同步', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_259', 0, TRUE, TRUE, FALSE, 1000), ('test again', '2024-10-31 14:00:00', '2024-10-31 15:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_262', 0, TRUE, TRUE, FALSE, 1000), ('测试鸿蒙日程同步', '2024-10-25 08:00:00', '2024-10-25 09:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_264', 0, TRUE, TRUE, FALSE, 1000), ('技术方案-一级文档:hfjfjnf', '2024-12-13 14:00:00', '2024-12-13 16:00:00', '1800', '2774b13f-91ff-4813-87d5-a7d62d22d87d_268', 0, TRUE, TRUE, FALSE, 1000), ('技术方案-二级文档:xvsdfsdfdsfdsfdsf', '2024-12-31 00:00:00', '2024-12-31 01:00:00', '900', '2774b13f-91ff-4813-87d5-a7d62d22d87d_269', 0, TRUE, TRUE, FALSE, 1000), ('咨询服务:发送范德萨', '2024-12-30 14:00:00', '2024-12-30 15:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_270', 0, TRUE, TRUE, FALSE, 1000), ('好吧宝贝', '2025-03-02 09:00:00', '2025-03-02 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_271', 0, TRUE, TRUE, FALSE, 1000), ('电话沟通项目进展', '2025-03-25 09:00:00', '2025-03-25 10:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_274', 0, TRUE, TRUE, FALSE, 1000), ('综合服务大半天:经常你从哪你', '2025-03-25 10:00:00', '2025-03-25 13:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_275', 0, TRUE, TRUE, FALSE, 1000), ('gvvh', '2025-04-21 09:00:00', '2025-04-21 18:00:00', NULL, '2774b13f-91ff-4813-87d5-a7d62d22d87d_301', 0, TRUE, TRUE, FALSE, 1000)
14:47:10.746	5.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:47:10.839	4.1 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 165, 'v2/calendar/save-synchronize', '{"SynchronizeData":["{\"Calendars[system_calendar_id]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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]\": \"2774b13f-91ff-4813-87d5-a7d62d22d87d_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":"1751006831","access_token":"rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u","device_type":"6","version_code":"165","token":"194f7352b677b620002f4dd3b305ce1e"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u65e5\u7a0b\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-06-27 14:47:10') RETURNING "id"
14:47:10.752	4.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='rpAaho7HBg3VJ1vNP7yVtm0Uw5j2xu-u'
14:47:10.768	3.6 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) AND ("system_calendar_id" NOT IN ('2774b13f-91ff-4813-87d5-a7d62d22d87d_65', '2774b13f-91ff-4813-87d5-a7d62d22d87d_67', '2774b13f-91ff-4813-87d5-a7d62d22d87d_258', '2774b13f-91ff-4813-87d5-a7d62d22d87d_259', '2774b13f-91ff-4813-87d5-a7d62d22d87d_262', '2774b13f-91ff-4813-87d5-a7d62d22d87d_264', '2774b13f-91ff-4813-87d5-a7d62d22d87d_268', '2774b13f-91ff-4813-87d5-a7d62d22d87d_269', '2774b13f-91ff-4813-87d5-a7d62d22d87d_270', '2774b13f-91ff-4813-87d5-a7d62d22d87d_271', '2774b13f-91ff-4813-87d5-a7d62d22d87d_274', '2774b13f-91ff-4813-87d5-a7d62d22d87d_275', '2774b13f-91ff-4813-87d5-a7d62d22d87d_301'))
14:47:10.764	3.6 ms	yii\db\Command::query	SELECT "system_calendar_id" FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27')) AND ("is_remind"=TRUE)
14:47:10.772	2.9 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_calendars" WHERE ("created_by"=1000) AND ("is_system"=TRUE) AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.775	2.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_65') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.778	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_67') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.807	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_275') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.787	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_262') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.781	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_258') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.793	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_268') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.796	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_269') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.784	2.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_259') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.801	2.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_271') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.790	2.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_264') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.799	2.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_270') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.804	2.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_274') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.810	2.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_calendars" WHERE ("system_calendar_id"='2774b13f-91ff-4813-87d5-a7d62d22d87d_301') AND (("start_at" >= '2025-06-27') OR ("end_at" >= '2025-06-27'))
14:47:10.757	1.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000