Performance Profiling

Total processing time: 76 ms; Peak memory: 3.216 MB. Show Profiling Timeline

总计17条数据

Time	Duration	Category	Info

16:29:58.551	6.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=13) AND ("visit_date"='2025-07-03')
16:29:58.522	5.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:29:58.545	3.2 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=110) AND ("object_id" IN (2097, 2096))
16:29:58.527	3.1 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5250
16:29:58.534	1.8 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:29:58.540	1.4 ms	yii\db\Command::query	SELECT COUNT() FROM (SELECT FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3848 ORDER BY "collected_date" DESC, "id" DESC) "c"
16:29:58.560	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") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/purchase-contract/list-payment', '{"contract_id":"3848","page":"1","web_access_token":"lF6lDSiCl5CRIFfE8shlx2wSeme229Hs"}', '{"code":2000,"result":{"list":[{"id":2097,"contract_id":3848,"amount":"1","created_by":1001,"created_at":"2025-07-03 14:49:53","collected_date":"2025-07-03","description":"","paid_amount":"0","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"files":[],"purchaseContractPaymentApproveRels":[]},{"id":2096,"contract_id":3848,"amount":"50000000","created_by":1001,"created_at":"2025-07-03 14:44:44","collected_date":"2025-07-03","description":"v","paid_amount":"0","createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","department_id":4,"avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"},"department":{"id":4,"key":4,"name":"\u603b\u7ecf\u7406"}},"files":[{"id":33183,"object_type":110,"object_id":2096,"attachment_id":24797,"attachment":{"id":24797,"key":24797,"name":"585fb836-3574-3b4e-bb7a-9a7f1ce61f24","extension":"png","path":"\/vue\/attachment\/view\/585fb836-3574-3b4e-bb7a-9a7f1ce61f24\/\u622a\u5c4f2025-07-01 17.28.01.png","orig_name":"\u622a\u5c4f2025-07-01 17.28.01.png"}}],"purchaseContractPaymentApproveRels":[{"id":156,"approve_id":1733,"purchase_contract_payment_id":2096,"approve":{"id":1733,"key":1733,"name":"34234 ","created_at":"2025-07-03 14:25:17"}}]}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-07-03 16:29:58') RETURNING "id"
16:29:58.543	1.0 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001)
16:29:58.559	1.0 ms	yii\db\Command::execute	UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=131, "last_visit_at"='now()' WHERE "id"=49770
16:29:58.538	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='3848'
16:29:58.532	0.7 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:29:58.542	0.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payments" WHERE "contract_id"=3848 ORDER BY "collected_date" DESC, "id" DESC LIMIT 20
16:29:58.549	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=24797
16:29:58.550	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "title" AS "name", "created_at" FROM "a57be577deb434"."tbl_approves" WHERE "id"=1733
16:29:58.549	0.5 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_approve_rels" WHERE "purchase_contract_payment_id" IN (2097, 2096)
16:29:58.545	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4
16:29:58.543	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001