12:23:01.575 | 2.3 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=5252 |
12:23:01.578 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:23:01.582 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"='2062' |
12:23:01.584 | 15.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=2062) AND ("object_type"=20012) |
12:23:01.599 | 12.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=2062) AND ("object_type"=20012) |
12:23:01.611 | 0.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_visit_object_histories" WHERE ("object_id"=2062) AND ("object_type"=20012) |
12:23:01.612 | 92.7 ms | UPDATE | UPDATE "a57be577deb434"."tbl_object_change_logs" SET "is_delete"=TRUE WHERE (("object_id"=2062) AND ("object_type"=20012)) OR (("target_id"=2062) AND ("target_object_type"=20012)) |
12:23:01.705 | 0.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.706 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072 |
12:23:01.708 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_client_rels" WHERE "contract_id"=4072 ORDER BY "id" |
12:23:01.709 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387 |
12:23:01.726 | 1.5 ms | UPDATE | UPDATE "a57be577deb434"."tbl_clients" SET "updated_at"='now()' WHERE "id"=3387 |
12:23:01.728 | 14.0 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_client_am_change_logs" WHERE ("client_id"=3387) AND ("sales_rep" IS NULL) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
12:23:01.743 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_client_am_change_logs" ("client_id", "sales_rep", "start_from", "end_at") VALUES (3387, 1005, 'now()', NULL) RETURNING "id" |
12:23:01.745 | 1.2 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', 177351, 'a:5:{s:2:"id";i:177351;s:9:"client_id";i:3387;s:9:"sales_rep";i:1005;s:10:"start_from";s:5:"now()";s:6:"end_at";N;}', '', 5252, '124.64.23.198') |
12:23:01.746 | 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', 3387, 'a:0:{}', '', 5252, '124.64.23.198') |
12:23:01.747 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:23:01.748 | 0.9 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', 3387, 10, 4072, 13, 5252, '[4072]', '[4072]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id" |
12:23:01.749 | 0.8 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', 551516, 'a:13:{s:2:"id";i:551516;s:9:"object_id";i:3387;s:11:"object_type";i:10;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:140:"{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198') |
12:23:01.757 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_projects" WHERE "id"=3934 |
12:23:01.759 | 1.1 ms | UPDATE | UPDATE "a57be577deb434"."tbl_projects" SET "updated_at"='now()' WHERE "id"=3934 |
12:23:01.760 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_project_change_logs" WHERE ("project_id"=3934) AND ("end_at" IS NULL) ORDER BY "id" DESC LIMIT 1 |
12:23:01.763 | 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', 3934, 'a:0:{}', '', 5252, '124.64.23.198') |
12:23:01.764 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "id"=3387 |
12:23:01.764 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:23:01.765 | 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', 3934, 1, 4072, 13, 5252, '[4072]', '[4072]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id" |
12:23:01.766 | 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', 551517, 'a:13:{s:2:"id";i:551517;s:9:"object_id";i:3934;s:11:"object_type";i:1;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:140:"{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198') |
12:23:01.768 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:23:01.769 | 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', 431, 12, 4072, 13, 5252, '[4072]', '[4072]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}') RETURNING "id" |
12:23:01.769 | 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', 551518, 'a:13:{s:2:"id";i:551518;s:9:"object_id";i:431;s:11:"object_type";i:12;s:9:"target_id";i:4072;s:18:"target_object_type";i:13;s:3:"act";i:2;s:9:"attribute";s:6:"update";s:9:"old_value";s:6:"[4072]";s:9:"new_value";s:6:"[4072]";s:11:"description";s:140:"{"d1":"\u738b\u7b11\u7b11","d2":"\u66f4\u65b0\u4e86","d3":"\u91c7\u8d2d\u5408\u540c","d4":["\u5408\u540c\u7f16\u53f7:(\u672a\u8bbe\u7f6e)"]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198') |
12:23:01.770 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252 |
12:23:01.771 | 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 (3, 'delete', 4072, 13, 2062, 20012, 5252, '[2062]', '[2062]', '{"d1":"\u738b\u7b11\u7b11","d2":"\u5220\u9664\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":[""]}') RETURNING "id" |
12:23:01.772 | 1.5 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', 551519, 'a:13:{s:2:"id";i:551519;s:9:"object_id";i:4072;s:11:"object_type";i:13;s:9:"target_id";i:2062;s:18:"target_object_type";i:20012;s:3:"act";i:3;s:9:"attribute";s:6:"delete";s:9:"old_value";s:6:"[2062]";s:9:"new_value";s:6:"[2062]";s:11:"description";s:95:"{"d1":"\u738b\u7b11\u7b11","d2":"\u5220\u9664\u4e86","d3":"\u4ed8\u6b3e\u8bb0\u5f55","d4":[""]}";s:10:"created_by";i:5252;s:10:"created_at";N;s:9:"is_delete";N;}', '', 5252, '124.64.23.198') |
12:23:01.773 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_erp_payment_tickets" SET "status"=6 WHERE "id"=2062 |
12:23:01.774 | 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\ErpPaymentTickets', 2062, 'a:1:{s:6:"status";i:6;}', '', 5252, '124.64.23.198') |
12:23:01.775 | 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\ErpPaymentTickets', 2062, 'a:0:{}', '', 5252, '124.64.23.198') |
12:23:01.776 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_bank_outs" WHERE "erp_payment_ticket_id"=2062 ORDER BY "id" |
12:23:01.777 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_approve_payment_settles" WHERE "erp_payment_ticket_id"=2062 ORDER BY "id" |
12:23:01.777 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=2106 |
12:23:01.785 | 7.3 ms | SELECT | SELECT 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"=2106) AND ("t"."status" IN (2, 5)) |
12:23:01.793 | 0.7 ms | SELECT | SELECT 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"=2106) AND ("t"."status" IN (2, 5)) |
12:23:01.794 | 0.4 ms | SELECT | SELECT 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"=2106) AND ("t"."status" IN (2, 5)) |
12:23:01.794 | 0.8 ms | UPDATE | UPDATE "a57be577deb434"."tbl_approves" SET "erp_payment_settle_amount"='0', "erp_payment_un_settle_amount"='1' WHERE "id"=2106 |
12:23:01.795 | 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', 2106, 'a:0:{}', '', 5252, '124.64.23.198') |
12:23:01.796 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (purchase_contract_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.797 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072 |
12:23:01.800 | 0.6 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.801 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.802 | 0.5 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.806 | 0.7 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.806 | 0.3 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1)) |
12:23:01.807 | 0.4 ms | SELECT | SELECT EXISTS(SELECT "r".* FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1)) |
12:23:01.807 | 0.4 ms | SELECT | SELECT SUM(r.amount) FROM "a57be577deb434"."tbl_erp_collect_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_collect_tickets" "t" ON r.erp_collect_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status"=1) |
12:23:01.808 | 0.9 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contracts" SET "erp_settle_amount"='7291', "erp_un_settle_amount"='46109' WHERE "id"=4072 |
12:23:01.809 | 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\PurchaseContracts', 4072, 'a:2:{s:17:"erp_settle_amount";i:7291;s:20:"erp_un_settle_amount";i:46109;}', '', 5252, '124.64.23.198') |
12:23:01.810 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"=431 |
12:23:01.815 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_purchase_costs" WHERE "purchase_contract_id"=4072 |
12:23:01.815 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id"=4072 |
12:23:01.816 | 0.3 ms | UPDATE | UPDATE "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" SET "paid_amount"='0', "status"=0, "overdue_days"=NULL WHERE "contract_id"=4072 |
12:23:01.816 | 0.3 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_other_income_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_other_income_tickets" "t" ON r.erp_other_income_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.817 | 0.3 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_cash_cost_ticket_purchase_contract_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_cash_cost_tickets" "t" ON r.erp_cash_cost_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.817 | 0.4 ms | SELECT | SELECT r.amount, t.created_at FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" "r" LEFT JOIN "a57be577deb434"."tbl_erp_payment_tickets" "t" ON r.erp_payment_ticket_id = t.id WHERE ("r"."purchase_contract_id"=4072) AND ("t"."status" IN (2, 5, 1)) |
12:23:01.818 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_purchase_contract_payment_collection_remind_dates" WHERE ("contract_id"=4072) AND (amount > paid_amount) ORDER BY "remind_date" |
12:23:01.818 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (sales_contract_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.819 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_cost_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.819 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_settles" WHERE (erp_other_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.820 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_advance_payment_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.820 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_payment_ticket_payments" WHERE (erp_other_collect_ticket_id is not null) AND ("erp_payment_ticket_id"=2062) ORDER BY "id" |
12:23:01.820 | 1.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20019) AND ("object_id"=2062) |
12:23:01.822 | 1.7 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=20020) AND ("object_id"=2062) |
12:23:01.824 | 12.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_comments" WHERE ("object_id"=2062) AND ("object_type"=20012) |
12:23:01.836 | 11.4 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_id"=2062) AND ("object_type"=20012) |
12:23:01.848 | 1.8 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_erp_payment_tickets" WHERE "id"=2062 |
12:23:01.850 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('DELETE', 'app\models\ErpPaymentTickets', 2062, '', '', 5252, '124.64.23.198') |
12:23:01.851 | 1.0 ms | INSERT | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5252, 5, 'vue/erp-payment-ticket/delete', '{"id":"2062","web_access_token":"zd4K9tC1F9pL73eX9UTaEjjdfA981F9e"}', '{"code":2000,"result":"","status":1,"msg":[{"name":"success","success":"\u4ed8\u6b3e\u5355\u5df2\u88ab\u6210\u529f\u5220\u9664","error":""}],"mod":0}', FALSE, '2025-08-04 12:23:01') RETURNING "id" |