The issue
After updating my forum, a visit becomes really SLOW(about 50s)
Although I fallback the version.
Do anyone have an idea about what happend?
Here is the slow log:
[26-Apr-2023 01:47:48] [pool www] pid 14417
script_filename = /www/wwwroot/flarum/public/index.php
[0x00007f033c4199c0] prepare() /www/wwwroot/flarum/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOConnection.php:82
[0x00007f033c419920] prepare() /www/wwwroot/flarum/vendor/illuminate/database/Connection.php:368
[0x00007f033c419800] Illuminate\Database\{closure}() /www/wwwroot/flarum/vendor/illuminate/database/Connection.php:705
[0x00007f033c419750] runQueryCallback() /www/wwwroot/flarum/vendor/illuminate/database/Connection.php:672
[0x00007f033c419670] run() /www/wwwroot/flarum/vendor/illuminate/database/Connection.php:376
[0x00007f033c4195e0] select() /www/wwwroot/flarum/vendor/illuminate/database/Query/Builder.php:2414
[0x00007f033c419570] runSelect() /www/wwwroot/flarum/vendor/illuminate/database/Query/Builder.php:2402
[0x00007f033c419490] Illuminate\Database\Query\{closure}() /www/wwwroot/flarum/vendor/illuminate/database/Query/Builder.php:2936
[0x00007f033c4193f0] onceWithColumns() /www/wwwroot/flarum/vendor/illuminate/database/Query/Builder.php:2403
[0x00007f033c419310] get() /www/wwwroot/flarum/vendor/illuminate/database/Query/Builder.php:2863
[0x00007f033c419270] aggregate() /www/wwwroot/flarum/vendor/illuminate/database/Query/Builder.php:2791
[0x00007f033c4191f0] count() /www/wwwroot/flarum/vendor/illuminate/database/Eloquent/Builder.php:1657
[0x00007f033c419140] __call() /www/wwwroot/flarum/vendor/ianm/follow-users/src/FollowState.php:54
[0x00007f033c4190d0] getFollowingCount() /www/wwwroot/flarum/vendor/ianm/follow-users/src/AddUserAttributes.php:38
[0x00007f033c419000] __invoke() /www/wwwroot/flarum/vendor/flarum/core/src/Foundation/ContainerUtil.php:30
[0x00007f033c418f40] Flarum\Foundation\{closure}() /www/wwwroot/flarum/vendor/flarum/core/src/Api/Serializer/AbstractSerializer.php:95
[0x00007f033c418e00] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:183
[0x00007f033c418d90] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:233
[0x00007f033c418c90] mergeAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:187
[0x00007f033c418c20] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:233
[26-Apr-2023 01:58:16] [pool www] pid 14401
script_filename = /www/wwwroot/flarum/public/index.php
[0x00007f033c417560] getCasts() /www/wwwroot/flarum/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php:1426
[0x00007f033c417470] hasCast() /www/wwwroot/flarum/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php:1999
[0x00007f033c4173f0] transformModelValue() /www/wwwroot/flarum/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php:451
[0x00007f033c417380] getAttributeValue() /www/wwwroot/flarum/vendor/illuminate/database/Eloquent/Concerns/HasAttributes.php:430
[0x00007f033c417310] getAttribute() /www/wwwroot/flarum/vendor/flarum/core/src/Database/AbstractModel.php:125
[0x00007f033c417200] getAttribute() /www/wwwroot/flarum/vendor/illuminate/database/Eloquent/Model.php:2065
[0x00007f033c417190] offsetGet() unknown:0
[0x00007fff50ba53d0] ???() /www/wwwroot/flarum/vendor/malago/flarum-achievements/src/AddUserData.php:31
[0x00007f033c417000] __invoke() /www/wwwroot/flarum/vendor/flarum/core/src/Foundation/ContainerUtil.php:30
[0x00007f033c416f40] Flarum\Foundation\{closure}() /www/wwwroot/flarum/vendor/flarum/core/src/Api/Serializer/AbstractSerializer.php:95
[0x00007f033c416e00] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:183
[0x00007f033c416d90] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:233
[0x00007f033c416c90] mergeAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:187
[0x00007f033c416c20] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:233
[0x00007f033c416b20] mergeAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:187
[0x00007f033c416ab0] getAttributes() /www/wwwroot/flarum/vendor/sycho/json-api/src/Resource.php:81
[0x00007f033c4169e0] toArray() /www/wwwroot/flarum/vendor/sycho/json-api/src/Document.php:194
[0x00007f033c416970] Tobscure\JsonApi\{closure}() /www/wwwroot/flarum/vendor/sycho/json-api/src/Document.php:193
[0x00007f033c416900] array_map() /www/wwwroot/flarum/vendor/sycho/json-api/src/Document.php:193
[0x00007f033c416880] toArray() /www/wwwroot/flarum/vendor/sycho/json-api/src/Document.php:232
