RapVerse.com Community
 Phenom | Kingz | Dabatos | TonySelf | Tha Q | Half Breed | Tito | 7th End RV Radio  

Go Back   RapVerse.com Community > The block > Lyricist Lounge
User Name
Password
FAQ Calendar Search Today's Posts Mark Forums Read

 
 
Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
Old 03-22-06, 10:43 AM   #1
Its a me.. Mario
Bone is gay.
 
Its a me.. Mario's Avatar
 
Posts: 1,651
RV Mods (Enter)

IP:

Does the following show up for any of you when you logg into your Mod CP?

Connecting to database
Time before: 0.00120091438293
Time after: 0.00176596641541
Time taken: 0.000565052032471

--------------------------------------------------------------------------------

Query:

SELECT title, data
FROM datastore
WHERE title IN ('options', 'cron', 'forumcache', 'usergroupcache', 'stylecache')

Time before: 0.00187110900879
Time after: 0.00374507904053
Time taken: 0.00187397003174

table type possible_keys key key_len ref rows Extra
datastore range PRIMARY PRIMARY 15 5 Using where


--------------------------------------------------------------------------------

Query:

SELECT *
FROM session
WHERE sessionhash = '4b65044a3d85d5e8970f808707d9ca89'
AND lastactivity > 1143040259
AND host = '69.49.144.69'
AND idhash = 'd641cdb59606f64fef253d9819491950'

Time before: 0.0184409618378
Time after: 0.0189950466156
Time taken: 0.000554084777832

table type possible_keys key key_len ref rows Extra
session const PRIMARY PRIMARY 32 const 1


--------------------------------------------------------------------------------

Query:

SELECT administrator.*,
userfield.*, usertextfield.*, user.*, UNIX_TIMESTAMP(passworddate) AS passworddate,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid,
language.phrasegroup_thread AS phrasegroup_thread,
language.phrasegroup_calendar AS phrasegroup_calendar,
language.phrasegroup_timezone AS phrasegroup_timezone,
language.phrasegroup_threadmanage AS phrasegroup_threadmanage,
language.phrasegroup_cpglobal AS phrasegroup_cpglobal,
language.phrasegroup_global AS phrasegroup_global,
language.options AS lang_options,
language.languagecode AS lang_code,
language.charset AS lang_charset,
language.locale AS lang_locale,
language.imagesoverride AS lang_imagesoverride,
language.dateoverride AS lang_dateoverride,
language.timeoverride AS lang_timeoverride,
language.registereddateoverride AS lang_registereddateoverride,
language.calformat1override AS lang_calformat1override,
language.calformat2override AS lang_calformat2override,
language.logdateoverride AS lang_logdateoverride,
language.decimalsep AS lang_decimalsep,
language.thousandsep AS lang_thousandsep
FROM user AS user
LEFT JOIN userfield AS userfield ON (user.userid = userfield.userid)
LEFT JOIN usertextfield AS usertextfield ON (usertextfield.userid = user.userid) LEFT JOIN administrator AS administrator ON (administrator.userid = user.userid) INNER JOIN language AS language ON (language.languageid = IF(user.languageid = 0, 1, user.languageid))
WHERE user.userid = 39012

Time before: 0.0195109844208
Time after: 0.0221130847931
Time taken: 0.00260210037231

table type possible_keys key key_len ref rows Extra
language system PRIMARY 1
user const PRIMARY PRIMARY 4 const 1
userfield const PRIMARY PRIMARY 4 const 1
usertextfield const PRIMARY PRIMARY 4 const 1
administrator const PRIMARY PRIMARY 4 const 0 unique row not found


--------------------------------------------------------------------------------

Query:

SELECT access.*, forum.forumid FROM forum AS forum LEFT JOIN access AS access ON
(userid = 39012 AND FIND_IN_SET(access.forumid, forum.parentlist))
WHERE NOT (ISNULL(access.forumid))

Time before: 0.0323250293732
Time after: 0.0328080654144
Time taken: 0.00048303604126

table type possible_keys key key_len ref rows Extra
forum ALL 323
access ref userid userid 4 const 2 Using where


--------------------------------------------------------------------------------

Query:

SELECT * FROM cpsession
WHERE userid = 39012
AND hash = '3646c5646802c835b8d2e7f90176c754'
AND dateline > 1143040259
Time before: 0.0334739685059
Time after: 0.033665895462
Time taken: 0.000191926956177

table type possible_keys key key_len ref rows Extra
cpsession system PRIMARY 1


--------------------------------------------------------------------------------

Query:
SELECT moderatorid, permissions FROM moderator WHERE userid = 39012
Time before: 0.0339529514313
Time after: 0.0340459346771
Time taken: 9.29832458496E-05

table type possible_keys key key_len ref rows Extra
moderator ref userid userid 4 const 4 Using where


--------------------------------------------------------------------------------












Moderation



Query:
SELECT script, action, optionname FROM adminhelp
Time before: 0.0347909927368
Time after: 0.0369729995728
Time taken: 0.00218200683594

table type possible_keys key key_len ref rows Extra
adminhelp index phraseunique 100 1163 Using index


--------------------------------------------------------------------------------

Query:
SELECT * FROM moderation
Time before: 0.0539300441742
Time after: 0.0541069507599
Time taken: 0.000176906585693

table type possible_keys key key_len ref rows Extra
moderation ALL 5


--------------------------------------------------------------------------------

Query:

SELECT DISTINCT forum.forumid
FROM forum AS forum, moderator AS moderator
WHERE FIND_IN_SET(moderator.forumid, forum.parentlist)
AND moderator.userid = 39012
AND moderator.permissions & 64
Time before: 0.0545120239258
Time after: 0.0546510219574
Time taken: 0.000138998031616

table type possible_keys key key_len ref rows Extra
moderator ref userid userid 4 const 4 Using where; Using temporary
forum ALL 323 Using where


--------------------------------------------------------------------------------




Help Threads Awaiting Moderation Query:

SELECT thread.threadid, thread.title AS title, thread.notes AS notes,
thread.forumid AS forumid, thread.postuserid AS userid,
thread.postusername AS username, thread.dateline, thread.firstpostid, pagetext
FROM thread AS thread
LEFT JOIN post AS post ON(thread.firstpostid = post.postid)
WHERE (1 = 0 OR thread.forumid IN (0,196,189,240,267,288,289,299,321,329,354,365,386 ,387)) AND thread.threadid IN(140782,118438,214535,212341)
ORDER BY thread.lastpost

Time before: 0.055300951004
Time after: 0.0554258823395
Time taken: 0.000124931335449


table type possible_keys key key_len ref rows Extra thread range PRIMARY,forumid PRIMARY 4 4 Using where; Using filesort post eq_ref PRIMARY PRIMARY 4 thread.firstpostid 1
--------------------------------------------------------------------------------


No Threads awaiting moderation










Help Posts Awaiting Moderation Query:

SELECT postid, pagetext, post.dateline, post.userid, post.title AS post_title,
thread.title AS thread_title, thread.forumid AS forumid, username, thread.threadid
FROM post AS post
LEFT JOIN thread AS thread ON(thread.threadid = post.threadid)
WHERE (1 = 0 OR thread.forumid IN (0,196,189,240,267,288,289,299,321,329,354,365,386 ,387)) AND postid IN(2580893)
ORDER BY dateline

Time before: 0.0564839839935
Time after: 0.0566630363464
Time taken: 0.000179052352905


If so whats the point?

If not then why the fuck am i seeing it?
  Reply With Quote
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump



All times are GMT -4. The time now is 05:27 AM.

Powered by vBulletin.
Copyright © 2000-2004 Jelsoft Enterprises Ltd.