ConfigurationRequestLogsProfilingDatabaseAsset BundlesMailTimeline
689038bcaaaf9: POST https://beta.jinchangxiao.com/vue/approve/save-new at 2025-08-04 12:36:12 pm by 124.64.23.198

Database Queries

总计42条数据
TimeDurationTypeQuery
  
12:36:12.7022.5 msSELECTSELECT * FROM "global"."vw_user_login" WHERE "id"=5252

[+] Explain
12:36:12.7061.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
12:36:12.7090.5 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_suppliers" WHERE "id"='431')

[+] Explain
12:36:12.7100.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252)

[+] Explain
12:36:12.7103.5 msINSERTINSERT INTO "a57be577deb434"."tbl_approves" ("title", "description", "borrow_amount", "borrow_collect_day", "amount", "client_id", "project_id", "supplier_id", "purchase_contract_id", "created_by", "created_at", "status", "is_resubmited") VALUES ('是否收到分', 's待发收到', NULL, NULL, NULL, NULL, NULL, 431, NULL, 5252, 'now()', 1, FALSE) RETURNING "id"

[+] Explain
12:36:12.7141.4 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Approves', 2109, 'a:25:{s:2:"id";i:2109;s:9:"client_id";s:0:"";s:10:"project_id";s:0:"";s:5:"title";s:15:"是否收到分";s:6:"status";i:1;s:16:"next_verify_user";N;s:9:"verify_at";N;s:11:"description";s:13:"s待发收到";s:18:"refuse_description";N;s:13:"is_resubmited";b:0;s:10:"created_by";i:5252;s:10:"created_at";s:19:"1970-01-01 08:00:00";s:10:"updated_at";N;s:11:"supplier_id";s:3:"431";s:20:"purchase_contract_id";s:0:"";s:6:"amount";N;s:13:"borrow_amount";N;s:18:"borrow_collect_day";s:0:"";s:21:"borrow_collect_status";N;s:26:"borrow_collect_description";N;s:17:"borrow_collect_at";N;s:25:"erp_payment_settle_amount";N;s:28:"erp_payment_un_settle_amount";N;s:24:"erp_borrow_settle_amount";N;s:27:"erp_borrow_un_settle_amount";N;}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7161.5 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id"=2109)

[+] Explain
12:36:12.7171.3 msDELETEDELETE FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id"=2109)

[+] Explain
12:36:12.7190.4 msDELETEDELETE FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE ("object_id"=2109) AND ("term_id"=17)

[+] Explain
12:36:12.7200.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE "id"='319')

[+] Explain
12:36:12.7200.2 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_terms" WHERE "id"=17)

[+] Explain
12:36:12.7211.1 msINSERTINSERT INTO "a57be577deb434"."tbl_term_taxonomy_relationships" ("term_id", "taxonomy_id", "object_id") VALUES (17, 319, 2109) RETURNING "id"

[+] Explain
12:36:12.7220.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\TermTaxonomyRelationships', 120783, 'a:9:{s:2:"id";i:120783;s:9:"object_id";i:2109;s:11:"taxonomy_id";s:3:"319";s:7:"term_id";i:17;s:5:"value";N;s:11:"object_type";N;s:9:"extra_int";N;s:9:"in_amount";N;s:10:"out_amount";N;}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7230.5 msDELETEDELETE FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id"=2109

[+] Explain
12:36:12.7253.2 msINSERTINSERT INTO "a57be577deb434"."tbl_approve_verify_rels" ("approve_id", "user_id", "status") VALUES (2109, 1011, 0)

[+] Explain
12:36:12.7281.0 msDELETEDELETE FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id"=2109

[+] Explain
12:36:12.7303.4 msINSERTINSERT INTO "a57be577deb434"."tbl_approve_carbon_copy_rels" ("approve_id", "user_id") VALUES (2109, 5360), (2109, 5252), (2109, 5388)

[+] Explain
12:36:12.7330.5 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2109) ORDER BY "id"

[+] Explain
12:36:12.7341.0 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "next_verify_user"=1011 WHERE "id"=2109

[+] Explain
12:36:12.7350.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', 2109, 'a:1:{s:16:"next_verify_user";i:1011;}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7415.4 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"=2109) AND ("t"."status" IN (2, 5))

[+] Explain
12:36:12.7461.2 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"=2109) AND ("t"."status" IN (2, 5))

[+] Explain
12:36:12.7480.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"=2109) AND ("t"."status" IN (2, 5))

[+] Explain
12:36:12.7490.7 msUPDATEUPDATE "a57be577deb434"."tbl_approves" SET "erp_payment_settle_amount"='0', "erp_payment_un_settle_amount"='0' WHERE "id"=2109

[+] Explain
12:36:12.7500.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', 2109, 'a:2:{s:25:"erp_payment_settle_amount";i:0;s:28:"erp_payment_un_settle_amount";i:0;}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7530.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', 2109, 'a:0:{}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7540.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
12:36:12.7540.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=2109

[+] Explain
12:36:12.7540.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id"=2109) ORDER BY "id"

[+] Explain
12:36:12.7550.2 msSELECTSELECT * FROM "a57be577deb434"."tbl_approves" WHERE "id"=2109

[+] Explain
12:36:12.7560.3 msSELECTSELECT EXISTS(SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252)

[+] Explain
12:36:12.7561.1 msINSERTINSERT INTO "a57be577deb434"."tbl_comments" ("created_by", "object_type", "object_id", "description", "is_system", "description2") VALUES (5252, '37', 2109, '王笑笑 有一个审批需要审批', TRUE, '是否收到分') RETURNING "id"

[+] Explain
12:36:12.7570.9 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\Comments', 185322, 'a:11:{s:2:"id";i:185322;s:9:"object_id";i:2109;s:11:"object_type";s:2:"37";s:6:"parent";N;s:11:"description";s:37:"王笑笑 有一个审批需要审批";s:10:"created_by";i:5252;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:15:"是否收到分";}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7591.1 msINSERTINSERT INTO "a57be577deb434"."tbl_unread_comments" ("object_id", "object_type", "comment_id", "remind_user_id") VALUES (2109, '37', 185322, 1011)

[+] Explain
12:36:12.7610.3 msSELECTSELECT "channel_id" FROM "global"."tbl_logins" WHERE ("id"=1011) AND ("id" != 5252) AND (channel_id IS NOT NULL)

[+] Explain
12:36:12.7620.4 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
12:36:12.7632.0 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id"=2109

[+] Explain
12:36:12.7650.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (212, 165, 179, 172, 154, 205, 204, 319, 359))

[+] Explain
12:36:12.7670.3 msSELECTSELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=5252

[+] Explain
12:36:12.7681.1 msINSERTINSERT INTO "a57be577deb434"."tbl_object_change_logs" ("act", "attribute", "object_id", "object_type", "created_by", "created_at", "new_value", "old_value", "description") VALUES (1, 'create', 2109, 37, 5252, '2025-08-04 12:36:12', '{"id":2109,"client_id":null,"project_id":null,"title":"\u662f\u5426\u6536\u5230\u5206","status":1,"next_verify_user":1011,"verify_at":null,"description":"s\u5f85\u53d1\u6536\u5230","refuse_description":null,"is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 12:36:12","updated_at":"2025-08-04 12:36:12","supplier_id":431,"purchase_contract_id":null,"amount":null,"borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}', '{"id":2109,"client_id":null,"project_id":null,"title":"\u662f\u5426\u6536\u5230\u5206","status":1,"next_verify_user":1011,"verify_at":null,"description":"s\u5f85\u53d1\u6536\u5230","refuse_description":null,"is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 12:36:12","updated_at":"2025-08-04 12:36:12","supplier_id":431,"purchase_contract_id":null,"amount":null,"borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}', '{"d1":"\u738b\u7b11\u7b11","d2":"\u521b\u5efa\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":[]}') RETURNING "id"

[+] Explain
12:36:12.7690.7 msINSERTINSERT INTO "a57be577deb434"."tbl_action_logs" ("action", "object_type", "object_id", "new_value", "old_value", "created_by", "ip_address") VALUES ('INSERT', 'app\models\ObjectChangeLogs', 551542, 'a:13:{s:2:"id";i:551542;s:9:"object_id";i:2109;s:11:"object_type";i:37;s:9:"target_id";N;s:18:"target_object_type";N;s:3:"act";i:1;s:9:"attribute";s:6:"create";s:9:"old_value";s:641:"{"id":2109,"client_id":null,"project_id":null,"title":"\u662f\u5426\u6536\u5230\u5206","status":1,"next_verify_user":1011,"verify_at":null,"description":"s\u5f85\u53d1\u6536\u5230","refuse_description":null,"is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 12:36:12","updated_at":"2025-08-04 12:36:12","supplier_id":431,"purchase_contract_id":null,"amount":null,"borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}";s:9:"new_value";s:641:"{"id":2109,"client_id":null,"project_id":null,"title":"\u662f\u5426\u6536\u5230\u5206","status":1,"next_verify_user":1011,"verify_at":null,"description":"s\u5f85\u53d1\u6536\u5230","refuse_description":null,"is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 12:36:12","updated_at":"2025-08-04 12:36:12","supplier_id":431,"purchase_contract_id":null,"amount":null,"borrow_amount":null,"borrow_collect_day":null,"borrow_collect_status":0,"borrow_collect_description":null,"borrow_collect_at":null,"erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0"}";s:11:"description";s:93:"{"d1":"\u738b\u7b11\u7b11","d2":"\u521b\u5efa\u4e86","d3":"\u5ba1\u6279\u7533\u8bf7","d4":[]}";s:10:"created_by";i:5252;s:10:"created_at";s:19:"2025-08-04 12:36:12";s:9:"is_delete";N;}', '', 5252, '124.64.23.198')

[+] Explain
12:36:12.7701.0 msINSERTINSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 5252, 5, 'vue/approve/save-new', '{"Approves":{"id":"","title":"\u662f\u5426\u6536\u5230\u5206","description":"s\u5f85\u53d1\u6536\u5230","form_type":"319","borrow_amount":"","borrow_collect_day":"","amount":"","client_id":"","client_name":"","project_id":"","supplier_id":"431","supplier_name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8","purchase_contract_id":"","form_approveVerifyRels":["1011"],"form_approveCarbonCopyRels":["5360","5252","5388"],"files":"","attachmentFiles":""},"web_access_token":"zd4K9tC1F9pL73eX9UTaEjjdfA981F9e"}', '{"code":2000,"result":{"id":2109},"status":1,"msg":[{"name":"success","success":"\u65b0\u5ba1\u6279\u5df2\u521b\u5efa\u6210\u529f","error":""}],"mod":0}', FALSE, '2025-08-04 12:36:12') RETURNING "id"

[+] Explain