Anmelden
Benutzername  
Kennwort  


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

Memory Usage: 18.556 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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEdatastore rangePRIMARYPRIMARY50 17100.00Using where

SQL Query #3

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '3.236.15.142' AND `idhash` = '4ecbdd718f434d119d979f2c1e6a71f0' 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refuser_activity,guest_lookupguest_lookup51const,const,const1100.00 

SQL Query #4

SELECT * FROM cache
 WHERE `cacheid` IN ('453a62c209e884f4d35a4838504e7166') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #5

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_CommonRoutes') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #6

SELECT * FROM routenew
 WHERE `prefix` IN ('modcp/','modcp') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEroutenew rangeprefixprefix202 2100.00Using index condition

SQL Query #7

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_UserPerms0') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #8

SELECT * FROM cache
 WHERE `cacheid` IN ('vb_types.types') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

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_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEchannel ALLguid   3141.94Using where

SQL Query #10

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #11

SELECT * FROM cache
 WHERE `cacheid` IN ('channelperms_1') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #12

SELECT * FROM style
 WHERE `styleid` = 5 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEstyle constPRIMARYPRIMARY2const1100.00 

SQL Query #13

SELECT * FROM session
 WHERE `userid` = 0 AND `host` = '3.236.15.142' AND `idhash` = '4ecbdd718f434d119d979f2c1e6a71f0' 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEsession refuser_activity,guest_lookupguest_lookup51const,const,const1100.00 

SQL Query #14

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_NamedRoutes') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #15

SELECT * FROM cache
 WHERE `cacheid` IN ('node_1_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #16

SELECT * FROM cache
 WHERE `cacheid` IN ('3e988f42e7d4a4c78cf0b1bf5ce9922f') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #17

SELECT * FROM cache
 WHERE `cacheid` IN ('vB_ChannelStructure') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #18

SELECT COUNT(*) AS count FROM moderator
 WHERE `userid` = 0 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEmoderator refuserid_nodeiduserid_nodeid4const1100.00Using index

SQL Query #19

SELECT script, action, optionname FROM adminhelp
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEadminhelp index phraseunique181 1529100.00Using index

SQL Query #20

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl1data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

SQL Query #21

SELECT * FROM routenew
 WHERE `routeid` = 45 
 LIMIT 1
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEroutenew constPRIMARYPRIMARY4const1100.00 

SQL Query #22

SELECT * FROM cache
 WHERE `cacheid` IN ('node_2_lvl3data') 
idselect_typetablepartitionstypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEcache constPRIMARYPRIMARY66const1100.00 

22 Queries Run : Total SQL time was 0.045134 seconds , Total PHP time was 0.262228 seconds , Overall time was 0.307362 seconds.