ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
All Latest
6a2ab130a4b0e: POST https://beta.jinchangxiao.com/v2/search/all-contact at 2026-06-11 08:59:28 pm by 125.78.87.174

Database Queries

总计7条数据
TimeDurationTypeQuery
  
20:59:28.6790.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC'

[+] Explain
20:59:28.6810.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
20:59:28.6826.0 msSELECTSELECT "id", "id" AS "key", "name", "telephone", "telephone_area_code", "telephone_extension_number", "sex", "client_id", "supplier_id" FROM "a57be577deb434"."tbl_contacts" WHERE ("name" ILIKE '%an%') OR ("pinyin_shortcut" ILIKE '%an%') ORDER BY "pinyin_shortcut", "created_at" DESC

[+] Explain
20:59:28.6890.6 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id" IN (57, 530, 23, 3210, 1464, 473, 2838)

[+] Explain
20:59:28.6900.3 msSELECTSELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (71, 670)

[+] Explain
20:59:28.6900.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_contact_mobiles" WHERE "contact_id" IN (2490, 731, 4556, 3821, 552, 5694, 2844, 5960, 1044, 5773)

[+] Explain
20:59:28.6931.5 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time", "duration") VALUES (200, 'a57be577deb434', 1001, 7, 176, 'v2/search/all-contact', '{"name":"an","posttime":"1781182768","access_token":"lLLCHpZSQkMu0_ceemp9PVo8_3HEKkFC","device_type":"7","version_code":"176","token":"2eae0247b56bb850f8fd6b04faff9bbb"}', '{"code":200,"data":[{"id":2490,"key":2490,"name":"Anna","telephone":"59293023","telephone_area_code":"010","telephone_extension_number":"","sex":"F","client_id":null,"supplier_id":71,"client":null,"supplier":{"id":71,"key":71,"name":"\u8054\u60f3\u51cc\u62d3\u79d1\u6280\u6709\u9650\u516c\u53f8"},"mobiles":[{"id":4244,"contact_id":2490,"mobile":"18614062571","mp_open_id":null}]},{"id":731,"key":731,"name":"armand","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":57,"supplier_id":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,"mobiles":[]},{"id":4556,"key":4556,"name":"Carry Wang","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":530,"supplier_id":null,"client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)"},"supplier":null,"mobiles":[{"id":5366,"contact_id":4556,"mobile":"15101104104","mp_open_id":"oagch6QL0TgpmL_ZtYhgkCMLl4oY"}]},{"id":3821,"key":3821,"name":"Hannah Li","telephone":"64448900","telephone_area_code":"010","telephone_extension_number":"6713","sex":"M","client_id":530,"supplier_id":null,"client":{"id":530,"key":530,"name":"\u54c8\u7f57\u56fd\u9645\u5b66\u6821(\u5317\u4eac\u5e02\u671d\u9633\u533a\u793c\u5fb7\u5b66\u6821)"},"supplier":null,"mobiles":[{"id":4700,"contact_id":3821,"mobile":"15814210148","mp_open_id":null}]},{"id":552,"key":552,"name":"Steve Grant","telephone":"","telephone_area_code":null,"telephone_extension_number":null,"sex":"M","client_id":23,"supplier_id":null,"client":{"id":23,"key":23,"name":"\u5a01\u8baf\u8054\u5408\u534a\u5bfc\u4f53(\u5317\u4eac)\u6709\u9650\u516c\u53f8"},"supplier":null,"mobiles":[{"id":530,"contact_id":552,"mobile":"","mp_open_id":null}]},{"id":5694,"key":5694,"name":"TinaZhang","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":3210,"supplier_id":null,"client":{"id":3210,"key":3210,"name":"IEEEFTSCarchipsCTO"},"supplier":null,"mobiles":[{"id":6476,"contact_id":5694,"mobile":"15921400278","mp_open_id":null}]},{"id":2844,"key":2844,"name":"TOM ZHANG","telephone":"","telephone_area_code":"","telephone_extension_number":"","sex":"M","client_id":1464,"supplier_id":null,"client":{"id":1464,"key":1464,"name":"\u82cf\u5dde\u4e39\u534e\u541b\u90fd\u623f\u5730\u4ea7\u5f00\u53d1\u6709\u9650\u516c\u53f8-\u5916\u5730"},"supplier":null,"mobiles":[{"id":2965,"contact_id":2844,"mobile":"13584848970","mp_open_id":null}]},{"id":5960,"key":5960,"name":"\u738b\u7ed8\u82b3\uff08Fenny Wang\uff09","telephone":"57379188","telephone_area_code":"010","telephone_extension_number":"","sex":"F","client_id":null,"supplier_id":670,"client":null,"supplier":{"id":670,"key":670,"name":"\u817e\u8010\u4fdd\u7f51\u7edc\u79d1\u6280\uff08\u4e0a\u6d77\uff09\u6709\u9650\u516c\u53f8\u5317\u4eac\u5206\u516c\u53f8"},"mobiles":[{"id":6749,"contact_id":5960,"mobile":"18614053635","mp_open_id":null}]},{"id":1044,"key":1044,"name":"William Zhang","telephone":"+86 512 6733 2010","telephone_area_code":null,"telephone_extension_number":null,"sex":"M","client_id":473,"supplier_id":null,"client":{"id":473,"key":473,"name":"\u8f89\u58eb\u5c14\u533b\u836f\u6280\u672f(\u82cf\u5dde)\u6709\u9650\u516c\u53f8-\u5916\u5730"},"supplier":null,"mobiles":[{"id":1035,"contact_id":1044,"mobile":" 177 0621 8296","mp_open_id":null}]},{"id":5773,"key":5773,"name":"Yanrou Cai","telephone":"65102070","telephone_area_code":"010","telephone_extension_number":"","sex":"F","client_id":2838,"supplier_id":null,"client":{"id":2838,"key":2838,"name":"\u8d5b\u514b\u8c31\u79d1\u6280\uff08\u5317\u4eac\uff09\u6709\u9650\u516c\u53f8(\u8fc7\u5355)"},"supplier":null,"mobiles":[{"id":6565,"contact_id":5773,"mobile":"18224029846","mp_open_id":null}]}],"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"ip":"125.78.87.174","ua":"jinchangxiao\/1.0.40 (emulator emulator; HarmonyOS 6.1.0)"}', FALSE, '2026-06-11 20:59:28', 16444928) RETURNING "id"

[+] Explain