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?
Code:
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
