Performance Profiling

Total processing time: 23 ms; Peak memory: 2.933 MB. Show Profiling Timeline

总计13条数据

Time	Duration	Category	Info

13:29:11.361	4.0 ms	yii\db\Command::query	SELECT * FROM "global"."vw_user_login" WHERE "id"=5495
13:29:11.378	1.2 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/purchase-contract/get-new', '{"web_access_token":"IuY-ym_H6ExVPmdOBBbdelHiinliWD4j"}', '{"code":2000,"result":{"model":{"can_create_supplier":true,"can_view_product":true,"handler":5495},"options":{"PurchaseContracts[erp_store_id]":{"key":"PurchaseContracts[erp_store_id]","name":"\u4ed3\u5e93","value":[{"id":1,"key":1,"name":"\u4e3b\u4ed3\u5e93"}]},"PurchaseContracts[costType]":{"key":"PurchaseContracts[costType]","name":"\u8d39\u7528\u4fe1\u606f","value":[{"key":124,"name":"\u5dee\u65c5\u8d39","description":""},{"key":125,"name":"\u4ea4\u901a\u8d39","description":""},{"key":126,"name":"\u529e\u516c\u8d39","description":""},{"key":127,"name":"\u4e1a\u52a1\u62db\u5f85\u8d39","description":""},{"key":128,"name":"\u901a\u8baf\u8d39\u7528","description":""},{"key":129,"name":"\u4f1a\u8bae\u8d39\u7528","description":""},{"key":130,"name":"\u8f66\u8f86\u4f7f\u7528\u8d39\u7528\u62a5\u9500","description":""},{"key":131,"name":"\u5176\u4ed6\u8d39\u7528","description":""},{"key":132,"name":"\u8d22\u52a1\u79d1\u76ee","description":""}]},"PurchaseContracts[contract_type]":{"key":"PurchaseContracts[contract_type]","name":"\u5408\u540c\u7c7b\u578b","value":[{"id":"1","key":"1","name":"\u4ea7\u54c1\u5408\u540c"},{"id":"3","key":"3","name":"\u670d\u52a1\u5408\u540c"}]},"PurchaseContracts[handler]":{"key":"PurchaseContracts[handler]","name":"\u91c7\u8d2d\u4eba","value":[{"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","pinyin_shortcut":"ljcs"}],"default":""},"PurchaseContracts[payment_collection_remind_ahead]":{"key":"PurchaseContracts[payment_collection_remind_ahead]","name":"\u6536\u6b3e\u63d0\u9192\u65f6\u95f4","value":[{"key":"","name":"\u65e0"},{"key":"1 day","name":"\u63d0\u524d1\u5929"},{"key":"2 days","name":"\u63d0\u524d2\u5929"},{"key":"7 days","name":"\u63d0\u524d7\u5929"},{"key":"15 days","name":"\u63d0\u524d15\u5929"},{"key":"30 days","name":"\u63d0\u524d30\u5929"}]},"PurchaseContracts[salesContractPaymentCollectionRemindReceivers]":{"key":"PurchaseContracts[salesContractPaymentCollectionRemindReceivers]","name":"\u6536\u6b3e\u63d0\u9192\u4eba","value":[{"id":1,"key":1,"name":"\u603b\u7ecf\u7406","child":[{"id":5493,"key":5493,"name":"97289742","department_id":1,"pinyin_shortcut":"97289742","avatar":null}]},{"id":2,"key":2,"name":"\u9500\u552e\u90e8","child":[]},{"id":3,"key":3,"name":"\u6280\u672f\u90e8","child":[]},{"id":4,"key":4,"name":"\u5546\u52a1\u90e8","child":[{"id":5495,"key":5495,"name":"\u903b\u8f91\u6d4b\u8bd5","department_id":4,"pinyin_shortcut":"ljcs","avatar":null}]},{"id":5,"key":5,"name":"\u9879\u76ee\u90e8","child":[]},{"id":6,"key":6,"name":"\u4eba\u529b\u8d44\u6e90\u90e8","child":[]},{"id":7,"key":7,"name":"\u8d22\u52a1\u90e8","child":[]},{"id":8,"key":8,"name":"\u5e93\u623f\u90e8","child":[]}]}}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0,"ip":"221.216.117.119","ua":"Mozilla\/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit\/537.36 (KHTML, like Gecko) Chrome\/147.0.0.0 Safari\/537.36"}', FALSE, '2026-06-01 13:29:11', 18208000) RETURNING "id"
13:29:11.370	0.8 ms	yii\db\Command::query	SELECT "user_id" FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" "urcl" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='CommercialAttache') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-06-01 13:29:11, 2026-06-01 13:29:11]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
13:29:11.373	0.8 ms	yii\db\Command::query	SELECT "user_id" FROM "o6a13e2c574d5a"."tbl_user_role_change_logs" "urcl" LEFT JOIN "o6a13e2c574d5a"."tbl_users" "u" ON urcl.user_id = u.id WHERE ("role_name"='CommercialAttache') AND (((start_from < end_at) or end_at is null)) AND (tsrange(start_from::TIMESTAMP, end_at::TIMESTAMP, '[)') && '[2026-06-01 13:29:11, 2026-06-01 13:29:11]'::tsrange) GROUP BY "user_id", "pinyin1", "namecut1", "pinyin2", "namecut2", "pinyin3", "namecut3", "pinyin4", "namecut4" ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
13:29:11.374	0.6 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE ("id"=5495) AND ("user_status"='1') ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
13:29:11.367	0.5 ms	yii\db\Command::query	SELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495
13:29:11.376	0.4 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name", "department_id", "pinyin_shortcut" FROM "o6a13e2c574d5a"."tbl_users" WHERE ("user_status"='1') AND ("department_id" IN (1, 2, 3, 4, 5, 6, 7, 8)) ORDER BY pinyin1 nulls first, namecut1 nulls first, pinyin2 nulls first, namecut2 nulls first, pinyin3 nulls first, namecut3 nulls first, pinyin4 nulls first, namecut4 nulls first
13:29:11.370	0.4 ms	yii\db\Command::query	SELECT "handler" FROM "o6a13e2c574d5a"."tbl_purchase_contracts" WHERE ("created_by"=5495) AND ("cost_type"=1) ORDER BY "created_at" DESC, "id" DESC
13:29:11.373	0.4 ms	yii\db\Command::query	SELECT "id" AS "key", "name", "description" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("is_delete"=FALSE) ORDER BY "sort", "id"
13:29:11.361	0.3 ms	yii\db\Connection::open	Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
13:29:11.372	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"
13:29:11.375	0.3 ms	yii\db\Command::query	SELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" ORDER BY "order"
13:29:11.377	0.3 ms	yii\db\Command::query	SELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495))