XF 1 Optimize or cache

[matyprot]

Hi, please help me, i need cache or any fix for my forum, this have lot of DB requests, can you please optimize or cache it?

Page Time: 2.4018s
Memory: 48.5851 MB (Peak: 52.7648 MB)
Queries (548, time: 2.0061s, 83.5%)

    Params: 2
    Run Time: 0.000487
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    xf_phrase_compiled    range    PRIMARY    PRIMARY    106         133    Using where

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000282
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000261
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000227
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000170
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000161
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000160
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000158
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000157
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000157
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000271
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000205
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000197
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000316
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000262
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000177
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000178
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000211
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000214
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000216
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000186
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000171
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000169
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000170
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000169
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000171
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000166
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000171
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000166
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000167
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000174
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000171
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000168
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000295
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000212
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000204
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000204
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000202
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000196
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000204
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000206
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000206
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000211
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000196
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000207
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000295
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000245
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000205
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000232
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000226
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000250
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000204
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000187
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000191
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000161
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000162
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000159
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

    SELECT domain.*
    FROM xc_mss_domain AS domain
    ORDER BY domain.active DESC, domain.title ASC

    Run Time: 0.000160
    Select Type    Table    Type    Possible Keys    Key    Key Len    Ref    Rows    Extra
    SIMPLE    domain    ALL                        18    Using filesort

 

[Snog]

That is coming from an addon. I think the xencentral multi-site addon. Talk to them about it.

XenCentral Multisite System [Paid]

XCentral updated XenCentral Multisite System with a new update entry: XenCentral Multisite System 2.1.0 Beta 1 is Released XenForo 2.1 compatible Multisite System 2.1.0 Beta 1 is released. Resource link: https://xenforo.com/community/resources/xencentral-multisite-system-2.6966/ All Multisite...

xenforo.com

 

[Xon]

You have 2 seconds of query time for +540 queries, this is absolutely an issue with that Multisite system add-on