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/.
Jak uzyskac normalna wydajnosc dla kart Ati r2xx ? Podobno nie są wspierana przez zamkniete sterownki fglrx.
glxinfo|grep -i -n opengl 24:OpenGL vendor string: Brian Paul 25:OpenGL renderer string: Mesa X11 26:OpenGL version string: 2.1 Mesa 7.7.1 27:OpenGL shading language version string: 1.20 28:OpenGL extensions:
tak wyglada rendering ati w przypadku otwartych sterow
xserver-xorg-video-radeon xserver-xorg-video-radeonhd xserver-xorg-video-ati libgl1-mesa-dri libgl1-mesa-glx libglu1-mesa mesa-common-dev mesa-utils xlibmesa-glu x11-utils
glxgears 422 frames in 5.0 seconds = 84.379 FPS 418 frames in 5.0 seconds = 83.475 FPS
a tak wygladal dla starszej karty nvidi opartej o nv17
5807 frames in 5.0 seconds = 1161.325 FPS 5832 frames in 5.0 seconds = 1166.250 FPS
Co mi zostaje . Upgradowac system do Wheeze aby zainstalowac mesa-experimetal -gallium? Co robić ?
Ostatnio edytowany przez Danio (2011-04-17 03:43:17)
Offline
Poczytaj mana i napisz /etc/X11/xorg.conf
Ostatnio edytowany przez torrentow (2011-04-17 10:42:49)
Offline
Section "ServerLayout" Identifier "X.org Configured" Screen 0 "Screen0" 0 0 InputDevice "Mouse0" "CorePointer" InputDevice "Keyboard0" "CoreKeyboard" EndSection Section "Files" ModulePath "/usr/lib/xorg/modules" FontPath "/usr/share/fonts/X11/misc" FontPath "/usr/share/fonts/X11/cyrillic" FontPath "/usr/share/fonts/X11/100dpi/:unscaled" FontPath "/usr/share/fonts/X11/75dpi/:unscaled" FontPath "/usr/share/fonts/X11/Type1" FontPath "/usr/share/fonts/X11/100dpi" FontPath "/usr/share/fonts/X11/75dpi" FontPath "/var/lib/defoma/x-ttcidfont-conf.d/dirs/TrueType" FontPath "built-ins" EndSection Section "Module" Load "dri" Load "extmod" Load "dri2" Load "record" Load "glx" Load "dbe" Load "GLcore" EndSection Section "InputDevice" Identifier "Keyboard0" Driver "kbd" EndSection Section "InputDevice" Identifier "Mouse0" Driver "mouse" Option "Protocol" "auto" Option "Device" "/dev/input/mice" Option "ZAxisMapping" "4 5 6 7" EndSection Section "Monitor" #DisplaySize 320 240 # mm Identifier "Monitor0" VendorName "STN" ModelName "S/T 77/76BDF" HorizSync 30.0 - 85.0 VertRefresh 50.0 - 160.0 Option "DPMS" EndSection Section "Device" ### Available Driver options are:- ### Values: <i>: integer, <f>: float, <bool>: "True"/"False", ### <string>: "String", <freq>: "<f> Hz/kHz/MHz" ### [arg]: arg optional #Option "NoAccel" # [<bool>] #Option "SWcursor" # [<bool>] #Option "Dac6Bit" # [<bool>] #Option "Dac8Bit" # [<bool>] #Option "BusType" # [<str>] #Option "CPPIOMode" # [<bool>] #Option "CPusecTimeout" # <i> #Option "AGPMode" # <i> #Option "AGPFastWrite" # [<bool>] #Option "AGPSize" # <i> #Option "GARTSize" # <i> #Option "RingSize" # <i> #Option "BufferSize" # <i> #Option "EnableDepthMoves" # [<bool>] #Option "EnablePageFlip" # [<bool>] #Option "NoBackBuffer" # [<bool>] #Option "DMAForXv" # [<bool>] #Option "FBTexPercent" # <i> #Option "DepthBits" # <i> #Option "PCIAPERSize" # <i> #Option "AccelDFS" # [<bool>] #Option "IgnoreEDID" # [<bool>] #Option "CustomEDID" # [<str>] #Option "DisplayPriority" # [<str>] #Option "PanelSize" # [<str>] #Option "ForceMinDotClock" # <freq> #Option "ColorTiling" # [<bool>] #Option "VideoKey" # <i> #Option "RageTheatreCrystal" # <i> #Option "RageTheatreTunerPort" # <i> #Option "RageTheatreCompositePort" # <i> #Option "RageTheatreSVideoPort" # <i> #Option "TunerType" # <i> #Option "RageTheatreMicrocPath" # <str> #Option "RageTheatreMicrocType" # <str> #Option "ScalerWidth" # <i> #Option "RenderAccel" # [<bool>] #Option "SubPixelOrder" # [<str>] #Option "ClockGating" # [<bool>] #Option "VGAAccess" # [<bool>] #Option "ReverseDDC" # [<bool>] #Option "LVDSProbePLL" # [<bool>] #Option "AccelMethod" # <str> #Option "DRI" # [<bool>] #Option "ConnectorTable" # <str> #Option "DefaultConnectorTable" # [<bool>] #Option "DefaultTMDSPLL" # [<bool>] #Option "TVDACLoadDetect" # [<bool>] #Option "ForceTVOut" # [<bool>] #Option "TVStandard" # <str> #Option "IgnoreLidStatus" # [<bool>] #Option "DefaultTVDACAdj" # [<bool>] #Option "Int10" # [<bool>] #Option "EXAVSync" # [<bool>] #Option "ATOMTVOut" # [<bool>] #Option "R4xxATOM" # [<bool>] #Option "ForceLowPowerMode" # [<bool>] #Option "DynamicPM" # [<bool>] #Option "NewPLL" # [<bool>] #Option "ZaphodHeads" # <str> Identifier "Card0" Driver "ati" VendorName "ATI Technologies Inc" BoardName "RV280 [Radeon 9200]" BusID "PCI:1:0:0" #Option "AGPFastWrite" "false" #Option "EnablePageFlip" "True" EndSection Section "Screen" Identifier "Screen0" Device "Card0" Monitor "Monitor0" SubSection "Display" Viewport 0 0 Depth 1 EndSubSection SubSection "Display" Viewport 0 0 Depth 4 EndSubSection SubSection "Display" Viewport 0 0 Depth 8 EndSubSection SubSection "Display" Viewport 0 0 Depth 15 EndSubSection SubSection "Display" Viewport 0 0 Depth 16 EndSubSection SubSection "Display" Viewport 0 0 Depth 24 EndSubSection EndSection Section "dri" Mode 0666 EndSection
Przeszedlem na Wheeze. Ale instalacja Galium sie nie udala wg tej instrukcjii
$ git clone git://anongit.freedesktop.org/mesa/mesa mesa.git $ cd mesa.git $ autoreconf -vfi
autoreconf -vfi autoreconf: Entering directory `.' autoreconf: configure.ac: not using Gettext autoreconf: running: aclocal --force configure.ac:108: error: Could not locate the pkg-config autoconf macros. These are usually located in /usr/share/aclocal/pkg.m4. If your macros are in a different location, try setting the environment variable ACLOCAL="aclocal -I/other/macro/dir" before running autoreconf. configure.ac:108: the top level autom4te: /usr/bin/m4 failed with exit status: 1 aclocal: /usr/bin/autom4te failed with exit status: 1 autoreconf: aclocal failed with exit status: 1
Offline
to jest koncowka kompilacjii w xtermie (chyba ma zmniejszoną pojemność)
autoreconf: Entering directory `.' autoreconf: configure.ac: not using Gettext autoreconf: running: aclocal --force configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: tracing configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: not using Libtool autoreconf: running: /usr/bin/autoconf --force configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: not using Autoheader autoreconf: configure.ac: not using Automake autoreconf: Leaving directory `.
dalej
./configure --enable-driglx-direct \ > --enable-gallium \ > --enable-gles-overlay \ > --enable-gles1 \ > --enable-gles2 \ > --enable-glx-tls \ > --with-driver=dri \ > --with-dri-driverdir=/usr/lib/dri \ > --with-egl-platforms='drm x11' \ > --with-state-trackers=egl,glx,dri,vega \ > … configure: WARNING: you should use --build, --host, --target configure: WARNING: invalid host type: … checking build system type... Invalid configuration `…': machine `…' not recognized configure: error: /bin/bash bin/config.sub … failed
a wiec trzeba bylo wybrac jedna opcję...
./configure --with-dri-drivers=radeon --enable-gallium-radeon checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for gcc... ccache gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether ccache gcc accepts -g... yes checking for ccache gcc option to accept ISO C89... none needed checking how to run the C preprocessor... ccache gcc -E checking for gcc... (cached) ccache gcc checking whether we are using the GNU C compiler... (cached) yes
ta była dla r300 - może zadziała
Ostatnio edytowany przez Danio (2011-04-17 19:31:42)
Offline
make
Please choose a configuration from the following list: aix aix-64 aix-64-static aix-gcc aix-static beos bluegene-osmesa bluegene-xlc-osmesa catamount-osmesa-pgi config.mgw darwin darwin-fat-32bit darwin-fat-all freebsd freebsd-dri freebsd-dri-amd64 freebsd-dri-x86 hpux10 hpux10-gcc hpux10-static hpux11-32 hpux11-32-static hpux11-32-static-nothreads hpux11-64 hpux11-64-static hpux11-ia64 hpux11-ia64-static hpux9 hpux9-gcc irix6-64 irix6-64-static irix6-n32 irix6-n32-static irix6-o32 irix6-o32-static linux linux-alpha linux-alpha-static linux-cell linux-cell-debug linux-debug linux-dri linux-dri-debug linux-dri-ppc linux-dri-x86 linux-dri-x86-64 linux-dri-xcb linux-egl linux-fbdev linux-i965 linux-ia64-icc linux-ia64-icc-static linux-icc linux-icc-static linux-indirect linux-llvm linux-llvm-debug linux-opengl-es linux-osmesa linux-osmesa16 linux-osmesa16-static linux-osmesa32 linux-osmesa-static linux-ppc linux-ppc-static linux-profile linux-sparc linux-sparc5 linux-static linux-ultrasparc linux-x86 linux-x86-32 linux-x86-64 linux-x86-64-debug linux-x86-64-profile linux-x86-64-static linux-x86-debug linux-x86-profile linux-x86-static netbsd openbsd osf1 osf1-static solaris-x86 solaris-x86-gcc solaris-x86-gcc-static sunos4 sunos4-gcc sunos4-static sunos5 sunos5-64-gcc sunos5-gcc sunos5-smp sunos5-v8 sunos5-v8-static sunos5-v9 sunos5-v9-cc-g++ sunos5-v9-static ultrix-gcc Then type 'make <config>' (ex: 'make linux-x86') Or, run './configure' then 'make' See './configure --help' for details (ignore the following error message) make: *** [configs/current] Błąd 1
mv lib/gallium/* lib/
mv: nie można wykonać stat na `lib/gallium/*': Nie ma takiego pliku ani katalogu
mkdir /lib/gallium/
mkdir /lib/gallium/lib
mv lib/gallium/* lib/
mv: nie można wykonać stat na `lib/gallium/*': Nie ma takiego pliku ani katalogu
zapomnialem powiedziec ,że wcześniej jedno z poleceń zostało pominięte
apt-get build-dep mesa Czytanie list pakietów... Gotowe Budowanie drzewa zależności Odczyt informacji o stanie... Gotowe E: Należy dopisać jakieś URI pakietów źródłowych do pliku sources.list
Ostatnio edytowany przez Danio (2011-04-17 19:43:28)
Offline
root@localhost:/home/mesa# autoreconf -vfi
autoreconf: Entering directory `.' autoreconf: configure.ac: not using Gettext autoreconf: running: aclocal --force configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: tracing configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: not using Libtool autoreconf: running: /usr/bin/autoconf --force configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: not using Autoheader autoreconf: configure.ac: not using Automake autoreconf: Leaving directory `.'
root@localhost:/home/mesa# ./configure --with-dri-drivers=radeon --enable-gallium-radeon
checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for gcc... ccache gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether ccache gcc accepts -g... yes checking for ccache gcc option to accept ISO C89... none needed checking how to run the C preprocessor... ccache gcc -E checking for gcc... (cached) ccache gcc checking whether we are using the GNU C compiler... (cached) yes checking whether ccache gcc accepts -g... (cached) yes checking for ccache gcc option to accept ISO C89... (cached) none needed checking whether we are using the GNU C++ compiler... no checking whether ccache g++ accepts -g... yes checking for gmake... no checking for make... make checking for python2... no checking for python... python checking for makedepend... /usr/bin/makedepend checking for sed... /bin/sed checking for a BSD-compatible install... /usr/bin/install -c checking if compiling with clang... no checking whether gcc version is sufficient... yes checking for pkg-config... /usr/bin/pkg-config checking pkg-config is at least version 0.9.0... yes checking whether ccache gcc supports -fvisibility=hidden... yes checking whether to enable assembly... yes, x86 checking for ccache gcc option to produce PIC... -fPIC checking for dlopen... no checking for dlopen in -ldl... yes checking for posix_memalign... yes checking pkg-config files for X11 are available... no checking for X... no configure: error: X11 development libraries needed for dri driver
apt-get install libX11-dev
autoreconf -vfi autoreconf: Entering directory `.' autoreconf: configure.ac: not using Gettext autoreconf: running: aclocal --force configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: tracing configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: not using Libtool autoreconf: running: /usr/bin/autoconf --force configure.ac:15: warning: AC_INIT: not a literal: https://bugs.freedesktop.org/enter_bug.cgi?product=Mesa autoreconf: configure.ac: not using Autoheader autoreconf: configure.ac: not using Automake autoreconf: Leaving directory `.'
apt-get install x11proto-gl-dev
Czytanie list pakietów... Gotowe Budowanie drzewa zależności Odczyt informacji o stanie... Gotowe Zostaną zainstalowane następujące NOWE pakiety: x11proto-gl-dev 0 aktualizowanych, 1 nowo instalowanych, 0 usuwanych i 1 nieaktualizowanych. Konieczne pobranie 21,6 kB archiwów. Po tej operacji zostanie dodatkowo użyte 172 kB miejsca na dysku. Pob: 1 http://ftp.pl.debian.org/debian/ testing/main x11proto-gl-dev i386 1.4.12-1 [21,6 kB] Pobrano 21,6 kB w 0s (65,7 kB/s) dpkg: ostrzeżenie: parsing file '/var/lib/dpkg/status' near line 9986 package 'linux-image-2.6.36': error in Version string 'custom.11.0': version number does not start with digit dpkg: ostrzeżenie: parsing file '/var/lib/dpkg/status' near line 16698 package 'linux-headers-2.6.36': error in Version string 'custom.11.0': version number does not start with digit dpkg: ostrzeżenie: parsing file '/var/lib/dpkg/available' near line 10933 package 'linux-image-2.6.36': error in Version string 'custom.11.0': version number does not start with digit dpkg: ostrzeżenie: parsing file '/var/lib/dpkg/available' near line 18284 package 'linux-headers-2.6.36': error in Version string 'custom.11.0': version number does not start with digit Zaznaczenie poprzednio niezaznaczonego pakietu x11proto-gl-dev. (Odczytywanie bazy danych ... 78927 files and directories currently installed.) Rozpakowanie x11proto-gl-dev (z .../x11proto-gl-dev_1.4.12-1_i386.deb) ... dpkg: ostrzeżenie: parsing file '/var/lib/dpkg/status' near line 10007 package 'linux-image-2.6.36': error in Version string 'custom.11.0': version number does not start with digit dpkg: ostrzeżenie: parsing file '/var/lib/dpkg/status' near line 16719 package 'linux-headers-2.6.36': error in Version string 'custom.11.0': version number does not start with digit Konfigurowanie x11proto-gl-dev (1.4.12-1) ... localepurge: Disk space freed in /usr/share/locale: 0 KiB localepurge: Disk space freed in /usr/share/man: 0 KiB localepurge: Disk space freed in /usr/share/gnome/help: 0 KiB localepurge: Disk space freed in /usr/share/omf: 0 KiB Total disk space freed by localepurge: 0 KiB
wymagane były pakiety z Sida
libdrm-dev zależy od libdrm2 (= 2.4.24-2); jednakże: Wersją libdrm2 w systemie jest 2.4.23-3. libdrm-dev zależy od libdrm-intel1 (= 2.4.24-2); jednakże: Wersją libdrm-intel1 w systemie jest 2.4.23-3. libdrm-dev zależy od libdrm-radeon1 (= 2.4.24-2); jednakże: Wersją libdrm-radeon1 w systemie jest 2.4.23-3. libdrm-dev zależy od libdrm-nouveau1a (= 2.4.24-2); jednakże: Wersją libdrm-nouveau1a w systemie jest 2.4.23-3. libdrm-dev zależy od libkms1 (= 2.4.24-2); jednakże:
root@localhost:/home/mesa# ./configure --with-dri-drivers=radeon --enable-gallium-radeon
checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for gcc... ccache gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether ccache gcc accepts -g... yes checking for ccache gcc option to accept ISO C89... none needed checking how to run the C preprocessor... ccache gcc -E checking for gcc... (cached) ccache gcc checking whether we are using the GNU C compiler... (cached) yes checking whether ccache gcc accepts -g... (cached) yes checking for ccache gcc option to accept ISO C89... (cached) none needed checking whether we are using the GNU C++ compiler... no checking whether ccache g++ accepts -g... yes checking for gmake... no checking for make... make checking for python2... no checking for python... python checking for makedepend... /usr/bin/makedepend checking for sed... /bin/sed checking for a BSD-compatible install... /usr/bin/install -c checking if compiling with clang... no checking whether gcc version is sufficient... yes checking for pkg-config... /usr/bin/pkg-config checking pkg-config is at least version 0.9.0... yes checking whether ccache gcc supports -fvisibility=hidden... yes checking whether to enable assembly... yes, x86 checking for ccache gcc option to produce PIC... -fPIC checking for dlopen... no checking for dlopen in -ldl... yes checking for posix_memalign... yes checking pkg-config files for X11 are available... yes checking for X11... yes checking for GLPROTO... yes checking for LIBDRM... yes checking for DRI2PROTO... yes checking for XF86VIDMODE... no checking for DRIGL... no configure: error: Package requirements (x11 xext xdamage xfixes) were not met: No package 'xext' found No package 'xdamage' found No package 'xfixes' found Consider adjusting the PKG_CONFIG_PATH environment variable if you installed software in a non-standard prefix. Alternatively, you may set the environment variables DRIGL_CFLAGS and DRIGL_LIBS to avoid the need to call pkg-config. See the pkg-config man page for more details.
apt-get install...
root@localhost:/home/mesa# ./configure --with-dri-drivers=radeon --enable-gallium-radeon
checking build system type... i686-pc-linux-gnu checking host system type... i686-pc-linux-gnu checking for gcc... ccache gcc checking whether the C compiler works... yes checking for C compiler default output file name... a.out checking for suffix of executables... checking whether we are cross compiling... no checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether ccache gcc accepts -g... yes checking for ccache gcc option to accept ISO C89... none needed checking how to run the C preprocessor... ccache gcc -E checking for gcc... (cached) ccache gcc checking whether we are using the GNU C compiler... (cached) yes checking whether ccache gcc accepts -g... (cached) yes checking for ccache gcc option to accept ISO C89... (cached) none needed checking whether we are using the GNU C++ compiler... no checking whether ccache g++ accepts -g... yes checking for gmake... no checking for make... make checking for python2... no checking for python... python checking for makedepend... /usr/bin/makedepend checking for sed... /bin/sed checking for a BSD-compatible install... /usr/bin/install -c checking if compiling with clang... no checking whether gcc version is sufficient... yes checking for pkg-config... /usr/bin/pkg-config checking pkg-config is at least version 0.9.0... yes checking whether ccache gcc supports -fvisibility=hidden... yes checking whether to enable assembly... yes, x86 checking for ccache gcc option to produce PIC... -fPIC checking for dlopen... no checking for dlopen in -ldl... yes checking for posix_memalign... yes checking pkg-config files for X11 are available... yes checking for X11... yes checking for GLPROTO... yes checking for LIBDRM... yes checking for DRI2PROTO... yes checking for XF86VIDMODE... no checking for DRIGL... yes checking for LIBDRM_RADEON... yes checking expat.h usability... no checking expat.h presence... no checking for expat.h... no configure: error: Expat required for DRI.
Ostatnio edytowany przez Danio (2011-04-18 09:29:40)
Offline
Zainstalowałem wszystkie zależności ,w tym pochodzące z Sida
po wykonaniu make kompilacja trwała jakąś godzinę
korzystalem z opisu na tej stronie
http://pkg-xorg.alioth.debian.org/howto/build-mesa.html
Ale nie udalo się. Nie ma nigdzie normalnego opisu ,artykulu w jezyku polskim . Jakby wsparcie 3d dla starszych kart ati nie bylo problemem. Nie wiem czy ten sterownik dziala. Ale jesli dziala to chyba sam napisze napisze poradnik bo sie wkurwilem
Ostatnio edytowany przez Danio (2011-04-18 13:51:58)
Offline
Time (s) | Query |
---|---|
0.00019 | SET CHARSET latin2 |
0.00005 | SET NAMES latin2 |
0.00184 | 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.133.137.10' WHERE u.id=1 |
0.00351 | REPLACE INTO punbb_online (user_id, ident, logged) VALUES(1, '3.133.137.10', 1732255627) |
0.00055 | SELECT * FROM punbb_online WHERE logged<1732255327 |
0.00102 | DELETE FROM punbb_online WHERE ident='13.58.200.78' |
0.00092 | DELETE FROM punbb_online WHERE ident='18.188.227.192' |
0.00098 | DELETE FROM punbb_online WHERE ident='18.221.192.248' |
0.00103 | DELETE FROM punbb_online WHERE ident='185.191.171.19' |
0.00120 | DELETE FROM punbb_online WHERE ident='3.14.132.178' |
0.00096 | DELETE FROM punbb_online WHERE ident='3.144.90.236' |
0.00099 | DELETE FROM punbb_online WHERE ident='3.147.68.39' |
0.00094 | DELETE FROM punbb_online WHERE ident='3.147.89.50' |
0.00088 | DELETE FROM punbb_online WHERE ident='3.15.239.0' |
0.00114 | SELECT topic_id FROM punbb_posts WHERE id=171092 |
0.00186 | SELECT id FROM punbb_posts WHERE topic_id=18805 ORDER BY posted |
0.00131 | 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=18805 AND t.moved_to IS NULL |
0.00007 | SELECT search_for, replace_with FROM punbb_censoring |
0.00170 | 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=18805 ORDER BY p.id LIMIT 0,25 |
0.00119 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=18805 |
Total query time: 0.02233 s |