ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
6a572c683d76f: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2026-07-15 02:44:56 pm by 39.156.194.178

Performance Profiling

Total processing time: 74 ms; Peak memory: 5.365 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
14:44:56.27222.6 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (5203, 5202, 5097, 4869, 4850, 4847, 4837, 4835, 4834, 4654)) GROUP BY "object_id"
14:44:56.29816.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 (5203, 5202, 5097, 4869, 4850, 4847, 4837, 4835, 4834, 4654)) GROUP BY "object_id"
14:44:56.2653.1 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"='2130' 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
14:44:56.2622.9 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"='2130' 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"
14:44:56.3202.0 msyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1000, 0, 276, 'v2/contact/of-client', '{"access_token":"wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm","device_type":"0","version_code":"276","id":"2130","page":"1","token":"4a56f62e8d0e2139cb0ef9e315b7246b","posttime":"1784097895","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":5203,"name":"\u5d14\u5f6c\u5f6c","email":"","pinyin_shortcut":"cbb","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2024-02-01 12:01:05","updated_at":"2024-02-01 12:01:05","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"cui","pinyin2":"bin","pinyin3":"bin","pinyin4":null,"namecut1":"\u5d14","namecut2":"\u5f6c","namecut3":"\u5f6c","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5991,"contact_id":5203,"mobile":"13260269945","mp_open_id":null,"mobile_display":"13260269945"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5d14\u5f6c\u5f6c","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5202,"name":"\u5b5f\u8273\u6885","email":"","pinyin_shortcut":"mym","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2024-02-01 11:25:01","updated_at":"2024-02-01 11:25:01","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"meng","pinyin2":"yan","pinyin3":"mei","pinyin4":null,"namecut1":"\u5b5f","namecut2":"\u8273","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5990,"contact_id":5202,"mobile":"15210084800","mp_open_id":null,"mobile_display":"15210084800"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5b5f\u8273\u6885","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":5097,"name":"\u90ed\u8001\u5e08","email":"","pinyin_shortcut":"gls","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5248,"created_at":"2023-12-14 14:25:04","updated_at":"2023-12-14 14:25:04","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"guo","pinyin2":"lao","pinyin3":"shi","pinyin4":null,"namecut1":"\u90ed","namecut2":"\u8001","namecut3":"\u5e08","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":5248,"key":5248,"name":"\u6587\u4f73\u9f99","sex":"M"},"keyRoles":[],"mobiles":[{"id":5886,"contact_id":5097,"mobile":"18210234954","mp_open_id":null,"mobile_display":"18210234954"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u90ed\u8001\u5e08","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4869,"name":"\u5434\u6842\u82b3","email":"","pinyin_shortcut":"wgf","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2023-10-23 17:22:56","updated_at":"2023-10-23 17:22:56","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wu","pinyin2":"gui","pinyin3":"fang","pinyin4":null,"namecut1":"\u5434","namecut2":"\u6842","namecut3":"\u82b3","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5665,"contact_id":4869,"mobile":"13810438352","mp_open_id":null,"mobile_display":"13810438352"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5434\u6842\u82b3","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4850,"name":"\u5f90\u5efa\u8fea","email":"","pinyin_shortcut":"xjd","sex":"M","birth_date":null,"department":"\u7f51\u4fe1","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2023-10-18 09:07:14","updated_at":"2023-10-18 09:07:14","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"xu","pinyin2":"jian","pinyin3":"di","pinyin4":null,"namecut1":"\u5f90","namecut2":"\u5efa","namecut3":"\u8fea","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5645,"contact_id":4850,"mobile":"17710271288","mp_open_id":null,"mobile_display":"17710271288"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f90\u5efa\u8fea","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4847,"name":"\u4faf\u777f\u54f2","email":"","pinyin_shortcut":"hrz","sex":"M","birth_date":null,"department":"\u822a\u76fe\u4e8b\u4e1a\u90e8","job_position":"\u526f\u90e8\u957f","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2023-10-17 13:12:03","updated_at":"2023-10-17 13:12:03","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"hou","pinyin2":"rui","pinyin3":"zhe","pinyin4":null,"namecut1":"\u4faf","namecut2":"\u777f","namecut3":"\u54f2","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5642,"contact_id":4847,"mobile":"18800096639","mp_open_id":null,"mobile_display":"18800096639"}],"commentCount":null,"contactKeyRoles":[{"id":138,"key":138,"name":"Coach"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u4faf\u777f\u54f2","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4837,"name":"\u5f20\u6c38\u9759","email":"","pinyin_shortcut":"zyj","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2023-10-07 00:47:29","updated_at":"2023-10-07 00:47:29","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"yong","pinyin3":"jing","pinyin4":null,"namecut1":"\u5f20","namecut2":"\u6c38","namecut3":"\u9759","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5632,"contact_id":4837,"mobile":"18601209622","mp_open_id":null,"mobile_display":"18601209622"}],"commentCount":null,"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f20\u6c38\u9759","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4835,"name":"\u674e\u540c\u5b87","email":"","pinyin_shortcut":"lty","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2023-09-28 13:32:56","updated_at":"2023-09-28 13:32:56","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"tong","pinyin3":"yu","pinyin4":null,"namecut1":"\u674e","namecut2":"\u540c","namecut3":"\u5b87","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5630,"contact_id":4835,"mobile":"18911276217","mp_open_id":null,"mobile_display":"18911276217"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u674e\u540c\u5b87","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":4834,"name":"\u6881\u5929\u9e4f","email":"","pinyin_shortcut":"ltp","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":5087,"created_at":"2023-09-28 08:54:47","updated_at":"2023-09-28 08:54:47","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":1,"pinyin1":"liang","pinyin2":"tian","pinyin3":"peng","pinyin4":null,"namecut1":"\u6881","namecut2":"\u5929","namecut3":"\u9e4f","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":5087,"key":5087,"name":"\u5218\u5fae","sex":"F"},"keyRoles":[],"mobiles":[{"id":5629,"contact_id":4834,"mobile":"17384692551","mp_open_id":"oagch6dvlEZsFnad9aSbOLDXRV6c","mobile_display":"17384692551"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u6881\u5929\u9e4f","telephone_display":"","unread":0,"bind_status":1,"bind_status_display":"\u5df2\u8ba4\u8bc1"},{"id":4654,"name":"\u5f20\u8d6b","email":"","pinyin_shortcut":"zh","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2130,"supplier_id":null,"created_by":1011,"created_at":"2023-06-20 17:57:58","updated_at":"2023-06-20 17:57:58","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhang","pinyin2":"he","pinyin3":null,"pinyin4":null,"namecut1":"\u5f20","namecut2":"\u8d6b","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":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F"},"keyRoles":[],"mobiles":[{"id":5463,"contact_id":4654,"mobile":"17710020124","mp_open_id":null,"mobile_display":"17710020124"}],"commentCount":null,"contactKeyRoles":[],"contactAttitude":null,"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5f20\u8d6b","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"}],"pagenation":{"totalcount":22,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"39.156.194.178","ua":"jinchangxiao\/2.3.176 (HUAWEIVOG-AL00; Android 10)"}', FALSE, '2026-07-15 14:44:56', 67661056) RETURNING "id"
14:44:56.2950.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5203, 5202, 5097, 4869, 4850, 4847, 4837, 4835, 4834, 4654)
14:44:56.2710.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (5203, 5202, 5097, 4869, 4850, 4847, 4837, 4835, 4834, 4654)
14:44:56.2550.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='wXfR6UQn7fW_MTEa9o-7H8Ixg0fJU0Zm'
14:44:56.2600.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='2130') AND ("deleted"=FALSE)
14:44:56.2970.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (198, 201, 197, 204, 184, 189, 199, 185, 191, 133, 140, 332, 1, 333, 2, 5, 226, 309, 138, 139, 215, 344, 349, 369, 377, 359)) ORDER BY "sort"
14:44:56.2570.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000
14:44:56.2700.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (5203, 5202, 5097, 4869, 4850, 4847, 4837, 4835, 4834, 4654) ORDER BY "key_role"
14:44:56.2690.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"=2
14:44:56.2970.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5203, 5202, 5097, 4869, 4850, 4847, 4837, 4835, 4834, 4654)
14:44:56.2960.4 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (198, 201, 197, 204, 184, 189, 199, 185, 191, 133, 140, 332, 1, 333, 2, 5, 226, 309, 138, 139, 215, 344, 349, 369, 377, 359)) ORDER BY "sort"
14:44:56.2700.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5087, 5248, 1011)
14:44:56.2550.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta