ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68c286bb5f8e7: POST https://beta.jinchangxiao.com/vue/address-book/contact-list at 2025-09-11 04:22:19 pm by 114.246.237.213

Log Messages

总计48条数据
TimeLevelCategoryMessage
 
16:22:19.391traceyii\base\Application::bootstrapBootstrap with yii\log\Dispatcher
16:22:19.391traceyii\base\Module::getModuleLoading module: debug
16:22:19.391traceyii\base\Application::bootstrapBootstrap with yii\debug\Module::bootstrap()
16:22:19.391traceyii\redis\Connection::openOpening redis DB connection: redis.server.local:6379, database=1
16:22:19.391traceyii\redis\Connection::executeCommandExecuting Redis Command: SELECT
16:22:19.391traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.391traceyii\base\Module::getModuleLoading module: gii
16:22:19.391traceyii\base\Application::bootstrapBootstrap with yii\gii\Module::bootstrap()
16:22:19.392traceyii\web\UrlManager::parseRequestNo matching URL rules. Using default URL parsing logic.
16:22:19.392traceyii\web\Application::handleRequestRoute requested: 'vue/address-book/contact-list'
16:22:19.392traceyii\base\Module::getModuleLoading module: vue
16:22:19.392infoyii\web\Session::openSession started
16:22:19.392infoyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "id"=1001
16:22:19.392infoyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
16:22:19.397traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.397traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:22:19.397traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.398traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:22:19.398infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001
16:22:19.399traceyii\base\Controller::runActionRoute to run: vue/address-book/contact-list
16:22:19.399traceyii\base\InlineAction::runWithParamsRunning action: app\modules\vue\controllers\AddressBookController::actionContactList()
16:22:19.400traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.400traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.401traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewClientContact
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Engineer
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking permission: viewSupplierContact
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: StoreKeeper
16:22:19.402traceuranus\rbac\DbManager::checkAccessFromCacheChecking role: Admin
16:22:19.402infoyii\db\Command::querySELECT COUNT(*) FROM (SELECT "c".* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON c.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON c.supplier_id = s.id WHERE (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (client_id is not null) AND (supplier_id is not null or client_id is not null) GROUP BY "c"."id" ORDER BY c.pinyin1 nulls last, namecut1 nulls last, c.pinyin2 nulls last, namecut2 nulls last, c.pinyin3 nulls last, namecut3 nulls last, c.pinyin4 nulls last, namecut4 nulls last, c.created_by, c.created_at DESC ) "c"
16:22:19.416infoyii\db\Command::querySELECT "c".* FROM "a57be577deb434"."tbl_contacts" "c" LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON c.client_id = client.id LEFT JOIN "a57be577deb434"."tbl_suppliers" "s" ON c.supplier_id = s.id WHERE (("client"."sales_rep" IN (1001, 5049, 5301, 5022, 5209, 5026, 5293, 5309, 5356, 5329, 5299, 5303, 5302, 5332, 5047, 1026, 5096, 5070, 5448, 5420, 1029, 5037, 5087, 1008, 5048, 5043, 5045, 5230, 5031, 5088, 5208, 1003, 5294, 5357, 5044, 1030, 5076, 5300, 5027, 5089, 5311, 5066, 5069, 5364, 1009, 5295, 1013, 5128, 5203, 1025, 5032, 5075, 1004, 5072, 5033, 5359, 5409, 5412, 5229, 1005, 5304, 5449, 5358, 1006, 5093)) OR ("client"."sales_rep" IS NULL) OR ("client"."id" IN (SELECT "client_id" FROM "a57be577deb434"."tbl_user_visit_clients" WHERE "user_id"=1001))) AND (client_id is not null) AND (supplier_id is not null or client_id is not null) GROUP BY "c"."id" ORDER BY c.pinyin1 nulls last, namecut1 nulls last, c.pinyin2 nulls last, namecut2 nulls last, c.pinyin3 nulls last, namecut3 nulls last, c.pinyin4 nulls last, namecut4 nulls last, c.created_by, c.created_at DESC LIMIT 20
16:22:19.423traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.423traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:22:19.424infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (530, 3101, 2585, 149, 399, 891, 3337, 27, 248, 2499, 79, 982, 521, 2472, 586, 295, 3294, 57, 46)
16:22:19.424infoyii\db\Command::querySELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 3, 1)
16:22:19.425infoyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5300, 1001, 5087, 1005, 1016, 5043, 5295, 1006, 1015, 5311, 5209, 5094, 5096, 5332, 5032, 5031, 5420)
16:22:19.425infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (5248, 5577, 5092, 1441, 941, 1772, 6064, 1351, 652, 4748, 3521, 3646, 3647, 2886, 4381, 1346, 1216, 5849, 731, 5821)
16:22:19.426infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5248, 5577, 5092, 1441, 941, 1772, 6064, 1351, 652, 4748, 3521, 3646, 3647, 2886, 4381, 1346, 1216, 5849, 731, 5821)
16:22:19.428infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 129, 180, 142, 100, 101, 226, 97, 166, 205, 189, 137, 140, 154, 94, 227, 128, 131, 181, 5, 184, 194, 198, 201, 93, 1, 2, 6, 185, 191, 164, 179, 197, 199, 232, 171, 196, 204, 212, 203, 153, 332, 136, 172, 333, 135, 340, 309, 313, 341, 2100000000, 160, 265, 316, 114, 133, 139, 317, 107, 349, 357, 369, 373, 377, 374, 323, 352)) ORDER BY "sort"
16:22:19.429infoyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (5248, 5577, 5092, 1441, 941, 1772, 6064, 1351, 652, 4748, 3521, 3646, 3647, 2886, 4381, 1346, 1216, 5849, 731, 5821)
16:22:19.429infoyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (46, 129, 180, 142, 100, 101, 226, 97, 166, 205, 189, 137, 140, 154, 94, 227, 128, 131, 181, 5, 184, 194, 198, 201, 93, 1, 2, 6, 185, 191, 164, 179, 197, 199, 232, 171, 196, 204, 212, 203, 153, 332, 136, 172, 333, 135, 340, 309, 313, 341, 2100000000, 160, 265, 316, 114, 133, 139, 317, 107, 349, 357, 369, 373, 377, 374, 323, 352)) ORDER BY "sort"
16:22:19.431traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.431traceyii\redis\Connection::executeCommandExecuting Redis Command: MGET
16:22:19.431infoyii\db\Command::queryINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/address-book/contact-list', '{"page":"1","type":"1","web_access_token":"2BZqbE639wqIoHhgH0VfUgn-meZYtkbz"}', '{"code":2000,"result":{"list":[{"id":5248,"name":"Alice","email":"","pinyin_shortcut":"Alice","sex":"M","birth_date":null,"department":"\u91c7\u8d2d","job_position":"","mobile":"","telephone":"00000000","client_id":530,"supplier_id":null,"created_by":5300,"created_at":"2024-03-21 17:36:54","updated_at":"2024-03-21 17:36:54","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"alice","pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"a","namecut2":"l","namecut3":"i","namecut4":"c","is_mp_bind":false,"client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6036,"contact_id":5248,"mobile":"15618229663","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"010-00000000","bgcolor":"#89c541"},{"id":5577,"name":"\u5b89\u8d6b","email":"","pinyin_shortcut":"ah","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":3101,"supplier_id":null,"created_by":1001,"created_at":"2024-05-10 18:01:56","updated_at":"2024-05-10 18:01:56","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"he","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u8d6b","namecut3":null,"namecut4":null,"is_mp_bind":false,"client":{"id":3101,"key":3101,"name":"\u897f\u5b89\u5b89\u6b23\u533b\u836f\u79d1\u6280\u6709\u9650\u516c\u53f8"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","user_status":"1"},"mobiles":[{"id":6362,"contact_id":5577,"mobile":"18066899606","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":5092,"name":"\u5b89\u9e64","email":"","pinyin_shortcut":"ah","sex":"F","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2585,"supplier_id":null,"created_by":5087,"created_at":"2023-12-14 13:47:31","updated_at":"2023-12-14 13:47:31","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"he","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u9e64","namecut3":null,"namecut4":null,"is_mp_bind":false,"client":{"id":2585,"key":2585,"name":"\u822a\u5929\u5b8f\u5eb7\u667a\u80fd\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8\uff08\u8fc7\u5355\uff09"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5087,"key":5087,"name":"\u5218\u5fae","sex":"F","user_status":"1"},"mobiles":[{"id":5881,"contact_id":5092,"mobile":"13811046207","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":1441,"name":"\u5b89\u6377","email":"","pinyin_shortcut":"aj","sex":"M","birth_date":null,"department":"","job_position":"\u6280\u672f","mobile":"","telephone":"","client_id":149,"supplier_id":null,"created_by":1005,"created_at":"2018-01-02 18:58:59","updated_at":"2018-01-02 18:58:59","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"jie","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u6377","namecut3":null,"namecut4":null,"is_mp_bind":null,"client":{"id":149,"key":149,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240(\u6cd5\u8bc1\u90e8)\uff08\u71d5\u4eac\uff09"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1005,"key":1005,"name":"\u8d75\u6657\u7131","sex":"F","user_status":"1"},"mobiles":[{"id":1355,"contact_id":1441,"mobile":"13522582788","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":941,"name":"\u5b89\u6770","email":"","pinyin_shortcut":"aj","sex":"M","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"","mobile":"","telephone":"","client_id":399,"supplier_id":null,"created_by":1016,"created_at":"2017-07-11 15:58:21","updated_at":"2022-03-14 10:45:37","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"jie","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u6770","namecut3":null,"namecut4":null,"is_mp_bind":null,"client":{"id":399,"key":399,"name":"\u516c\u5b89\u90e8\u7b2c\u4e00\u7814\u7a76\u6240\u4e2d\u76fe(\u8fc7\u5355\u516c\u53f8)"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1016,"key":1016,"name":"\u8346\u626c","sex":"M","user_status":"-1"},"mobiles":[{"id":933,"contact_id":941,"mobile":"13522582788","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":1772,"name":"\u5b89\u7ecf\u7406","email":"","pinyin_shortcut":"ajl","sex":"M","birth_date":null,"department":"IT","job_position":"\u5e94\u7528\u8fd0\u7ef4","mobile":"","telephone":"","client_id":891,"supplier_id":null,"created_by":5043,"created_at":"2018-02-05 17:50:17","updated_at":"2022-01-13 11:43:42","user_status":3,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"jing","pinyin3":"li","pinyin4":null,"namecut1":"\u5b89","namecut2":"\u7ecf","namecut3":"\u7406","namecut4":null,"is_mp_bind":null,"client":{"id":891,"key":891,"name":"\u5317\u4eac\u5f53\u5f53\u7f51\u4fe1\u606f\u6280\u672f\u6709\u9650\u516c\u53f8"},"supplier":null,"contactStatus":{"id":3,"key":3,"name":"\u5931\u8054"},"createdBy":{"id":5043,"key":5043,"name":"\u5218\u79b9","sex":"M","user_status":"-1"},"mobiles":[{"id":4507,"contact_id":1772,"mobile":"15101559121","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":6064,"name":"\u5b89\u5eb7","email":"","pinyin_shortcut":"ak","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"57364237","client_id":3337,"supplier_id":null,"created_by":5295,"created_at":"2025-05-28 20:31:45","updated_at":"2025-05-28 20:31:45","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"kang","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u5eb7","namecut3":null,"namecut4":null,"is_mp_bind":false,"client":{"id":3337,"key":3337,"name":"\u4e2d\u56fd\u822a\u5929\u79d1\u6280\u96c6\u56e2\u516c\u53f8\u7b2c\u4e00\u7814\u7a76\u9662\u4e8c\u4e00\u4e00\u5382"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"57364237","bgcolor":"#89c541"},{"id":1351,"name":"\u5b89\u5764","email":"ankun@e-autolife.com","pinyin_shortcut":"ak","sex":"F","birth_date":null,"department":"\u91c7\u8d2d\u90e8","job_position":"\u91c7\u8d2d\u7ecf\u7406","mobile":null,"telephone":"","client_id":27,"supplier_id":null,"created_by":1006,"created_at":"2017-11-30 12:34:53","updated_at":"2017-11-30 12:35:00","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"an","pinyin2":"kun","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u5764","namecut3":null,"namecut4":null,"is_mp_bind":null,"client":{"id":27,"key":27,"name":"\u5317\u4eac\u6c7d\u8f66\u6613\u751f\u6d3b\u7f51\u7edc\u79d1\u6280\u6709\u9650\u516c\u53f8\uff08\u5317\u4eac\u4e2d\u6cb9\u623f\u5c71\u71d5\u5bbe\u6cb9\u6599\u9500\u552e\u6709\u9650\u516c\u53f8\uff09"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":597,"contact_id":1351,"mobile":"","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":652,"name":"\u5b89\u4f1f\u656c","email":"an_wj@cnplhd.com.cn","pinyin_shortcut":"awj","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u6280\u672f\u90e8","job_position":"\u8bbe\u5907\u5de5\u7a0b\u5e08","mobile":"","telephone":"010-56792723","client_id":248,"supplier_id":null,"created_by":1015,"created_at":"2017-05-17 18:02:01","updated_at":"2017-05-17 18:02:01","user_status":1,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"wei","pinyin3":"jing","pinyin4":null,"namecut1":"\u5b89","namecut2":"\u4f1f","namecut3":null,"namecut4":null,"is_mp_bind":null,"client":{"id":248,"key":248,"name":"\u4e2d\u56fd\u90ae\u653f\u4f9b\u5e94\u94fe"},"supplier":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1015,"key":1015,"name":"\u5434\u660a","sex":"M","user_status":"1"},"mobiles":[{"id":636,"contact_id":652,"mobile":"18910165831\uff1b13661392436","mp_open_id":null}],"contactKeyRoles":[{"id":137,"key":137,"name":"\u4f7f\u7528\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"010-56792723","bgcolor":"#89c541"},{"id":4748,"name":"\u5b89\u5148\u751f(\u77f3\u666f\u5c71\u4f4f\u5efa\u59d4)","email":"","pinyin_shortcut":"axssjszjw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2499,"supplier_id":null,"created_by":5311,"created_at":"2023-07-28 09:53:14","updated_at":"2023-07-28 09:53:14","user_status":2,"description":"\u77f3\u666f\u5c71\u533a\u516b\u89d2\u897f\u885766\u53f7\u65b9\u5730\u5927\u53a6A\u5ea71013\u5ba4\n","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"xian","pinyin3":"sheng","pinyin4":"shi","namecut1":"\u5b89","namecut2":"\u5148","namecut3":"\u751f","namecut4":"(","is_mp_bind":false,"client":{"id":2499,"key":2499,"name":"\u540c\u65b9\u552e\u540e\u670d\u52a1\u7528\u6237"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5311,"key":5311,"name":"\u62d3\u5b9e\u79d1\u6280","sex":"F","user_status":"1"},"mobiles":[{"id":5555,"contact_id":4748,"mobile":"13141336952","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":3521,"name":"\u5b89\u5148\u751f","email":"","pinyin_shortcut":"axs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":79,"supplier_id":null,"created_by":5209,"created_at":"2021-01-28 15:27:25","updated_at":"2021-02-01 16:02:39","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"xian","pinyin3":"sheng","pinyin4":null,"namecut1":"\u5b89","namecut2":"\u5148","namecut3":null,"namecut4":null,"is_mp_bind":null,"client":{"id":79,"key":79,"name":"\u5317\u4eac\u79c0\u6c34\u8857\u7535\u5b50\u5546\u52a1\u6709\u9650\u516c\u53f8(\u5317\u4eac\u79c0\u6c34\u8857\u5e02\u573a\u6709\u9650\u516c\u53f8)"},"supplier":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":5209,"key":5209,"name":"\u5d14\u5efa\u8def","sex":"M","user_status":"-1"},"mobiles":[{"id":4052,"contact_id":3521,"mobile":"15652477039","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":3646,"name":"\u5b89\u4e91\u971e(\u6d4b\u8bd5)","email":"","pinyin_shortcut":"ayxcs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":5094,"created_at":"2021-06-30 18:14:09","updated_at":"2021-06-30 18:14:09","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6Z3XrSBNtqlTXvlOUUokn4c","pinyin1":"an","pinyin2":"yun","pinyin3":"xia","pinyin4":"ce","namecut1":"\u5b89","namecut2":"\u4e91","namecut3":"\u971e","namecut4":"(","is_mp_bind":true,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5094,"key":5094,"name":"\u5218\u5fd7\u521a","sex":"M","user_status":"-1"},"mobiles":[{"id":4288,"contact_id":3646,"mobile":"13691146376","mp_open_id":"oagch6Z3XrSBNtqlTXvlOUUokn4c"}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":3647,"name":"\u5b89\u4e91\u971e1(\u6d4b\u8bd5)","email":"","pinyin_shortcut":"ayx1cs","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":982,"supplier_id":null,"created_by":5094,"created_at":"2021-06-30 18:18:53","updated_at":"2021-06-30 18:18:53","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6WFOscIieV-tC6K7t0T98Fk","pinyin1":"an","pinyin2":"yun","pinyin3":"xia","pinyin4":"ce","namecut1":"\u5b89","namecut2":"\u4e91","namecut3":"\u971e","namecut4":"1","is_mp_bind":true,"client":{"id":982,"key":982,"name":"\u4e2d\u56fd\u4fe1\u606f\u5b89\u5168\u7814\u7a76\u6240"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5094,"key":5094,"name":"\u5218\u5fd7\u521a","sex":"M","user_status":"-1"},"mobiles":[{"id":4289,"contact_id":3647,"mobile":"13911665172","mp_open_id":"oagch6WFOscIieV-tC6K7t0T98Fk"}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":2886,"name":"\u5b89\u5fd7\u660e","email":"","pinyin_shortcut":"azm","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":521,"supplier_id":null,"created_by":5096,"created_at":"2019-09-05 13:45:19","updated_at":"2019-11-01 12:56:07","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"zhi","pinyin3":"ming","pinyin4":null,"namecut1":"\u5b89","namecut2":"\u5fd7","namecut3":"\u660e","namecut4":null,"is_mp_bind":null,"client":{"id":521,"key":521,"name":"\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662\u6709\u9650\u516c\u53f8\/\u4e2d\u8f66\u5de5\u4e1a\u7814\u7a76\u9662(\u9752\u5c9b)\u6709\u9650\u516c\u53f8"},"supplier":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":5096,"key":5096,"name":"\u674e\u6c5f\u661f","sex":"F","user_status":"-1"},"mobiles":[{"id":3128,"contact_id":2886,"mobile":"15210573104","mp_open_id":null}],"contactKeyRoles":[{"id":135,"key":135,"name":"\u91c7\u8d2d\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":4381,"name":"\u5b89\u5fd7\u5e73","email":"","pinyin_shortcut":"azp","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":2472,"supplier_id":null,"created_by":5332,"created_at":"2022-10-25 17:27:55","updated_at":"2022-10-25 17:27:55","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"an","pinyin2":"zhi","pinyin3":"ping","pinyin4":null,"namecut1":"\u5b89","namecut2":"\u5fd7","namecut3":"\u5e73","namecut4":null,"is_mp_bind":false,"client":{"id":2472,"key":2472,"name":"\u4e2d\u56fd\u5317\u65b9\u8f66\u8f86\u7814\u7a76\u6240(\u9999\u6e2f)"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5332,"key":5332,"name":"\u970d\u536b\u8d85","sex":"M","user_status":"1"},"mobiles":[{"id":5193,"contact_id":4381,"mobile":"13910796862","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":1346,"name":"\u5b89\u603b","email":"","pinyin_shortcut":"az","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u5316","job_position":"\u4e3b\u4efb","mobile":null,"telephone":"","client_id":586,"supplier_id":null,"created_by":5032,"created_at":"2017-11-28 23:29:14","updated_at":"2017-11-28 23:29:14","user_status":2,"description":null,"contact_type":"1","contact_attitude":1,"telephone_area_code":null,"telephone_extension_number":null,"mp_open_id":null,"pinyin1":"an","pinyin2":"zong","pinyin3":null,"pinyin4":null,"namecut1":"\u5b89","namecut2":"\u603b","namecut3":null,"namecut4":null,"is_mp_bind":null,"client":{"id":586,"key":586,"name":"\u6676\u9f99\u79d1\u6280\u80a1\u4efd\u6709\u9650\u516c\u53f8"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5032,"key":5032,"name":"\u9122\u535a","sex":"M","user_status":"-1"},"mobiles":[{"id":686,"contact_id":1346,"mobile":"","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":1216,"name":"\u6602\u767b\u534e","email":"adh@jcmeh.com","pinyin_shortcut":"adh","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u90e8\u957f","mobile":"","telephone":"87707370","client_id":295,"supplier_id":null,"created_by":5031,"created_at":"2017-10-25 14:52:47","updated_at":"2019-10-15 23:58:52","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"ang","pinyin2":"deng","pinyin3":"hua","pinyin4":null,"namecut1":"\u6602","namecut2":"\u767b","namecut3":"\u534e","namecut4":null,"is_mp_bind":null,"client":{"id":295,"key":295,"name":"\u5317\u4eac\u4eac\u57ce\u673a\u7535\u63a7\u80a1\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5031,"key":5031,"name":"\u7f57\u8c46","sex":"F","user_status":"-1"},"mobiles":[{"id":3073,"contact_id":1216,"mobile":"13520518396","mp_open_id":null}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"87707370","bgcolor":"#89c541"},{"id":5849,"name":"\u6556\u7fd4","email":"","pinyin_shortcut":"ax","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":3294,"supplier_id":null,"created_by":5420,"created_at":"2024-08-16 11:34:02","updated_at":"2024-08-16 11:34:02","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"ao","pinyin2":"xiang","pinyin3":null,"pinyin4":null,"namecut1":"\u6556","namecut2":"\u7fd4","namecut3":null,"namecut4":null,"is_mp_bind":false,"client":{"id":3294,"key":3294,"name":"\u56fd\u5bb6\u77e5\u8bc6\u4ea7\u6743\u5c40"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5420,"key":5420,"name":"\u674e\u6ea6","sex":"M","user_status":"-1"},"mobiles":[{"id":6642,"contact_id":5849,"mobile":"13391956605","mp_open_id":null}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":139,"key":139,"name":"\u652f\u6301"},"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":731,"name":"armand","email":"armand.amin@bioduro.com","pinyin_shortcut":"armand","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":57,"supplier_id":null,"created_by":1006,"created_at":"2017-05-27 16:13:10","updated_at":"2022-09-29 10:33:51","user_status":1,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"armand","pinyin2":null,"pinyin3":null,"pinyin4":null,"namecut1":"a","namecut2":"r","namecut3":"m","namecut4":"a","is_mp_bind":null,"client":{"id":57,"key":57,"name":"\u4fdd\u8bfa\u79d1\u6280(\u5317\u4eac)\u6709\u9650\u516c\u53f8\u3001\u4e0a\u6d77\u6da6\u8bfa\u3001\u4e2d\u56fd\u7535\u5b50\u7cfb\u7edf\u5de5\u7a0b\u7b2c\u4e8c\u5efa\u8bbe\u6709\u9650\u516c\u53f8,\u6851\u8fea\u4e9a\u533b\u836f\u6280\u672f(\u4e0a\u6d77)\u6709\u9650\u8d23\u4efb\u516c\u53f8"},"supplier":null,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[],"contactKeyRoles":[{"id":136,"key":136,"name":"\u6280\u672f\u51b3\u7b56\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"},"sign":"A","telephone_display":"","bgcolor":"#89c541"},{"id":5821,"name":"\u5df4\u96ea\u8273","email":"","pinyin_shortcut":"bxy","sex":"M","birth_date":null,"department":"IT","job_position":"","mobile":"","telephone":"","client_id":46,"supplier_id":null,"created_by":5300,"created_at":"2024-07-04 10:29:45","updated_at":"2024-07-04 10:29:45","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"ba","pinyin2":"xue","pinyin3":"yan","pinyin4":null,"namecut1":"\u5df4","namecut2":"\u96ea","namecut3":"\u8273","namecut4":null,"is_mp_bind":false,"client":{"id":46,"key":46,"name":"\u5317\u4eac\u4eac\u4e1c\u65b9\u663e\u793a\u6280\u672f\u6709\u9650\u516c\u53f8-\u4ea6\u5e84\uff08CAE\uff09"},"supplier":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5300,"key":5300,"name":"\u82cf\u6e05\u4e91","sex":"F","user_status":"1"},"mobiles":[{"id":6614,"contact_id":5821,"mobile":"15201297862","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null,"sign":"B","telephone_display":"","bgcolor":"#89c541"}],"pagenation":{"totalcount":3338,"thispage":1,"pagesize":20}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-11 16:22:19') RETURNING "id"
16:22:19.433traceyii\redis\Connection::executeCommandExecuting Redis Command: GET
16:22:19.433traceyii\redis\Connection::executeCommandExecuting Redis Command: SET