68ccb272ac5e9: POST https://beta.jinchangxiao.com/vue/reimbursement/save-recognize at 2025-09-19 09:31:30 am by 114.244.128.96
Database Queries
总计192条数据
| Time | Duration | Type | Query |
|---|---|---|---|
| 09:31:30.709 | 2.2 ms | SELECT | SELECT * FROM "global"."vw_user_login" WHERE "id"=1001 |
| 09:31:30.712 | 1.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:31:30.716 | 1.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursements" WHERE "created_by"=1001 ORDER BY "created_at" DESC |
| 09:31:30.718 | 0.3 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:31:30.719 | 0.7 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 09:31:30.720 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id"=4 |
| 09:31:30.720 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=8280 |
| 09:31:30.721 | 0.5 ms | SELECT | SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("id" IN (184, 374)) |
| 09:31:30.721 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("term_id"=18) AND ("object_type"=7) AND ("object_id"=8280) |
| 09:31:30.722 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374 |
| 09:31:30.722 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8280 |
| 09:31:30.723 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:31:30.723 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 09:31:30.723 | 0.7 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE ("user_id"=1001) AND ("reimbursement_id"=8280) |
| 09:31:30.724 | 0.5 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8280 |
| 09:31:30.725 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:31:30.725 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 09:31:30.725 | 1.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8280 ORDER BY "id" |
| 09:31:30.727 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:31:30.727 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 09:31:30.727 | 1.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status"=0) AND ("reimbursement_id"=8280) ORDER BY "id" |
| 09:31:30.729 | 0.2 ms | SELECT | SELECT "id", "id" AS "key", "name", "sex", "user_status" FROM "a57be577deb434"."tbl_users" WHERE "id"=1001 |
| 09:31:30.729 | 0.2 ms | SELECT | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id"=1001) |
| 09:31:30.729 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE ("status" != 0) AND ("reimbursement_id"=8280) ORDER BY "id" |
| 09:31:30.731 | 2.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=19) AND ("object_id"=8280) |
| 09:31:30.733 | 0.4 ms | SELECT | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=28378 |
| 09:31:30.734 | 1.8 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=22) AND ("object_id"=8280) |
| 09:31:30.736 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_erp_cash_cost_tickets" WHERE "reimbursement_id"=8280 |
| 09:31:30.737 | 20.7 ms | SELECT | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=20) AND ("object_id"=8280) GROUP BY "object_id" |
| 09:31:30.758 | 17.0 ms | SELECT | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=20) AND (remind_user_id = 1001 AND is_read = false) AND ("object_id"=8280) GROUP BY "object_id" |
| 09:31:30.775 | 0.4 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE "reimbursement_id"=8280 |
| 09:31:30.776 | 0.5 ms | SELECT | SELECT count(distinct reimbursement_id) as count, number FROM "a57be577deb434"."tbl_reimbursement_invoice_numbers" WHERE (number is not null) AND ("number"='13501247040138560180') GROUP BY "number" |
| 09:31:30.776 | 0.2 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=15) AND ("is_delete"=FALSE) |
| 09:31:30.777 | 0.2 ms | SELECT | SELECT "id" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=18) AND ("is_delete"=FALSE) |
| 09:31:30.777 | 0.8 ms | SELECT | SELECT "u"."id" FROM "a57be577deb434"."tbl_users" "u" RIGHT JOIN "a57be577deb434"."tbl_auth_assignments" "aa" ON aa.user_id = u.id WHERE ("u"."user_status"='1') AND ("aa"."item_name"='Treasurer') |
| 09:31:30.779 | 1.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='' |
| 09:31:30.781 | 1.4 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("status", "amount", "occurrence_at", "created_by") VALUES (0, '33.00', '2025-03-20 00:00:00', 1001) RETURNING "id" |
| 09:31:30.782 | 1.0 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\Reimbursements', 8281, 'a:18:{s:2:"id";i:8281;s:6:"status";i:0;s:6:"amount";s:5:"33.00";s:13:"occurrence_at";s:19:"2025-03-20 00:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";N;s:10:"project_id";N;s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";N;s:12:"pre_sales_id";N;s:19:"implement_record_id";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.784 | 1.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8281 |
| 09:31:30.785 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8281, 1001, 0) |
| 09:31:30.786 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8281 |
| 09:31:30.787 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8281, 1001) |
| 09:31:30.788 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8281 |
| 09:31:30.788 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (8281, 1001) |
| 09:31:30.789 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8281) AND ("term_id"=15) |
| 09:31:30.790 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=184) |
| 09:31:30.790 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
| 09:31:30.790 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8281) RETURNING "id" |
| 09:31:30.791 | 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\TermTaxonomyRelationships', 129547, 'a:9:{s:2:"id";i:129547;s:9:"object_id";i:8281;s:11:"taxonomy_id";i:184;s:7:"term_id";i:15;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, '114.244.128.96') |
| 09:31:30.792 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8281) AND ("object_type"=7) |
| 09:31:30.793 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374) |
| 09:31:30.793 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
| 09:31:30.793 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 374, 8281) RETURNING "id" |
| 09:31:30.794 | 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\TermTaxonomyRelationships', 129548, 'a:9:{s:2:"id";i:129548;s:9:"object_id";i:8281;s:11:"taxonomy_id";i:374;s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.795 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='28380' |
| 09:31:30.811 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("name", "path", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('f45dc079-2838-3d26-b4fc-e51a3785d8bc', '/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '20151758183294_.pic_副本.jpeg', 'jpeg', 'image/jpeg', 43321, '114.244.128.96', 1001) RETURNING "id" |
| 09:31:30.812 | 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\Attachments', 28381, 'a:10:{s:2:"id";i:28381;s:9:"orig_name";s:31:"20151758183294_.pic_副本.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"f45dc079-2838-3d26-b4fc-e51a3785d8bc";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:43321;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1001, '114.244.128.96') |
| 09:31:30.813 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 8281, 28381) RETURNING "id" |
| 09:31:30.814 | 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\AttachmentRelationships', 49727, 'a:4:{s:2:"id";i:49727;s:11:"object_type";i:19;s:9:"object_id";i:8281;s:13:"attachment_id";i:28381;}', '', 1001, '114.244.128.96') |
| 09:31:30.815 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_invoice_numbers" ("op", "attachment_id", "reimbursement_id", "number") VALUES ('toll_invoice', 28381, 8281, '13501247040138558184') RETURNING "id" |
| 09:31:30.816 | 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\ReimbursementInvoiceNumbers', 108, 'a:5:{s:2:"id";i:108;s:16:"reimbursement_id";i:8281;s:13:"attachment_id";i:28381;s:2:"op";s:12:"toll_invoice";s:6:"number";s:20:"13501247040138558184";}', '', 1001, '114.244.128.96') |
| 09:31:30.817 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='' |
| 09:31:30.818 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("status", "amount", "occurrence_at", "created_by") VALUES (0, '33.00', '2025-03-23 00:00:00', 1001) RETURNING "id" |
| 09:31:30.819 | 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\Reimbursements', 8282, 'a:18:{s:2:"id";i:8282;s:6:"status";i:0;s:6:"amount";s:5:"33.00";s:13:"occurrence_at";s:19:"2025-03-23 00:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";N;s:10:"project_id";N;s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";N;s:12:"pre_sales_id";N;s:19:"implement_record_id";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.820 | 1.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8282 |
| 09:31:30.821 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8282, 1001, 0) |
| 09:31:30.822 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8282 |
| 09:31:30.822 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8282, 1001) |
| 09:31:30.823 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8282 |
| 09:31:30.823 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (8282, 1001) |
| 09:31:30.824 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8282) AND ("term_id"=15) |
| 09:31:30.825 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=184) |
| 09:31:30.825 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
| 09:31:30.825 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8282) RETURNING "id" |
| 09:31:30.826 | 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\TermTaxonomyRelationships', 129549, 'a:9:{s:2:"id";i:129549;s:9:"object_id";i:8282;s:11:"taxonomy_id";i:184;s:7:"term_id";i:15;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, '114.244.128.96') |
| 09:31:30.827 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8282) AND ("object_type"=7) |
| 09:31:30.827 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374) |
| 09:31:30.828 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
| 09:31:30.828 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 374, 8282) RETURNING "id" |
| 09:31:30.829 | 1.3 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', 129550, 'a:9:{s:2:"id";i:129550;s:9:"object_id";i:8282;s:11:"taxonomy_id";i:374;s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.830 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='28380' |
| 09:31:30.847 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("name", "path", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('304e14b3-d8d4-36b7-9395-4a9bf80c67f1', '/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '20151758183294_.pic_副本.jpeg', 'jpeg', 'image/jpeg', 61564, '114.244.128.96', 1001) RETURNING "id" |
| 09:31:30.849 | 0.9 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\Attachments', 28382, 'a:10:{s:2:"id";i:28382;s:9:"orig_name";s:31:"20151758183294_.pic_副本.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"304e14b3-d8d4-36b7-9395-4a9bf80c67f1";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:61564;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1001, '114.244.128.96') |
| 09:31:30.850 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 8282, 28382) RETURNING "id" |
| 09:31:30.851 | 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\AttachmentRelationships', 49728, 'a:4:{s:2:"id";i:49728;s:11:"object_type";i:19;s:9:"object_id";i:8282;s:13:"attachment_id";i:28382;}', '', 1001, '114.244.128.96') |
| 09:31:30.852 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_invoice_numbers" ("op", "attachment_id", "reimbursement_id", "number") VALUES ('toll_invoice', 28382, 8282, '13501257040143416517') RETURNING "id" |
| 09:31:30.853 | 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\ReimbursementInvoiceNumbers', 109, 'a:5:{s:2:"id";i:109;s:16:"reimbursement_id";i:8282;s:13:"attachment_id";i:28382;s:2:"op";s:12:"toll_invoice";s:6:"number";s:20:"13501257040143416517";}', '', 1001, '114.244.128.96') |
| 09:31:30.854 | 0.9 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='' |
| 09:31:30.855 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("status", "amount", "occurrence_at", "created_by") VALUES (0, '33.00', '2025-03-21 00:00:00', 1001) RETURNING "id" |
| 09:31:30.856 | 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\Reimbursements', 8283, 'a:18:{s:2:"id";i:8283;s:6:"status";i:0;s:6:"amount";s:5:"33.00";s:13:"occurrence_at";s:19:"2025-03-21 00:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";N;s:10:"project_id";N;s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";N;s:12:"pre_sales_id";N;s:19:"implement_record_id";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.857 | 2.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8283 |
| 09:31:30.859 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8283, 1001, 0) |
| 09:31:30.860 | 0.9 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8283 |
| 09:31:30.861 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8283, 1001) |
| 09:31:30.862 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8283 |
| 09:31:30.863 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (8283, 1001) |
| 09:31:30.864 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8283) AND ("term_id"=15) |
| 09:31:30.864 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=184) |
| 09:31:30.865 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
| 09:31:30.865 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8283) RETURNING "id" |
| 09:31:30.866 | 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\TermTaxonomyRelationships', 129551, 'a:9:{s:2:"id";i:129551;s:9:"object_id";i:8283;s:11:"taxonomy_id";i:184;s:7:"term_id";i:15;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, '114.244.128.96') |
| 09:31:30.867 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8283) AND ("object_type"=7) |
| 09:31:30.868 | 0.3 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374) |
| 09:31:30.868 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
| 09:31:30.868 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 374, 8283) RETURNING "id" |
| 09:31:30.870 | 1.0 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', 129552, 'a:9:{s:2:"id";i:129552;s:9:"object_id";i:8283;s:11:"taxonomy_id";i:374;s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.871 | 0.3 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='28380' |
| 09:31:30.891 | 1.1 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("name", "path", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('0b8a2610-2bce-3637-8367-4eea3d351cd2', '/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '20151758183294_.pic_副本.jpeg', 'jpeg', 'image/jpeg', 49016, '114.244.128.96', 1001) RETURNING "id" |
| 09:31:30.892 | 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\Attachments', 28383, 'a:10:{s:2:"id";i:28383;s:9:"orig_name";s:31:"20151758183294_.pic_副本.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"0b8a2610-2bce-3637-8367-4eea3d351cd2";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:49016;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1001, '114.244.128.96') |
| 09:31:30.893 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 8283, 28383) RETURNING "id" |
| 09:31:30.894 | 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\AttachmentRelationships', 49729, 'a:4:{s:2:"id";i:49729;s:11:"object_type";i:19;s:9:"object_id";i:8283;s:13:"attachment_id";i:28383;}', '', 1001, '114.244.128.96') |
| 09:31:30.895 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_invoice_numbers" ("op", "attachment_id", "reimbursement_id", "number") VALUES ('toll_invoice', 28383, 8283, '13501247040138560180') RETURNING "id" |
| 09:31:30.896 | 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\ReimbursementInvoiceNumbers', 110, 'a:5:{s:2:"id";i:110;s:16:"reimbursement_id";i:8283;s:13:"attachment_id";i:28383;s:2:"op";s:12:"toll_invoice";s:6:"number";s:20:"13501247040138560180";}', '', 1001, '114.244.128.96') |
| 09:31:30.897 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='' |
| 09:31:30.898 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("status", "amount", "occurrence_at", "created_by") VALUES (0, '122.00', '2025-03-24 00:00:00', 1001) RETURNING "id" |
| 09:31:30.899 | 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\Reimbursements', 8284, 'a:18:{s:2:"id";i:8284;s:6:"status";i:0;s:6:"amount";s:6:"122.00";s:13:"occurrence_at";s:19:"2025-03-24 00:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";N;s:10:"project_id";N;s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";N;s:12:"pre_sales_id";N;s:19:"implement_record_id";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.899 | 1.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8284 |
| 09:31:30.901 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8284, 1001, 0) |
| 09:31:30.901 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8284 |
| 09:31:30.902 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8284, 1001) |
| 09:31:30.903 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8284 |
| 09:31:30.903 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (8284, 1001) |
| 09:31:30.904 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8284) AND ("term_id"=15) |
| 09:31:30.904 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=184) |
| 09:31:30.905 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
| 09:31:30.905 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8284) RETURNING "id" |
| 09:31:30.906 | 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', 129553, 'a:9:{s:2:"id";i:129553;s:9:"object_id";i:8284;s:11:"taxonomy_id";i:184;s:7:"term_id";i:15;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, '114.244.128.96') |
| 09:31:30.907 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8284) AND ("object_type"=7) |
| 09:31:30.907 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374) |
| 09:31:30.908 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
| 09:31:30.908 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 374, 8284) RETURNING "id" |
| 09:31:30.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\TermTaxonomyRelationships', 129554, 'a:9:{s:2:"id";i:129554;s:9:"object_id";i:8284;s:11:"taxonomy_id";i:374;s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.910 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='28380' |
| 09:31:30.926 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("name", "path", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('1cfbdf56-2ef7-3cbe-a4c8-9a4cbd1c8718', '/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '20151758183294_.pic_副本.jpeg', 'jpeg', 'image/jpeg', 60455, '114.244.128.96', 1001) RETURNING "id" |
| 09:31:30.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\Attachments', 28384, 'a:10:{s:2:"id";i:28384;s:9:"orig_name";s:31:"20151758183294_.pic_副本.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"1cfbdf56-2ef7-3cbe-a4c8-9a4cbd1c8718";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:60455;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1001, '114.244.128.96') |
| 09:31:30.928 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 8284, 28384) RETURNING "id" |
| 09:31:30.929 | 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\AttachmentRelationships', 49730, 'a:4:{s:2:"id";i:49730;s:11:"object_type";i:19;s:9:"object_id";i:8284;s:13:"attachment_id";i:28384;}', '', 1001, '114.244.128.96') |
| 09:31:30.930 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_invoice_numbers" ("op", "attachment_id", "reimbursement_id", "number") VALUES ('toll_invoice', 28384, 8284, '13501257040143410464') RETURNING "id" |
| 09:31:30.931 | 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\ReimbursementInvoiceNumbers', 111, 'a:5:{s:2:"id";i:111;s:16:"reimbursement_id";i:8284;s:13:"attachment_id";i:28384;s:2:"op";s:12:"toll_invoice";s:6:"number";s:20:"13501257040143410464";}', '', 1001, '114.244.128.96') |
| 09:31:30.932 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='' |
| 09:31:30.932 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("status", "amount", "occurrence_at", "created_by") VALUES (0, '33.00', '2025-03-23 00:00:00', 1001) RETURNING "id" |
| 09:31:30.933 | 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\Reimbursements', 8285, 'a:18:{s:2:"id";i:8285;s:6:"status";i:0;s:6:"amount";s:5:"33.00";s:13:"occurrence_at";s:19:"2025-03-23 00:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";N;s:10:"project_id";N;s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";N;s:12:"pre_sales_id";N;s:19:"implement_record_id";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.934 | 1.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8285 |
| 09:31:30.935 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8285, 1001, 0) |
| 09:31:30.936 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8285 |
| 09:31:30.937 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8285, 1001) |
| 09:31:30.938 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8285 |
| 09:31:30.938 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (8285, 1001) |
| 09:31:30.939 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8285) AND ("term_id"=15) |
| 09:31:30.939 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=184) |
| 09:31:30.939 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
| 09:31:30.940 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8285) RETURNING "id" |
| 09:31:30.940 | 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\TermTaxonomyRelationships', 129555, 'a:9:{s:2:"id";i:129555;s:9:"object_id";i:8285;s:11:"taxonomy_id";i:184;s:7:"term_id";i:15;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, '114.244.128.96') |
| 09:31:30.941 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8285) AND ("object_type"=7) |
| 09:31:30.942 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374) |
| 09:31:30.942 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
| 09:31:30.942 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 374, 8285) RETURNING "id" |
| 09:31:30.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\TermTaxonomyRelationships', 129556, 'a:9:{s:2:"id";i:129556;s:9:"object_id";i:8285;s:11:"taxonomy_id";i:374;s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.944 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='28380' |
| 09:31:30.960 | 1.0 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("name", "path", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('a4c72535-ab48-33d0-9b2c-1b3640c2e3a0', '/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '20151758183294_.pic_副本.jpeg', 'jpeg', 'image/jpeg', 57348, '114.244.128.96', 1001) RETURNING "id" |
| 09:31:30.961 | 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\Attachments', 28385, 'a:10:{s:2:"id";i:28385;s:9:"orig_name";s:31:"20151758183294_.pic_副本.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"a4c72535-ab48-33d0-9b2c-1b3640c2e3a0";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:57348;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1001, '114.244.128.96') |
| 09:31:30.962 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 8285, 28385) RETURNING "id" |
| 09:31:30.963 | 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\AttachmentRelationships', 49731, 'a:4:{s:2:"id";i:49731;s:11:"object_type";i:19;s:9:"object_id";i:8285;s:13:"attachment_id";i:28385;}', '', 1001, '114.244.128.96') |
| 09:31:30.964 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_invoice_numbers" ("op", "attachment_id", "reimbursement_id", "number") VALUES ('toll_invoice', 28385, 8285, '13501257040143412230') RETURNING "id" |
| 09:31:30.964 | 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\ReimbursementInvoiceNumbers', 112, 'a:5:{s:2:"id";i:112;s:16:"reimbursement_id";i:8285;s:13:"attachment_id";i:28385;s:2:"op";s:12:"toll_invoice";s:6:"number";s:20:"13501257040143412230";}', '', 1001, '114.244.128.96') |
| 09:31:30.965 | 0.6 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_clients" WHERE "name"='' |
| 09:31:30.966 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursements" ("status", "amount", "occurrence_at", "created_by") VALUES (0, '33.00', '2025-03-19 00:00:00', 1001) RETURNING "id" |
| 09:31:30.967 | 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\Reimbursements', 8286, 'a:18:{s:2:"id";i:8286;s:6:"status";i:0;s:6:"amount";s:5:"33.00";s:13:"occurrence_at";s:19:"2025-03-19 00:00:00";s:18:"settle_accounts_at";N;s:18:"settle_accounts_by";N;s:11:"description";N;s:10:"created_by";i:1001;s:10:"created_at";N;s:10:"updated_at";N;s:18:"refuse_description";N;s:9:"client_id";N;s:10:"project_id";N;s:16:"next_verify_user";N;s:13:"is_resubmited";N;s:11:"work_log_id";N;s:12:"pre_sales_id";N;s:19:"implement_record_id";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.968 | 1.0 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_verify_rels" WHERE "reimbursement_id"=8286 |
| 09:31:30.969 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_verify_rels" ("reimbursement_id", "user_id", "status") VALUES (8286, 1001, 0) |
| 09:31:30.970 | 0.5 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_settle_rels" WHERE "reimbursement_id"=8286 |
| 09:31:30.970 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_settle_rels" ("reimbursement_id", "user_id") VALUES (8286, 1001) |
| 09:31:30.971 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" WHERE "reimbursement_id"=8286 |
| 09:31:30.971 | 0.9 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_carbon_copy_rels" ("reimbursement_id", "user_id") VALUES (8286, 1001) |
| 09:31:30.972 | 0.2 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8286) AND ("term_id"=15) |
| 09:31:30.973 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=184) |
| 09:31:30.973 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=15) |
| 09:31:30.973 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (15, 184, 8286) RETURNING "id" |
| 09:31:30.974 | 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\TermTaxonomyRelationships', 129557, 'a:9:{s:2:"id";i:129557;s:9:"object_id";i:8286;s:11:"taxonomy_id";i:184;s:7:"term_id";i:15;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, '114.244.128.96') |
| 09:31:30.975 | 0.1 ms | DELETE | DELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=8286) AND ("object_type"=7) |
| 09:31:30.975 | 0.2 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"=374) |
| 09:31:30.976 | 0.1 ms | SELECT | SELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=18) |
| 09:31:30.976 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "object_type", "taxonomy_id", "object_id") VALUES (18, 7, 374, 8286) RETURNING "id" |
| 09:31:30.977 | 1.3 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', 129558, 'a:9:{s:2:"id";i:129558;s:9:"object_id";i:8286;s:11:"taxonomy_id";i:374;s:7:"term_id";i:18;s:5:"value";N;s:11:"object_type";i:7;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 1001, '114.244.128.96') |
| 09:31:30.978 | 0.2 ms | SELECT | SELECT * FROM "a57be577deb434"."tbl_attachments" WHERE "id"='28380' |
| 09:31:30.993 | 1.2 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachments" ("name", "path", "orig_name", "extension", "file_type", "file_size", "ip_address", "created_by") VALUES ('dd86fcc2-41fe-338b-ab99-4f0f4ea50c21', '/var/www/beta/web/files/protected/a57be577deb434/2025/09/', '20151758183294_.pic_副本.jpeg', 'jpeg', 'image/jpeg', 48095, '114.244.128.96', 1001) RETURNING "id" |
| 09:31:30.994 | 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\Attachments', 28386, 'a:10:{s:2:"id";i:28386;s:9:"orig_name";s:31:"20151758183294_.pic_副本.jpeg";s:4:"path";s:57:"/var/www/beta/web/files/protected/a57be577deb434/2025/09/";s:4:"name";s:36:"dd86fcc2-41fe-338b-ab99-4f0f4ea50c21";s:9:"extension";s:4:"jpeg";s:9:"file_size";i:48095;s:10:"ip_address";s:14:"114.244.128.96";s:10:"created_by";i:1001;s:10:"created_at";N;s:9:"file_type";s:10:"image/jpeg";}', '', 1001, '114.244.128.96') |
| 09:31:30.995 | 0.7 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_attachement_relationships" ("object_type", "object_id", "attachment_id") VALUES (19, 8286, 28386) RETURNING "id" |
| 09:31:30.996 | 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\AttachmentRelationships', 49732, 'a:4:{s:2:"id";i:49732;s:11:"object_type";i:19;s:9:"object_id";i:8286;s:13:"attachment_id";i:28386;}', '', 1001, '114.244.128.96') |
| 09:31:30.997 | 0.8 ms | INSERT | INSERT INTO "a57be577deb434"."tbl_reimbursement_invoice_numbers" ("op", "attachment_id", "reimbursement_id", "number") VALUES ('toll_invoice', 28386, 8286, '13501247040169240677') RETURNING "id" |
| 09:31:30.998 | 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\ReimbursementInvoiceNumbers', 113, 'a:5:{s:2:"id";i:113;s:16:"reimbursement_id";i:8286;s:13:"attachment_id";i:28386;s:2:"op";s:12:"toll_invoice";s:6:"number";s:20:"13501247040169240677";}', '', 1001, '114.244.128.96') |
| 09:31:30.999 | 1.1 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/reimbursement/save-recognize', '{"InvoiceRecognize":[{"saler_name":"","purchaser_name":"","serial_no":"13501247040138558184","occurrence_at":"2025-03-20 00:00:00","type":"\u8fc7\u8def\u8fc7\u6865\u8d39\u53d1\u7968","op":"toll_invoice","amount":"33.00","invoice_duplicated":"true","attachment_id":"28380","x0":"597","y0":"12","x1":"1042","y1":"16","x2":"1059","y2":"542","x3":"581","y3":"541"},{"saler_name":"","purchaser_name":"","serial_no":"13501257040143416517","occurrence_at":"2025-03-23 00:00:00","type":"\u8fc7\u8def\u8fc7\u6865\u8d39\u53d1\u7968","op":"toll_invoice","amount":"33.00","invoice_duplicated":"true","attachment_id":"28380","x0":"576","y0":"527","x1":"1075","y1":"516","x2":"1133","y2":"1174","x3":"574","y3":"1196"},{"saler_name":"","purchaser_name":"","serial_no":"13501247040138560180","occurrence_at":"2025-03-21 00:00:00","type":"\u8fc7\u8def\u8fc7\u6865\u8d39\u53d1\u7968","op":"toll_invoice","amount":"33.00","invoice_duplicated":"true","attachment_id":"28380","x0":"174","y0":"14","x1":"618","y1":"17","x2":"590","y2":"560","x3":"98","y3":"555"},{"saler_name":"","purchaser_name":"","serial_no":"13501257040143410464","occurrence_at":"2025-03-24 00:00:00","type":"\u8fc7\u8def\u8fc7\u6865\u8d39\u53d1\u7968","op":"toll_invoice","amount":"122.00","invoice_duplicated":"true","attachment_id":"28380","x0":"96","y0":"515","x1":"588","y1":"535","x2":"570","y2":"1189","x3":"3","y3":"1175"},{"saler_name":"","purchaser_name":"","serial_no":"13501257040143412230","occurrence_at":"2025-03-23 00:00:00","type":"\u8fc7\u8def\u8fc7\u6865\u8d39\u53d1\u7968","op":"toll_invoice","amount":"33.00","invoice_duplicated":"true","attachment_id":"28380","x0":"1078","y0":"529","x1":"1560","y1":"511","x2":"1595","y2":"1164","x3":"1121","y3":"1177"},{"saler_name":"","purchaser_name":"","serial_no":"13501247040169240677","occurrence_at":"2025-03-19 00:00:00","type":"\u8fc7\u8def\u8fc7\u6865\u8d39\u53d1\u7968","op":"toll_invoice","amount":"33.00","invoice_duplicated":"true","attachment_id":"28380","x0":"1019","y0":"25","x1":"1446","y1":"42","x2":"1543","y2":"533","x3":"1077","y3":"549"}],"web_access_token":"Hlt1ZmLXNhK2kSIyrIUGksUdIH0iseH7"}', '{"code":2000,"result":{"success":6},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}],"mod":0}', FALSE, '2025-09-19 09:31:30') RETURNING "id" |