ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68955fa1e3b07: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2025-08-08 10:23:29 am by 223.104.39.199

Database Queries

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

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

[+] Explain
10:23:30.3551.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='304') AND ("deleted"=FALSE)

[+] Explain
10:23:30.3613.2 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"='304' 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:23:30.3641.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"='304' 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:23:30.3670.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2

[+] Explain
10:23:30.3670.2 msSELECTSELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1007, 1016)

[+] Explain
10:23:30.3680.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (669, 2061) ORDER BY "key_role"

[+] Explain
10:23:30.3680.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (669, 2061)

[+] Explain
10:23:30.36921.2 msSELECTSELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (669, 2061)) GROUP BY "object_id"

[+] Explain
10:23:30.3900.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (669, 2061)

[+] Explain
10:23:30.3910.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (8, 5, 1, 101, 107, 114, 165, 179, 135, 136, 137, 139, 142, 183, 194, 313, 354, 7, 160, 163, 175, 205, 204, 320, 359)) ORDER BY "sort"

[+] Explain
10:23:30.3920.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (669, 2061)

[+] Explain
10:23:30.3920.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (8, 5, 1, 101, 107, 114, 165, 179, 135, 136, 137, 139, 142, 183, 194, 313, 354, 7, 160, 163, 175, 205, 204, 320, 359)) ORDER BY "sort"

[+] Explain
10:23:30.39317.0 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 (669, 2061)) GROUP BY "object_id"

[+] Explain
10:23:30.4121.4 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":"304","page":"1","posttime":"1754619776","token":"1120bd5ec70526aebd165df2f0716a74","version_code":"1146"}', '{"code":200,"data":{"list":[{"id":669,"name":"\u9ad8\u4fca","email":"gaojun@sevenstar.com.cn","pinyin_shortcut":"gj","sex":"M","birth_date":null,"department":"\u4f01\u4e1a\u7ba1\u7406\u90e8","job_position":"\u526f\u90e8\u957f","mobile":"","telephone":"","client_id":304,"supplier_id":null,"created_by":1007,"created_at":"2017-05-19 18:06:04","updated_at":"2019-11-01 08:03:53","user_status":2,"description":"4\u5c42\u529e\u516c","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"gao","pinyin2":"jun","pinyin3":null,"pinyin4":null,"namecut1":"\u9ad8","namecut2":"\u4fca","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":1007,"key":1007,"name":"\u5b59\u6167","sex":"F"},"keyRoles":[],"mobiles":[{"id":3121,"contact_id":669,"mobile":"15810082383","mp_open_id":"oagch6Z0AtwjvGo83Y9mArIitSY8","mobile_display":"15810082383"}],"commentCount":null,"contactKeyRoles":[{"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":"\u9ad8\u4fca","email_display":"gaojun@sevenstar.com.cn","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":2061,"name":"\u5218\u6770","email":"","pinyin_shortcut":"lj","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":304,"supplier_id":null,"created_by":1016,"created_at":"2018-06-13 19:53:08","updated_at":"2019-11-01 08:03:18","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liu","pinyin2":"jie","pinyin3":null,"pinyin4":null,"namecut1":"\u5218","namecut2":"\u6770","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":1016,"key":1016,"name":"\u8346\u626c","sex":"M"},"keyRoles":[],"mobiles":[{"id":3120,"contact_id":2061,"mobile":"13810765068","mp_open_id":"oagch6d5-CwoFXwGbN31QDvj_bTY","mobile_display":"13810765068"}],"commentCount":null,"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":163,"key":163,"name":"\u5ffd\u8fdc\u5ffd\u8fd1"},"unreadComments":null,"can_update":true,"can_delete":false,"name_display":"\u5218\u6770","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"}],"pagenation":{"totalcount":2,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-08 10:23:30') RETURNING "id"

[+] Explain