SQL Report


Page generated in 0.2321 seconds with 11 queries + 4 queries returning data from cache

Time spent on mysqli queries: 0.12656s | Time spent on PHP: 0.10557s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic1const22 

Before: 0.01060s | After: 0.01084s | Elapsed: 0.00024s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY3const1 

Before: 0.03941s | After: 0.04036s | Elapsed: 0.00095s



Query results obtained from the cache

Before: 0.04171s | After: 0.04211s | Elapsed [cache]: 0.00040s | Elapsed [db]: 0.00022s



Query #4
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.04361s | After: 0.08748s | Elapsed: 0.04386s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configconstPRIMARYPRIMARY767const1 

Affected rows: 1 | Before: 0.08868s | After: 0.12667s | Elapsed: 0.03799s



Query #6

Before: 0.12715s | After: 0.16102s | Elapsed: 0.03388s



Query #7
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsrangesession_time,session_user_idsession_time4 367Using where

Before: 0.16286s | After: 0.16687s | Elapsed: 0.00402s



Query results obtained from the cache

Before: 0.17282s | After: 0.17323s | Elapsed [cache]: 0.00041s | Elapsed [db]: 0.00035s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsindexPRIMARYforum_lastpost_id3 53Using where; Using index

Before: 0.18233s | After: 0.18267s | Elapsed: 0.00034s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEfALLPRIMARY   53Using where; Using filesort
1SIMPLEfarefPRIMARYPRIMARY3forum_fedegnv3.f.forum_id1Using where; Using index

Before: 0.18566s | After: 0.18808s | Elapsed: 0.00242s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefforum_id,poster_id,post_visibilityposter_id3const1Using where; Using filesort

Before: 0.19349s | After: 0.19468s | Elapsed: 0.00119s



Query #12
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEprefforum_id,poster_id,post_visibilityposter_id3const1Using where; Using filesort

Before: 0.19622s | After: 0.19749s | Elapsed: 0.00127s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE       No tables used

Before: 0.19849s | After: 0.19890s | Elapsed: 0.00041s



Query results obtained from the cache

Before: 0.20398s | After: 0.20442s | Elapsed [cache]: 0.00044s | Elapsed [db]: 0.00025s



Query results obtained from the cache

Before: 0.21699s | After: 0.21797s | Elapsed [cache]: 0.00098s | Elapsed [db]: 0.00074s