ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
685b60b24cb60: POST https://beta.jinchangxiao.com/v2/contact/of-client at 2025-06-25 10:36:34 am by 223.104.41.148

Performance Profiling

Total processing time: 382 ms; Peak memory: 5.080 MB. Show Profiling Timeline

总计17条数据
TimeDurationCategoryInfo
  
10:36:34.63324.2 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=14) AND ("object_id" IN (542, 846, 728, 543, 540, 310, 516)) GROUP BY "object_id"
10:36:34.66319.5 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=14) AND (remind_user_id = 5016 AND is_read = false) AND ("object_id" IN (542, 846, 728, 543, 540, 310, 516)) GROUP BY "object_id"
10:36:34.5998.4 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
10:36:34.6083.5 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L'
10:36:34.6213.3 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"='141' 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"
10:36:34.6252.9 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"='141' 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
10:36:34.6892.0 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', 5016, 2, 1141, 'v2/contact/of-client', '{"access_token":"J6r5ayQCjcEIGs4KLBJLDPH45YZsr80L","device_type":"2","id":"141","page":"1","posttime":"1750818944","token":"0baca505f82aaac9a6a4509a6cf7145a","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":542,"name":"\u8584\u6d0b","email":"","pinyin_shortcut":"by","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u7f51\u7edc\u8fd0\u7ef4","mobile":"","telephone":"","client_id":141,"supplier_id":null,"created_by":1007,"created_at":"2017-04-28 19:19:21","updated_at":"2025-01-15 16:32:49","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"bao","pinyin2":"yang","pinyin3":null,"pinyin4":null,"namecut1":"\u8584","namecut2":"\u6d0b","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":1007,"key":1007,"name":"\u5b59\u6167","sex":"F"},"keyRoles":[{"id":215,"key_role":4,"contact_id":542,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"mobiles":[{"id":523,"contact_id":542,"mobile":"18612528123","mp_open_id":null,"mobile_display":"18612528123"}],"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":"\u8584\u6d0b","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":846,"name":"\u674e\u4e1c","email":"","pinyin_shortcut":"ld","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"65008084","client_id":141,"supplier_id":null,"created_by":1023,"created_at":"2017-06-16 08:53:13","updated_at":"2024-10-10 15:15:51","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"li","pinyin2":"dong","pinyin3":null,"pinyin4":null,"namecut1":"\u674e","namecut2":"\u4e1c","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":2057,"contact_id":846,"mobile":"18610293071","mp_open_id":null,"mobile_display":"18610293071"}],"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":true,"name_display":"\u674e\u4e1c","telephone_display":"010-65008084","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":728,"name":"\u6768\u536b\u56ed","email":"","pinyin_shortcut":"ywy","sex":"M","birth_date":null,"department":"","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"","client_id":141,"supplier_id":null,"created_by":1016,"created_at":"2017-05-27 11:52:52","updated_at":"2018-07-30 10:45:48","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"yang","pinyin2":"wei","pinyin3":"yuan","pinyin4":null,"namecut1":"\u6768","namecut2":"\u536b","namecut3":"\u56ed","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":[{"id":2056,"contact_id":728,"mobile":"15210747282","mp_open_id":null,"mobile_display":"15210747282"}],"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":true,"name_display":"\u6768\u536b\u56ed","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":543,"name":"\u5b8b\u5f3a","email":"","pinyin_shortcut":"sq","sex":"M","birth_date":null,"department":"\u603b\u88c1","job_position":"\u603b\u7ecf\u7406","mobile":"","telephone":"","client_id":141,"supplier_id":null,"created_by":1007,"created_at":"2017-04-28 19:20:24","updated_at":"2017-04-28 19:20:24","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"song","pinyin2":"qiang","pinyin3":null,"pinyin4":null,"namecut1":"\u5b8b","namecut2":"\u5f3a","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":1007,"key":1007,"name":"\u5b59\u6167","sex":"F"},"keyRoles":[{"id":216,"key_role":1,"contact_id":543,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":217,"key_role":2,"contact_id":543,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"}],"mobiles":[{"id":524,"contact_id":543,"mobile":"18920717175","mp_open_id":null,"mobile_display":"18920717175"}],"commentCount":null,"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u5b8b\u5f3a","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":540,"name":"\u817e\u98de","email":"","pinyin_shortcut":"tf","sex":"M","birth_date":null,"department":"\u4ea7\u54c1\u7814\u53d1\u90e8","job_position":"\u603b\u7ecf\u7406","mobile":"","telephone":"","client_id":141,"supplier_id":null,"created_by":1007,"created_at":"2017-04-28 19:17:57","updated_at":"2017-04-28 19:17:57","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"teng","pinyin2":"fei","pinyin3":null,"pinyin4":null,"namecut1":"\u817e","namecut2":"\u98de","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":1007,"key":1007,"name":"\u5b59\u6167","sex":"F"},"keyRoles":[{"id":213,"key_role":5,"contact_id":540,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"mobiles":[{"id":522,"contact_id":540,"mobile":"13681466208","mp_open_id":null,"mobile_display":"13681466208"}],"commentCount":null,"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"unreadComments":null,"can_update":true,"can_delete":true,"name_display":"\u817e\u98de","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":310,"name":"\u9ad8\u632f\u9f99","email":"","pinyin_shortcut":"gzl","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u7cfb\u7edf\u8fd0\u7ef4","mobile":"","telephone":"","client_id":141,"supplier_id":null,"created_by":1016,"created_at":"2017-03-09 17:44:49","updated_at":"2017-04-28 19:16:47","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"gao","pinyin2":"zhen","pinyin3":"long","pinyin4":null,"namecut1":"\u9ad8","namecut2":"\u632f","namecut3":"\u9f99","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":[{"id":211,"key_role":4,"contact_id":310,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"mobiles":[{"id":324,"contact_id":310,"mobile":"18612755285","mp_open_id":null,"mobile_display":"18612755285"}],"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":"\u9ad8\u632f\u9f99","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"},{"id":516,"name":"\u590f\u957f\u9f99(\u5173\u952e\u4eba)","email":"","pinyin_shortcut":"xclgjr","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u67b6\u6784\u5e08","mobile":"","telephone":"","client_id":141,"supplier_id":null,"created_by":1015,"created_at":"2017-04-25 17:40:33","updated_at":"2018-07-25 18:18:57","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"xia","pinyin2":"chang","pinyin3":"long","pinyin4":"guan","namecut1":"\u590f","namecut2":"\u957f","namecut3":"\u9f99","namecut4":"(","is_mp_bind":null,"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":1015,"key":1015,"name":"\u5434\u660a","sex":"M"},"keyRoles":[{"id":212,"key_role":3,"contact_id":516,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"id":154,"key_role":4,"contact_id":516,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"mobiles":[{"id":2008,"contact_id":516,"mobile":"15011151345","mp_open_id":null,"mobile_display":"15011151345"}],"commentCount":null,"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"},{"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":"\u590f\u957f\u9f99(\u5173\u952e\u4eba)","telephone_display":"","unread":0,"bind_status":0,"bind_status_display":"\u672a\u8ba4\u8bc1"}],"pagenation":{"totalcount":7,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-06-25 10:36:34') RETURNING "id"
10:36:34.6172.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_clients" WHERE ("id"='141') AND ("deleted"=FALSE)
10:36:34.6131.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016
10:36:34.6291.4 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1)
10:36:34.6581.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (542, 846, 728, 543, 540, 310, 516)
10:36:34.6320.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (542, 846, 728, 543, 540, 310, 516)
10:36:34.6600.9 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 165, 179, 142, 164, 101, 103, 100, 97, 197, 194, 107, 226, 169, 172, 185, 191, 93, 94, 2, 6, 153, 7, 8, 1, 205, 204, 196, 199, 319, 316, 2100000000, 311, 212, 5, 114, 154, 136, 140, 105, 326, 340, 359, 369, 377, 133, 134, 135, 137, 160)) ORDER BY "sort"
10:36:34.6610.6 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (542, 846, 728, 543, 540, 310, 516)
10:36:34.6310.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_key_roles" WHERE "contact_id" IN (542, 846, 728, 543, 540, 310, 516) ORDER BY "key_role"
10:36:34.6620.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (46, 165, 179, 142, 164, 101, 103, 100, 97, 197, 194, 107, 226, 169, 172, 185, 191, 93, 94, 2, 6, 153, 7, 8, 1, 205, 204, 196, 199, 319, 316, 2100000000, 311, 212, 5, 114, 154, 136, 140, 105, 326, 340, 359, 369, 377, 133, 134, 135, 137, 160)) ORDER BY "sort"
10:36:34.6300.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1007, 1023, 1016, 1015)