688e130cd15ee: POST https://beta.jinchangxiao.com/v2/approve/save-edit at 2025-08-02 09:30:52 pm by 120.244.156.196
Database Queries
总计85条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 21:30:52.861 | 2.8 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc' |
| 21:30:52.865 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 21:30:52.867 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"='1756' |
| 21:30:52.870 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id"=1756) ORDER BY "id" |
| 21:30:52.872 | 0.6 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
| 21:30:52.872 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822') |
| 21:30:52.873 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 21:30:52.873 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=1756 |
| 21:30:52.874 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (165, 179, 172, 166, 184, 189, 319, 349)) |
| 21:30:52.875 | 0.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=1756) AND ("term_id"=17) |
| 21:30:52.876 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='319') |
| 21:30:52.876 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=17) |
| 21:30:52.877 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (17, 319, 1756) RETURNING "id" |
| 21:30:52.878 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 118346, 'a:9:{s:2:"id";i:118346;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') |
| 21:30:52.880 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815') |
| 21:30:52.880 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822') |
| 21:30:52.880 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 21:30:52.881 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_approves" SET "client_id"=2815, "project_id"=3822 WHERE "id"=1756 |
| 21:30:52.882 | 0.8 ms | INSERT | INSERT 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') |
| 21:30:52.883 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=1756) |
| 21:30:52.884 | 1.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=1756) |
| 21:30:52.885 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=1756 ORDER BY "id" |
| 21:30:52.886 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1017' |
| 21:30:52.887 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1000' |
| 21:30:52.887 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5016' |
| 21:30:52.887 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5250' |
| 21:30:52.888 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5329' |
| 21:30:52.888 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5085' |
| 21:30:52.889 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1017 |
| 21:30:52.889 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
| 21:30:52.889 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
| 21:30:52.890 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 21:30:52.890 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5329 |
| 21:30:52.891 | 1.1 ms | INSERT | INSERT 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","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5","\u970d\u4e1c\u9633"]]', '[["\u8f66\u660e\u98de","\u66f9\u6c38\u751f","\u9ad8\u90e1\u9633","\u8463\u8363","\u9ad8\u5ce5"]]', '{"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; <b>\u53d8\u4e3a<\/b> \u8f66\u660e\u98de;\u66f9\u6c38\u751f;\u9ad8\u90e1\u9633;\u8463\u8363;\u9ad8\u5ce5;\u970d\u4e1c\u9633;"]}') |
| 21:30:52.892 | 0.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=1756 |
| 21:30:52.893 | 1.5 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_approve_verify_rels" ("approve_id", "user_id", "status") VALUES (1756, 1017, 0), (1756, 1000, 0), (1756, 5016, 0), (1756, 5250, 0), (1756, 5329, 0), (1756, 5085, 0) |
| 21:30:52.894 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=1756 |
| 21:30:52.895 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5360' |
| 21:30:52.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5252' |
| 21:30:52.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5388' |
| 21:30:52.896 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5445' |
| 21:30:52.897 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5250' |
| 21:30:52.897 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5016' |
| 21:30:52.898 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='5085' |
| 21:30:52.898 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5360 |
| 21:30:52.898 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
| 21:30:52.899 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5388 |
| 21:30:52.899 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5445 |
| 21:30:52.900 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5250 |
| 21:30:52.900 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5016 |
| 21:30:52.900 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'approveCarbonCopyRels', 1756, 37, 1004, 'now()', '[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363","\u9ad8\u90e1\u9633","\u970d\u4e1c\u9633"]]', '[["\u5f20\u7ea2\u82b3","\u738b\u7b11\u7b11","\u6768\u71d5\u971e","\u674e\u9896","\u8463\u8363","\u9ad8\u90e1\u9633"]]', '{"d1":"\u4f0a\u5cfb\u8fb0","d2":"\u66f4\u65b0\u4e86","d3":"\u6284\u9001\u4eba","d4":["\u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;\u9ad8\u90e1\u9633; <b>\u53d8\u4e3a<\/b> \u5f20\u7ea2\u82b3;\u738b\u7b11\u7b11;\u6768\u71d5\u971e;\u674e\u9896;\u8463\u8363;\u9ad8\u90e1\u9633;\u970d\u4e1c\u9633;"]}') |
| 21:30:52.901 | 0.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=1756 |
| 21:30:52.902 | 1.3 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_approve_carbon_copy_rels" ("approve_id", "user_id") VALUES (1756, 5360), (1756, 5252), (1756, 5388), (1756, 5445), (1756, 5250), (1756, 5016), (1756, 5085) |
| 21:30:52.904 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("approve_id"=1756) AND ("status"=0) ORDER BY "id" |
| 21:30:52.904 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_approves" SET "updated_at"='now()' WHERE "id"=1756 |
| 21:30:52.905 | 0.7 ms | INSERT | INSERT 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') |
| 21:30:52.906 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004 |
| 21:30:52.906 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=1756) ORDER BY "id" |
| 21:30:52.907 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=1756 |
| 21:30:52.908 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1004) |
| 21:30:52.908 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1004, '37', 1756, '伊峻辰 有一个审批需要审批', TRUE, '发发发') RETURNING "id" |
| 21:30:52.909 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 170588, 'a:11:{s:2:"id";i:170588;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') |
| 21:30:52.910 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (1756, '37', 170588, 1017) |
| 21:30:52.912 | 0.2 ms | SELECT | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1017) AND ("id" != 1004) AND (channel_id IS NOT NULL) |
| 21:30:52.912 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
| 21:30:52.913 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822' |
| 21:30:52.914 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2815' |
| 21:30:52.916 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=2815 |
| 21:30:52.917 | 8.8 ms | SELECT | SELECT * 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 |
| 21:30:52.926 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (2815, 1004, 'now()', NULL) RETURNING "id" |
| 21:30:52.927 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ClientAmChangeLogs', 165440, 'a:5:{s:2:"id";i:165440;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') |
| 21:30:52.928 | 0.7 ms | INSERT | INSERT 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') |
| 21:30:52.929 | 0.8 ms | INSERT | INSERT 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" |
| 21:30:52.930 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 511119, 'a:13:{s:2:"id";i:511119;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') |
| 21:30:52.931 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"='3822' |
| 21:30:52.933 | 1.2 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3822 |
| 21:30:52.934 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3822) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
| 21:30:52.940 | 0.8 ms | INSERT | INSERT 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') |
| 21:30:52.941 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 21:30:52.942 | 0.8 ms | INSERT | INSERT 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" |
| 21:30:52.943 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 511120, 'a:13:{s:2:"id";i:511120;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') |
| 21:30:52.943 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2815 |
| 21:30:52.944 | 1.1 ms | INSERT | INSERT 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" |
| 21:30:52.945 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\UserActionLogs', 137311, 'a:15:{s:2:"id";i:137311;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') |
| 21:30:52.947 | 1.0 ms | INSERT | INSERT 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","5250","5016","5085"],"form_approveVerifyRels":["1017","1000","5016","5250","5329","5085"],"form_type":"319","id":"1756","project_id":"3822","title":"\u53d1\u53d1\u53d1"},"access_token":"NwDlebRkXSJbZFNIiImHKy4sVWr3Lufc","device_type":"2","posttime":"1754141440","token":"ca16e799e4b2003589978639a51ef6af","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:30:52') RETURNING "id" |