ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a1d18a7577ac: POST https://beta.jinchangxiao.com/vue/purchase-contract/get-new at 2026-06-01 01:29:11 pm by 221.216.117.119

Database Queries

总计12条数据
TimeDurationTypeQuery
  
13:29:11.3614.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5495

[+] Explain
13:29:11.3670.5 msSELECTSELECT * FROM "o6a13e2c574d5a"."tbl_users" WHERE "id"=5495

[+] Explain
13:29:11.3700.4 msSELECTSELECT "handler" FROM "o6a13e2c574d5a"."tbl_purchase_contracts" WHERE ("created_by"=5495) AND ("cost_type"=1) ORDER BY "created_at" DESC, "id" DESC

[+] Explain
13:29:11.3700.8 msSELECTSELECT "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

[+] Explain
13:29:11.3720.3 msSELECTSELECT "id", "id" AS "key", "title" AS "name" FROM "o6a13e2c574d5a"."tbl_erp_stores" WHERE "is_delete"=FALSE ORDER BY "sort", "id"

[+] Explain
13:29:11.3730.4 msSELECTSELECT "id" AS "key", "name", "description" FROM "o6a13e2c574d5a"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("is_delete"=FALSE) ORDER BY "sort", "id"

[+] Explain
13:29:11.3730.8 msSELECTSELECT "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

[+] Explain
13:29:11.3740.6 msSELECTSELECT * 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

[+] Explain
13:29:11.3750.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "o6a13e2c574d5a"."tbl_departments" ORDER BY "order"

[+] Explain
13:29:11.3760.4 msSELECTSELECT "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

[+] Explain
13:29:11.3770.3 msSELECTSELECT "id", "user_id", "meta_value" AS "name" FROM "o6a13e2c574d5a"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (5493, 5495))

[+] Explain
13:29:11.3781.2 msINSERTINSERT 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"

[+] Explain