6a3d336c2fdeb: POST https://beta.jinchangxiao.com/v2/task/delete at 2026-06-25 09:55:56 pm by 117.176.187.29
Performance Profiling
Total processing time: 1,110 ms; Peak memory: 5.244 MB. Show Profiling Timeline
总计47条数据
| Time | Duration | Category | Info |
|---|---|---|---|
| 21:55:56.210 | 267.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=1652) AND ("object_type"=101) |
| 21:55:56.507 | 184.5 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=1652) AND ("object_type"=101)) OR (("target_id"=1652) AND ("target_object_type"=101)) |
| 21:55:56.807 | 181.3 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=1654) AND ("object_type"=101)) OR (("target_id"=1654) AND ("target_object_type"=101)) |
| 21:55:57.112 | 179.6 ms | yii\db\Command::execute | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=1653) AND ("object_type"=101)) OR (("target_id"=1653) AND ("target_object_type"=101)) |
| 21:55:57.006 | 83.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=1653) AND ("object_type"=101) |
| 21:55:56.694 | 82.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=1654) AND ("object_type"=101) |
| 21:55:56.478 | 22.1 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=1652) AND ("object_type"=101) |
| 21:55:57.090 | 21.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=1653) AND ("object_type"=101) |
| 21:55:56.777 | 21.2 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=1654) AND ("object_type"=101) |
| 21:55:56.503 | 1.6 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (3, 'delete', 106, 102, 1652, 101, 1000, '[1652]', '[1652]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u6e05\u5355","d4":["\u4e5d\u516b\u4e5d\u516b"]}') RETURNING "id" |
| 21:55:56.991 | 1.6 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_tasks" WHERE "id"=1654 |
| 21:55:56.801 | 1.5 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (3, 'delete', 106, 102, 1654, 101, 1000, '[1654]', '[1654]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u6e05\u5355","d4":["www"]}') RETURNING "id" |
| 21:55:57.293 | 1.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_tasks" WHERE "id"=1653 |
| 21:55:56.506 | 1.4 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 642685, 'a:13:{s:2:"id";i:642685;s:9:"object_id";i:106;s:11:"object_type";i:102;s:9:"target_id";i:1652;s:18:"target_object_type";i:101;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:6:"[1652]";s:9:"new_value";s:6:"[1652]";s:11:"description";s:107:"{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u6e05\u5355","d4":["\u4e5d\u516b\u4e5d\u516b"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '117.176.187.29') |
| 21:55:57.301 | 1.3 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", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1160, 'v2/task/delete', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"1652","posttime":"1782395776","token":"0261aadbb65fcbbc997b0805b2345100","version_code":"1160"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u9879\u76ee\u4efb\u52a1\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"ip":"117.176.187.29","ua":"jinchangxiao\/2.3.157 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-25 21:55:57', 1103902976) RETURNING "id" |
| 21:55:57.296 | 1.3 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_tasks" WHERE "id"=1652 |
| 21:55:56.802 | 1.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 642686, 'a:13:{s:2:"id";i:642686;s:9:"object_id";i:106;s:11:"object_type";i:102;s:9:"target_id";i:1654;s:18:"target_object_type";i:101;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:6:"[1654]";s:9:"new_value";s:6:"[1654]";s:11:"description";s:86:"{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u6e05\u5355","d4":["www"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '117.176.187.29') |
| 21:55:57.298 | 1.2 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\Tasks', 1652, '', '', 1000, '117.176.187.29') |
| 21:55:56.200 | 1.1 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC' |
| 21:55:56.805 | 1.1 ms | yii\db\Command::query | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (3, 'delete', 1652, 101, 1654, 101, 1000, '[1654]', '[1654]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u6e05\u5355","d4":["www"]}') RETURNING "id" |
| 21:55:56.993 | 1.1 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\Tasks', 1654, '', '', 1000, '117.176.187.29') |
| 21:55:56.995 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1652, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:46";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '117.176.187.29') |
| 21:55:57.295 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\Tasks', 1653, '', '', 1000, '117.176.187.29') |
| 21:55:56.806 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 642687, 'a:13:{s:2:"id";i:642687;s:9:"object_id";i:1652;s:11:"object_type";i:101;s:9:"target_id";i:1654;s:18:"target_object_type";i:101;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:6:"[1654]";s:9:"new_value";s:6:"[1654]";s:11:"description";s:86:"{"d1":"\u66f9\u6c38\u751f","d2":"\u5220\u9664\u4e86","d3":"\u6e05\u5355","d4":["www"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '117.176.187.29') |
| 21:55:57.005 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\TaskGroups', 106, 'a:0:{}', '', 1000, '117.176.187.29') |
| 21:55:57.001 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1652, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:46";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '117.176.187.29') |
| 21:55:56.997 | 1.0 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1653, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-08 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:43";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-08 00:00:00";}', '', 1000, '117.176.187.29') |
| 21:55:56.999 | 0.9 ms | yii\db\Command::execute | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Tasks', 1652, 'a:4:{s:19:"target_completed_at";s:19:"2026-06-30 00:00:00";s:12:"completed_at";s:19:"2026-06-07 15:41:46";s:8:"start_at";s:19:"2026-05-31 00:00:00";s:6:"end_at";s:19:"2026-06-30 00:00:00";}', '', 1000, '117.176.187.29') |
| 21:55:57.292 | 0.9 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1653 |
| 21:55:56.203 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 21:55:56.693 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1652 |
| 21:55:56.990 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1654 |
| 21:55:56.501 | 0.7 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=1652) AND ("object_type"=101) |
| 21:55:57.004 | 0.7 ms | yii\db\Command::query | SELECT "status", "progress" FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=106) AND (parent_id is null) |
| 21:55:56.800 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 21:55:57.003 | 0.6 ms | yii\db\Command::query | SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=106) AND ("status"=1) |
| 21:55:56.989 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"=1652 |
| 21:55:56.996 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "parent_id"=1652 |
| 21:55:56.692 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id" IS NULL |
| 21:55:56.205 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"='1652' |
| 21:55:56.502 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 21:55:56.804 | 0.5 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 21:55:56.799 | 0.5 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=1654) AND ("object_type"=101) |
| 21:55:57.111 | 0.4 ms | yii\db\Command::execute | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=1653) AND ("object_type"=101) |
| 21:55:56.200 | 0.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
| 21:55:57.002 | 0.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |
| 21:55:57.000 | 0.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"=106 |