ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
68b1763744410: POST https://beta.jinchangxiao.com/v2/contact/save-new-for-supplier at 2025-08-29 05:43:19 pm by 124.64.23.198

Database Queries

总计19条数据
TimeDurationTypeQuery
  
17:43:19.2832.7 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='c1glbS3oPWuii9fAd_nsZY9pK1ntZvhw'

[+] Explain
17:43:19.2861.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446

[+] Explain
17:43:19.2900.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"='2')

[+] Explain
17:43:19.2910.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='718')

[+] Explain
17:43:19.2910.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446)

[+] Explain
17:43:19.2920.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_contact_statuses" WHERE "id"='2')

[+] Explain
17:43:19.2920.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='718')

[+] Explain
17:43:19.2920.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5446)

[+] Explain
17:43:19.2941.8 msINSERTINSERT INTO "a57be577deb434"."tbl_contacts" ("contact_type", "user_status", "telephone", "telephone_extension_number", "sex", "department", "supplier_id", "description", "birth_date", "contact_attitude", "email", "telephone_area_code", "job_position", "name", "created_by", "mobile", "pinyin_shortcut", "pinyin1", "namecut1") VALUES ('2', 2, '', '', 'M', '', 718, '', NULL, NULL, '', '', '', 'B', 5446, '', 'B', 'b', 'b') RETURNING "id"

[+] Explain
17:43:19.2961.2 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Contacts', 6127, 'a:31:{s:2:"id";i:6127;s:4:"name";s:1:"B";s:5:"email";s:0:"";s:15:"pinyin_shortcut";s:1:"B";s:3:"sex";s:1:"M";s:10:"birth_date";s:0:"";s:10:"department";s:0:"";s:12:"job_position";s:0:"";s:6:"mobile";s:0:"";s:9:"telephone";s:0:"";s:9:"client_id";N;s:11:"supplier_id";s:3:"718";s:10:"created_by";i:5446;s:10:"created_at";N;s:10:"updated_at";N;s:11:"user_status";s:1:"2";s:11:"description";s:0:"";s:12:"contact_type";s:1:"2";s:16:"contact_attitude";s:0:"";s:19:"telephone_area_code";s:0:"";s:26:"telephone_extension_number";s:0:"";s:10:"mp_open_id";N;s:7:"pinyin1";s:1:"b";s:7:"pinyin2";N;s:7:"pinyin3";N;s:7:"pinyin4";N;s:8:"namecut1";s:1:"b";s:8:"namecut2";N;s:8:"namecut3";N;s:8:"namecut4";N;s:10:"is_mp_bind";N;}', '', 5446, '124.64.23.198')

[+] Explain
17:43:19.2970.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='718'

[+] Explain
17:43:19.2980.9 msINSERTINSERT INTO "a57be577deb434"."tbl_contact_mobiles" ("mobile", "contact_id") VALUES ('13444444444', 6127)

[+] Explain
17:43:19.2990.3 msDELETEDELETE FROM "a57be577deb434"."tbl_contact_key_roles" WHERE contact_id = 6127

[+] Explain
17:43:19.2990.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_contacts" WHERE "id"=6127

[+] Explain
17:43:19.3001.0 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 6127, 15, 5446, '2025-08-29 17:43:19', '{"mobiles":null,"operation_status":null,"keyword":"","from":"","to":"","period":"","unread":0}', '{"mobiles":null,"operation_status":null,"keyword":"","from":"","to":"","period":"","unread":0}', '{"d1":"\u5218\u5a1f","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":[]}') RETURNING "id"

[+] Explain
17:43:19.3010.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 554487, 'a:13:{s:2:"id";i:554487;s:9:"object_id";i:6127;s:11:"object_type";i:15;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:94:"{"mobiles":null,"operation_status":null,"keyword":"","from":"","to":"","period":"","unread":0}";s:9:"new_value";s:94:"{"mobiles":null,"operation_status":null,"keyword":"","from":"","to":"","period":"","unread":0}";s:11:"description";s:81:"{"d1":"\u5218\u5a1f","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":[]}";s:10:"created_by";i:5446;s:10:"created_at";s:19:"2025-08-29 17:43:19";s:9:"is_delete";N;}', '', 5446, '124.64.23.198')

[+] Explain
17:43:19.3021.2 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "description") VALUES (1, 'create', 718, 12, 6127, 15, 5446, '6127', '6127', '{"d1":"\u5218\u5a1f","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["B"]}') RETURNING "id"

[+] Explain
17:43:19.3041.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 554488, 'a:13:{s:2:"id";i:554488;s:9:"object_id";i:718;s:11:"object_type";i:12;s:9:"target_id";i:6127;s:18:"target_object_type";i:15;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:4:"6127";s:9:"new_value";s:4:"6127";s:11:"description";s:84:"{"d1":"\u5218\u5a1f","d2":"\u521b\u5efa\u4e86","d3":"\u8054\u7cfb\u4eba","d4":["B"]}";s:10:"created_by";i:5446;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5446, '124.64.23.198')

[+] Explain
17:43:19.3051.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5446, 0, 266, 'v2/contact/save-new-for-supplier', '{"access_token":"c1glbS3oPWuii9fAd_nsZY9pK1ntZvhw","device_type":"0","Contacts":{"telephone":"","telephone_extension_number":"","sex":"M","department":"","user_status":"2","supplier_id":"718","description":"","birth_date":"","contact_attitude":"","email":"","telephone_area_code":"","job_position":"","name":"B","mobiles":["13444444444"]},"version_code":"266","token":"b6e26945a19e54eb36ea19d4adcfcc61","posttime":"1756460599"}', '{"code":200,"data":{"id":6127},"status":1,"msg":[{"name":"success","success":"\u65b0\u8054\u7cfb\u4eba\u5df2\u521b\u5efa\u6210\u529f","error":""}]}', FALSE, '2025-08-29 17:43:19') RETURNING "id"

[+] Explain