Anmelden
Benutzername  
Kennwort  


SQL Queries (22) | $RCSfile$ - $Revision: 83864 $ | Explain

Memory Usage: 18.616 KiB

Duplicate Queries: (Exact textual duplicates, also included in the full listing of queries below)

SQL Query #1

SET @@sql_mode = ''

SQL Query #2

SELECT * FROM datastore
 WHERE `title` IN ('options','bitfields','attachmentcache','usergroupcache','stylecache','languagecache','products','cron','profilefield','loadcache','miscoptions','noticecache','hooks','publicoptions','vBUgChannelAccess','vBUgChannelPermissionsFrom','vBChannelTypes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEdatastorerangePRIMARYPRIMARY50 17Using where

SQL Query #3

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '34.238.189.171' AND `idhash` = '108ee824c2fbc39943652e776703a842' 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefuser_activity,guest_lookupguest_lookup51const,const,const1Using index condition

SQL Query #4

SELECT * FROM cache
 WHERE `cacheid` IN ('453a62c209e884f4d35a4838504e7166') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #5

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_CommonRoutes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #6

SELECT * FROM routenew
 WHERE `prefix` IN ('modcp/','modcp') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewrangeprefixprefix202 2Using index condition

SQL Query #7

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms0') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #8

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_types.types') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #9

SELECT * FROM channel
 WHERE `guid` IN ('vbulletin-4ecbdf567f2773.55528984','vbulletin-4ecbdf567f3341.44450667','vbulletin-4ecbdf567f3341.44451100','vbulletin-4ecbdf567f2c35.70389590','vbulletin-4ecbdf567f3a38.99555305','vbulletin-4ecbdf567f3a38.99555306','vbulletin-4ecbdf567f3a38.99555307','vbulletin-c-cmshome5229fa38b251e2.92227401','vbulletin-4ecbdf567f3da8.31769341','vbulletin-4ecbdf567f36c3.90966558','vbulletin-4ecbdf567f3a38.99555303','vbulletin-4ecbdf567f3a38.99555304','vbulletin-4ecbdf567f3a38.99555308') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEchannelALLguid   31Using where

SQL Query #10

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl1data') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #11

SELECT * FROM cache
 WHERE `cacheid` IN ('channelperms_1') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #12

SELECT * FROM style
 WHERE `styleid` = 5 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEstyleconstPRIMARYPRIMARY2const1 

SQL Query #13

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '34.238.189.171' AND `idhash` = '108ee824c2fbc39943652e776703a842' 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEsessionrefuser_activity,guest_lookupguest_lookup51const,const,const1Using index condition

SQL Query #14

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_NamedRoutes') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #15

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl3data') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #16

SELECT * FROM cache
 WHERE `cacheid` IN ('3e988f42e7d4a4c78cf0b1bf5ce9922f') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #17

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_ChannelStructure') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #18

SELECT COUNT(*) AS count FROM moderator
 WHERE `userid` = 0 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEmoderatorrefuserid_nodeiduserid_nodeid4const1Using index

SQL Query #19

SELECT script, action, optionname FROM adminhelp
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEadminhelpindex phraseunique181 1529Using index

SQL Query #20

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl1data') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

SQL Query #21

SELECT * FROM routenew
 WHERE `routeid` = 45 
 LIMIT 1
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEroutenewconstPRIMARYPRIMARY4const1 

SQL Query #22

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl3data') 
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEcacheconstPRIMARYPRIMARY66const1 

22 Queries Run : Total SQL time was 0.005204 seconds , Total PHP time was 0.060253 seconds , Overall time was 0.065457 seconds.