After installing some extensions, the time it takes to open the homepage is currently around one second, which is too long for me. I'd like to reduce it to around 500ms. My forum runs on a 16-core 32GB VPS. I've already optimized the parameters for PHP and MySQL as much as possible. Now, if the performance bottleneck lies with the plugins, how should I optimize them? Do you have any suggestions? Additionally, if I want to view all executed SQL statements to optimize them during execution, how should I proceed? Thank you.
Flarum core: 1.8.5
PHP version: 8.2.16
MySQL version: 5.7.44-log
Loaded extensions: Core, date, libxml, openssl, pcre, sqlite3, zlib, bcmath, ctype, curl, dom, filter, ftp, gd, gettext, hash, iconv, intl, json, mbstring, SPL, session, pcntl, standard, mysqlnd, PDO, pdo_mysql, pdo_sqlite, Phar, posix, random, Reflection, mysqli, shmop, SimpleXML, soap, sockets, sodium, sysvsem, tokenizer, xml, xmlreader, xmlwriter, zip, fileinfo, igbinary, redis, exif, imagick, Zend OPcache
+----------------------------------------+---------+--------+
| Flarum Extensions | | |
+----------------------------------------+---------+--------+
| ID | Version | Commit |
+----------------------------------------+---------+--------+
| askvortsov-auto-moderator | v0.1.3 | |
| flarum-likes | v1.8.0 | |
| flarum-flags | v1.8.0 | |
| flarum-tags | v1.8.0 | |
| antoinefr-money | v1.3.1 | |
| fof-doorman | 1.1.4 | |
| afrux-forum-widgets-core | v0.1.7 | |
| flarum-suspend | v1.8.1 | |
| fof-pages | 1.0.8 | |
| fof-oauth | 1.6.6 | |
| flarum-approval | v1.8.1 | |
| flarum-mentions | v1.8.3 | |
| ziiven-raffle-ticket | v1.1.3 | |
| ziiven-money-leaderboard | v0.1.7 | |
| ziiven-decoration-store | v1.0.8 | |
| ziiven-daily-check-in | v0.3.7 | |
| zerosonesfun-composer-preview | 1.3 | |
| xypp-pay-to-read | v1.2.0 | |
| v17development-user-badges | v1.1.0 | |
| v17development-seo | v1.8.0 | |
| swaggymacro-only-starter | 0.6.6 | |
| pipecraft-id-slug | v1.1.0 | |
| noriods-auto-more | v1.0.0 | |
| nodeloc-whisper | 0.0.4 | |
| nodeloc-referral | 0.0.1 | |
| nodeloc-pagination | 0.1 | |
| nodeloc-my-emoji | 1.0.0 | |
| nodeloc-lottery | 0.0.2 | |
| nodeloc-ignore-hidden-tags | 1.0 | |
| nodeloc-friend-link | 0.1 | |
| nodeloc-dislikes | 1.0.1 | |
| nodeloc-checkin-leaderboard | 1.0.1 | |
| nearata-embed-video | 3.3.2 | |
| justoverclock-welcomebox | 2.0.2 | |
| justoverclock-last-registered-users | 0.1.5 | |
| justoverclock-hot-discussions | 0.1.2 | |
| imeepo-more-bbcode | v1.0.3 | |
| ianm-syndication | 1.3.4 | |
| ianm-boring-avatars | 1.0.0 | |
| glowingblue-redis-setup | 1.2.1 | |
| foskym-custom-levels | v1.0.3 | |
| fof-user-bio | 1.3.1 | |
| fof-terms | 1.3.0 | |
| fof-sitemap | 2.2.1 | |
| fof-recaptcha | 1.3.2 | |
| fof-profile-image-crop | 1.1.6 | |
| fof-prevent-necrobumping | 1.1.2 | |
| fof-pretty-mail | 1.1.2 | |
| fof-polls | 2.1.2 | |
| fof-nightmode | 1.5.3 | |
| fof-moderator-notes | 1.2.2 | |
| fof-merge-discussions | 1.4.1 | |
| fof-links | 1.2.1 | |
| fof-ignore-users | 1.2.1 | |
| fof-github-autolink | 1.1.4 | |
| fof-drafts | 1.2.10 | |
| fof-default-group | 1.1.2 | |
| fof-best-answer | 1.4.1 | |
| flarumite-simple-discussion-views | 1.2.2 | |
| flarum-subscriptions | v1.8.0 | |
| flarum-sticky | v1.8.0 | |
| flarum-statistics | v1.8.0 | |
| flarum-pusher | v1.8.0 | |
| flarum-nicknames | v1.8.0 | |
| flarum-markdown | v1.8.0 | |
| flarum-lock | v1.8.0 | |
| flarum-lang-english | v1.8.0 | |
| flarum-lang-chinese-simplified | v1.3.0 | |
| flarum-bbcode | v1.8.0 | |
| ffans-clipboardjs | v1.0.0 | |
| davwheat-ads | 1.2.0 | |
| darkle-fancybox | 1.1.2 | |
| club-1-cross-references | v1.1.1 | |
| clarkwinkelmann-scout | 0.3.5 | |
| clarkwinkelmann-prominent-post-numbers | 1.0.1 | |
| clarkwinkelmann-money-rewards | 1.0.0 | |
| clarkwinkelmann-discussion-bookmarks | 2.0.1 | |
| clarkwinkelmann-auth-popup-failsafe | 0.1.1 | |
| askvortsov-moderator-warnings | v0.6.3 | |
| afrux-top-posters-widget | v0.1.4 | |
| afrux-news-widget | v0.1.1 | |
+----------------------------------------+---------+--------+
Base URL: https://www.nodeloc.com
Installation path: /www/wwwroot/www.nodeloc.com
Queue driver: redis
Session driver: redis (Code override. Configured to file)
Scheduler status: Active
Mail driver: smtp
Debug mode: off
