Performance Profiling

Total processing time: 65 ms; Peak memory: 3.839 MB. Show Profiling Timeline

总计30条数据

Time	Duration	Category	Info

14:29:57.300	4.9 ms	yii\db\Command::execute	UPDATE "o6a13e2c574d5a"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=1) AND ("object_type"=107)) OR (("target_id"=1) AND ("target_object_type"=107))
14:29:57.320	4.1 ms	yii\db\Command::execute	DELETE FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "id"=1
14:29:57.283	2.0 ms	yii\db\Command::query	INSERT INTO "o6a13e2c574d5a"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (2, 'update', 1, 10, 8, 7, 5495, '[8]', '[8]', '{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-05-27-001"]}') RETURNING "id"
14:29:57.293	1.9 ms	yii\db\Command::query	INSERT INTO "o6a13e2c574d5a"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (3, 'delete', 1, 1, 1, 107, 5495, '1', '1', array[5493], '{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u5220\u9664\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}') RETURNING "id"
14:29:57.297	1.6 ms	yii\db\Command::query	INSERT INTO "o6a13e2c574d5a"."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', 8, 7, 1, 107, 5495, '[1]', '[1]', '{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u5220\u9664\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}') RETURNING "id"
14:29:57.314	1.5 ms	yii\db\Command::query	INSERT INTO "o6a13e2c574d5a"."tbl_comments" ("created_by", "object_type", "object_id", "is_system", "description", "description2") VALUES (5495, '7', 8, TRUE, '逻辑测试删除了：2026-05-27-001发票信息2026-06-11￥1111', '商机：销售线索生成20260527001；客户：逻辑测试-销售合同') RETURNING "id"
14:29:57.295	1.5 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 23, 'a:15:{s:2:"id";i:23;s:9:"object_id";i:1;s:11:"object_type";i:1;s:9:"target_id";i:1;s:18:"target_object_type";i:107;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:1:"1";s:9:"new_value";s:1:"1";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[5493]";s:6:"params";a:0:{}}s:11:"description";s:101:"{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u5220\u9664\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}";s:10:"created_by";i:5495;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 5495, '39.156.194.178')
14:29:57.299	1.5 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 188, 'a:13:{s:2:"id";i:188;s:9:"object_id";i:8;s:11:"object_type";i:7;s:9:"target_id";i:1;s:18:"target_object_type";i:107;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:3:"[1]";s:9:"new_value";s:3:"[1]";s:11:"description";s:101:"{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u5220\u9664\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}";s:10:"created_by";i:5495;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5495, '39.156.194.178')
14:29:57.286	1.4 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 186, 'a:13:{s:2:"id";i:186;s:9:"object_id";i:1;s:11:"object_type";i:10;s:9:"target_id";i:8;s:18:"target_object_type";i:7;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:3:"[8]";s:9:"new_value";s:3:"[8]";s:11:"description";s:140:"{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u66f4\u65b0\u4e86","d3":"\u9500\u552e\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:2026-05-27-001"]}";s:10:"created_by";i:5495;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5495, '39.156.194.178')
14:29:57.316	1.4 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 56, 'a:11:{s:2:"id";i:56;s:9:"object_id";i:8;s:11:"object_type";s:1:"7";s:6:"parent";N;s:11:"description";s:67:"逻辑测试删除了：2026-05-27-001发票信息2026-06-11￥1111";s:10:"created_by";i:5495;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:75:"商机：销售线索生成20260527001；客户：逻辑测试-销售合同";}', '', 5495, '39.156.194.178')
14:29:57.287	1.4 ms	yii\db\Command::query	INSERT INTO "o6a13e2c574d5a"."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', 1, 1, 1, 107, 5495, '[1]', '[1]', '{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u5220\u9664\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}') RETURNING "id"
14:29:57.330	1.3 ms	yii\db\Command::query	INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'o6a13e2c574d5a', 5495, 5, 'vue/sales-contract/delete-invoice', '{"id":"1","contract_id":"8","web_access_token":"fBwCmd7csXIYKc0xRKne9r8J7AW22Ivz"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u53d1\u7968\u4fe1\u606f\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0,"ip":"39.156.194.178","ua":"Mozilla\/5.0 (Macintosh; Intel Mac OS X 10.15; rv:151.0) Gecko\/20100101 Firefox\/151.0"}', FALSE, '2026-06-11 14:29:57', 58580992) RETURNING "id"
14:29:57.318	1.2 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (8, '7', 56, 5493)
14:29:57.312	1.2 ms	yii\db\Command::query	SELECT EXISTS(SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495)
14:29:57.324	1.2 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\SalesContractInvoices', 1, '', '', 5495, '39.156.194.178')
14:29:57.289	1.1 ms	yii\db\Command::execute	INSERT INTO "o6a13e2c574d5a"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 187, 'a:13:{s:2:"id";i:187;s:9:"object_id";i:1;s:11:"object_type";i:1;s:9:"target_id";i:1;s:18:"target_object_type";i:107;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:3:"[1]";s:9:"new_value";s:3:"[1]";s:11:"description";s:101:"{"d1":"\u903b\u8f91\u6d4b\u8bd5","d2":"\u5220\u9664\u4e86","d3":"\u53d1\u7968\u4fe1\u606f","d4":[""]}";s:10:"created_by";i:5495;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5495, '39.156.194.178')
14:29:57.327	1.0 ms	yii\db\Command::execute	DELETE FROM "o6a13e2c574d5a"."tbl_invoices" WHERE "project_id"=1
14:29:57.274	0.8 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5495
14:29:57.306	0.7 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
14:29:57.310	0.6 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
14:29:57.308	0.6 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id"=8
14:29:57.291	0.6 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_clients" WHERE "id"=1
14:29:57.309	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1
14:29:57.326	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_projects" WHERE "id"=1
14:29:57.277	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
14:29:57.280	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_sales_contracts" WHERE "id"='8'
14:29:57.273	0.5 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:29:57.319	0.5 ms	yii\db\Command::query	SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=5493) AND ("id" != 5495) AND (channel_id IS NOT NULL)
14:29:57.328	0.4 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "contract_id"=8
14:29:57.281	0.4 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_sales_contract_invoices" WHERE "id"='1'