Nie jesteś zalogowany.
Jeśli nie posiadasz konta, zarejestruj je już teraz! Pozwoli Ci ono w pełni korzystać z naszego serwisu. Spamerom dziękujemy!
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Dzień dobry !
Na moim laptopie mam grafikę hybrydową Intel5500 oraz GeForce920M.
Zainstalowałem bumblebee wg.info na debianwiki. Przy próbie testu optirun zwraca błąd:
Cannot access secondary GPU - error: [XORG] (EE) Failed to load module "mouse" (module does not exist, 0)
a tu więcej szczegółów
[ 433.844096] [ERROR]Cannot access secondary GPU - error: [XORG] (EE) Failed to load module "mouse" (module does not exist, 0) [ 433.844133] [ERROR]Aborting because fallback start is disabled. root@debian:/home/lech/ optirun -vv glxgears -info [ 561.920717] [DEBUG]Reading file: /etc/bumblebee/bumblebee.conf [ 561.920891] [INFO]Configured driver: nvidia [ 561.921108] [DEBUG]optirun version 3.2.1 starting... [ 561.921119] [DEBUG]Active configuration: [ 561.921122] [DEBUG] bumblebeed config file: /etc/bumblebee/bumblebee.conf [ 561.921125] [DEBUG] X display: :8 [ 561.921127] [DEBUG] LD_LIBRARY_PATH: /usr/lib/x86_64-linux-gnu/nvidia:/usr/lib/i386-linux-gnu/nvidia:/usr/lib/nvidia [ 561.921130] [DEBUG] Socket path: /var/run/bumblebee.socket [ 561.921132] [DEBUG] Accel/display bridge: auto [ 561.921136] [DEBUG] VGL Compression: proxy [ 561.921138] [DEBUG] VGLrun extra options: [ 561.921141] [DEBUG] Primus LD Path: /usr/lib/x86_64-linux-gnu/primus:/usr/lib/i386-linux-gnu/primus:/usr/lib/primus:/usr/lib32/primus [ 561.921176] [DEBUG]Using auto-detected bridge primus [ 561.935598] [INFO]Response: No - error: [XORG] (EE) Failed to load module "mouse" (module does not exist, 0) [ 561.935632] [ERROR]Cannot access secondary GPU - error: [XORG] (EE) Failed to load module "mouse" (module does not exist, 0) [ 561.935643] [DEBUG]Socket closed. [ 561.935664] [ERROR]Aborting because fallback start is disabled. [ 561.935676] [DEBUG]Killing all remaining processes.
Dodam że używam strownika własnościowego nvidia.
Ostatnio edytowany przez peiner85 (2017-11-01 17:15:57)
Offline
Pokaż zawartość tych plików konfiguracyjnych.
Offline
# Configuration file for Bumblebee. Values should **not** be put between quotes ## Server options. Any change made in this section will need a server restart # to take effect. [bumblebeed] # The secondary Xorg server DISPLAY number VirtualDisplay=:8 # Should the unused Xorg server be kept running? Set this to true if waiting # for X to be ready is too long and don't need power management at all. KeepUnusedXServer=false # The name of the Bumbleblee server group name (GID name) ServerGroup=bumblebee # Card power state at exit. Set to false if the card shoud be ON when Bumblebee # server exits. TurnCardOffAtExit=false # The default behavior of '-f' option on optirun. If set to "true", '-f' will # be ignored. NoEcoModeOverride=false # The Driver used by Bumblebee server. If this value is not set (or empty), # auto-detection is performed. The available drivers are nvidia and nouveau # (See also the driver-specific sections below) Driver=nvidia # Directory with a dummy config file to pass as a -configdir to secondary X XorgConfDir=/etc/bumblebee/xorg.conf.d # Xorg binary to run XorgBinary=/usr/lib/xorg/Xorg ## Client options. Will take effect on the next optirun executed. [optirun] # Acceleration/ rendering bridge, possible values are auto, virtualgl and # primus. Bridge=auto # The method used for VirtualGL to transport frames between X servers. # Possible values are proxy, jpeg, rgb, xv and yuv. VGLTransport=proxy # List of paths which are searched for the primus libGL.so.1 when using # the primus bridge PrimusLibraryPath=/usr/lib/x86_64-linux-gnu/primus:/usr/lib/i386-linux-gnu/primus:/usr/lib/primus:/usr/lib32/primus # Should the program run under optirun even if Bumblebee server or nvidia card # is not available? AllowFallbackToIGC=false # Driver-specific settings are grouped under [driver-NAME]. The sections are # parsed if the Driver setting in [bumblebeed] is set to NAME (or if auto- # detection resolves to NAME). # PMMethod: method to use for saving power by disabling the nvidia card, valid # values are: auto - automatically detect which PM method to use # bbswitch - new in BB 3, recommended if available # switcheroo - vga_switcheroo method, use at your own risk # none - disable PM completely # https://github.com/Bumblebee-Project/Bumblebee/wiki/Comparison-of-PM-methods ## Section with nvidia driver specific options, only parsed if Driver=nvidia [driver-nvidia] # Module name to load, defaults to Driver if empty or unset KernelDriver=nvidia-current PMMethod=auto # colon-separated path to the nvidia libraries LibraryPath=/usr/lib/x86_64-linux-gnu/nvidia:/usr/lib/i386-linux-gnu/nvidia:/usr/lib/nvidia # comma-separated path of the directory containing nvidia_drv.so and the # default Xorg modules path XorgModulePath=/usr/lib/nvidia/nvidia,/usr/lib/xorg/modules XorgConfFile=/etc/bumblebee/xorg.conf.nvidia ## Section with nouveau driver specific options, only parsed if Driver=nouveau [driver-nouveau] KernelDriver=nouveau PMMethod=auto XorgConfFile=/etc/bumblebee/xorg.conf.nouveau
Ostatnio edytowany przez peiner85 (2017-11-01 17:25:36)
Offline
A jakiś xorg.conf?
I przydałby się cały log xorga.
Offline
W /etc/X11/ nie mam xorg.conf
[ 1936.684] X.Org X Server 1.19.2 Release Date: 2017-03-02 [ 1936.684] X Protocol Version 11, Revision 0 [ 1936.684] Build Operating System: Linux 4.9.0-4-amd64 x86_64 Debian [ 1936.684] Current Operating System: Linux debian 4.9.0-4-amd64 #1 SMP Debian 4.9.51-1 (2017-09-28) x86_64 [ 1936.684] Kernel command line: BOOT_IMAGE=/boot/vmlinuz-4.9.0-4-amd64 root=UUID=6b2869bc-40c2-4ef3-9279-b84bbf1de635 ro quiet [ 1936.684] Build Date: 16 October 2017 08:19:45AM [ 1936.684] xorg-server 2:1.19.2-1+deb9u2 (https://www.debian.org/support) [ 1936.684] Current version of pixman: 0.34.0 [ 1936.684] Before reporting problems, check http://wiki.x.org to make sure that you have the latest version. [ 1936.684] Markers: (--) probed, (**) from config file, (==) default setting, (++) from command line, (!!) notice, (II) informational, (WW) warning, (EE) error, (NI) not implemented, (??) unknown. [ 1936.684] (==) Log file: "/var/log/Xorg.8.log", Time: Wed Nov 1 17:34:12 2017 [ 1936.684] (++) Using config file: "/etc/bumblebee/xorg.conf.nvidia" [ 1936.684] (++) Using config directory: "/etc/bumblebee/xorg.conf.d" [ 1936.684] (==) Using system config directory "/usr/share/X11/xorg.conf.d" [ 1936.685] (==) ServerLayout "Layout0" [ 1936.685] (==) No screen section available. Using defaults. [ 1936.685] (**) |-->Screen "Default Screen Section" (0) [ 1936.685] (**) | |-->Monitor "<default monitor>" [ 1936.685] (==) No device specified for screen "Default Screen Section". Using the first device section listed. [ 1936.685] (**) | |-->Device "DiscreteNvidia" [ 1936.685] (==) No monitor specified for screen "Default Screen Section". Using a default monitor configuration. [ 1936.685] (**) Option "AutoAddDevices" "false" [ 1936.685] (**) Option "AutoAddGPU" "false" [ 1936.685] (**) Not automatically adding devices [ 1936.685] (==) Automatically enabling devices [ 1936.685] (**) Not automatically adding GPU devices [ 1936.685] (==) Max clients allowed: 256, resource mask: 0x1fffff [ 1936.685] (WW) The directory "/usr/share/fonts/X11/cyrillic" does not exist. [ 1936.685] Entry deleted from font path. [ 1936.685] (==) FontPath set to: /usr/share/fonts/X11/misc, /usr/share/fonts/X11/100dpi/:unscaled, /usr/share/fonts/X11/75dpi/:unscaled, /usr/share/fonts/X11/Type1, /usr/share/fonts/X11/100dpi, /usr/share/fonts/X11/75dpi, built-ins [ 1936.685] (++) ModulePath set to "/usr/lib/nvidia/nvidia,/usr/lib/xorg/modules" [ 1936.685] (==) |-->Input Device "<default pointer>" [ 1936.685] (==) |-->Input Device "<default keyboard>" [ 1936.685] (==) The core pointer device wasn't specified explicitly in the layout. Using the default mouse configuration. [ 1936.685] (==) The core keyboard device wasn't specified explicitly in the layout. Using the default keyboard configuration. [ 1936.685] (II) Loader magic: 0x5584a694be00 [ 1936.685] (II) Module ABI versions: [ 1936.685] X.Org ANSI C Emulation: 0.4 [ 1936.685] X.Org Video Driver: 23.0 [ 1936.685] X.Org XInput driver : 24.1 [ 1936.685] X.Org Server Extension : 10.0 [ 1936.686] (--) using VT number 7 [ 1936.686] (II) systemd-logind: logind integration requires -keeptty and -keeptty was not provided, disabling logind integration [ 1936.686] (II) xfree86: Adding drm device (/dev/dri/card0) [ 1936.687] (EE) /dev/dri/card0: failed to set DRM interface version 1.4: Permission denied [ 1936.687] (--) PCI:*(0:8:0:0) 10de:1299:1028:06b0 rev 161, Mem @ 0xa9000000/16777216, 0xc0000000/268435456, 0xd0000000/33554432, I/O @ 0x00003000/128, BIOS @ 0x????????/524288 [ 1936.687] (II) LoadModule: "glx" [ 1936.687] (II) Loading /usr/lib/nvidia/nvidia/libglx.so [ 1936.691] (II) Module glx: vendor="NVIDIA Corporation" [ 1936.691] compiled for 4.0.2, module version = 1.0.0 [ 1936.691] Module class: X.Org Server Extension [ 1936.691] (II) NVIDIA GLX Module 375.82 Wed Jul 19 20:30:13 PDT 2017 [ 1936.691] (II) LoadModule: "nvidia" [ 1936.691] (II) Loading /usr/lib/nvidia/nvidia/nvidia_drv.so [ 1936.691] (II) Module nvidia: vendor="NVIDIA Corporation" [ 1936.691] compiled for 4.0.2, module version = 1.0.0 [ 1936.691] Module class: X.Org Video Driver [ 1936.691] (II) LoadModule: "mouse" [ 1936.691] (WW) Warning, couldn't open module mouse [ 1936.691] (II) UnloadModule: "mouse" [ 1936.691] (II) Unloading mouse [ 1936.691] (EE) Failed to load module "mouse" (module does not exist, 0) [ 1936.691] (II) LoadModule: "kbd" [ 1936.691] (WW) Warning, couldn't open module kbd [ 1936.691] (II) UnloadModule: "kbd" [ 1936.691] (II) Unloading kbd [ 1936.691] (EE) Failed to load module "kbd" (module does not exist, 0) [ 1936.692] (II) NVIDIA dlloader X Driver 375.82 Wed Jul 19 20:05:50 PDT 2017 [ 1936.692] (II) NVIDIA Unified Driver for all Supported NVIDIA GPUs [ 1936.692] (II) Loading sub module "fb" [ 1936.692] (II) LoadModule: "fb" [ 1936.692] (II) Loading /usr/lib/xorg/modules/libfb.so [ 1936.692] (II) Module fb: vendor="X.Org Foundation" [ 1936.692] compiled for 1.19.2, module version = 1.0.0 [ 1936.692] ABI class: X.Org ANSI C Emulation, version 0.4 [ 1936.692] (II) Loading sub module "wfb" [ 1936.692] (II) LoadModule: "wfb" [ 1936.692] (II) Loading /usr/lib/xorg/modules/libwfb.so [ 1936.692] (II) Module wfb: vendor="X.Org Foundation" [ 1936.692] compiled for 1.19.2, module version = 1.0.0 [ 1936.692] ABI class: X.Org ANSI C Emulation, version 0.4 [ 1936.692] (II) Loading sub module "ramdac" [ 1936.692] (II) LoadModule: "ramdac" [ 1936.692] (II) Module "ramdac" already built-in [ 1936.692] (II) NVIDIA(0): Creating default Display subsection in Screen section "Default Screen Section" for depth/fbbpp 24/32 [ 1936.692] (==) NVIDIA(0): Depth 24, (==) framebuffer bpp 32 [ 1936.692] (==) NVIDIA(0): RGB weight 888 [ 1936.692] (==) NVIDIA(0): Default visual is TrueColor [ 1936.692] (==) NVIDIA(0): Using gamma correction (1.0, 1.0, 1.0) [ 1936.692] (**) NVIDIA(0): Option "NoLogo" "true" [ 1936.692] (**) NVIDIA(0): Option "ProbeAllGpus" "false" [ 1936.692] (**) NVIDIA(0): Option "UseEDID" "false" [ 1936.692] (**) NVIDIA(0): Option "UseDisplayDevice" "none" [ 1936.692] (**) NVIDIA(0): Enabling 2D acceleration [ 1936.692] (**) NVIDIA(0): Ignoring EDIDs [ 1936.692] (**) NVIDIA(0): Option "UseDisplayDevice" set to "none"; enabling NoScanout [ 1936.692] (**) NVIDIA(0): mode [ 1936.695] (EE) NVIDIA(GPU-0): Failed to initialize the NVIDIA GPU at PCI:8:0:0. Please [ 1936.695] (EE) NVIDIA(GPU-0): check your system's kernel log for additional error [ 1936.695] (EE) NVIDIA(GPU-0): messages and refer to Chapter 8: Common Problems in the [ 1936.695] (EE) NVIDIA(GPU-0): README for additional information. [ 1936.695] (EE) NVIDIA(GPU-0): Failed to initialize the NVIDIA graphics device! [ 1936.695] (EE) NVIDIA(0): Failing initialization of X screen 0 [ 1936.695] (II) UnloadModule: "nvidia" [ 1936.695] (II) UnloadSubModule: "wfb" [ 1936.695] (II) UnloadSubModule: "fb" [ 1936.695] (EE) Screen(s) found, but none have a usable configuration. [ 1936.695] (EE) Fatal server error: [ 1936.695] (EE) no screens found(EE) [ 1936.695] (EE) Please consult the The X.Org Foundation support at http://wiki.x.org for help. [ 1936.695] (EE) Please also check the log file at "/var/log/Xorg.8.log" for additional information. [ 1936.695] (EE) [ 1936.695] (EE) Server terminated with error (1). Closing log file.
a to konfiguracja /etc/bumbleebee/xorg.conf.nvidia
Section "ServerLayout" Identifier "Layout0" Option "AutoAddDevices" "false" Option "AutoAddGPU" "false" EndSection Section "Device" Identifier "DiscreteNvidia" Driver "nvidia" VendorName "NVIDIA Corporation" # If the X server does not automatically detect your VGA device, # you can manually set it here. # To get the BusID prop, run `lspci | egrep 'VGA|3D'` and input the data # as you see in the commented example. # This Setting may be needed in some platforms with more than one # nvidia card, which may confuse the proprietary driver (e.g., # trying to take ownership of the wrong device). Also needed on Ubuntu 13.04. # BusID "PCI:01:00:0" # Setting ProbeAllGpus to false prevents the new proprietary driver # instance spawned to try to control the integrated graphics card, # which is already being managed outside bumblebee. # This option doesn't hurt and it is required on platforms running # more than one nvidia graphics card with the proprietary driver. # (E.g. Macbook Pro pre-2010 with nVidia 9400M + 9600M GT). # If this option is not set, the new Xorg may blacken the screen and # render it unusable (unless you have some way to run killall Xorg). Option "ProbeAllGpus" "false" Option "NoLogo" "true" Option "UseEDID" "false" Option "UseDisplayDevice" "none" EndSection
Ostatnio edytowany przez peiner85 (2017-11-01 17:40:22)
Offline
Zrobione, nie pomogło niestety. Ciągle ten sam błąd występuje :(
Offline
Może to pomoże:
Section "Screen" Identifier "Default Screen" Device "DiscreteNvidia" EndSection
Offline
w tym msg dziwny jest "mouse" bo ja mialem podobny problem kiedys ale modul to byl normalnie nvidia,
[ERROR]Cannot access secondary GPU – error: [XORG] (EE) Failed to load module „nvidia” (module does not exist, 0)
pokaz co masz w /usr/share/X11/xorg.conf.d/*
Ostatnio edytowany przez Pakos (2017-11-01 21:07:03)
Offline
w pliku 10-quirks.conf jest wzmianka o mouse
# Collection of quirks and blacklist/whitelists for specific devices. # Accelerometer device, posts data through ABS_X/ABS_Y, making X unusable # http://bugs.freedesktop.org/show_bug.cgi?id=22442 Section "InputClass" Identifier "ThinkPad HDAPS accelerometer blacklist" MatchProduct "ThinkPad HDAPS accelerometer data" Option "Ignore" "on" EndSection # https://bugzilla.redhat.com/show_bug.cgi?id=523914 # Mouse does not move in PV Xen guest # Explicitly tell evdev to not ignore the absolute axes. Section "InputClass" Identifier "Xen Virtual Pointer axis blacklist" MatchProduct "Xen Virtual Pointer" Option "IgnoreAbsoluteAxes" "off" Option "IgnoreRelativeAxes" "off" EndSection # https://bugs.freedesktop.org/show_bug.cgi?id=55867 # Bug 55867 - Doesn't know how to tag XI_TRACKBALL Section "InputClass" Identifier "Tag trackballs as XI_TRACKBALL" MatchProduct "trackball" MatchDriver "evdev" Option "TypeName" "TRACKBALL" EndSection # https://bugs.freedesktop.org/show_bug.cgi?id=62831 # Bug 62831 - Mionix Naos 5000 mouse detected incorrectly Section "InputClass" Identifier "Tag Mionix Naos 5000 mouse XI_MOUSE" MatchProduct "La-VIEW Technology Naos 5000 Mouse" MatchDriver "evdev" Option "TypeName" "MOUSE" EndSection
Offline
spróbowałem tego jeszcze:
root@debian:/usr/share/X11/xorg.conf.d# systemctl status bumblebeed
● bumblebeed.service - Bumblebee C Daemon
Loaded: loaded (/lib/systemd/system/bumblebeed.service; enabled; vendor preset: enabled)
Active: active (running) since Wed 2017-11-01 21:32:48 CET; 19min ago
Main PID: 8226 (bumblebeed)
Tasks: 1 (limit: 4915)
CGroup: /system.slice/bumblebeed.service
└─8226 /usr/sbin/bumblebeed
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790075] [ERROR][XORG] (EE) NVIDIA(GPU-0): Failed to initialize the NVIDIA graphics device!
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790079] [ERROR][XORG] (EE) NVIDIA(0): Failing initialization of X screen 0
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790089] [ERROR][XORG] (EE) Screen(s) found, but none have a usable configuration.
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790093] [ERROR][XORG] (EE)
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790096] [ERROR][XORG] (EE) no screens found(EE)
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790099] [ERROR][XORG] (EE)
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790103] [ERROR][XORG] (EE) Please also check the log file at "/var/log/Xorg.8.log" for additional information.
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790106] [ERROR][XORG] (EE)
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790110] [ERROR][XORG] (EE) Server terminated with error (1). Closing log file.
lis 01 21:41:36 debian bumblebeed[8226]: [ 5645.790113] [ERROR]X did not start properly
Offline
I teraz najlepsze. Zainstalowałem pakiet xorg-input-mouse i teraz wywala inny błąd:
[ 54.886969] [ERROR]Cannot access secondary GPU - error: [XORG] (EE) NVIDIA(GPU-0): Failed to initialize the NVIDIA GPU at PCI:8:0:0. Please [ 54.887012] [ERROR]Aborting because fallback start is disabled.
Offline
[quote=peiner85]I teraz najlepsze. Zainstalowałem pakiet xorg-input-mouse i teraz wywala inny błąd:[/quote]
Musisz zainstalowac xorg-input-evdev, bo na tej zasadzie masz wpisy w xorg.conf.d
Offline
Możliwe że problem leży po stronie bbswitch. Dmesg wywalił:
[ 18.081630] bbswitch: loading out-of-tree module taints kernel. [ 18.081867] bbswitch: version 0.8 [ 18.081873] bbswitch: Found integrated VGA device 0000:00:02.0: \_SB_.PCI0.GFX0 [ 18.081880] bbswitch: Found discrete VGA device 0000:08:00.0: \_SB_.PCI0.RP05.D030 [ 18.081890] bbswitch: failed to evaluate \_SB_.PCI0.RP05.D030._DSM {0xF8,0xD8,0x86,0xA4,0xDA,0x0B,0x1B,0x47,0xA7,0x2B,0x60,0x42,0xA6,0xB5,0xBE,0xE0} 0x100 0x0 {0x00,0x00,0x00,0x00}: AE_NOT_FOUND [ 18.081895] bbswitch: failed to evaluate \_SB_.PCI0.RP05.D030._DSM {0xA0,0xA0,0x95,0x9D,0x60,0x00,0x48,0x4D,0xB3,0x4D,0x7E,0x5F,0xEA,0x12,0x9F,0xD4} 0x102 0x0 {0x00,0x00,0x00,0x00}: AE_NOT_FOUND [ 18.081903] ACPI Warning: \_SB.PCI0.GFX0._DSM: Argument #4 type mismatch - Found [Buffer], ACPI requires [Package] (20160831/nsarguments-95) [ 18.081963] bbswitch: No suitable _DSM call found.
Offline
Zainstalowałem nowej jajko z backportów 4.13 i teraz wszystko działa. Winowajcą był kernel 4.9. Wątek do zamknięcia.
Offline
Time (s) | Query |
---|---|
0.00012 | SET CHARSET latin2 |
0.00005 | SET NAMES latin2 |
0.00101 | SELECT u.*, g.*, o.logged FROM punbb_users AS u INNER JOIN punbb_groups AS g ON u.group_id=g.g_id LEFT JOIN punbb_online AS o ON o.ident='3.144.40.239' WHERE u.id=1 |
0.00066 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.144.40.239', 1732443729) |
0.00050 | SELECT * FROM punbb_online WHERE logged<1732443429 |
0.00065 | DELETE FROM punbb_online WHERE ident='3.14.135.82' |
0.00065 | SELECT topic_id FROM punbb_posts WHERE id=315144 |
0.00147 | SELECT id FROM punbb_posts WHERE topic_id=30020 ORDER BY posted |
0.00055 | SELECT t.subject, t.closed, t.num_replies, t.sticky, f.id AS forum_id, f.forum_name, f.moderators, fp.post_replies, 0 FROM punbb_topics AS t INNER JOIN punbb_forums AS f ON f.id=t.forum_id LEFT JOIN punbb_forum_perms AS fp ON (fp.forum_id=f.id AND fp.group_id=3) WHERE (fp.read_forum IS NULL OR fp.read_forum=1) AND t.id=30020 AND t.moved_to IS NULL |
0.00011 | SELECT search_for, replace_with FROM punbb_censoring |
0.00112 | SELECT u.email, u.title, u.url, u.location, u.use_avatar, u.signature, u.email_setting, u.num_posts, u.registered, u.admin_note, p.id, p.poster AS username, p.poster_id, p.poster_ip, p.poster_email, p.message, p.hide_smilies, p.posted, p.edited, p.edited_by, g.g_id, g.g_user_title, o.user_id AS is_online FROM punbb_posts AS p INNER JOIN punbb_users AS u ON u.id=p.poster_id INNER JOIN punbb_groups AS g ON g.g_id=u.group_id LEFT JOIN punbb_online AS o ON (o.user_id=u.id AND o.user_id!=1 AND o.idle=0) WHERE p.topic_id=30020 ORDER BY p.id LIMIT 0,25 |
0.00075 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=30020 |
Total query time: 0.00764 s |