SQL Report


Page generated in 0.6557 seconds with 12 queries + 2 queries returning data from cache

Time spent on mysqli queries: 0.02546s | Time spent on PHP: 0.63026s



Query #1
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_configrefis_dynamicis_dynamic4const26 

Before: 0.25922s | After: 0.25956s | Elapsed: 0.00034s



Query #2
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_usersconstPRIMARYPRIMARY4const1 

Before: 0.37607s | After: 0.37694s | Elapsed: 0.00087s



Query #3
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_banlistALLban_user,ban_email,ban_ip   45Using where

Before: 0.37795s | After: 0.38171s | Elapsed: 0.00376s



Query #4

Before: 0.38780s | After: 0.38821s | Elapsed: 0.00041s



Query #5
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_sessionsALLsession_time,session_user_id   271Using where

Before: 0.38872s | After: 0.38935s | Elapsed: 0.00063s



Query #6
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEtconstPRIMARY,forum_id,forum_id_type,fid_time_moved,forum_vis_last,latest_topicsPRIMARY4const1 
1SIMPLEfconstPRIMARYPRIMARY4const1 

Before: 0.39555s | After: 0.39619s | Elapsed: 0.00064s



Query results obtained from the cache

Before: 0.41410s | After: 0.41471s | Elapsed [cache]: 0.00061s | Elapsed [db]: 0.00053s



Query #8
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefauth_option_id,auth_role_idauth_option_id4const1Using where

Before: 0.42225s | After: 0.42273s | Elapsed: 0.00048s



Query #9
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLErrefPRIMARY,ath_op_idath_op_id4const4 
1SIMPLEarefauth_role_idauth_role_id4Sql1089517_1.r.role_id20Using where

Before: 0.42345s | After: 0.42407s | Elapsed: 0.00063s



Query #10
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLEarefgroup_id,auth_opt_id,auth_role_idauth_opt_id4const1Using where
1SIMPLEgeq_refPRIMARYPRIMARY4Sql1089517_1.a.group_id1 
1SIMPLEugrefgroup_id,group_leadergroup_id4Sql1089517_1.a.group_id545Using where

Before: 0.42676s | After: 0.42727s | Elapsed: 0.00051s



Query #11
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEaoconstPRIMARY,auth_optionauth_option152const1Using index
1SIMPLErrefPRIMARY,ath_op_idath_op_id4const4 
1SIMPLEarefgroup_id,auth_role_idauth_role_id4Sql1089517_1.r.role_id92Using where
1SIMPLEgeq_refPRIMARYPRIMARY4Sql1089517_1.a.group_id1 
1SIMPLEugrefgroup_id,group_leadergroup_id4Sql1089517_1.a.group_id545Using where

Before: 0.42786s | After: 0.42835s | Elapsed: 0.00049s



Query results obtained from the cache

Before: 0.43755s | After: 0.43817s | Elapsed [cache]: 0.00062s | Elapsed [db]: 0.00080s



Query #13
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLE       Impossible WHERE noticed after reading const tables

Before: 0.52661s | After: 0.52692s | Elapsed: 0.00031s



Query #14
IdSelect TypeTableTypePossible KeysKeyKey LenRefRowsExtra
1SIMPLEphpbb_forumsALL    73Using filesort

Before: 0.57605s | After: 0.59243s | Elapsed: 0.01638s