ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689599375cd3b: POST https://beta.jinchangxiao.com/vue/approve/save-edit at 2025-08-08 02:29:11 pm by 124.64.23.198

Database Queries

总计51条数据
TimeDurationTypeQuery
  
14:29:11.3832.3 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=1001

[+] Explain
14:29:11.3871.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:29:11.3900.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"='2117'

[+] Explain
14:29:11.3930.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431')

[+] Explain
14:29:11.3932.8 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4073')

[+] Explain
14:29:11.3960.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
14:29:11.3960.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:29:11.397120.3 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "object_id"=431 WHERE ("object_type"=12) AND ("target_id"=2117) AND ("target_object_type"=37)

[+] Explain
14:29:11.5200.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431'

[+] Explain
14:29:11.521118.4 msUPDATEUPDATE "a57be577deb434"."tbl_object_change_logs" SET "object_id"=4073 WHERE ("object_type"=13) AND ("target_id"=2117) AND ("target_object_type"=37)

[+] Explain
14:29:11.6400.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"='4073'

[+] Explain
14:29:11.6411.3 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (2, 'supplier_id', 2117, 37, 1001, 'now()', '["\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"]', '[null]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u4f9b\u5e94\u5546","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"]}'), (2, 'purchase_contract_id', 2117, 37, 1001, 'now()', '["\u6d4b\u8bd5\u6d4b\u8bd5"]', '[null]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["(\u672a\u8bbe\u7f6e) <b>\u53d8\u4e3a<\/b> \u6d4b\u8bd5\u6d4b\u8bd5"]}')

[+] Explain
14:29:11.6420.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2117

[+] Explain
14:29:11.6430.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (164, 171, 181, 156, 184, 189, 2100000000, 349))

[+] Explain
14:29:11.6440.7 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=2117) AND ("term_id"=17)

[+] Explain
14:29:11.6460.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='2100000000')

[+] Explain
14:29:11.6461.4 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=17)

[+] Explain
14:29:11.6482.7 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (17, 2100000000, 2117) RETURNING "id"

[+] Explain
14:29:11.6511.1 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 120985, 'a:9:{s:2:"id";i:120985;s:9:"object_id";i:2117;s:11:"taxonomy_id";s:10:"2100000000";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;}', '', 1001, '124.64.23.198')

[+] Explain
14:29:11.6521.0 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "client_id"=NULL, "project_id"=NULL, "supplier_id"=431, "purchase_contract_id"=4073, "borrow_collect_status"=0 WHERE "id"=2117

[+] Explain
14:29:11.6530.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Approves', 2117, 'a:2:{s:11:"supplier_id";s:3:"431";s:20:"purchase_contract_id";s:4:"4073";}', '', 1001, '124.64.23.198')

[+] Explain
14:29:11.6541.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2117)

[+] Explain
14:29:11.6561.2 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2117)

[+] Explain
14:29:11.6571.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2117)

[+] Explain
14:29:11.6591.2 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2117)

[+] Explain
14:29:11.6600.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2117 ORDER BY "id"

[+] Explain
14:29:11.6610.8 msDELETEDELETE FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2117

[+] Explain
14:29:11.6623.3 msINSERTINSERT INTO "a57be577deb434"."tbl_approve_verify_rels" ("approve_id", "user_id", "status") VALUES (2117, 1000, 0), (2117, 1001, 0), (2117, 5250, 0), (2117, 5016, 0), (2117, 5064, 0), (2117, 5085, 0), (2117, 5332, 0), (2117, 1011, 0)

[+] Explain
14:29:11.6650.6 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2117

[+] Explain
14:29:11.6660.4 msDELETEDELETE FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2117

[+] Explain
14:29:11.6660.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("approve_id"=2117) AND ("status"=0) ORDER BY "id"

[+] Explain
14:29:11.6670.8 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "next_verify_user"=1000, "updated_at"='now()' WHERE "id"=2117

[+] Explain
14:29:11.6680.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Approves', 2117, 'a:1:{s:16:"next_verify_user";i:1000;}', '', 1001, '124.64.23.198')

[+] Explain
14:29:11.6690.8 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."approve_id"=2117) AND ("t"."status" IN (2, 5))

[+] Explain
14:29:11.6700.6 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_approve_payment_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."approve_id"=2117) AND ("t"."status" IN (2, 5))

[+] Explain
14:29:11.6710.7 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."approve_id"=2117) AND ("t"."status" IN (2, 5))

[+] Explain
14:29:11.6720.7 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "erp_payment_settle_amount"='0', "erp_payment_un_settle_amount"='1' WHERE "id"=2117

[+] Explain
14:29:11.6730.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('UPDATE', 'app\models\Approves', 2117, 'a:0:{}', '', 1001, '124.64.23.198')

[+] Explain
14:29:11.6740.7 msSELECTSELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_approve_borrow_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."approve_id"=2117) AND ("t"."status" IN (2, 5))

[+] Explain
14:29:11.6750.7 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "borrow_collect_status"=1, "erp_borrow_settle_amount"='0', "erp_borrow_un_settle_amount"='0' WHERE "id"=2117

[+] Explain
14:29:11.6760.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', 2117, 'a:0:{}', '', 1001, '124.64.23.198')

[+] Explain
14:29:11.6760.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:29:11.6770.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2117) ORDER BY "id"

[+] Explain
14:29:11.6780.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=2117

[+] Explain
14:29:11.6780.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001)

[+] Explain
14:29:11.6791.0 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '37', 2117, '刘人诚 有一个审批需要审批', TRUE, '测试') RETURNING "id"

[+] Explain
14:29:11.6800.8 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 185421, 'a:11:{s:2:"id";i:185421;s:9:"object_id";i:2117;s:11:"object_type";s:2:"37";s:6:"parent";N;s:11:"description";s:37:"刘人诚 有一个审批需要审批";s:10:"created_by";i:1001;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:6:"测试";}', '', 1001, '124.64.23.198')

[+] Explain
14:29:11.6811.0 msINSERTINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2117, '37', 185421, 1000)

[+] Explain
14:29:11.6820.2 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1000) AND ("id" != 1001) AND (channel_id IS NOT NULL)

[+] Explain
14:29:11.6820.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001

[+] Explain
14:29:11.6841.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/approve/save-edit', '{"Approves":{"id":"2117","title":"\u6d4b\u8bd5","description":"c\u989d\u4e0a","form_type":"2100000000","amount":"1","borrow_amount":"","borrow_collect_day":"","client_id":"","client_name":"","project_id":"","supplier_id":"431","supplier_name":"","purchase_contract_id":"4073","files":"","attachmentFiles":"","form_approveVerifyRels":["1000","1001","5250","5016","5064","5085","5332","1011"],"form_approveCarbonCopyRels":""},"web_access_token":"0Bjt7zsA4RpFpNhApjLlKpy587hFcKCO"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u5ba1\u6279\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-08-08 14:29:11') RETURNING "id"

[+] Explain