68c7c7ed843ad: POST https://beta.jinchangxiao.com/vue/erp-advance-payment-ticket/save-edit at 2025-09-15 04:01:49 pm by 114.246.237.213
Database Queries
总计122条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 16:01:49.545 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 16:01:49.548 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.551 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"='2' |
| 16:01:49.552 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("status" != 0) AND ("erp_advance_payment_ticket_id"=2) ORDER BY "id" |
| 16:01:49.553 | 0.9 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "serial_no"='YFKD-20250915-00001' LIMIT 2 |
| 16:01:49.554 | 0.5 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"='2133') |
| 16:01:49.555 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"='1001') |
| 16:01:49.555 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:01:49.556 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.556 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "handler"=1001, "client_id"=2133, "supplier_id"=NULL WHERE "id"=2 |
| 16:01:49.558 | 1.0 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.559 | 2.1 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20033) AND ("object_id"=2) |
| 16:01:49.561 | 2.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20033) AND ("object_id"=2) |
| 16:01:49.564 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (20033, 2, 28158) |
| 16:01:49.565 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.565 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.566 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.567 | 1.7 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, 'erpAdvancePaymentTicketVerifyRels', 2, 20019, 1001, 'now()', '[[]]', '[["\u5218\u4eba\u8bda"]]', '{"d1":"\u5218\u4eba\u8bda","d2":"\u66f4\u65b0\u4e86","d3":"\u5ba1\u6279\u4eba","d4":["\u5218\u4eba\u8bda; <b>\u53d8\u4e3a<\/b> (\u672a\u8bbe\u7f6e)"]}') |
| 16:01:49.568 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 |
| 16:01:49.569 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2 |
| 16:01:49.569 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2 |
| 16:01:49.570 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.570 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:01:49.571 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"='1' |
| 16:01:49.571 | 0.6 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 |
| 16:01:49.572 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" ("erp_advance_payment_ticket_id", "erp_bank_id", "amount", "description") VALUES (2, 1, '22.97', '') |
| 16:01:49.573 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.573 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 |
| 16:01:49.574 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "amount"='22.97' WHERE "id"=2 |
| 16:01:49.575 | 0.9 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.575 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("erp_advance_payment_ticket_id"=2) AND ("status"=0) ORDER BY "id" |
| 16:01:49.576 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "next_verify_user"=NULL, "updated_at"='now()' WHERE "id"=2 |
| 16:01:49.577 | 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.578 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.578 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.578 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.579 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:01:49.579 | 0.8 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.580 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.581 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.581 | 2.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.584 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.584 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.585 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.586 | 0.7 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.587 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.588 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.589 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.589 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.590 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.591 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.592 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115322.97' WHERE "id"=1 |
| 16:01:49.593 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.593 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:01:49.594 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:01:49.595 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71 |
| 16:01:49.596 | 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\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.596 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.597 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.598 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "settle_amount"='0' WHERE "id"=2 |
| 16:01:49.599 | 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.599 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.600 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5)) |
| 16:01:49.600 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5)) |
| 16:01:49.601 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "paid_amount"='0', "un_paid_amount"='22.97' WHERE "id"=2 |
| 16:01:49.602 | 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.603 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.603 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE ("status"=0) AND ("erp_advance_payment_ticket_id"=2) ORDER BY "id" |
| 16:01:49.604 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "status"=2, "verify_at"='now()', "updated_at"='now()' WHERE "id"=2 |
| 16:01:49.604 | 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\ErpAdvancePaymentTickets', 2, 'a:2:{s:6:"status";i:1;s:9:"verify_at";s:5:"now()";}', '', 1001, '114.246.237.213') |
| 16:01:49.605 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_approve_payment_settles" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.606 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.606 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:01:49.606 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.607 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.607 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_bank_transfer_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_bank_transfer_tickets" "t" ON r.erp_bank_transfer_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.607 | 1.9 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.610 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_advance_payment_tickets" "t" ON r.erp_advance_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.610 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_payment_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_payment_tickets" "t" ON r.erp_other_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.610 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.611 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.611 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_bank_ins" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.612 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_social_insurance_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_social_insurances" "t" ON r.erp_social_insurance_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.612 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_provident_fund_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_provident_funds" "t" ON r.erp_provident_fund_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.613 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_personal_tax_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_personal_taxs" "t" ON r.erp_personal_tax_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.613 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_prize_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_prizes" "t" ON r.erp_wage_prize_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) AND ("t"."is_payment_settle"=TRUE) |
| 16:01:49.614 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_wage_ticket_bank_outs" "r" LEFT JOIN "a57be577deb434"."tbl_erp_wage_tickets" "t" ON r.erp_wage_ticket_id = t.id WHERE ("r"."erp_bank_id"=1) AND ("t"."status" IN (2, 5)) |
| 16:01:49.614 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_banks" SET "balance_amount"='115322.97' WHERE "id"=1 |
| 16:01:49.615 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.616 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_banks" WHERE "id"=1 |
| 16:01:49.616 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_account_captions" WHERE "id"=71 |
| 16:01:49.616 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_account_captions" SET "created_at"='2025-08-01 23:14:45', "updated_at"='2025-08-08 18:50:15' WHERE "id"=71 |
| 16:01:49.617 | 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\ErpAccountCaptions', 71, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.618 | 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\ErpBanks', 1, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.619 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.619 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "settle_amount"='0' WHERE "id"=2 |
| 16:01:49.620 | 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.621 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.621 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_collect_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_collect_tickets" "t" ON r.erp_other_collect_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5)) |
| 16:01:49.622 | 0.3 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."erp_advance_payment_ticket_id"=2) AND ("t"."status" IN (2, 5)) |
| 16:01:49.622 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_advance_payment_tickets" SET "paid_amount"='0', "un_paid_amount"='22.97' WHERE "id"=2 |
| 16:01:49.623 | 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\ErpAdvancePaymentTickets', 2, 'a:0:{}', '', 1001, '114.246.237.213') |
| 16:01:49.624 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.624 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.625 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_carbon_copy_rels" WHERE "erp_advance_payment_ticket_id"=2 |
| 16:01:49.625 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_ticket_verify_rels" WHERE "erp_advance_payment_ticket_id"=2 ORDER BY "id" |
| 16:01:49.625 | 0.3 ms | SELECT | SELECT "user_id" FROM "a57be577deb434"."tbl_auth_assignments" WHERE "item_name"='Treasurer' |
| 16:01:49.627 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.628 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001) |
| 16:01:49.628 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (1001, '20019', 2, '刘人诚通过了这个审批', TRUE, 'YFKD-20250915-00001') RETURNING "id" |
| 16:01:49.629 | 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', 191363, 'a:11:{s:2:"id";i:191363;s:9:"object_id";i:2;s:11:"object_type";s:5:"20019";s:6:"parent";N;s:11:"description";s:30:"刘人诚通过了这个审批";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:19:"YFKD-20250915-00001";}', '', 1001, '114.246.237.213') |
| 16:01:49.630 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2, '20019', 191363, 1013), (2, '20019', 191363, 5388) |
| 16:01:49.632 | 0.3 ms | SELECT | SELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id" IN (1013, 5388)) AND ("id" != 1001) AND (channel_id IS NOT NULL) |
| 16:01:49.632 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 16:01:49.633 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=2133 |
| 16:01:49.634 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_advance_payment_tickets" WHERE "id"=2 |
| 16:01:49.635 | 3.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_logs" ("status", "ticket_type", "serial_no", "wrote_date", "description", "abstract", "amount", "client_id", "supplier_id", "contact_id", "user_id", "created_by", "created_at", "updated_at", "object_id", "verify_at") VALUES (2, 20019, 'YFKD-20250915-00001', '2025-09-15', '三分大赛', 'f史蒂夫', '22.97', 2133, NULL, NULL, NULL, 1001, '2025-09-15 16:00:55', '2025-09-15 16:01:49', 2, '2025-09-15 16:01:49.604228+08') RETURNING "id" |
| 16:01:49.638 | 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\ErpTicketChangeLogs', 534, 'a:17:{s:2:"id";i:534;s:9:"serial_no";s:19:"YFKD-20250915-00001";s:11:"ticket_type";i:20019;s:10:"wrote_date";s:10:"2025-09-15";s:6:"status";i:2;s:11:"supplier_id";N;s:9:"client_id";i:2133;s:8:"abstract";s:10:"f史蒂夫";s:11:"description";s:12:"三分大赛";s:9:"verify_at";s:29:"2025-09-15 16:01:49.604228+08";s:10:"created_by";i:1001;s:10:"created_at";s:19:"2025-09-15 16:00:55";s:10:"updated_at";s:19:"2025-09-15 16:01:49";s:10:"contact_id";N;s:7:"user_id";N;s:6:"amount";s:5:"22.97";s:9:"object_id";i:2;}', '', 1001, '114.246.237.213') |
| 16:01:49.639 | 3.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_erp_ticket_change_log_handlers" ("erp_ticket_change_log_id", "user_id") VALUES (534, 1001) |
| 16:01:49.643 | 3.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_visit_module_histories" WHERE ("user_id"=1001) AND ("object_type"=20000) AND ("visit_date"='2025-09-15') |
| 16:01:49.647 | 0.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_visit_module_histories" SET "num"=1438, "last_visit_at"='now()' WHERE "id"=56557 |
| 16:01:49.648 | 0.9 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1001, 5, 'vue/erp-advance-payment-ticket/save-edit', '{"ErpAdvancePaymentTickets":{"id":"2","auto_id":"2133","auto_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","auto_type":"client","handler":"1001","from_date":"2025-09-15","serial_no":"YFKD-20250915-00001","abstract":"f\u53f2\u8482\u592b","files":["28158"],"attachmentFile":{"28158":"\u56fe\u7247.png"},"description":"\u4e09\u5206\u5927\u8d5b","client_id":"2133","client_name":"\u5317\u4eac\u5e02\u4e2d\u4fdd\u7f51\u76fe\u79d1\u6280\u6709\u9650\u516c\u53f8","supplier_id":"","supplier_name":"","erpAdvancePaymentTicketVerifyRels":"","erpAdvancePaymentTicketBankOuts":[{"amount":"22.97","id":"1","description":""}],"erpAdvancePaymentTicketApprovePaymentSettles":""},"web_access_token":"S7OJrULURAq348jTGnVvRiAMpe10N7Zn"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u9884\u4ed8\u6b3e\u5355\u5df2\u88ab\u6210\u529f\u4fee\u6539","error":""}],"mod":0}', FALSE, '2025-09-15 16:01:49') RETURNING "id" |