![]() |
|
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() |
Phenom | Kingz | Dabatos | TonySelf | Tha Q | Half Breed | Tito | 7th End | RV Radio ![]() |
![]() |
![]() |
|
Bone is gay.
|
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? |
|
![]() ![]() |
Thread Tools | Search this Thread |
Display Modes | |
|
|