Performance Profiling

Total processing time: 28 ms; Peak memory: 2.477 MB. Show Profiling Timeline

总计23条数据

Time	Duration	Category	Info

11:24:51.787	3.9 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_tasks" ("description", "head_of", "is_important", "target_completed_at", "task_group_id", "title", "weight", "created_by") VALUES ('', 1000, 0, NULL, 196, '精彩精彩集锦', 10, 1000) RETURNING "id"
11:24:51.778	2.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
11:24:51.776	1.8 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
11:24:51.791	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 ('INSERT', 'app\models\Tasks', 1560, 'a:15:{s:2:"id";i:1560;s:13:"task_group_id";s:3:"196";s:5:"title";s:18:"精彩精彩集锦";s:11:"description";s:0:"";s:9:"client_id";N;s:7:"head_of";s:4:"1000";s:6:"status";N;s:19:"target_completed_at";s:0:"";s:12:"completed_at";N;s:10:"created_by";i:1000;s:10:"created_at";N;s:10:"updated_at";N;s:12:"is_important";s:1:"0";s:20:"complete_description";N;s:6:"weight";s:2:"10";}', '', 1000, '223.104.41.148')
11:24:51.782	1.0 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
11:24:51.801	1.0 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, 2, 1141, 'v2/task/save-new', '{"Tasks":{"description":"","head_of":"1000","is_important":"0","target_completed_at":"","task_group_id":"196","title":"\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526","weight":"10"},"access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"2","posttime":"1751599488","token":"89cc52052f53ce3f62049df49b57b703","version_code":"1141"}', '{"code":200,"data":{"id":1560},"status":1,"msg":[{"name":"success","success":"\u65b0\u9879\u76ee\u6e05\u5355\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-07-04 11:24:51') RETURNING "id"
11:24:51.796	1.0 ms	yii\db\Command::query	INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 1560, 101, 1000, '2025-07-04 11:24:51', '{"id":1560,"task_group_id":196,"title":"\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526","description":"","client_id":null,"head_of":1000,"status":0,"target_completed_at":null,"completed_at":null,"created_by":1000,"created_at":"2025-07-04 11:24:51","updated_at":"2025-07-04 11:24:51","is_important":0,"complete_description":null,"weight":10}', '{"id":1560,"task_group_id":196,"title":"\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526","description":"","client_id":null,"head_of":1000,"status":0,"target_completed_at":null,"completed_at":null,"created_by":1000,"created_at":"2025-07-04 11:24:51","updated_at":"2025-07-04 11:24:51","is_important":0,"complete_description":null,"weight":10}', '{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u6e05\u5355","d4":[]}') RETURNING "id"
11:24:51.793	0.8 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_task_groups" SET "weight"=NULL WHERE "id"=196
11:24:51.797	0.8 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', 510009, 'a:13:{s:2:"id";i:510009;s:9:"object_id";i:1560;s:11:"object_type";i:101;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:330:"{"id":1560,"task_group_id":196,"title":"\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526","description":"","client_id":null,"head_of":1000,"status":0,"target_completed_at":null,"completed_at":null,"created_by":1000,"created_at":"2025-07-04 11:24:51","updated_at":"2025-07-04 11:24:51","is_important":0,"complete_description":null,"weight":10}";s:9:"new_value";s:330:"{"id":1560,"task_group_id":196,"title":"\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526","description":"","client_id":null,"head_of":1000,"status":0,"target_completed_at":null,"completed_at":null,"created_by":1000,"created_at":"2025-07-04 11:24:51","updated_at":"2025-07-04 11:24:51","is_important":0,"complete_description":null,"weight":10}";s:11:"description";s:81:"{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u6e05\u5355","d4":[]}";s:10:"created_by";i:1000;s:10:"created_at";s:19:"2025-07-04 11:24:51";s:9:"is_delete";N;}', '', 1000, '223.104.41.148')
11:24:51.799	0.7 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', 510010, 'a:13:{s:2:"id";i:510010;s:9:"object_id";i:196;s:11:"object_type";i:102;s:9:"target_id";i:1560;s:18:"target_object_type";i:101;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:6:"[1560]";s:9:"new_value";s:6:"[1560]";s:11:"description";s:119:"{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u6e05\u5355","d4":["\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526"]}";s:10:"created_by";i:1000;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1000, '223.104.41.148')
11:24:51.798	0.7 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 (1, 'create', 196, 102, 1560, 101, 1000, '[1560]', '[1560]', '{"d1":"\u66f9\u6c38\u751f","d2":"\u521b\u5efa\u4e86","d3":"\u6e05\u5355","d4":["\u7cbe\u5f69\u7cbe\u5f69\u96c6\u9526"]}') RETURNING "id"
11:24:51.794	0.7 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', 196, 'a:0:{}', '', 1000, '223.104.41.148')
11:24:51.784	0.5 ms	yii\db\Command::query	SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE "task_group_id"='196'
11:24:51.786	0.4 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='196'
11:24:51.784	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='196')
11:24:51.793	0.3 ms	yii\db\Command::query	SELECT SUM(weight) FROM "a57be577deb434"."tbl_tasks" WHERE ("task_group_id"=196) AND ("status"=1)
11:24:51.795	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
11:24:51.798	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
11:24:51.786	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_task_group_user_relationships" WHERE ("user_id"=1000) AND ("task_group_id"=196)
11:24:51.785	0.3 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000')
11:24:51.795	0.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_tasks" WHERE "id"=1560
11:24:51.785	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000)
11:24:51.792	0.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_task_groups" WHERE "id"='196'