vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   Forum and Server Management (https://vborg.vbsupport.ru/forumdisplay.php?f=232)
-   -   Query taking a long time to run (https://vborg.vbsupport.ru/showthread.php?t=187030)

nsanden 08-02-2008 04:44 PM
Query taking a long time to run
 
This query in memberlist.php line 527 showed up in mysql slow query log (for good reason apparently...)

Has anyone else had this problem? Our vb3user table is only 17k rows.

Code:
Showing rows 0 - 49 (50 total, Query took 25.2542 sec)
SQL query:
SELECT user . * , usertextfield . * , userfield . * , user.userid, options,
IF (
displaygroupid =0, user.usergroupid, displaygroupid
) AS displaygroupid, infractiongroupid, avatar.avatarpath, NOT ISNULL(
customavatar.userid
) AS hascustomavatar, customavatar.dateline AS avatardateline, customavatar.width AS avwidth, customavatar.height AS avheight,
IF (
(
options &512
AND user.userid <>0
), 1, lastactivity
) AS lastvisittime
FROM vb3user AS user
LEFT JOIN vb3usertextfield AS usertextfield ON ( usertextfield.userid = user.userid )
LEFT JOIN vb3userfield AS userfield ON ( userfield.userid = user.userid )
LEFT JOIN vb3avatar AS avatar ON ( avatar.avatarid = user.avatarid )
LEFT JOIN vb3customavatar AS customavatar ON ( customavatar.userid = user.userid )
WHERE 1 =1
AND user.usergroupid
IN (
-1, 6, 7, 2, 5, 19
)
ORDER BY user.username ASC
LIMIT 0 , 50

nexialys 08-03-2008 02:08 AM
this query is executed in 0.005sec in most cases, so i suppose you have some problem with your tables that are not optimized...

or

you installed some hack that is interacting with the system...


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

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00949 seconds
  • Memory Usage 1,709KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)bbcode_code_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 
Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete