ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
688e14f462004: POST https://beta.jinchangxiao.com/v2/approve/save-edit at 2025-08-02 09:39:00 pm by 120.244.156.196

Database Queries

总计68条数据
TimeDurationTypeQuery
  
21:39:00.4052.8 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc'

[+] Explain
21:39:00.4082.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
21:39:00.4130.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"='1756'

[+] Explain
21:39:00.4160.7 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id"=1756) ORDER BY "id"

[+] Explain
21:39:00.4180.6 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')

[+] Explain
21:39:00.4190.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822')

[+] Explain
21:39:00.4190.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004)

[+] Explain
21:39:00.4200.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=1756

[+] Explain
21:39:00.4200.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (165, 179, 172, 166, 184, 189, 319, 349))

[+] Explain
21:39:00.4210.8 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=1756) AND ("term_id"=17)

[+] Explain
21:39:00.4220.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='319')

[+] Explain
21:39:00.4230.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=17)

[+] Explain
21:39:00.4231.1 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (17, 319, 1756) RETURNING "id"

[+] Explain
21:39:00.4251.0 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 118348, 'a:9:{s:2:"id";i:118348;s:9:"object_id";i:1756;s:11:"taxonomy_id";s:3:"319";s:7:"term_id";i:17;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4260.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815')

[+] Explain
21:39:00.4260.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822')

[+] Explain
21:39:00.4260.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004)

[+] Explain
21:39:00.4270.8 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "client_id"=2815, "project_id"=3822 WHERE "id"=1756

[+] Explain
21:39:00.4280.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Approves', 1756, 'a:0:{}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4291.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=1756)

[+] Explain
21:39:00.4301.1 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=1756)

[+] Explain
21:39:00.4310.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=1756 ORDER BY "id"

[+] Explain
21:39:00.4320.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1017'

[+] Explain
21:39:00.4330.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000'

[+] Explain
21:39:00.4330.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017

[+] Explain
21:39:00.4330.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000

[+] Explain
21:39:00.4340.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016

[+] Explain
21:39:00.4340.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250

[+] Explain
21:39:00.4350.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5329

[+] Explain
21:39:00.4350.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5085

[+] Explain
21:39:00.4361.1 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'approveVerifyRels', 1756, 37, 1004, 'now()', '[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f"]]', '[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5","\u970d\u4e1c\u9633"]]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;\u8463\u8363;\u9ad8\u5ce5;\u970d\u4e1c\u9633; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;\u66f9\u6c38\u751f;"]}')

[+] Explain
21:39:00.4370.9 msDELETEDELETE FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=1756

[+] Explain
21:39:00.4381.2 msINSERTINSERT INTO "a57be577deb434"."tbl_approve_verify_rels" ("approve_id", "user_id", "status") VALUES (1756, 1017, 0), (1756, 1000, 0)

[+] Explain
21:39:00.4390.9 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=1756

[+] Explain
21:39:00.4411.2 msDELETEDELETE FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=1756

[+] Explain
21:39:00.4421.3 msINSERTINSERT INTO "a57be577deb434"."tbl_approve_carbon_copy_rels" ("approve_id", "user_id") VALUES (1756, 5360), (1756, 5252), (1756, 5388), (1756, 5445)

[+] Explain
21:39:00.4440.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("approve_id"=1756) AND ("status"=0) ORDER BY "id"

[+] Explain
21:39:00.4450.9 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "updated_at"='now()' WHERE "id"=1756

[+] Explain
21:39:00.4460.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Approves', 1756, 'a:0:{}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4460.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004

[+] Explain
21:39:00.4470.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=1756) ORDER BY "id"

[+] Explain
21:39:00.4480.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=1756

[+] Explain
21:39:00.4480.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004)

[+] Explain
21:39:00.4491.1 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1004, '37', 1756, '伊峻辰 有一个审批需要审批', TRUE, '发发发') RETURNING "id"

[+] Explain
21:39:00.4500.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 170590, 'a:11:{s:2:"id";i:170590;s:9:"object_id";i:1756;s:11:"object_type";s:2:"37";s:6:"parent";N;s:11:"description";s:37:"伊峻辰 有一个审批需要审批";s:10:"created_by";i:1004;s:10:"created_at";N;s:8:"reply_to";N;s:9:"is_system";b:1;s:8:"for_user";N;s:12:"description2";s:9:"发发发";}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4511.0 msINSERTINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (1756, '37', 170590, 1017)

[+] Explain
21:39:00.4530.2 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1017) AND ("id" != 1004) AND (channel_id IS NOT NULL)

[+] Explain
21:39:00.4530.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'

[+] Explain
21:39:00.4540.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822'

[+] Explain
21:39:00.4550.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815'

[+] Explain
21:39:00.4571.2 msUPDATEUPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815

[+] Explain
21:39:00.4588.8 msSELECTSELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=2815) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
21:39:00.4671.1 msINSERTINSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id"

[+] Explain
21:39:00.4690.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165442, 'a:5:{s:2:"id";i:165442;s:9:"client_id";i:2815;s:9:"sales_rep";i:1004;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4700.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Clients', 2815, 'a:0:{}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4710.8 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 (2, 'update', 2815, 10, 1756, 37, 1004, '1756', '1756', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5f00\u7968"]}') RETURNING "id"

[+] Explain
21:39:00.4710.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 511125, 'a:13:{s:2:"id";i:511125;s:9:"object_id";s:4:"2815";s:11:"object_type";i:10;s:9:"target_id";i:1756;s:18:"target_object_type";i:37;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:4:"1756";s:9:"new_value";s:4:"1756";s:11:"description";s:119:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5f00\u7968"]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4720.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822'

[+] Explain
21:39:00.4731.0 msUPDATEUPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3822

[+] Explain
21:39:00.4751.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3822) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1

[+] Explain
21:39:00.4760.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Projects', 3822, 'a:0:{}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4770.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815

[+] Explain
21:39:00.4780.8 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 (2, 'update', 3822, 1, 1756, 37, 1004, '1756', '1756', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5f00\u7968"]}') RETURNING "id"

[+] Explain
21:39:00.4790.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', 511126, 'a:13:{s:2:"id";i:511126;s:9:"object_id";s:4:"3822";s:11:"object_type";i:1;s:9:"target_id";i:1756;s:18:"target_object_type";i:37;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:4:"1756";s:9:"new_value";s:4:"1756";s:11:"description";s:119:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5f00\u7968"]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4800.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815

[+] Explain
21:39:00.4801.0 msINSERTINSERT INTO "a57be577deb434"."tbl_user_action_logs" ("act", "attribute", "object_id", "object_type", "target_id", "target_object_type", "created_by", "new_value", "old_value", "users", "description") VALUES (2, 'update', 3822, 1, 1756, 37, 1004, '1756', '1756', array[1004], '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5f00\u7968"]}') RETURNING "id"

[+] Explain
21:39:00.4810.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 137313, 'a:15:{s:2:"id";i:137313;s:9:"object_id";s:4:"3822";s:11:"object_type";i:1;s:9:"target_id";i:1756;s:18:"target_object_type";i:37;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:4:"1756";s:9:"new_value";s:4:"1756";s:5:"users";O:17:"yii\db\Expression":2:{s:10:"expression";s:11:"array[1004]";s:6:"params";a:0:{}}s:11:"description";s:119:"{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":["\u6b63\u5e38\u5f00\u7968"]}";s:10:"created_by";i:1004;s:10:"created_at";N;s:9:"is_delete";N;s:9:"parent_id";N;}', '', 1004, '120.244.156.196')

[+] Explain
21:39:00.4831.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1004, 2, 1146, 'v2/approve/save-edit', '{"Approves":{"attachmentFiles":"","client_id":"2815","description":"vvvvv","form_approveCarbonCopyRels":["5360","5252","5388","5445"],"form_approveVerifyRels":["1017","1000"],"form_type":"319","id":"1756","project_id":"3822","title":"\u53d1\u53d1\u53d1"},"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","posttime":"1754141952","token":"0ff91fed2b1d1a222da988f8caadea07","version_code":"1146"}', '{"code":200,"data":"","status":1,"msg":[{"name":"success","success":"\u5ba1\u6279\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}]}', FALSE, '2025-08-02 21:39:00') RETURNING "id"

[+] Explain