Total processing time: 317 ms; Peak memory: 5.254 MB. Show Profiling Timeline
Time | Duration | Category | Info |
---|---|---|---|
13:47:03.540 | 59.4 ms | yii\db\Command::query | SELECT count(object_id) as count FROM "a57be577deb434"."tbl_unread_comments" "uc" LEFT JOIN "a57be577deb434"."tbl_approves" "r" ON uc.object_id = r.id LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE (object_id = r.id AND object_type = '37' AND remind_user_id = '1000' AND is_read = false) AND ("rccr"."user_id"=1000) AND ("r"."status" != '0') GROUP BY "object_id" |
13:47:03.493 | 39.7 ms | yii\db\Command::query | SELECT count(*) as count, sum(case when "sub".status=1 then 1 else 0 end) countStatus1, sum(case when "sub".status=2 then 1 else 0 end) countStatus2, sum(case when "sub".status=4 then 1 else 0 end) countStatus4 FROM (SELECT DISTINCT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000)) GROUP BY "r"."id") "sub" |
13:47:03.659 | 36.5 ms | yii\db\Command::query | SELECT "object_id", count(*) as comment FROM "a57be577deb434"."tbl_comments" WHERE ("object_type"=37) AND ("object_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097)) GROUP BY "object_id" |
13:47:03.695 | 30.8 ms | yii\db\Command::query | SELECT "object_id", count(*) AS unread FROM "a57be577deb434"."tbl_unread_comments" WHERE ("object_type"=37) AND (remind_user_id = 1000 AND is_read = false) AND ("object_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097)) GROUP BY "object_id" |
13:47:03.603 | 26.0 ms | yii\db\Command::query | SELECT COUNT(*) FROM (SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000)) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC) "c" |
13:47:03.630 | 26.0 ms | yii\db\Command::query | SELECT r.* FROM "a57be577deb434"."tbl_approves" "r" LEFT JOIN "a57be577deb434"."tbl_users" "u" ON r.created_by = u.id LEFT JOIN "a57be577deb434"."tbl_approve_verify_rels" "rvr" ON rvr.approve_id = r.id LEFT JOIN "a57be577deb434"."tbl_clients" "client" ON client.id = r.client_id AND client.deleted = FALSE LEFT JOIN "a57be577deb434"."tbl_term_taxonomy_relationships" "dt1" ON dt1.object_id = r.id AND dt1.term_id = 17 LEFT JOIN "a57be577deb434"."tbl_approve_carbon_copy_rels" "rccr" ON rccr.approve_id = r.id WHERE ("r"."status" != 0) AND (("r"."created_by" IN (1000, 1001, 1004, 1005, 1011, 1013, 1015, 1017, 1022, 1023, 5016, 5064, 5085, 5087, 5248, 5250, 5252, 5295, 5300, 5311, 5332, 5360, 5388, 5446, 5449)) OR ("rccr"."user_id"=1000) OR ("rvr"."user_id"=1000)) GROUP BY "r"."id" ORDER BY case when r.status = 1 then 0 else 1 end asc, case when r.status = 1 then r.created_at else r.verify_at end DESC, r.created_at DESC LIMIT 10 |
13:47:03.761 | 13.5 ms | yii\db\Command::query | INSERT INTO "global"."tbl_api_log" ("code", "schema", "user_id", "device_type", "version_code", "url", "request", "response", "php_error", "time") VALUES (200, 'a57be577deb434', 1000, 0, 264, 'v2/approve/list', '{"ApproveSearch":{"filter":"","created_by":""},"access_token":"JaijjTZWzZjgdx9RhHhwFXGU-e0N-Sfm","device_type":"0","version_code":"264","page":"1","token":"3f29887a56a4bcf334455904e937412c","posttime":"1754372823","pagesize":"10"}', '{"code":200,"data":{"list":[{"id":2111,"client_id":"","project_id":"","title":"cccc","status":1,"next_verify_user":1011,"verify_at":"","description":"dddd","refuse_description":"","is_resubmited":false,"created_by":1000,"created_at":"2025-08-04 16:26:05","updated_at":"2025-08-05 13:44:30","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2111,"comment":6},"unreadComments":{},"type":{"id":319,"name":"\u6b63\u5e38\u5f00\u7968"},"approveCarbonCopyRels":[{"id":7593,"approve_id":2111,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}},{"id":7594,"approve_id":2111,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":7595,"approve_id":2111,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7596,"approve_id":2111,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7597,"approve_id":2111,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}}],"approveVerifyRels":[{"id":2769,"approve_id":2111,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2770,"approve_id":2111,"user_id":5252,"status":0,"description":"","verify_at":"","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]},{"id":2771,"approve_id":2111,"user_id":1017,"status":0,"description":"","verify_at":"","user":{"id":1017,"key":1017,"name":"\u8f66\u660e\u98de","sex":"M","avatar":{"id":8,"user_id":1017,"name":"\/files\/cdn\/a57be577deb434\/avatar\/e538f0fe-48a7-33da-a512-b252266c9e91.jpg"}},"attachmentRelationships":[],"files":[]},{"id":2772,"approve_id":2111,"user_id":5250,"status":0,"description":"","verify_at":"","user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":2769,"approve_id":2111,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},"haveApproveVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","files":[],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#00B7EE","status_display":"\u5ba1\u6279\u4e2d"},{"id":2110,"client_id":"","project_id":"","title":"aaaa","status":1,"next_verify_user":1011,"verify_at":"","description":"bbbb","refuse_description":"","is_resubmited":false,"created_by":1000,"created_at":"2025-08-04 16:24:15","updated_at":"2025-08-04 16:25:18","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1000,"key":1000,"name":"\u66f9\u6c38\u751f","sex":"M","department_id":10,"avatar":{"id":1,"user_id":1000,"name":"\/files\/cdn\/a57be577deb434\/avatar\/80759bee-0611-3ad4-bb4a-30d802dd0032.png"},"department":{"id":10,"key":10,"name":"\u8f6f\u4ef6\u5f00\u53d1"}},"commentCount":{"object_id":2110,"comment":3},"unreadComments":{},"type":{"id":319,"name":"\u6b63\u5e38\u5f00\u7968"},"approveCarbonCopyRels":[{"id":7560,"approve_id":2110,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}},{"id":7561,"approve_id":2110,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":7562,"approve_id":2110,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7563,"approve_id":2110,"user_id":5250,"user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}}},{"id":7564,"approve_id":2110,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}}],"approveVerifyRels":[{"id":2748,"approve_id":2110,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]},{"id":2749,"approve_id":2110,"user_id":5250,"status":0,"description":"","verify_at":"","user":{"id":5250,"key":5250,"name":"\u8463\u8363","sex":"M","avatar":{"id":157,"user_id":5250,"name":"\/files\/cdn\/a57be577deb434\/avatar\/10f9a0d9-7ea7-3910-9465-6ece76a0dae4.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":2748,"approve_id":2110,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},"haveApproveVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","files":[],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#00B7EE","status_display":"\u5ba1\u6279\u4e2d"},{"id":2109,"client_id":"","project_id":"","title":"\u662f\u5426\u6536\u5230\u5206","status":1,"next_verify_user":1011,"verify_at":"","description":"s\u5f85\u53d1\u6536\u5230","refuse_description":"","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":"","amount":"","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2109,"comment":1},"unreadComments":{},"type":{"id":319,"name":"\u6b63\u5e38\u5f00\u7968"},"approveCarbonCopyRels":[{"id":7550,"approve_id":2109,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}},{"id":7551,"approve_id":2109,"user_id":5252,"user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}}},{"id":7552,"approve_id":2109,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}}],"approveVerifyRels":[{"id":2743,"approve_id":2109,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":2743,"approve_id":2109,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}}},"haveApproveVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":"","files":[],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#00B7EE","status_display":"\u5ba1\u6279\u4e2d"},{"id":2108,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":1,"next_verify_user":1001,"verify_at":"","description":"\u4ed8\u6b3e\u5ba1\u6279","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:49:30","updated_at":"2025-08-05 13:26:11","supplier_id":"","purchase_contract_id":"","amount":"","borrow_amount":"123456","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"1","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2108,"comment":2},"unreadComments":{},"type":{"id":2100000001,"name":"\u501f\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7582,"approve_id":2108,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7583,"approve_id":2108,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7584,"approve_id":2108,"user_id":5016,"user":{"id":5016,"key":5016,"name":"\u9ad8\u90e1\u9633","sex":"M","avatar":{"id":35,"user_id":5016,"name":"\/files\/cdn\/a57be577deb434\/avatar\/404e0bcf-6382-3f63-b93b-4d936f35a4b2.png"}}}],"approveVerifyRels":[{"id":2760,"approve_id":2108,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]},{"id":2761,"approve_id":2108,"user_id":1011,"status":0,"description":"","verify_at":"","user":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{"id":2760,"approve_id":2108,"user_id":1001,"status":0,"description":"","verify_at":"","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}},"haveApproveVerifyRel":{},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","files":[],"unread":0,"can_update":true,"can_delete":true,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#00B7EE","status_display":"\u5ba1\u6279\u4e2d"},{"id":2107,"client_id":"","project_id":"","title":"\u975e\u5730\u65b9","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:48:47","description":"f\u5f85\u53d1","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:48:44","updated_at":"2025-08-04 11:48:47","supplier_id":431,"purchase_contract_id":4072,"amount":"1","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"1","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2107,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7547,"approve_id":2107,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2741,"approve_id":2107,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:48:47","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2741,"approve_id":2107,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:48:47"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4072,"key":4072,"name":"\u6d4b\u8bd5\u8c01\u662f\u8c01","cost_type":1},"files":[],"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7"},{"id":2106,"client_id":"","project_id":"","title":"v\u4eba\u7684","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:45:49","description":"v\u7684\u98ce\u683c","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:45:46","updated_at":"2025-08-04 11:45:49","supplier_id":431,"purchase_contract_id":4072,"amount":"1","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"1","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2106,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7546,"approve_id":2106,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2740,"approve_id":2106,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:45:49","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2740,"approve_id":2106,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:45:49"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4072,"key":4072,"name":"\u6d4b\u8bd5\u8c01\u662f\u8c01","cost_type":1},"files":[],"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7"},{"id":2105,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:34:31","description":"\u6d4b\u8bd5","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:32:56","updated_at":"2025-08-04 11:34:31","supplier_id":431,"purchase_contract_id":4072,"amount":"2222","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"2222","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2105,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7545,"approve_id":2105,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2739,"approve_id":2105,"user_id":5252,"status":1,"description":"\u6d4b\u8bd5","verify_at":"2025-08-04 11:34:31","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2739,"approve_id":2105,"user_id":5252,"status":1,"description":"\u6d4b\u8bd5","verify_at":"2025-08-04 11:34:31"},"attachmentRelationships":[],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4072,"key":4072,"name":"\u6d4b\u8bd5\u8c01\u662f\u8c01","cost_type":1},"files":[],"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7"},{"id":2103,"client_id":"","project_id":"","title":"\u6d4b\u8bd5","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:30:10","description":"\u5403","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:03:30","updated_at":"2025-08-04 11:30:10","supplier_id":431,"purchase_contract_id":4072,"amount":"4000","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"5068","erp_payment_un_settle_amount":"-1068","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2103,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7544,"approve_id":2103,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2738,"approve_id":2103,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:30:10","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2738,"approve_id":2103,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:30:10"},"attachmentRelationships":[{"id":37345,"object_type":28,"object_id":2103,"attachment_id":27143,"attachment":{"id":27143,"key":27143,"name":"\/files\/protected\/a57be577deb434\/2025\/08\/be83c968-2963-3390-8bea-7fd4edb49161.png","extension":"png","orig_name":"\u622a\u5c4f2025-08-04 10.34.45.png"}}],"client":{},"project":{},"supplier":{"id":431,"key":431,"name":"\u5317\u4eac\u60e0\u8054\u8baf\u901a\u4fe1\u606f\u6280\u672f\u670d\u52a1\u6709\u9650\u516c\u53f8"},"purchaseContract":{"id":4072,"key":4072,"name":"\u6d4b\u8bd5\u8c01\u662f\u8c01","cost_type":1},"files":[],"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7"},{"id":2104,"client_id":"","project_id":"","title":"\u662f\u5426\u5bf9\u7684\u4e8b","status":2,"next_verify_user":"","verify_at":"2025-08-04 11:16:45","description":"\u662f\u5426","refuse_description":"","is_resubmited":false,"created_by":5252,"created_at":"2025-08-04 11:16:41","updated_at":"2025-08-04 11:16:45","supplier_id":"","purchase_contract_id":"","amount":"333","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"333","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","department_id":6,"avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"},"department":{"id":6,"key":6,"name":"\u8d22\u52a1\u90e8"}},"commentCount":{"object_id":2104,"comment":1},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7541,"approve_id":2104,"user_id":1001,"user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}}}],"approveVerifyRels":[{"id":2735,"approve_id":2104,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:16:45","user":{"id":5252,"key":5252,"name":"\u738b\u7b11\u7b11","sex":"F","avatar":{"id":101,"user_id":5252,"name":"\/files\/cdn\/a57be577deb434\/avatar\/f5529321-408e-3d11-aa95-9b0a384f2d9c.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2735,"approve_id":2104,"user_id":5252,"status":1,"description":"","verify_at":"2025-08-04 11:16:45"},"attachmentRelationships":[],"client":{},"project":{},"supplier":"","purchaseContract":"","files":[],"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7"},{"id":2097,"client_id":12,"project_id":3930,"title":"\u4ed8\u6b3e\u7533\u8bf7-\u6dd8\u5b9d\u7f51\uff08\u4e2a\u4eba\u5df2\u57ab\u4ed8\uff09","status":2,"next_verify_user":"","verify_at":"2025-07-28 17:55:50","description":"Tristen\uff0c\u7533\u8bf7\u652f\u4ed8\u56fa\u6001\u76d8\u91c7\u8d2d\u6b3e\uff0c\u91d1\u989d\uff1a\uffe5130\u5143\uff0c\u8bf7\u5ba1\u6279\uff01\n\n\u5907\u6ce8\uff1a\u7eb8\u8d28\u5355\u636e\u5df2\u63d0\u4ea4\u5ba1\u6838\uff01","refuse_description":"","is_resubmited":false,"created_by":1011,"created_at":"2025-07-28 17:55:34","updated_at":"2025-07-28 17:55:50","supplier_id":608,"purchase_contract_id":4069,"amount":"130","borrow_amount":"","borrow_collect_day":"","borrow_collect_status":0,"borrow_collect_description":"","borrow_collect_at":"","erp_payment_settle_amount":"0","erp_payment_un_settle_amount":"0","erp_borrow_settle_amount":"0","erp_borrow_un_settle_amount":"0","createdBy":{"id":1011,"key":1011,"name":"\u97e9\u96c5\u82b3","sex":"F","department_id":3,"avatar":{"id":17,"user_id":1011,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b54747f4-248d-380e-93bc-0f62f769e70d.png"},"department":{"id":3,"key":3,"name":"\u5546\u52a1\u90e8"}},"commentCount":{"object_id":2097,"comment":2},"unreadComments":{},"type":{"id":2100000000,"name":"\u4ed8\u6b3e\u7533\u8bf7"},"approveCarbonCopyRels":[{"id":7537,"approve_id":2097,"user_id":5388,"user":{"id":5388,"key":5388,"name":"\u6768\u71d5\u971e","sex":"F","avatar":{"id":156,"user_id":5388,"name":"\/files\/cdn\/a57be577deb434\/avatar\/b8d4f68f-e736-3c38-9e2f-1ab47885b3d8.png"}}},{"id":7538,"approve_id":2097,"user_id":1013,"user":{"id":1013,"key":1013,"name":"\u7fc1\u5bb6\u6210","sex":"M","avatar":{"id":34,"user_id":1013,"name":"\/files\/cdn\/a57be577deb434\/avatar\/25ef1fe7-8dda-3daa-b8ea-9fabd0a47439.png"}}},{"id":7539,"approve_id":2097,"user_id":5360,"user":{"id":5360,"key":5360,"name":"\u5f20\u7ea2\u82b3","sex":"F","avatar":{"id":153,"user_id":5360,"name":"\/files\/cdn\/a57be577deb434\/avatar\/612c2410-e800-3507-aa05-3f1fbeb408a7.png"}}}],"approveVerifyRels":[{"id":2733,"approve_id":2097,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 17:55:50","user":{"id":1001,"key":1001,"name":"\u5218\u4eba\u8bda","sex":"M","avatar":{"id":2,"user_id":1001,"name":"\/files\/cdn\/a57be577deb434\/avatar\/9f73cfbd-bae6-3b50-b7ac-61b936c40727.png"}},"attachmentRelationships":[],"files":[]}],"lastApproveVerifyRel":{},"haveApproveVerifyRel":{"id":2733,"approve_id":2097,"user_id":1001,"status":1,"description":"","verify_at":"2025-07-28 17:55:50"},"attachmentRelationships":[],"client":{"id":12,"key":12,"name":"smc(\u4e2d\u56fd)\u6709\u9650\u516c\u53f8\/SMC(\u5317\u4eac)\u5236\u9020\u6709\u9650\u516c\u53f8"},"project":{"id":3930,"key":3930,"name":"POTJ25078337-\u56fa\u6001\u786c\u76d8-2025"},"supplier":{"id":608,"key":608,"name":"\u6dd8\u5b9d\u7f51"},"purchaseContract":{"id":4069,"key":4069,"name":"\u8ba2\u5355\u53f7: 4651203278745161702\t","cost_type":1},"files":[{"id":36098,"object_type":29,"object_id":2097,"attachment_id":27103,"attachment":{"id":27103,"key":27103,"name":"\/files\/protected\/var\/www\/html\/web\/files\/protected\/a57be577deb434\/2025\/07\/0186417a-90af-3f39-ba73-82a4ee437d40.pdf","extension":"pdf","orig_name":"2025_07_25_17_08_57.pdf"}}],"unread":0,"can_update":false,"can_delete":false,"can_resubmit":false,"can_verify":false,"can_refuse":false,"can_borrow":false,"borrow_expire_day":"","bgcolor":"#F39800","status_display":"\u5df2\u901a\u8fc7"}],"countArr":[{"key":"all","name":"\u5168\u90e8","count":1971},{"key":1,"name":"\u5ba1\u6279\u4e2d","count":4},{"key":2,"name":"\u5df2\u901a\u8fc7","count":1941},{"key":4,"name":"\u5df2\u62d2\u7edd","count":26}],"navCount":[{"key":"approve","name":"\u6211\u5ba1\u6279\u7684","value":0},{"key":"copy","name":"\u6284\u9001\u6211\u7684","value":0}],"can_create":true,"pagenation":{"totalcount":1971,"thispage":1,"pagesize":10}},"status":1,"msg":[{"name":"success","success":"\u6210\u529f\u83b7\u53d6\u6570\u636e","error":""}]}', FALSE, '2025-08-05 13:47:03') RETURNING "id" |
13:47:03.473 | 5.4 ms | yii\db\Connection::open | Opening DB connection: pgsql:host=postgresql.server.local;port=5432;dbname=beta |
13:47:03.478 | 4.3 ms | yii\db\Command::query | SELECT * FROM "global"."vw_user_login" WHERE "access_token"='JaijjTZWzZjgdx9RhHhwFXGU-e0N-Sfm' |
13:47:03.742 | 2.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=28) AND ("object_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097)) |
13:47:03.734 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=30) AND ("object_id" IN (2733, 2735, 2738, 2739, 2740, 2741, 2743, 2748, 2749, 2760, 2761, 2769, 2770, 2771, 2772)) |
13:47:03.749 | 2.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=29) AND ("object_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097)) |
13:47:03.737 | 2.4 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_attachement_relationships" WHERE ("object_type"=31) AND ("object_id" IN (2733, 2735, 2738, 2739, 2740, 2741, 2743, 2748, 2749, 2760, 2761, 2769, 2770, 2771, 2772)) |
13:47:03.484 | 2.0 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_users" WHERE "id"=1000 |
13:47:03.537 | 1.4 ms | yii\db\Command::query | SELECT COUNT(*) FROM "a57be577deb434"."tbl_approves" WHERE ("next_verify_user"=1000) AND ("status" != 0) |
13:47:03.729 | 1.3 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_carbon_copy_rels" WHERE "approve_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097) |
13:47:03.492 | 0.9 ms | yii\db\Command::query | SELECT "id" FROM "a57be577deb434"."tbl_users" WHERE "user_status"='1' ORDER BY "id" |
13:47:03.727 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_term_taxonomy_relationships" WHERE "object_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097) |
13:47:03.731 | 0.8 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE "approve_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097) ORDER BY "id" |
13:47:03.741 | 0.7 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status" != 0) AND ("approve_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097)) ORDER BY "id" |
13:47:03.745 | 0.7 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27143 |
13:47:03.657 | 0.6 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 5252, 1000)) |
13:47:03.739 | 0.6 ms | yii\db\Command::query | SELECT * FROM "a57be577deb434"."tbl_approve_verify_rels" WHERE ("status"=0) AND ("approve_id" IN (2111, 2110, 2109, 2108, 2107, 2106, 2105, 2103, 2104, 2097)) ORDER BY "id" |
13:47:03.747 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "project_title" AS "name" FROM "a57be577deb434"."tbl_projects" WHERE "id"=3930 |
13:47:03.728 | 0.6 ms | yii\db\Command::query | SELECT "id", "name" FROM "a57be577deb434"."tbl_term_taxonomies" WHERE ("term_id"=17) AND ("id" IN (326, 155, 156, 164, 179, 172, 154, 212, 226, 129, 175, 153, 227, 210, 165, 131, 174, 197, 194, 171, 205, 173, 199, 184, 200, 204, 183, 187, 2, 331, 133, 354, 359, 372, 374, 377, 2100000000, 319, 2100000001)) |
13:47:03.748 | 0.6 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "serial_no" AS "name", "cost_type" FROM "a57be577deb434"."tbl_purchase_contracts" WHERE "id" IN (4072, 4069) |
13:47:03.747 | 0.5 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_suppliers" WHERE "id" IN (431, 608) |
13:47:03.731 | 0.5 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1001, 5252, 5250, 5016, 5388, 1013, 5360)) |
13:47:03.658 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_departments" WHERE "id" IN (3, 6, 10) |
13:47:03.733 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1001, 5252, 1011, 5250, 1017) |
13:47:03.730 | 0.4 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (5388, 1013, 5360, 1001, 5252, 5250, 5016) |
13:47:03.657 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex", "department_id" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1000, 5252, 1011) |
13:47:03.740 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "sex" FROM "a57be577deb434"."tbl_users" WHERE "id" IN (1011, 5250, 1001, 5252, 1017) |
13:47:03.746 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name" FROM "a57be577deb434"."tbl_clients" WHERE "id"=12 |
13:47:03.741 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5252, 5250, 1017)) |
13:47:03.733 | 0.3 ms | yii\db\Command::query | SELECT "id", "user_id", "meta_value" AS "name" FROM "a57be577deb434"."tbl_user_meta" WHERE ("meta_key"='avatar') AND ("user_id" IN (1011, 1001, 5252, 5250, 1017)) |
13:47:03.752 | 0.3 ms | yii\db\Command::query | SELECT "id", "id" AS "key", "name", "extension", "path", "orig_name" FROM "a57be577deb434"."tbl_attachments" WHERE "id"=27103 |