Performance Profiling

Total processing time: 167 ms; Peak memory: 5.022 MB. Show Profiling Timeline

总计24条数据

Time	Duration	Category	Info

10:36:32.863	11.9 ms	yii\db\Command::execute	INSERT INTO "a57be577deb434"."tbl_work_log_verify_rels" ("work_log_id", "user_id", "status") VALUES (37025, 1000, 0)
10:36:32.852	8.9 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=37025
10:36:32.883	8.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\WorkLogs', 37025, 'a:0:{}', '', 5016, '223.104.41.148')
10:36:32.899	8.7 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', 5016, 2, 1141, 'v2/work-log/save-edit', '{"WorkLogs":{"client_id":"","created_by":"1000","description":"","end_at":"","escort":"","form_workLogCarbonCopyRels":"","form_workLogVerifyRels":["1000"],"id":"37025","is_draft":"1","location_in_distance":"999999999","location_out_distance":"999999999","project_id":"","scenario_id":"1","scenario_option_id":"","start_at":"","workLogContacts":""},"access_token":"J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L","device_type":"2","posttime":"1750818944","token":"3027705d827038c24b6778e6fba80b97","version_code":"1141"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5de5\u4f5c\u65e5\u5fd7\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-06-25 10:36:32') RETURNING "id"
10:36:32.824	6.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=37025
10:36:32.771	5.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=37025
10:36:32.833	5.7 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_work_log_carbon_copy_rels" WHERE "work_log_id"=37025
10:36:32.810	5.6 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=37025)
10:36:32.788	5.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000')
10:36:32.841	4.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_work_log_verify_rels" WHERE "work_log_id"=37025 ORDER BY "id"
10:36:32.758	4.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "access_token"='J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L'
10:36:32.798	3.5 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_work_logs" SET "client_id"=NULL, "scenario_id"=1, "scenario_option_id"=NULL, "end_at"=NULL, "created_by"=1000, "updated_at"='now()', "start_at"=NULL, "is_draft"=TRUE, "project_id"=NULL WHERE "id"=37025
10:36:32.803	2.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 ('UPDATE', 'app\models\WorkLogs', 37025, 'a:0:{}', '', 5016, '223.104.41.148')
10:36:32.756	2.4 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:36:32.820	2.3 ms	yii\db\Command::execute	DELETE FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=37025
10:36:32.806	2.3 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=18) AND ("object_id"=37025)
10:36:32.817	2.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_work_log_contacts" WHERE "work_log_id"=37025
10:36:32.794	1.5 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"='1')
10:36:32.764	1.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
10:36:32.767	0.9 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_work_logs" WHERE "id"='37025'
10:36:32.819	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_contacts" WHERE 0=1
10:36:32.796	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
10:36:32.797	0.4 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000')
10:36:32.797	0.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_work_log_scenarios" WHERE "id"='1')