Anmelden
Benutzername  
Kennwort  


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

Memory Usage: 19.394 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.204.0.181' AND `idhash` = 'a430c06a8860ba84efb0411319a4e4fd' 
 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.204.0.181' AND `idhash` = 'a430c06a8860ba84efb0411319a4e4fd' 
 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 node.*, cl.parent, cl.child, cl.depth, cl.displayorder AS clorder, 'Channel' AS contenttypeclass 
			FROM closure AS cl
			INNER JOIN node AS node ON node.nodeid = cl.child
			 WHERE cl.parent  = 1
AND node.contenttypeid = 23
AND node.nodeid IN (1,2,3,4,7,8,9,10,13,14,15,16,17,18,19,20,21,22)
 ORDER BY node.parentid ASC, node.displayorder ASC
/**getChannel**/
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEclrangeclosure_uniq,parent_2,childclosure_uniq8 18Using where; Using temporary; Using filesort
1SIMPLEnodeeq_refPRIMARY,node_ctypid_userid_dispo_idx,nodeid,contenttypeid_parentidPRIMARY4d01c6db3.cl.child1Using where

SQL Query #19

SELECT `nodeid` FROM node
 WHERE `nodeid` IN (1,2,14,4,7,3,17,15,16,8,9,10,13,18,19,20,21,22) AND `protected` = 1  
idselect_typetabletypepossible_keyskeykey_lenrefrowsExtra
1SIMPLEnodeALLPRIMARY,nodeid   41Using where

SQL Query #20

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

SQL Query #21

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

SQL Query #22

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

SQL Query #23

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

SQL Query #24

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

24 Queries Run : Total SQL time was 0.004089 seconds , Total PHP time was 0.150287 seconds , Overall time was 0.154376 seconds.