Improve perfomance

[arogachev]

Q	A
Is bugfix?	❌
New feature?	❌
Breaks BC?	✔️

[codecov[bot]]

Codecov Report

Attention: 2 lines in your changes are missing coverage. Please review.

Comparison is base (1a805a7) 99.42% compared to head (00395e6) 96.18%. Report is 1 commits behind head on master.

:exclamation: Current head 00395e6 differs from pull request most recent head 6db6f55. Consider uploading reports for the commit 6db6f55 to get more accurate results

Additional details and impacted files

```diff @@ Coverage Diff @@ ## master #46 +/- ## ============================================ - Coverage 99.42% 96.18% -3.24% - Complexity 123 149 +26 ============================================ Files 9 7 -2 Lines 518 656 +138 ============================================ + Hits 515 631 +116 - Misses 3 25 +22 ``` | [Files](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft) | Coverage Δ | | |---|---|---| | [src/DbSchemaManager.php](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft#diff-c3JjL0RiU2NoZW1hTWFuYWdlci5waHA=) | `100.00% <100.00%> (ø)` | | | [src/ItemTreeTraversal/CteItemTreeTraversal.php](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft#diff-c3JjL0l0ZW1UcmVlVHJhdmVyc2FsL0N0ZUl0ZW1UcmVlVHJhdmVyc2FsLnBocA==) | `100.00% <100.00%> (ø)` | | | [src/ItemTreeTraversal/MysqlItemTreeTraversal.php](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft#diff-c3JjL0l0ZW1UcmVlVHJhdmVyc2FsL015c3FsSXRlbVRyZWVUcmF2ZXJzYWwucGhw) | `100.00% <100.00%> (ø)` | | | [src/ItemsStorage.php](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft#diff-c3JjL0l0ZW1zU3RvcmFnZS5waHA=) | `100.00% <100.00%> (ø)` | | | [src/TransactionalManagerDecorator.php](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft#diff-c3JjL1RyYW5zYWN0aW9uYWxNYW5hZ2VyRGVjb3JhdG9yLnBocA==) | `100.00% <100.00%> (+4.54%)` | :arrow_up: | | [src/AssignmentsStorage.php](https://app.codecov.io/gh/yiisoft/rbac-db/pull/46?src=pr&el=tree&utm_medium=referral&utm_source=github&utm_content=comment&utm_campaign=pr+comments&utm_term=yiisoft#diff-c3JjL0Fzc2lnbm1lbnRzU3RvcmFnZS5waHA=) | `77.27% <95.23%> (-22.73%)` | :arrow_down: |

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

[what-the-diff[bot]]

PR Summary

• Enhanced CHANGELOG.md File An essential file keeping track of project version history has been updated, providing clearer and updated project information.
• Updated Dependency yiisoft/rbac The version of a key component, yiisoft/rbac, has been changed, which could result in improved performance and/or additional features.
• Refactored Methods in AssignmentsStorage.php The getByUserId and getByItemNames methods have been tweaked for a better flow.
• New Methods in ItemTreeTraversalInterface.php New methods named getChildPermissionRows, getChildRoleRows, and hasChild have been added to improve versatility and extend existing functionality.
• Refactored getParentRows and getChildrenRows Methods The logic of these methods is more streamlined, which should result in improved efficiency.
• More Methods in MysqlItemTreeTraversal.php File Additional methods like getRowsStatement, getAllChildPermissions, getAllChildRoles, and hasChild have been added, further extending the utility of this module.
• Refactored Methods in ItemsStorage.php The exists and roleExists methods have been revamped with better readability and enhanced operation.
• Updated assign Method in TransactionalManagerDecorator.php The assign method now includes a createdAt parameter making the system more informative.
• Adjusted Unit Tests Various test methods have been updated for more accurate testing.
• Removed and Marked Certain Tests as Skipped The testRemoveChild method is no longer active for now; it's marked as skipped, indicating a temporary deactivation.