Performance Profiling

Total processing time: 16 ms; Peak memory: 2.246 MB. Show Profiling Timeline

总计8条数据

Time	Duration	Category	Info

09:26:38.863	2.2 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=1001
09:26:38.861	1.9 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
09:26:38.866	1.6 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
09:26:38.872	1.4 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/search/purchase-contract-by-supplier-id', '{"supplier_id":"511","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":[{"id":3621,"key":3621,"name":"KJS1X24211(2024-10-23)","created_at":"2024-10-23 15:32:20","purchaseClientRels":[{"id":2806,"contract_id":3621,"client_id":3301,"project_id":3679,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001},"project":{"id":3679,"key":3679,"name":"\u5b89\u5168\u68c0\u6d4b\u4e0e\u54cd\u5e94\u5e73\u53f0\u670d\u52a1\u9879\u76ee\uff08\u8fc7\u5355\uff09"}}]},{"id":3617,"key":3617,"name":"TSKJ20241022-HYF-001(2024-10-22)","created_at":"2024-10-22 12:53:19","purchaseClientRels":[{"id":2500,"contract_id":3617,"client_id":3301,"project_id":3653,"client":{"id":3301,"key":3301,"name":"\u91d1\u878d\u65f6\u62a5\u793e","sales_rep":1001},"project":{"id":3653,"key":3653,"name":"\u6df1\u4fe1\u670dAD-1000-B1800-TP 2\u53f0\u91c7\u8d2d\u9879\u76ee\uff08\u8fc7\u5355\uff09"}}]},{"id":3359,"key":3359,"name":"TSKJ20240620-HYF-002(2024-06-20)","created_at":"2024-06-20 17:36:22","purchaseClientRels":[{"id":2025,"contract_id":3359,"client_id":3009,"project_id":3544,"client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3544,"key":3544,"name":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u9879\u76ee"}},{"id":2228,"contract_id":3359,"client_id":3009,"project_id":3568,"client":{"id":3009,"key":3009,"name":"\u540c\u65b9\u77e5\u7f51\uff08\u5317\u4eac\uff09\u6280\u672f\u6709\u9650\u516c\u53f8\/\u540c\u65b9\u77e5\u7f51\u6570\u5b57\u51fa\u7248\u6280\u672f\u80a1\u4efd\u6709\u9650\u516c\u53f8\/\u300a\u4e2d\u56fd\u5b66\u672f\u671f\u520a\uff08\u5149\u76d8\u7248\uff09\u300b\u7535\u5b50\u6742\u5fd7\u793e\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3568,"key":3568,"name":"\u6df1\u4fe1\u670d\u5206\u5e03\u5f0f\u5b58\u50a8\u91c7\u8d2d\u9879\u76ee"}}]},{"id":2813,"key":2813,"name":"YC-TSKJ-20230822(2023-08-24)","created_at":"2023-08-24 17:25:44","purchaseClientRels":[{"id":1487,"contract_id":2813,"client_id":2582,"project_id":3281,"client":{"id":2582,"key":2582,"name":"\u4e2d\u56fd\u80fd\u6e90\u4f20\u5a92\u96c6\u56e2\u6709\u9650\u516c\u53f8","sales_rep":1001},"project":{"id":3281,"key":3281,"name":"\u7f51\u7edc\u5b89\u5168\u8bbe\u5907\u53ca\u6c47\u805a\u4ea4\u6362\u673a\u91c7\u8d2d\u9879\u76ee"}}]},{"id":2657,"key":2657,"name":"KJS1XS2355(2023-05-18)","created_at":"2023-05-18 11:40:04","purchaseClientRels":[{"id":1344,"contract_id":2657,"client_id":2536,"project_id":3195,"client":{"id":2536,"key":2536,"name":"\u9996\u90fd\u533b\u79d1\u5927\u5b66\u9644\u5c5e\u5317\u4eac\u5b89\u8d1e\u533b\u9662","sales_rep":1001},"project":{"id":3195,"key":3195,"name":"Symantec \u9632\u75c5\u6bd2\u8f6f\u4ef6\u4ea7\u54c1\u7eed\u8ba2\u4e00\u5e74"}}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-12 09:26:38') RETURNING "id"
09:26:38.869	0.9 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "serial_no" AS "name", "created_at" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "supplier_id"='511' ORDER BY "signed_at" DESC
09:26:38.870	0.7 ms	yii\db\Command::query	SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id" IN (3621, 3617, 3359, 2813, 2657) ORDER BY "id"
09:26:38.871	0.6 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "sales_rep" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (2536, 2582, 3009, 3301)
09:26:38.871	0.5 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id" IN (3195, 3281, 3544, 3568, 3653, 3679)