ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685b67d8be864: POST https://beta.jinchangxiao.com/v2/client/get-filter at 2025-06-25 11:07:04 am by 211.137.80.11

Database Queries

总计8条数据
TimeDurationTypeQuery
  
11:07:04.8273.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'

[+] Explain
11:07:04.8321.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
11:07:04.8381.3 msSELECTSELECT "id" FROM "a57be577deb434"."tbl_users" WHERE ("id" IN (5295, 5311)) 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
11:07:04.8401.1 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_classes" WHERE "is_delete"=FALSE ORDER BY "order", "id"

[+] Explain
11:07:04.8410.6 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "is_delete"=FALSE ORDER BY "order"

[+] Explain
11:07:04.8420.6 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "is_delete"=FALSE ORDER BY "order"

[+] Explain
11:07:04.8430.6 msSELECTSELECT "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "is_delete"=FALSE ORDER BY "order"

[+] Explain
11:07:04.8441.8 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5295, 2, 1141, 'v2/client/get-filter', '{"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","posttime":"1750820864","token":"e2e1879997fdcad0deafe28548c19310","version_code":"1141"}', '{"code":200,"data":[{"key":"ClientSearch[sales_rep]","name":"\u5ba2\u6237\u7ecf\u7406","value":[{"key":5311,"name":"\u62d3\u5c0f\u6587"},{"key":5295,"name":"\u9b4f\u6cfd\u6587"},{"key":0,"name":"\u516c\u6d77\u5ba2\u6237"}]},{"key":"ClientSearch[cooperated]","name":"\u5408\u4f5c\u72b6\u6001","value":[{"key":"1","name":"\u5df2\u5408\u4f5c"},{"key":"0","name":"\u672a\u5408\u4f5c"}]},{"key":"ClientSearch[client_class]","name":"\u5ba2\u6237\u7ea7\u522b","value":[{"key":1,"name":"\u6838\u5fc3\u5ba2\u6237"},{"key":80,"name":"\u7a33\u5b9a\u5ba2\u6237"},{"key":47,"name":"\u76ee\u6807\u5ba2\u6237"},{"key":43,"name":"\u6f5c\u529b\u5ba2\u6237"}]},{"key":"ClientSearch[client_type]","name":"\u5ba2\u6237\u6027\u8d28","value":[{"key":1,"name":"\u653f\u5e9c"},{"key":6,"name":"\u592e\u4f01"},{"key":5,"name":"\u5546\u4e1a"},{"key":3,"name":"\u5916\u4f01"}]},{"key":"ClientSearch[company_nature]","name":"\u516c\u53f8\u6027\u8d28","value":[{"key":1,"name":"\u56fd\u6709\u4e0a\u5e02"},{"key":2,"name":"\u6c11\u8425\u4e0a\u5e02"},{"key":3,"name":"\u56fd\u6709\u4f01\u4e1a"},{"key":4,"name":"\u6c11\u8425\u4f01\u4e1a"},{"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"}]},{"key":"ClientSearch[client_industry]","name":"\u5ba2\u6237\u884c\u4e1a","value":[{"key":57,"name":"EDA\/CAE"},{"key":1,"name":"\u653f\u5e9c"},{"key":25,"name":"\u6559\u80b2\uff08\u673a\u6784\uff09"},{"key":2,"name":"\u6559\u80b2\uff08\u9ad8\u6821\uff09"},{"key":24,"name":"\u6559\u80b2\uff08\u666e\u6559\uff09"},{"key":3,"name":"\u533b\u7597"},{"key":4,"name":"\u901a\u4fe1"},{"key":5,"name":"\u5236\u9020"},{"key":58,"name":"\u519b\u5de5"},{"key":6,"name":"\u7535\u5546"},{"key":7,"name":"\u9152\u5e97"},{"key":8,"name":"\u7269\u6d41"},{"key":9,"name":"\u5730\u4ea7"},{"key":10,"name":"\u91d1\u878d"},{"key":11,"name":"\u4ea4\u901a"},{"key":12,"name":"\u5e7f\u544a"},{"key":13,"name":"SI\/ISV"},{"key":14,"name":"\u5e7f\u7535"},{"key":15,"name":"\u7535\u529b"},{"key":16,"name":"\u80fd\u6e90"},{"key":17,"name":"\u96f6\u552e"},{"key":18,"name":"\u5a92\u4f53"},{"key":19,"name":"OTT"},{"key":20,"name":"\u5176\u4ed6"}]},{"key":"ClientSearch[contact_status]","name":"\u903e\u671f\u72b6\u6001","value":[{"key":"1","name":"\u5df2\u903e\u671f"},{"key":"0","name":"\u672a\u903e\u671f"}]},{"key":"Filter[name]","name":"\u65f6\u95f4\u6392\u5e8f","value":[{"key":"updated_at","name":"\u66f4\u65b0\u65f6\u95f4"},{"key":"created_at","name":"\u521b\u5efa\u65f6\u95f4"},{"key":"last_contact","name":"\u6700\u8fd1\u8054\u7cfb"}]},{"key":"Filter[sort]","name":"\u6392\u5e8f\u65b9\u5f0f","value":[{"key":"ASC","name":"\u6b63\u5e8f"},{"key":"DESC","name":"\u5012\u5e8f"}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 11:07:04') RETURNING "id"

[+] Explain