ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686b9549be583: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2025-07-07 05:37:13 pm by 223.160.230.231

Performance Profiling

Total processing time: 98 ms; Peak memory: 4.957 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
17:37:13.81124.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (3642, 3649, 3915, 3912, 3899, 3890, 3877, 3855, 3837, 3819)) GROUP BY "object_id"
17:37:13.84022.5 msyii\db\Command::querySELECT "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 (3642, 3649, 3915, 3912, 3899, 3890, 3877, 3855, 3837, 3819)) GROUP BY "object_id"
17:37:13.86510.1 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 6, 166, 'v2/contact/of-client', '{"id":"982","page":"1","posttime":"1751881033","access_token":"Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd","device_type":"6","version_code":"166","token":"0dc015da70a7fac720f950b242677a43"}', '{"code":200,"data":{"list":[{"id":3642,"name":"\u5218\u4eba\u8bda","email":"","pinyin_shortcut":"lrc","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2021-06-30 15:36:59","updated_at":"2022-05-05 09:01:11","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liu","pinyin2":"ren","pinyin3":"cheng","pinyin4":null,"namecut1":"\u5218","namecut2":"\u4eba","namecut3":"\u8bda","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4282,"contact_id":3642,"mobile":"13501128560","mp_open_id":"oagch6Zg40PW4PKtJZmsSRbK5K8g","mobile_display":"13501128560"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5218\u4eba\u8bda","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3649,"name":"\u59da\u96ea\u7eaf","email":"","pinyin_shortcut":"yxc","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":5094,"created_at":"2021-07-01 16:12:40","updated_at":"2022-04-11 15:25:48","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"yao","pinyin2":"xue","pinyin3":"chun","pinyin4":null,"namecut1":"\u59da","namecut2":"\u96ea","namecut3":"\u7eaf","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":5094,"key":5094,"name":"\u5218\u5fd7\u521a","sex":"M"},"keyRoles":[],"mobiles":[{"id":4388,"contact_id":3649,"mobile":"17610273960","mp_open_id":"oagch6dTsMHJsvajGlohtNzbymvw","mobile_display":"17610273960"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u59da\u96ea\u7eaf","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3915,"name":"\u5218\u5fae","email":"","pinyin_shortcut":"lw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2022-03-04 10:27:33","updated_at":"2022-03-04 10:27:33","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liu","pinyin2":"wei","pinyin3":null,"pinyin4":null,"namecut1":"\u5218","namecut2":"\u5fae","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4734,"contact_id":3915,"mobile":"13910698067","mp_open_id":"oagch6WkYmUGsn6oW9zL-hhNTAqk","mobile_display":"13910698067"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5218\u5fae","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3912,"name":"\u4ed8\u9e4f","email":"","pinyin_shortcut":"fp","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2022-03-03 13:30:36","updated_at":"2022-03-03 13:30:36","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"fu","pinyin2":"peng","pinyin3":null,"pinyin4":null,"namecut1":"\u4ed8","namecut2":"\u9e4f","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4731,"contact_id":3912,"mobile":"18513460715","mp_open_id":"oagch6aFnOFVc_ZtBb6K3n21Lg-c","mobile_display":"18513460715"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u4ed8\u9e4f","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3899,"name":"\u960e\u603b","email":"","pinyin_shortcut":"yz","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2022-02-22 20:40:34","updated_at":"2022-02-22 20:40:34","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"yan","pinyin2":"zong","pinyin3":null,"pinyin4":null,"namecut1":"\u960e","namecut2":"\u603b","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4717,"contact_id":3899,"mobile":"18910031050","mp_open_id":"oagch6XhQAzooO9CnKv25hXm1Az0","mobile_display":"18910031050"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u960e\u603b","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3890,"name":"\u5218\u82cf\u4eea","email":"","pinyin_shortcut":"lsy","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2022-02-11 06:46:55","updated_at":"2022-02-11 06:46:55","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liu","pinyin2":"su","pinyin3":"yi","pinyin4":null,"namecut1":"\u5218","namecut2":"\u82cf","namecut3":"\u4eea","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4709,"contact_id":3890,"mobile":"13811185248","mp_open_id":"oagch6X9oKHYrKOTENZVweuS3nyc","mobile_display":"13811185248"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5218\u82cf\u4eea","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3877,"name":"\u90a2\u603b","email":"","pinyin_shortcut":"xz","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2022-01-11 16:24:28","updated_at":"2022-01-11 16:24:28","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"xing","pinyin2":"zong","pinyin3":null,"pinyin4":null,"namecut1":"\u90a2","namecut2":"\u603b","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4695,"contact_id":3877,"mobile":"13501188916","mp_open_id":"oagch6ZfWSuCRKCWLA-sfd1svW_Q","mobile_display":"13501188916"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u90a2\u603b","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3855,"name":"\u90ed\u603b","email":"","pinyin_shortcut":"gz","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"CTO","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2021-12-23 10:32:43","updated_at":"2021-12-31 21:05:01","user_status":2,"description":"\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5\u6d4b\u8bd5","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"guo","pinyin2":"zong","pinyin3":null,"pinyin4":null,"namecut1":"\u90ed","namecut2":"\u603b","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4674,"contact_id":3855,"mobile":"13810389198","mp_open_id":"oagch6T1_ZjxHBQAkY2BwGMWKsVY","mobile_display":"13810389198"}],"commentCount":null,"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u90ed\u603b","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3837,"name":"\u5218\u6d77\u9759","email":"","pinyin_shortcut":"lhj","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2021-12-03 09:48:02","updated_at":"2021-12-03 09:48:02","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liu","pinyin2":"hai","pinyin3":"jing","pinyin4":null,"namecut1":"\u5218","namecut2":"\u6d77","namecut3":"\u9759","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4655,"contact_id":3837,"mobile":"13361065172","mp_open_id":"oagch6eY0rbrcq3XzvnP-ZLwCqnk","mobile_display":"13361065172"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5218\u6d77\u9759","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":3819,"name":"JJ","email":"","pinyin_shortcut":"JJ","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":1001,"created_at":"2021-11-15 14:54:24","updated_at":"2021-11-29 18:45:50","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"jj","pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"j","namecut2":"j","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":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M"},"keyRoles":[],"mobiles":[{"id":4648,"contact_id":3819,"mobile":"18610100906","mp_open_id":null,"mobile_display":"18610100906"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"JJ","telephone_display":"","unread":0,"bind_status":2,"bind_status_display":"\u5df2\u89e3\u7ed1"}],"pagenation":{"totalcount":64,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-07 17:37:13') RETURNING "id"
17:37:13.7955.0 msyii\db\Command::querySELECT 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"='982' 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"
17:37:13.7843.9 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='Ll7CI5iYtgVyQJHl2tkvnIHNJc9_fUfd'
17:37:13.7812.6 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
17:37:13.8002.5 msyii\db\Command::querySELECT 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"='982' 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
17:37:13.8081.7 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (3642, 3649, 3915, 3912, 3899, 3890, 3877, 3855, 3837, 3819) ORDER BY "key_role"
17:37:13.7891.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
17:37:13.7931.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='982') AND ("deleted"=FALSE)
17:37:13.8071.2 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5094)
17:37:13.8101.1 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (3642, 3649, 3915, 3912, 3899, 3890, 3877, 3855, 3837, 3819)
17:37:13.8361.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3642, 3649, 3915, 3912, 3899, 3890, 3877, 3855, 3837, 3819)
17:37:13.8370.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (1, 2, 226, 5, 215, 184, 189, 205, 192, 197, 199, 185, 191, 133, 139, 164, 142, 181, 349, 350, 369, 377)) ORDER BY "sort"
17:37:13.8380.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (3642, 3649, 3915, 3912, 3899, 3890, 3877, 3855, 3837, 3819)
17:37:13.8060.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2
17:37:13.8390.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (1, 2, 226, 5, 215, 184, 189, 205, 192, 197, 199, 185, 191, 133, 139, 164, 142, 181, 349, 350, 369, 377)) ORDER BY "sort"