ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
686383a619c8c: POST https://beta.jinchangxiao.com/v2/client/list at 2025-07-01 02:43:50 pm by 223.104.41.148

Performance Profiling

Total processing time: 349 ms; Peak memory: 4.807 MB. Show Profiling Timeline

总计38条数据
TimeDurationCategoryInfo
  
14:43:50.16353.7 msyii\db\Command::querySELECT COUNT(*) FROM (SELECT c.*, CASE WHEN p.client_id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, sl.lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, sl.last_contact, max(arrive.end_at) as last_arrive, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cl.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cl.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cl.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cl.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 182::float END) / cl.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 182::float END) / cl.visit_base::float) END) ELSE 20 END) + (CASE WHEN cl.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cl.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cl.cooperate_base END) ELSE 20 END) + (CASE WHEN cl.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cl.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cl.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cl.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cl.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cl.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%%' GROUP BY "client_id") "cc" ON cc.client_id = c.id WHERE ("c"."sales_rep"='5295') AND ("c"."sales_rep"='5295') AND ("client_class"='1') AND ("deleted"=FALSE) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC, lost_contact_days ASC NULLS LAST, "c"."created_at" DESC) "c"
14:43:50.36146.2 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (443, 3662, 991, 3661, 293, 5149, 5144)
14:43:50.21734.5 msyii\db\Command::querySELECT c.*, CASE WHEN p.client_id IS NULL THEN false ELSE true END AS cooperated, CASE WHEN c.sales_rep IS NULL THEN 0 ELSE 1 END AS is_public, sl.lost_contact_days, extract(epoch from (now() - max(arrive.end_at))) / 86400 AS last_arrive_days, sl.last_contact, max(arrive.end_at) as last_arrive, CASE WHEN c.client_class IS NOT NULL THEN ( (CASE WHEN cl.contact_base > 0 THEN floor(CASE WHEN c.contact_count > cl.contact_base THEN 1 * 15 ELSE c.contact_count * 15 / cl.contact_base END) ELSE 15 END) + floor(c.client_base_info_count * 15 / 9) + (CASE WHEN cl.visit_base > 0 THEN floor(CASE WHEN c.visit_count > ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 182::float END) / cl.visit_base::float) THEN 1 * 20 ELSE c.visit_count * 20 / ceil((CASE WHEN extract(year from now()) = extract(year from c.created_at::date) THEN (now()::date - c.created_at::date + 1)::float ELSE 182::float END) / cl.visit_base::float) END) ELSE 20 END) + (CASE WHEN cl.cooperate_base > 0 THEN floor(CASE WHEN c.cooperate_count > cl.cooperate_base THEN 1 * 20 ELSE c.cooperate_count * 20 / cl.cooperate_base END) ELSE 20 END) + (CASE WHEN cl.case_pre_sales_base > 0 THEN floor(CASE WHEN c.case_pre_sales_count > cl.case_pre_sales_base THEN 1 * 15 ELSE c.case_pre_sales_count * 15 / cl.case_pre_sales_base END) ELSE 15 END) + (CASE WHEN cl.case_implement_base > 0 THEN floor(CASE WHEN c.case_implement_count > cl.case_implement_base THEN 1 * 15 ELSE c.case_implement_count * 15 / cl.case_implement_base END) ELSE 15 END) ) ELSE NULL END as score FROM "a57be577deb434"."tbl_clients" "c" LEFT JOIN "a57be577deb434"."tbl_sales_group_relationships" "sgr" ON sgr.sales_id = c.sales_rep LEFT JOIN "a57be577deb434"."tbl_client_classes" "cl" ON cl.id = c.client_class LEFT JOIN "a57be577deb434"."tbl_client_address_rels" "car" ON car.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_addresses" "a" ON car.address_id = a.id LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_projects" WHERE "project_status"=3 GROUP BY "client_id") "p" ON p.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_work_logs" "arrive" ON (arrive.client_id = c.id) AND ("arrive"."scenario_id"=1) AND ("arrive"."is_draft"=FALSE) AND ("arrive"."location_in_id" IS NOT NULL) AND ("arrive"."location_out_id" IS NOT NULL) AND ("arrive"."client_id" IS NOT NULL) LEFT JOIN (SELECT extract(epoch from (now() - max(end_at))) / 86400 AS lost_contact_days, max(end_at) as last_contact, client_id FROM "a57be577deb434"."tbl_work_logs" WHERE "is_draft"=FALSE GROUP BY "client_id") "sl" ON sl.client_id = c.id LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "ttr" ON ttr.object_id = c.id AND ttr.term_id = 14 LEFT JOIN (SELECT "client_id" FROM "a57be577deb434"."tbl_contacts" WHERE lower(name) LIKE '%%' GROUP BY "client_id") "cc" ON cc.client_id = c.id WHERE ("c"."sales_rep"='5295') AND ("c"."sales_rep"='5295') AND ("client_class"='1') AND ("deleted"=FALSE) GROUP BY "c"."id", "cl"."id", "cooperated", "lost_contact_days", "last_contact" ORDER BY "is_public" DESC, lost_contact_days ASC NULLS LAST, "c"."created_at" DESC LIMIT 10
14:43:50.27326.3 msyii\db\Command::querySELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=10) AND ("object_id"=90) GROUP BY "object_id"
14:43:50.41123.6 msyii\db\Command::querySELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=10) AND (remind_user_id = 5295 AND is_read = false) AND ("object_id"=90) GROUP BY "object_id"
14:43:50.30715.0 msyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(left_at - arrived_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_implement_records" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=2) AND ("c"."client_id"=90) GROUP BY "c"."client_id"
14:43:50.32310.1 msyii\db\Command::querySELECT "c"."client_id", sum(hours), sum(times) as times FROM "a57be577deb434"."tbl_cases" "c" LEFT JOIN (SELECT "case_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_pre_sales" WHERE "is_draft"=FALSE GROUP BY "case_id") "i" ON i.case_id = c.id WHERE ("case_type"=1) AND ("c"."client_id"=90) GROUP BY "c"."client_id"
14:43:50.4368.8 msyii\db\Command::querySELECT *, geolocation[0] AS lng, geolocation[1] AS lat FROM "a57be577deb434"."tbl_addresses" WHERE ("address2" != '') AND ("address2" IS NOT NULL) AND ("id" IN (3996, 3997))
14:43:50.1348.2 msyii\db\Connection::openOpening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta
14:43:50.3427.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "client_id"=90
14:43:50.2577.0 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=90
14:43:50.1424.7 msyii\db\Command::querySELECT * FROM "global"."vw_user_login" WHERE "access_token"='aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b'
14:43:50.3564.3 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (443, 3662, 991, 3661, 293, 5149, 5144)
14:43:50.2643.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=14) AND ("id" IN (45, 6, 212, 165, 179, 142, 183, 187, 210, 231, 5, 207, 229, 1, 224, 2, 223, 214, 8, 9, 208, 211, 226, 227, 7, 216, 93, 228, 11, 209, 94, 217, 10, 213, 221, 225, 215, 222, 106, 112, 317, 372)) ORDER BY "sort"
14:43:50.3383.4 msyii\db\Command::querySELECT "id", "id" AS "key", "address" AS "name", "client_id" FROM "a57be577deb434"."tbl_client_addresses" WHERE "client_id"=90
14:43:50.4483.4 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', 5295, 2, 1141, 'v2/client/list', '{"ClientSearch":{"clientFrom":"","client_class":"1","client_industry":"","client_type":"","company_nature":"","cooperated":"","sales_rep":"5295"},"access_token":"aqasSz_RSaWdjUP8D1Z84eLdkCaCqi8b","device_type":"2","lat":"39.96028971354167","lng":"116.2889219835069","posttime":"1751352192","token":"dc5eac9e463a2cf5c4b88c7a02ea41cf","version_code":"1141"}', '{"code":200,"data":{"list":[{"id":90,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","abbr":null,"pinyin_shortcut":"slsccbxzgyxgsslsccbxzgyxgsbjfgs","description":"\u603b\u90e8\u5728\u745e\u58eb","corp_rep":"\u4e8e\u7490\u5dcd","website":"www.baoxian999.cn","capital":"92200","established_at":"2013-07-02","headcount":"500","reg_address":670,"working_address":null,"telephone":"021-20895500","fax":"","scale":"10\u4ebf","branch":"","purchase_scale_per_yr":"100","purchase_freq":"2","company_nature":6,"client_class":1,"client_industry":10,"client_type":1,"sales_rep":5295,"main_contact":null,"created_by":1006,"created_at":"2017-02-21 11:34:20","updated_at":"2025-04-19 16:40:58","main_business":"\u7406\u8d54\u5728\u7ebf\u62a5\u6848\u7cfb\u7edf\uff0c\u4fdd\u5355\u67e5\u8be2\u7cfb\u7edf\uff0cOA\u7cfb\u7edf\uff0c\u8d22\u52a1\u7cfb\u7edf\u3002","deleted":false,"capital_currency":"rmb","invoice_info":"","logo":null,"en_name":"","pick_at":"2021-06-03 15:44:50","it_budget":"200\u4e07","deployment_mode":"\u672c\u5730\u90e8\u7f72","it_per_num":"3-4\u4eba","public_relations_difficulty":"","it_status":"IBM\uff0fDELL\u670d\u52a1\u5668\uff0c\u5c0f\u578b\u673a\uff0cNETAPP\u5b58\u50a8\uff0cPA\u9632\u706b\u5899\uff0c\u7528\u7684\u90fd\u662f\u56fd\u5916\u54c1\u724c","decision_process":"\u6280\u672f\u2014\u9886\u5bfc\u2014\u6280\u672f","coach":"\u5b59\u51ef","competitor":"\u65e0","peers":"","supplier":"\u65e0","main_product":"1.\u8d22\u4ea7\u4fdd\u9669\uff1a\u5bf9\u4eba\u6216\u4f01\u4e1a\u7684\u7269\u8d44\u8d22\u4ea7\u8fdb\u884c\u4fdd\u9669\n2.\u8d23\u4efb\u4fdd\u9669\uff1a\u6bd4\u5982\u8f66\u9669\u5c31\u662f\u8d23\u4efb\u4fdd\u9669\u7684\u4e00\u79cd\uff0c\u5c31\u662f\u66ff\u4eba\u8d54\u507f\u5e94\u627f\u62c5\u8d23\u4efb\u7684\u94b1\u3002\n3.\u77ed\u671f\u5065\u5eb7\u4fdd\u9669\uff1a\u5c31\u662f\u4eba\u7684\u610f\u5916\u4f24\u5bb3\u4fdd\u9669","client_base_info_count":6,"client_key_info_count":12,"contact_count":6,"visit_count":2,"cooperate_count":5,"case_pre_sales_count":2,"case_implement_count":2,"is_overdue_remind":false,"from_contact":null,"cooperated":true,"is_public":1,"lost_contact_days":"109.985997928657","last_arrive_days":"124.106136817546","last_contact":"2025-03-13 15:04:00","last_arrive":"2025-02-27 12:11:00+08","score":"58","clientType":{"id":1,"key":1,"name":"\u653f\u5e9c"},"clientClass":{"id":1,"key":1,"name":"\u6838\u5fc3\u5ba2\u6237","notice_days":10,"color":"#E89F0E","visit_base":7},"clientFrom":null,"clientIndustry":{"id":10,"key":10,"name":"\u91d1\u878d"},"companyNature":{"id":6,"key":6,"name":"\u5916\u8d44\u4f01\u4e1a"},"salesRep":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","client_lock":true,"avatar":{"id":137,"user_id":5295,"name":"\/files\/cdn\/a57be577deb434\/avatar\/85c67d90-6989-3d4e-bbf8-31d69b6e8ffe.jpg"}},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","department_id":1,"avatar":{"id":3,"user_id":1006,"name":"\/files\/cdn\/a57be577deb434\/avatar\/1006.jpg"},"department":{"id":1,"key":1,"name":"\u9500\u552e\u90e8"}},"commentCount":{"object_id":90,"comment":49},"workingAddress":null,"unCloseCases":[{"id":8245,"client_id":90},{"id":8249,"client_id":90}],"workLogCount":{"client_id":90,"count":317},"caseCount":{"client_id":90,"count":136},"salesTimeCount":{"client_id":90,"hours":"58.4005555555556","times":44},"implementTimeCount":{"client_id":90,"sum":"419.902777777778","times":"118"},"presalesTimeCount":{"client_id":90,"sum":"34.1752777777778","times":"19"},"engineerTimeCount":{"client_id":90,"hours":"11.5","times":2},"reimbursementAmountSum":{"client_id":90,"sum":"45440.19"},"addresses":[{"id":169,"key":169,"name":"\u671d\u9633\u533a\u66d9\u5149\u897f\u91cc\u75325\u53f7\u966221\u53f7\u697c\u51e4\u51f0\u7f6e\u5730\u5e7f\u573aF\u5ea76\u5c42","client_id":90},{"id":170,"key":170,"name":"\u4e2d\u56fd\uff08\u4e0a\u6d77\uff09\u81ea\u7531\u8d38\u6613\u8bd5\u9a8c\u533a\u4e16\u7eaa\u5927\u9053100\u53f7\u73af\u7403\u91d1\u878d\u4e2d\u5fc316\u697cT20","client_id":90}],"contacts":[{"id":443,"name":"\u5b59\u51ef","email":"kai.sun@zurich.com","pinyin_shortcut":"sk","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u4fe1\u606f\u4e2d\u5fc3\u4e3b\u4efb","mobile":null,"telephone":"84547860","client_id":90,"supplier_id":null,"created_by":1006,"created_at":"2017-03-28 13:39:44","updated_at":"2019-01-11 10:38:19","user_status":2,"description":"","contact_type":"1","contact_attitude":2,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":"oagch6b--laeW4GGf0v1j0DBFhUc","pinyin1":"sun","pinyin2":"kai","pinyin3":null,"pinyin4":null,"namecut1":"\u5b59","namecut2":"\u51ef","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1006,"key":1006,"name":"\u6731\u5bb8\u96e8","sex":"F","user_status":"-1"},"mobiles":[{"id":2489,"contact_id":443,"mobile":"13501278068","mp_open_id":"oagch6b--laeW4GGf0v1j0DBFhUc"}],"contactKeyRoles":[{"id":133,"key":133,"name":"\u603b\u51b3\u7b56\u4eba"},{"id":134,"key":134,"name":"\u8d22\u52a1\u51b3\u7b56\u4eba"},{"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"}},{"id":3662,"name":"\u9b4f\u6cfd\u6587","email":"","pinyin_shortcut":"wzw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2021-07-08 15:43:57","updated_at":"2021-07-08 15:43:57","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6WylEpz3T5IwaJCijWrYh94","pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":null,"namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":4329,"contact_id":3662,"mobile":"18601965887","mp_open_id":"oagch6WylEpz3T5IwaJCijWrYh94"}],"contactKeyRoles":[],"contactAttitude":null},{"id":991,"name":"\u675c\u4fca","email":"","pinyin_shortcut":"dj","sex":"M","birth_date":null,"department":"\u6280\u672f\u90e8","job_position":"\u6280\u672f","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":1023,"created_at":"2017-07-22 10:46:59","updated_at":"2021-04-19 16:51:15","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"du","pinyin2":"jun","pinyin3":null,"pinyin4":null,"namecut1":"\u675c","namecut2":"\u4fca","namecut3":null,"namecut4":null,"is_mp_bind":null,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1023,"key":1023,"name":"\u5468\u5b50\u5065","sex":"M","user_status":"1"},"mobiles":[{"id":4166,"contact_id":991,"mobile":"13918058385","mp_open_id":null}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":3661,"name":"\u9b4f\u6cfd\u6587","email":"","pinyin_shortcut":"wzw","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2021-07-08 15:43:56","updated_at":"2021-07-08 15:43:56","user_status":1,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":null,"pinyin1":"wei","pinyin2":"ze","pinyin3":"wen","pinyin4":null,"namecut1":"\u9b4f","namecut2":"\u6cfd","namecut3":"\u6587","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":1,"key":1,"name":"\u79bb\u804c"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":4328,"contact_id":3661,"mobile":"18601965887","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":293,"name":"\u5468\u5b87\u98de","email":"shane.zhou@zurich.com","pinyin_shortcut":"zyf","sex":"M","birth_date":null,"department":"\u4fe1\u606f\u90e8","job_position":"\u8fd0\u7ef4\u5de5\u7a0b\u5e08","mobile":"","telephone":"01084547861","client_id":90,"supplier_id":null,"created_by":1021,"created_at":"2017-03-07 17:46:28","updated_at":"2021-04-25 19:35:17","user_status":2,"description":"","contact_type":"1","contact_attitude":1,"telephone_area_code":"","telephone_extension_number":"","mp_open_id":"oagch6Thfxj2WTnYv5CWgnW4ptuU","pinyin1":"zhou","pinyin2":"yu","pinyin3":"fei","pinyin4":null,"namecut1":"\u5468","namecut2":"\u5b87","namecut3":null,"namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":1021,"key":1021,"name":"\u6c6a\u6653\u50b2","sex":"M","user_status":"-1"},"mobiles":[{"id":4198,"contact_id":293,"mobile":"13671022772","mp_open_id":"oagch6Thfxj2WTnYv5CWgnW4ptuU"}],"contactKeyRoles":[{"id":160,"key":160,"name":"\u666e\u901a\u4eba"}],"contactAttitude":{"id":140,"key":140,"name":"\u4e2d\u7acb"}},{"id":5149,"name":"\u5b8b\u5609\u660e","email":"","pinyin_shortcut":"sjm","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2024-01-08 09:44:04","updated_at":"2024-01-08 09:44:04","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"song","pinyin2":"jia","pinyin3":"ming","pinyin4":null,"namecut1":"\u5b8b","namecut2":"\u5609","namecut3":"\u660e","namecut4":null,"is_mp_bind":false,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":5936,"contact_id":5149,"mobile":"15021452550","mp_open_id":null}],"contactKeyRoles":[],"contactAttitude":null},{"id":5144,"name":"\u8d75\u91d1\u7a0b","email":"","pinyin_shortcut":"zjc","sex":"M","birth_date":null,"department":"","job_position":"","mobile":"","telephone":"","client_id":90,"supplier_id":null,"created_by":5295,"created_at":"2024-01-03 11:01:28","updated_at":"2024-02-20 15:28:09","user_status":2,"description":"","contact_type":"1","contact_attitude":null,"telephone_area_code":"010","telephone_extension_number":"","mp_open_id":null,"pinyin1":"zhao","pinyin2":"jin","pinyin3":"cheng","pinyin4":null,"namecut1":"\u8d75","namecut2":"\u91d1","namecut3":"\u7a0b","namecut4":null,"is_mp_bind":true,"contactStatus":{"id":2,"key":2,"name":"\u5728\u804c"},"createdBy":{"id":5295,"key":5295,"name":"\u9b4f\u6cfd\u6587","sex":"F","user_status":"1"},"mobiles":[{"id":5931,"contact_id":5144,"mobile":"13602159075","mp_open_id":"oagch6UFe3mx9ON7HIBpToY84YWE"}],"contactKeyRoles":[],"contactAttitude":null}],"unreadComments":null,"fromContact":null,"workingAddresses":[{"id":3996,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","address1":"","address2":"\u5317\u4eac\u5e02\u671d\u9633\u533a\u51e4\u51f0\u7f6e\u5730\u5e7f\u573aF\u5ea7\u5199\u5b57\u697c","state":"\u5317\u4eac\u5e02","city":"\u5e02\u8f96\u533a","region":"\u671d\u9633\u533a","zip":null,"country":"\u4e2d\u56fd","geolocation":"(116.457,39.96239)","created_by":5295,"created_at":"2024-11-12 09:10:59","updated_at":"2024-11-12 09:10:59","state_id":110000,"city_id":110100,"region_id":110105,"country_id":1,"lng":"116.457","lat":"39.96239"},{"id":3997,"name":"\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\uff08\u82cf\u9ece\u4e16\u8d22\u4ea7\u4fdd\u9669(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8 \uff09","address1":"\u4e0a\u6d77\u5e02\u6d66\u4e1c\u65b0\u533a\u4e16\u7eaa\u5927\u9053100\u53f7","address2":"\u4e0a\u6d77\u5e02\u4e0a\u6d77\u5e02\u6d66\u4e1c\u65b0\u533a\u4e16\u7eaa\u5927\u9053100\u53f7\u73af\u7403\u91d1\u878d\u4e2d\u5fc332\u697cT12","state":"\u4e0a\u6d77\u5e02","city":"\u5e02\u8f96\u533a","region":"\u6d66\u4e1c\u65b0\u533a","zip":null,"country":"\u4e2d\u56fd","geolocation":"(121.5078,31.23429)","created_by":5295,"created_at":"2024-11-12 09:10:59","updated_at":"2024-11-12 09:10:59","state_id":310000,"city_id":310100,"region_id":310115,"country_id":1,"lng":"121.5078","lat":"31.23429"}],"unread":0,"lost_contact_days_display":"3\u4e2a\u6708\u524d","last_arrive_days_display":"4\u4e2a\u6708\u524d","bgcolor":"#E89F0E","overdue_display":"\u903e\u671f100\u5929\u672a\u8054\u7cfb","last_arrive_overdue_display":"\u903e\u671f118\u5929\u672a\u62dc\u8bbf","can_pick_up":false,"can_transfer":false,"can_update":true,"can_delete":false,"can_give_up":false,"can_create_contact":true,"can_edit_contact":true,"can_create_reimbursement":true,"can_create_schedule":true,"can_create_work_log":false}],"pagenation":{"totalcount":1,"thispage":1,"pagesize":10},"can_create":true},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-07-01 14:43:50') RETURNING "id"
14:43:50.3503.0 msyii\db\Command::querySELECT "id", "id" AS "key", "status" AS "name" FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id" IN (2, 1)
14:43:50.3352.7 msyii\db\Command::querySELECT "client_id", sum(amount) AS sum FROM "a57be577deb434"."tbl_reimbursements" WHERE ("status" IN (3, 2)) AND ("client_id"=90) GROUP BY "client_id"
14:43:50.3542.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1006, 5295, 1023, 1021)
14:43:50.3002.4 msyii\db\Command::querySELECT "id", "client_id" FROM "a57be577deb434"."tbl_cases" WHERE ("case_status" NOT IN (5, 6)) AND ("client_id"=90)
14:43:50.1491.9 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
14:43:50.2541.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_types" WHERE "id"=1
14:43:50.3041.4 msyii\db\Command::querySELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_cases" WHERE "client_id"=90 GROUP BY "client_id"
14:43:50.3031.1 msyii\db\Command::querySELECT "client_id", count(id) as count FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("client_id"=90) GROUP BY "client_id"
14:43:50.3061.0 msyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=1) AND (("location_in_id" IS NOT NULL) AND ("location_out_id" IS NOT NULL) AND ("client_id" IS NOT NULL)) AND ("client_id"=90) GROUP BY "client_id"
14:43:50.3341.0 msyii\db\Command::querySELECT "client_id", EXTRACT(epoch FROM sum(end_at - start_at)) /3600 AS hours, count(id) as times FROM "a57be577deb434"."tbl_work_logs" WHERE ("is_draft"=FALSE) AND ("scenario_id"=2) AND ("client_id"=90) GROUP BY "client_id"
14:43:50.4090.8 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (443, 3662, 991, 3661, 293, 5149, 5144)
14:43:50.2700.8 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=5295)
14:43:50.4080.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=11) AND ("id" IN (46, 107, 102, 197, 199, 198, 202, 229, 142, 133, 134, 135, 136, 137, 139, 185, 191, 164, 167, 2, 6, 8, 2100000000, 7, 9, 153, 160, 140, 204, 165, 179, 1, 226, 313, 114, 184, 189, 324, 344, 349, 369, 377, 319, 215, 232)) ORDER BY "sort"
14:43:50.2720.7 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=1
14:43:50.2680.6 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_client_industries" WHERE "id"=10
14:43:50.2690.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_company_natures" WHERE "id"=6
14:43:50.4100.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=12) AND ("id" IN (46, 107, 102, 197, 199, 198, 202, 229, 142, 133, 134, 135, 136, 137, 139, 185, 191, 164, 167, 2, 6, 8, 2100000000, 7, 9, 153, 160, 140, 204, 165, 179, 1, 226, 313, 114, 184, 189, 324, 344, 349, 369, 377, 319, 215, 232)) ORDER BY "sort"
14:43:50.2690.5 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "client_lock" FROM "a57be577deb434"."tbl_users" WHERE "id"=5295
14:43:50.4350.5 msyii\db\Command::querySELECT * FROM "a57be577deb434"."tbl_client_address_rels" WHERE "client_id"=90
14:43:50.2560.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "notice_days", "color", "visit_base" FROM "a57be577deb434"."tbl_client_classes" WHERE "id"=1
14:43:50.2710.3 msyii\db\Command::querySELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1006
14:43:50.2720.3 msyii\db\Command::querySELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1006)