ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6891c3063e88d: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2025-08-05 04:38:30 pm by 124.64.23.198

Database Queries

总计16条数据
TimeDurationTypeQuery
  
16:38:30.29111.9 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='JaijjTZWzZjgdx9RhHhwFXGU-e0N-Sfm'

[+] Explain
16:38:30.3088.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
16:38:30.3267.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='12') AND ("deleted"=FALSE)

[+] Explain
16:38:30.3378.0 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"='12' 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
16:38:30.3495.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"='12' 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
16:38:30.3596.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2

[+] Explain
16:38:30.3685.9 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1011, 1015, 1003, 1016)

[+] Explain
16:38:30.3775.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (6096, 6091, 6038, 5761, 5275, 5191, 1022, 1852, 4518, 1931) ORDER BY "key_role"

[+] Explain
16:38:30.3855.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (6096, 6091, 6038, 5761, 5275, 5191, 1022, 1852, 4518, 1931)

[+] Explain
16:38:30.39562.8 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (6096, 6091, 6038, 5761, 5275, 5191, 1022, 1852, 4518, 1931)) GROUP BY "object_id"

[+] Explain
16:38:30.4616.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6096, 6091, 6038, 5761, 5275, 5191, 1022, 1852, 4518, 1931)

[+] Explain
16:38:30.47010.8 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (102, 164, 179, 172, 196, 204, 1, 6, 128, 131, 173, 212, 184, 189, 153, 229, 2, 154, 320, 5, 340, 136, 140, 160, 139, 349, 185, 183, 315, 322, 348, 323)) ORDER BY "sort"

[+] Explain
16:38:30.4847.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (6096, 6091, 6038, 5761, 5275, 5191, 1022, 1852, 4518, 1931)

[+] Explain
16:38:30.4984.7 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (102, 164, 179, 172, 196, 204, 1, 6, 128, 131, 173, 212, 184, 189, 153, 229, 2, 154, 320, 5, 340, 136, 140, 160, 139, 349, 185, 183, 315, 322, 348, 323)) ORDER BY "sort"

[+] Explain
16:38:30.50552.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 (6096, 6091, 6038, 5761, 5275, 5191, 1022, 1852, 4518, 1931)) GROUP BY "object_id"

[+] Explain
16:38:30.58014.6 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 265, 'v2/contact/of-client', '{"access_token":"JaijjTZWzZjgdx9RhHhwFXGU-e0N-Sfm","device_type":"0","version_code":"265","id":"12","page":"1","token":"330e6c0fe04fd37fbf3ea2bd67f913cd","posttime":"1754383110","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":6096,"name":"\u8096\u9701\u6850","email":"xiaojitong@smc.com.cn","pinyin_shortcut":"xjt","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"67885566","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2025-07-02 17:35:48","updated_at":"2025-07-02 17:35:48","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"16925","mp_open_id":null,"pinyin1":"xiao","pinyin2":"ji","pinyin3":"tong","pinyin4":null,"namecut1":"\u8096","namecut2":"\u9701","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"},"keyRoles":[],"mobiles":[],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u8096\u9701\u6850","email_display":"xiaojitong@smc.com.cn","telephone_display":"010-67885566-16925","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":6091,"name":"\u4ed8\u677e\u741b","email":"","pinyin_shortcut":"fsc","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1011,"created_at":"2025-07-01 11:48:36","updated_at":"2025-07-01 11:48:36","user_status":2,"description":"SMC\uff08\u5929\u6d25\uff09\u5236\u9020\u6709\u9650\u516c\u53f8 \u6536\u8d27\u4eba","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"fu","pinyin2":"song","pinyin3":"chen","pinyin4":null,"namecut1":"\u4ed8","namecut2":"\u677e","namecut3":"\u741b","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":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"keyRoles":[],"mobiles":[{"id":6875,"contact_id":6091,"mobile":"17822165115","mp_open_id":null,"mobile_display":"17822165115"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u4ed8\u677e\u741b","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":6038,"name":"\u5f20\u91d1\u946b","email":"","pinyin_shortcut":"zjx","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2025-04-17 10:38:52","updated_at":"2025-04-17 10:38:52","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"jin","pinyin3":"xin","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u91d1","namecut3":"\u946b","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"},"keyRoles":[],"mobiles":[{"id":6820,"contact_id":6038,"mobile":"18222331096","mp_open_id":null,"mobile_display":"18222331096"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f20\u91d1\u946b","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5761,"name":"\u8bb8\u4e16\u5fe0","email":"","pinyin_shortcut":"xsz","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2024-05-14 14:05:59","updated_at":"2024-05-14 14:05:59","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"xu","pinyin2":"shi","pinyin3":"zhong","pinyin4":null,"namecut1":"\u8bb8","namecut2":"\u4e16","namecut3":"\u5fe0","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"},"keyRoles":[],"mobiles":[{"id":6553,"contact_id":5761,"mobile":"18518572891","mp_open_id":null,"mobile_display":"18518572891"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u8bb8\u4e16\u5fe0","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5275,"name":"\u674e\u83b9","email":"","pinyin_shortcut":"ly","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"80480101","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2024-04-16 14:05:54","updated_at":"2024-04-16 14:05:54","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"ying","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u83b9","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"},"keyRoles":[],"mobiles":[{"id":6064,"contact_id":5275,"mobile":"13501032024","mp_open_id":null,"mobile_display":"13501032024"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u674e\u83b9","telephone_display":"010-80480101","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5191,"name":"\u6768\u65ed","email":"","pinyin_shortcut":"yx","sex":"M","birth_date":null,"department":"","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"00000000","client_id":12,"supplier_id":null,"created_by":1015,"created_at":"2024-01-25 00:36:22","updated_at":"2024-01-25 00:36:22","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"000","telephone_extension_number":"00","mp_open_id":null,"pinyin1":"yang","pinyin2":"xu","pinyin3":null,"pinyin4":null,"namecut1":"\u6768","namecut2":"\u65ed","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":1015,"key":1015,"name":"\u5434\u660a","sex":"M"},"keyRoles":[],"mobiles":[{"id":5979,"contact_id":5191,"mobile":"13662051825","mp_open_id":null,"mobile_display":"13662051825"}],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u6768\u65ed","telephone_display":"000-00000000-00","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":1022,"name":"\u674e\u7194\u53cb","email":"lirongyou@smc.com.cn","pinyin_shortcut":"lry","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobile":"","telephone":"80480101","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2017-07-31 15:37:51","updated_at":"2023-10-17 17:49:15","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"li","pinyin2":"rong","pinyin3":"you","pinyin4":null,"namecut1":"\u674e","namecut2":"\u7194","namecut3":"\u53cb","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":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M"},"keyRoles":[{"id":367,"key_role":4,"contact_id":1022,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"mobiles":[{"id":5574,"contact_id":1022,"mobile":"15311444022","mp_open_id":"oagch6STIcr4Xg3n38Njq9ZI3Kwg","mobile_display":"15311444022"}],"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":"\u674e\u7194\u53cb","email_display":"lirongyou@smc.com.cn","telephone_display":"80480101","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":1852,"name":"\u59da\u6606","email":"yaokun@smc.com.cn","pinyin_shortcut":"yk","sex":"M","birth_date":null,"department":"\u7535\u7b97\u5ba4","job_position":"\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":1003,"created_at":"2018-03-23 11:36:16","updated_at":"2023-09-08 09:24:23","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yao","pinyin2":"kun","pinyin3":null,"pinyin4":null,"namecut1":"\u59da","namecut2":"\u6606","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":1003,"key":1003,"name":"\u5415\u5174\u5143","sex":"M"},"keyRoles":[{"id":566,"key_role":4,"contact_id":1852,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"mobiles":[],"commentCount":null,"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u59da\u6606","email_display":"yaokun@smc.com.cn","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4518,"name":"\u738b\u73b2\u7389","email":"","pinyin_shortcut":"wly","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":12,"supplier_id":null,"created_by":5300,"created_at":"2023-03-07 16:10:49","updated_at":"2023-03-07 16:10:49","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wang","pinyin2":"ling","pinyin3":"yu","pinyin4":null,"namecut1":"\u738b","namecut2":"\u73b2","namecut3":"\u7389","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":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F"},"keyRoles":[],"mobiles":[{"id":5332,"contact_id":4518,"mobile":"13132115791","mp_open_id":null,"mobile_display":"13132115791"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u738b\u73b2\u7389","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":1931,"name":"\u803f\u6653\u8389","email":"","pinyin_shortcut":"gxl","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"67885566","client_id":12,"supplier_id":null,"created_by":1016,"created_at":"2018-05-03 14:30:03","updated_at":"2018-08-08 19:06:46","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"42111","mp_open_id":null,"pinyin1":"geng","pinyin2":"xiao","pinyin3":"li","pinyin4":null,"namecut1":"\u803f","namecut2":"\u6653","namecut3":"\u8389","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":1016,"key":1016,"name":"\u8346\u626c","sex":"M"},"keyRoles":[],"mobiles":[],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u803f\u6653\u8389","telephone_display":"67885566-42111","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"}],"pagenation":{"totalcount":18,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-05 16:38:30') RETURNING "id"

[+] Explain