ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a24e1179c22c: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2026-06-07 11:10:15 am by 111.9.5.86

Database Queries

总计16条数据
TimeDurationTypeQuery
  
11:10:15.7403.0 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC'

[+] Explain
11:10:15.7501.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
11:10:15.7551.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='93') AND ("deleted"=FALSE)

[+] Explain
11:10:15.7583.6 msSELECTSELECT COUNT(*) FROM (SELECT c.*, CASE WHEN count(cm.id) != 0 THEN 1 ELSE null END as mp_open_id FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_contact_mobiles" "cm" ON c.id = cm.contact_id AND cm.mp_open_id IS NOT NULL WHERE "client"."id"='93' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC) "c"

[+] Explain
11:10:15.7612.9 msSELECTSELECT c.*, CASE WHEN count(cm.id) != 0 THEN 1 ELSE null END as mp_open_id FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = c.client_id LEFT JOIN "a57be577deb434"."tbl_contact_mobiles" "cm" ON c.id = cm.contact_id AND cm.mp_open_id IS NOT NULL WHERE "client"."id"='93' GROUP BY "c"."id" ORDER BY (case c.user_status when 3 then 1 when 1 then 0 else c.user_status end) DESC, c.updated_at DESC LIMIT 10

[+] Explain
11:10:15.7650.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2

[+] Explain
11:10:15.7660.3 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5360, 1005, 1023, 1022, 5296)

[+] Explain
11:10:15.7670.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (6136, 5983, 5201, 5876, 4701, 5847, 5842, 5793, 5233, 5182) ORDER BY "key_role"

[+] Explain
11:10:15.7681.1 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6136, 5983, 5201, 5876, 4701, 5847, 5842, 5793, 5233, 5182)

[+] Explain
11:10:15.76936.4 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (6136, 5983, 5201, 5876, 4701, 5847, 5842, 5793, 5233, 5182)) GROUP BY "object_id"

[+] Explain
11:10:15.8072.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6136, 5983, 5201, 5876, 4701, 5847, 5842, 5793, 5233, 5182)

[+] Explain
11:10:15.8101.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (184, 189, 135, 140, 160, 137, 139, 136, 327, 2, 1, 226, 215, 5, 183, 190, 307, 203, 197, 199, 185, 229, 349, 356, 377, 348, 332, 369, 367)) ORDER BY "sort"

[+] Explain
11:10:15.8120.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6136, 5983, 5201, 5876, 4701, 5847, 5842, 5793, 5233, 5182)

[+] Explain
11:10:15.8131.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (184, 189, 135, 140, 160, 137, 139, 136, 327, 2, 1, 226, 215, 5, 183, 190, 307, 203, 197, 199, 185, 229, 349, 356, 377, 348, 332, 369, 367)) ORDER BY "sort"

[+] Explain
11:10:15.81520.7 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (6136, 5983, 5201, 5876, 4701, 5847, 5842, 5793, 5233, 5182)) GROUP BY "object_id"

[+] Explain
11:10:15.8402.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 2, 1159, 'v2/contact/of-client', '{"access_token":"R8ScrIY1ab3sgHgv8KlMKFukwMtD6QYC","device_type":"2","id":"93","page":"1","posttime":"1780801792","token":"727a5d32f211a1acba6b637f96b0819a","version_code":"1159"}', '{"code":200,"data":{"list":[{"id":6136,"name":"\u51af\u6d77\u4fa0","email":"","pinyin_shortcut":"fhx","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":5360,"created_at":"2025-09-02 09:18:53","updated_at":"2025-09-02 09:18:53","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"feng","pinyin2":"hai","pinyin3":"xia","pinyin4":null,"namecut1":"\u51af","namecut2":"\u6d77","namecut3":"\u4fa0","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F"},"keyRoles":[],"mobiles":[{"id":6917,"contact_id":6136,"mobile":"17320765603","mp_open_id":null,"mobile_display":"17320765603"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u51af\u6d77\u4fa0","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5983,"name":"\u8d75\u79b9\u6850","email":"yutong.zhao@pharmaron.com","pinyin_shortcut":"zyt","sex":"M","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":1005,"created_at":"2025-01-15 11:17:59","updated_at":"2025-03-05 13:35:07","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhao","pinyin2":"yu","pinyin3":"tong","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u79b9","namecut3":"\u6850","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F"},"keyRoles":[],"mobiles":[{"id":6770,"contact_id":5983,"mobile":"19525486256","mp_open_id":null,"mobile_display":"19525486256"}],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u8d75\u79b9\u6850","email_display":"yutong.zhao@pharmaron.com","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5201,"name":"\u5f90\u8f89","email":"","pinyin_shortcut":"xh","sex":"M","birth_date":null,"department":"","job_position":"\u6280\u672f","mobile":"","telephone":"57330000","client_id":93,"supplier_id":null,"created_by":1005,"created_at":"2024-01-31 17:15:10","updated_at":"2024-12-11 13:41:07","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"xu","pinyin2":"hui","pinyin3":null,"pinyin4":null,"namecut1":"\u5f90","namecut2":"\u8f89","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F"},"keyRoles":[],"mobiles":[{"id":5989,"contact_id":5201,"mobile":"18910065517","mp_open_id":null,"mobile_display":"18910065517"}],"commentCount":null,"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f90\u8f89","telephone_display":"010-57330000","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5876,"name":"\u51af\u5b66\u9e4f","email":"xuepeng.feng@pharmaron.com","pinyin_shortcut":"fxp","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":1005,"created_at":"2024-09-13 13:27:00","updated_at":"2024-09-13 13:27:00","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"feng","pinyin2":"xue","pinyin3":"peng","pinyin4":null,"namecut1":"\u51af","namecut2":"\u5b66","namecut3":"\u9e4f","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F"},"keyRoles":[],"mobiles":[{"id":6667,"contact_id":5876,"mobile":"18611394482","mp_open_id":null,"mobile_display":"18611394482"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u51af\u5b66\u9e4f","email_display":"xuepeng.feng@pharmaron.com","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4701,"name":"\u5218\u6653\u51cc","email":"xiaoling.liu@pharmaron.com","pinyin_shortcut":"lxl","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"57330000","client_id":93,"supplier_id":null,"created_by":1005,"created_at":"2023-07-16 17:56:44","updated_at":"2024-09-03 14:02:32","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liu","pinyin2":"xiao","pinyin3":"ling","pinyin4":null,"namecut1":"\u5218","namecut2":"\u6653","namecut3":"\u51cc","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F"},"keyRoles":[],"mobiles":[{"id":5509,"contact_id":4701,"mobile":"18601034651","mp_open_id":"oagch6Z9oHFEx7_v9jzvSrokypoU","mobile_display":"18601034651"}],"commentCount":null,"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5218\u6653\u51cc","email_display":"xiaoling.liu@pharmaron.com","telephone_display":"57330000","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":5847,"name":"\u5f20\u7389\u6885","email":"Yumei.zhang@pharmaron.com","pinyin_shortcut":"zym","sex":"F","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":1005,"created_at":"2024-08-12 11:41:11","updated_at":"2024-08-12 11:41:11","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"yu","pinyin3":"mei","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u7389","namecut3":"\u6885","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F"},"keyRoles":[],"mobiles":[{"id":6640,"contact_id":5847,"mobile":"13520635417","mp_open_id":null,"mobile_display":"13520635417"}],"commentCount":null,"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f20\u7389\u6885","email_display":"Yumei.zhang@pharmaron.com","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5842,"name":"\u4f55\u5ca9","email":"","pinyin_shortcut":"hy","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":1023,"created_at":"2024-08-07 16:06:40","updated_at":"2024-08-07 16:06:40","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"he","pinyin2":"yan","pinyin3":null,"pinyin4":null,"namecut1":"\u4f55","namecut2":"\u5ca9","namecut3":null,"namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M"},"keyRoles":[],"mobiles":[{"id":6635,"contact_id":5842,"mobile":"18910065569","mp_open_id":null,"mobile_display":"18910065569"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u4f55\u5ca9","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5793,"name":"\u6881\u6b63","email":"","pinyin_shortcut":"lz","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":1022,"created_at":"2024-06-05 18:30:48","updated_at":"2024-06-05 18:30:48","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liang","pinyin2":"zheng","pinyin3":null,"pinyin4":null,"namecut1":"\u6881","namecut2":"\u6b63","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1022,"key":1022,"name":"\u5f90\u7855","sex":"M"},"keyRoles":[],"mobiles":[{"id":6586,"contact_id":5793,"mobile":"18610298995","mp_open_id":"oagch6aBrbhNPvMfokuVmtgGIOLw","mobile_display":"18610298995"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u6881\u6b63","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":5233,"name":"\u5f20\u5b50\u5cb3","email":"","pinyin_shortcut":"zzy","sex":"M","birth_date":null,"department":"","job_position":"\u6280\u672f\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":5296,"created_at":"2024-03-12 21:06:05","updated_at":"2024-03-12 21:07:25","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"zhang","pinyin2":"zi","pinyin3":"yue","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u5b50","namecut3":"\u5cb3","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":5296,"key":5296,"name":"\u8d75\u5b87","sex":"M"},"keyRoles":[],"mobiles":[{"id":6022,"contact_id":5233,"mobile":"15801415393","mp_open_id":"oagch6UX6EgAPHG2NBsLgSwNF2PA","mobile_display":"15801415393"}],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f20\u5b50\u5cb3","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":5182,"name":"\u5b59\u96ea\u5a67","email":"","pinyin_shortcut":"sxj","sex":"M","birth_date":null,"department":"","job_position":"\u8d44\u4ea7\u8c03\u914d","mobile":"","telephone":"","client_id":93,"supplier_id":null,"created_by":1005,"created_at":"2024-01-23 11:51:18","updated_at":"2024-01-23 11:51:18","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"sun","pinyin2":"xue","pinyin3":"jing","pinyin4":null,"namecut1":"\u5b59","namecut2":"\u96ea","namecut3":"\u5a67","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"status":"\u5728\u804c","description":"\u5728\u804c","created_by":1000,"created_at":"2016-10-31 21:28:36","updated_at":"2016-10-31 21:28:40"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u660e\uff08\u9500\u552e\u4eba\u5458\uff09","sex":"F"},"keyRoles":[],"mobiles":[{"id":5970,"contact_id":5182,"mobile":"13436788133","mp_open_id":null,"mobile_display":"13436788133"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5b59\u96ea\u5a67","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"}],"pagenation":{"totalcount":12,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"111.9.5.86","ua":"jinchangxiao\/2.3.156 (iPhone 12 mini; iOS 26.2; Scale\/3.00)"}', FALSE, '2026-06-07 11:10:15', 199180032) RETURNING "id"

[+] Explain