ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68955e772662e: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2025-08-08 10:18:31 am by 223.104.39.199

Database Queries

总计16条数据
TimeDurationTypeQuery
  
10:18:32.2083.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA'

[+] Explain
10:18:32.2132.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295

[+] Explain
10:18:32.2191.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='90') AND ("deleted"=FALSE)

[+] Explain
10:18:32.2213.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"='90' 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
10:18:32.2252.8 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"='90' 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
10:18:32.2280.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1)

[+] Explain
10:18:32.2291.0 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5295, 1021, 1023, 1006)

[+] Explain
10:18:32.2300.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (5144, 5149, 3662, 293, 991, 443, 3661) ORDER BY "key_role"

[+] Explain
10:18:32.2310.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (5144, 5149, 3662, 293, 991, 443, 3661)

[+] Explain
10:18:32.23226.8 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (5144, 5149, 3662, 293, 991, 443, 3661)) GROUP BY "object_id"

[+] Explain
10:18:32.2601.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5144, 5149, 3662, 293, 991, 443, 3661)

[+] Explain
10:18:32.2622.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 107, 102, 197, 199, 198, 202, 229, 142, 133, 134, 135, 136, 137, 139, 185, 191, 164, 167, 2, 6, 8, 2100000000, 7, 9, 153, 160, 140, 204, 165, 179, 1, 226, 313, 184, 189, 344, 114, 319, 215, 232, 324, 349, 369, 377)) ORDER BY "sort"

[+] Explain
10:18:32.2640.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5144, 5149, 3662, 293, 991, 443, 3661)

[+] Explain
10:18:32.2660.5 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (46, 107, 102, 197, 199, 198, 202, 229, 142, 133, 134, 135, 136, 137, 139, 185, 191, 164, 167, 2, 6, 8, 2100000000, 7, 9, 153, 160, 140, 204, 165, 179, 1, 226, 313, 184, 189, 344, 114, 319, 215, 232, 324, 349, 369, 377)) ORDER BY "sort"

[+] Explain
10:18:32.26618.2 msSELECTSELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id" IN (5144, 5149, 3662, 293, 991, 443, 3661)) GROUP BY "object_id"

[+] Explain
10:18:32.2905.3 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, 1146, 'v2/contact/of-client', '{"access_token":"qLUfmF7prXLXaLejyBy9ATRtm1ACl6bA","device_type":"2","id":"90","page":"1","posttime":"1754619520","token":"d183ecdc572571f36262181d793cf986","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":5144,"name":"\u8d75\u91d1\u7a0b","email":"","pinyin_shortcut":"zjc","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2024-01-03 11:01:28","updated_at":"2024-02-20 15:28:09","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":1,"pinyin1":"zhao","pinyin2":"jin","pinyin3":"cheng","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u91d1","namecut3":"\u7a0b","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":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"},"keyRoles":[],"mobiles":[{"id":5931,"contact_id":5144,"mobile":"13602159075","mp_open_id":"oagch6UFe3mx9ON7HIBpToY84YWE","mobile_display":"13602159075"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u8d75\u91d1\u7a0b","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":5149,"name":"\u5b8b\u5609\u660e","email":"","pinyin_shortcut":"sjm","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2024-01-08 09:44:04","updated_at":"2024-01-08 09:44:04","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"song","pinyin2":"jia","pinyin3":"ming","pinyin4":null,"namecut1":"\u5b8b","namecut2":"\u5609","namecut3":"\u660e","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":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"},"keyRoles":[],"mobiles":[{"id":5936,"contact_id":5149,"mobile":"15021452550","mp_open_id":null,"mobile_display":"15021452550"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u5b8b\u5609\u660e","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":3662,"name":"\u9b4f\u6cfd\u6587","email":"","pinyin_shortcut":"wzw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2021-07-08 15:43:57","updated_at":"2021-07-08 15:43:57","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":null,"namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","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":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"},"keyRoles":[],"mobiles":[{"id":4329,"contact_id":3662,"mobile":"18601965887","mp_open_id":"oagch6WylEpz3T5IwaJCijWrYh94","mobile_display":"18601965887"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u9b4f\u6cfd\u6587","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":293,"name":"\u5468\u5b87\u98de","email":"shane.zhou@zurich.com","pinyin_shortcut":"zyf","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"01084547861","client_id":90,"supplier_id":null,"created_by":1021,"created_at":"2017-03-07 17:46:28","updated_at":"2021-04-25 19:35:17","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"zhou","pinyin2":"yu","pinyin3":"fei","pinyin4":null,"namecut1":"\u5468","namecut2":"\u5b87","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":1021,"key":1021,"name":"\u6c6a\u6653\u50b2","sex":"M"},"keyRoles":[],"mobiles":[{"id":4198,"contact_id":293,"mobile":"13671022772","mp_open_id":"oagch6Thfxj2WTnYv5CWgnW4ptuU","mobile_display":"13671022772"}],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u5468\u5b87\u98de","email_display":"shane.zhou@zurich.com","telephone_display":"01084547861","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":991,"name":"\u675c\u4fca","email":"","pinyin_shortcut":"dj","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":1023,"created_at":"2017-07-22 10:46:59","updated_at":"2021-04-19 16:51:15","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"du","pinyin2":"jun","pinyin3":null,"pinyin4":null,"namecut1":"\u675c","namecut2":"\u4fca","namecut3":null,"namecut4":null,"is_mp_bind":null,"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":4166,"contact_id":991,"mobile":"13918058385","mp_open_id":null,"mobile_display":"13918058385"}],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u675c\u4fca","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":443,"name":"\u5b59\u51ef","email":"kai.sun@zurich.com","pinyin_shortcut":"sk","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u4fe1\u606f\u4e2d\u5fc3\u4e3b\u4efb","mobile":null,"telephone":"84547860","client_id":90,"supplier_id":null,"created_by":1006,"created_at":"2017-03-28 13:39:44","updated_at":"2019-01-11 10:38:19","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":1,"pinyin1":"sun","pinyin2":"kai","pinyin3":null,"pinyin4":null,"namecut1":"\u5b59","namecut2":"\u51ef","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":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F"},"keyRoles":[{"id":18,"key_role":1,"contact_id":443,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":186,"key_role":2,"contact_id":443,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"},{"id":19,"key_role":3,"contact_id":443,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":20,"key_role":4,"contact_id":443,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"id":155,"key_role":5,"contact_id":443,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"mobiles":[{"id":2489,"contact_id":443,"mobile":"13501278068","mp_open_id":"oagch6b--laeW4GGf0v1j0DBFhUc","mobile_display":"13501278068"}],"commentCount":null,"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"},{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"},{"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":false,"name_display":"\u5b59\u51ef","email_display":"kai.sun@zurich.com","telephone_display":"010-84547860","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3661,"name":"\u9b4f\u6cfd\u6587","email":"","pinyin_shortcut":"wzw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2021-07-08 15:43:56","updated_at":"2021-07-08 15:43:56","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":null,"namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":1,"status":"\u79bb\u804c","description":"","created_by":1000,"created_at":"2016-10-31 21:28:29","updated_at":"2016-10-31 21:28:29"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F"},"keyRoles":[],"mobiles":[{"id":4328,"contact_id":3661,"mobile":"18601965887","mp_open_id":null,"mobile_display":"18601965887"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u9b4f\u6cfd\u6587","telephone_display":"","unread":0,"bind_status":2,"bind_status_display":"\u5df2\u89e3\u7ed1"}],"pagenation":{"totalcount":7,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:18:32') RETURNING "id"

[+] Explain