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!
Ogłoszenie
Prosimy o pomoc dla małej Julki — przekaż 1% podatku na Fundacji Dzieciom zdazyć z Pomocą.
Więcej informacji na dug.net.pl/pomagamy/.
Strony: 1
- Forum Debian Users Gang
- » Hardware
- » problem z dyskiem w Acer Aspire 5830 ciągłe usypianie wybudzanie
#1 2011-11-20 20:06:54
bobycob - 
Członek z Ramienia
- bobycob
- Członek z Ramienia
- Skąd: Wrocław
- Zarejestrowany: 2007-08-15
problem z dyskiem w Acer Aspire 5830 ciągłe usypianie wybudzanie
Witam
Od jakiegoś czasu komputer miewa czkawkę i właśnie zorientowałem się, że jest to związane z wyłączaniem i włączaniem dysku twardego. Pomimo ciągłej pracy można usłyszeć zatrzymywanie talerzy i ich ponowny start. Byłem przekonany, że jest to związane z zarządzaniem energią - jednak chyba nie. Próbowałem ustawić czas wyłączania dysku za pomocą hdparm jednak zmiany wyraźnie są ignorowane.
Zainstalowałem też smartmontools - też nie chciały pomóc
Nie bardzo wiem od której strony mogę to jeszcze ugryźć - pod windowsem działa poprawnie.
Debian testing
Kernel kompilacja własna - ze względu na sterowniki do tego modelu
Linux debian 3.2.0-rc2-rel-2 x86_64
Kod:
=== START OF INFORMATION SECTION ===
Model Family: Western Digital Scorpio Blue Serial ATA (Adv. Format)
Device Model: WDC WD6400BPVT-22HXZT1
Serial Number: WD-WX21A21D7784
LU WWN Device Id: 5 0014ee 25b078a8e
Firmware Version: 01.01A01
User Capacity: 640,135,028,736 bytes [640 GB]
Sector Sizes: 512 bytes logical, 4096 bytes physical
Device is: In smartctl database [for details use: -P show]
ATA Version is: 8
ATA Standard is: Exact ATA specification draft version not indicated
Local Time is: Sun Nov 20 19:55:59 2011 CET
SMART support is: Available - device has SMART capability.
SMART support is: Enabled
=== START OF READ SMART DATA SECTION ===
SMART overall-health self-assessment test result: PASSED
General SMART Values:
Offline data collection status: (0x00) Offline data collection activity
was never started.
Auto Offline Data Collection: Disabled.
Self-test execution status: ( 0) The previous self-test routine completed
without error or no self-test has ever
been run.
Total time to complete Offline
data collection: (15480) seconds.
Offline data collection
capabilities: (0x7b) SMART execute Offline immediate.
Auto Offline data collection on/off support.
Suspend Offline collection upon new
command.
Offline surface scan supported.
Self-test supported.
Conveyance Self-test supported.
Selective Self-test supported.
SMART capabilities: (0x0003) Saves SMART data before entering
power-saving mode.
Supports SMART auto save timer.
Error logging capability: (0x01) Error logging supported.
General Purpose Logging supported.
Short self-test routine
recommended polling time: ( 2) minutes.
Extended self-test routine
recommended polling time: ( 152) minutes.
Conveyance self-test routine
recommended polling time: ( 5) minutes.
SCT capabilities: (0x7035) SCT Status supported.
SCT Feature Control supported.
SCT Data Table supported.
SMART Attributes Data Structure revision number: 16
Vendor Specific SMART Attributes with Thresholds:
ID# ATTRIBUTE_NAME FLAG VALUE WORST THRESH TYPE UPDATED WHEN_FAILED RAW_VALUE
1 Raw_Read_Error_Rate 0x002f 200 200 051 Pre-fail Always - 0
3 Spin_Up_Time 0x0027 163 153 021 Pre-fail Always - 2850
4 Start_Stop_Count 0x0032 095 095 000 Old_age Always - 5070
5 Reallocated_Sector_Ct 0x0033 200 200 140 Pre-fail Always - 0
7 Seek_Error_Rate 0x002e 200 200 000 Old_age Always - 0
9 Power_On_Hours 0x0032 100 100 000 Old_age Always - 195
10 Spin_Retry_Count 0x0032 100 100 000 Old_age Always - 0
11 Calibration_Retry_Count 0x0032 100 100 000 Old_age Always - 0
12 Power_Cycle_Count 0x0032 100 100 000 Old_age Always - 139
191 G-Sense_Error_Rate 0x0032 001 001 000 Old_age Always - 5426
192 Power-Off_Retract_Count 0x0032 200 200 000 Old_age Always - 22
193 Load_Cycle_Count 0x0032 188 188 000 Old_age Always - 37739
194 Temperature_Celsius 0x0022 112 102 000 Old_age Always - 35
196 Reallocated_Event_Count 0x0032 200 200 000 Old_age Always - 0
197 Current_Pending_Sector 0x0032 200 200 000 Old_age Always - 0
198 Offline_Uncorrectable 0x0030 100 253 000 Old_age Offline - 0
199 UDMA_CRC_Error_Count 0x0032 200 200 000 Old_age Always - 0
200 Multi_Zone_Error_Rate 0x0008 100 253 000 Old_age Offline - 0
SMART Error Log Version: 1
No Errors Logged
SMART Self-test log structure revision number 1
No self-tests have been logged. [To run self-tests, use: smartctl -t]
SMART Selective self-test log data structure revision number 1
SPAN MIN_LBA MAX_LBA CURRENT_TEST_STATUS
1 0 0 Not_testing
2 0 0 Not_testing
3 0 0 Not_testing
4 0 0 Not_testing
5 0 0 Not_testing
Selective self-test flags (0x0):
After scanning selected spans, do NOT read-scan remainder of disk.
If Selective self-test is pending on power-up, resume after 0 minute delay.działające procesy
Kod:
root 1 0.1 0.0 10612 804 ? Ss 19:32 0:03 init [2] root 2 0.0 0.0 0 0 ? S 19:32 0:00 [kthreadd] root 3 0.0 0.0 0 0 ? S 19:32 0:00 [ksoftirqd/0] root 4 0.0 0.0 0 0 ? S 19:32 0:00 [kworker/0:0] root 6 0.0 0.0 0 0 ? S 19:32 0:00 [migration/0] root 7 0.0 0.0 0 0 ? S 19:32 0:00 [watchdog/0] root 8 0.0 0.0 0 0 ? S 19:32 0:00 [migration/1] root 10 0.0 0.0 0 0 ? S 19:32 0:00 [ksoftirqd/1] root 12 0.0 0.0 0 0 ? S 19:32 0:00 [watchdog/1] root 13 0.0 0.0 0 0 ? S 19:32 0:00 [migration/2] root 15 0.0 0.0 0 0 ? S 19:32 0:00 [ksoftirqd/2] root 16 0.0 0.0 0 0 ? S 19:32 0:00 [watchdog/2] root 17 0.0 0.0 0 0 ? S 19:32 0:00 [migration/3] root 19 0.0 0.0 0 0 ? S 19:32 0:00 [ksoftirqd/3] root 20 0.0 0.0 0 0 ? S 19:32 0:00 [watchdog/3] root 21 0.0 0.0 0 0 ? S< 19:32 0:00 [cpuset] root 22 0.0 0.0 0 0 ? S< 19:32 0:00 [khelper] root 23 0.0 0.0 0 0 ? S 19:32 0:00 [kdevtmpfs] root 24 0.0 0.0 0 0 ? S< 19:32 0:00 [netns] root 25 0.0 0.0 0 0 ? S 19:32 0:00 [sync_supers] root 26 0.0 0.0 0 0 ? S 19:32 0:00 [bdi-default] root 27 0.0 0.0 0 0 ? S< 19:32 0:00 [kintegrityd] root 28 0.0 0.0 0 0 ? S< 19:32 0:00 [kblockd] root 30 0.0 0.0 0 0 ? S 19:32 0:00 [khungtaskd] root 31 0.0 0.0 0 0 ? S 19:32 0:00 [kswapd0] root 32 0.0 0.0 0 0 ? SN 19:32 0:00 [ksmd] root 33 0.0 0.0 0 0 ? SN 19:32 0:00 [khugepaged] root 34 0.0 0.0 0 0 ? S 19:32 0:00 [fsnotify_mark] root 35 0.0 0.0 0 0 ? S< 19:32 0:00 [crypto] root 38 0.0 0.0 0 0 ? S 19:32 0:00 [kworker/1:1] root 135 0.0 0.0 0 0 ? S 19:32 0:00 [khubd] root 163 0.0 0.0 0 0 ? S< 19:32 0:00 [ata_sff] root 172 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_0] root 173 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_1] root 174 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_2] root 175 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_3] root 176 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_4] root 177 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_5] root 234 0.0 0.0 0 0 ? S 19:32 0:00 [jbd2/sda5-8] root 235 0.0 0.0 0 0 ? S< 19:32 0:00 [ext4-dio-unwrit] root 288 0.0 0.0 21872 1892 ? Ss 19:32 0:00 udevd --daemon root 548 0.0 0.0 0 0 ? S 19:32 0:00 [scsi_eh_6] root 549 0.0 0.0 0 0 ? S< 19:32 0:00 [cfg80211] root 555 0.0 0.0 0 0 ? S 19:32 0:00 [rts_pstor] root 557 0.0 0.0 0 0 ? S 19:32 0:00 [rtsx-polling] root 569 0.0 0.0 0 0 ? S< 19:32 0:00 [kpsmoused] root 674 0.0 0.0 0 0 ? S< 19:32 0:00 [hd-audio0] root 704 0.0 0.0 0 0 ? S< 19:32 0:00 [kvm-irqfd-clean] root 1235 0.0 0.0 118544 1808 ? Sl 19:32 0:00 /usr/sbin/rsyslogd -c5 root 1259 0.0 0.0 3904 80 ? Ss 19:32 0:00 /usr/sbin/acpi_fakekeyd 102 1263 0.0 0.0 24260 1728 ? Ss 19:32 0:00 /usr/bin/dbus-daemon --system root 1273 0.0 0.0 4372 832 ? Ss 19:32 0:00 /usr/sbin/acpid root 1283 0.0 0.0 0 0 ? S 19:32 0:00 [flush-8:0] root 1284 0.0 0.1 157736 5328 ? Ssl 19:32 0:00 /usr/sbin/NetworkManager root 1296 0.0 0.1 129580 4072 ? Sl 19:33 0:00 /usr/lib/policykit-1/polkitd root 1303 0.0 0.0 78440 3068 ? S 19:33 0:00 /usr/sbin/modem-manager root 1318 0.0 0.0 30908 2916 ? S 19:33 0:00 /sbin/wpa_supplicant -u -s -O /var/run/wpa_supplicant root 1324 0.0 0.0 26624 780 ? Ss 19:33 0:00 /usr/bin/kdm root 1333 18.2 1.5 167180 59628 tty7 Ss+ 19:33 4:45 /usr/bin/X :0 vt7 -br -nolisten tcp -auth /var/run/xauth/A:0-dSQsfa root 1358 0.0 0.0 0 0 ? S 19:33 0:00 [kworker/3:2] root 1360 0.0 0.2 182948 9896 ? Ss 19:33 0:00 /usr/sbin/apache2 -k start avahi 1381 0.0 0.0 34104 1716 ? S 19:33 0:00 avahi-daemon: running [debian.local] avahi 1382 0.0 0.0 33980 452 ? S 19:33 0:00 avahi-daemon: chroot helper www-data 1439 0.0 0.1 182972 5620 ? S 19:33 0:00 /usr/sbin/apache2 -k start www-data 1440 0.0 0.1 182972 5620 ? S 19:33 0:00 /usr/sbin/apache2 -k start www-data 1441 0.0 0.1 182972 5620 ? S 19:33 0:00 /usr/sbin/apache2 -k start www-data 1442 0.0 0.1 182972 5620 ? S 19:33 0:00 /usr/sbin/apache2 -k start www-data 1443 0.0 0.1 182972 5620 ? S 19:33 0:00 /usr/sbin/apache2 -k start root 1466 0.0 0.0 66536 2320 ? S 19:33 0:00 -:0 root 1467 0.0 0.0 20372 1068 ? Ss 19:33 0:00 /usr/sbin/cron root 1490 0.0 0.0 21868 1440 ? S 19:33 0:00 udevd --daemon root 1493 0.0 0.0 21868 1432 ? S 19:33 0:00 udevd --daemon root 1495 0.0 0.1 78812 4276 ? Ss 19:33 0:00 /usr/sbin/cupsd -C /etc/cups/cupsd.conf colord 1497 0.0 0.2 321952 9532 ? Sl 19:33 0:00 /usr/lib/x86_64-linux-gnu/colord/colord root 1585 0.0 0.0 49644 1164 ? Ss 19:33 0:00 /usr/sbin/sshd root 1607 0.0 0.0 4148 696 ? S 19:33 0:00 /bin/sh /usr/bin/mysqld_safe root 1617 0.0 0.0 18788 964 ? S 19:33 0:00 /usr/sbin/smartd --pidfile /var/run/smartd.pid mysql 1720 0.0 0.7 171416 29280 ? Sl 19:33 0:00 /usr/sbin/mysqld --basedir=/usr --datadir=/var/lib/mysql --user=mysql --pid-file=/var/run/mysqld/mysqld.pid --socket=/var/run/mysqld/mysqld.sock --port=3306 root 1721 0.0 0.0 4044 632 ? S 19:33 0:00 logger -t mysqld -p daemon.error root 1847 0.0 0.0 4096 332 ? Ss 19:33 0:00 /usr/sbin/noflushd -n 5 root 1861 0.0 0.0 6120 628 tty1 Ss+ 19:33 0:00 /sbin/getty 38400 tty1 root 1862 0.0 0.0 6120 632 tty2 Ss+ 19:33 0:00 /sbin/getty 38400 tty2 root 1863 0.0 0.0 6120 632 tty3 Ss+ 19:33 0:00 /sbin/getty 38400 tty3 root 1864 0.0 0.0 6120 632 tty4 Ss+ 19:33 0:00 /sbin/getty 38400 tty4 root 1865 0.0 0.0 6120 628 tty5 Ss+ 19:33 0:00 /sbin/getty 38400 tty5 root 1866 0.0 0.0 6120 628 tty6 Ss+ 19:33 0:00 /sbin/getty 38400 tty6 root 1876 0.0 0.0 0 0 ? S 19:33 0:00 [kworker/2:3] root 1922 0.0 0.0 125104 3784 ? Sl 19:33 0:00 /usr/sbin/console-kit-daemon --no-daemon robert 1995 0.0 0.0 4148 692 ? Ss 19:33 0:00 /bin/sh /usr/bin/startkde robert 2035 0.0 0.0 12236 304 ? Ss 19:33 0:00 /usr/bin/ssh-agent /usr/bin/dbus-launch --exit-with-session /usr/bin/startkde robert 2038 0.0 0.0 26320 816 ? S 19:33 0:00 /usr/bin/dbus-launch --exit-with-session /usr/bin/startkde robert 2039 0.0 0.0 24468 1224 ? Ss 19:33 0:00 /usr/bin/dbus-daemon --fork --print-pid 5 --print-address 7 --session robert 2078 0.0 0.0 3912 84 ? S 19:33 0:00 /usr/lib/kde4/libexec/start_kdeinit +kcminit_startup robert 2079 0.0 0.5 301624 21836 ? Ss 19:33 0:00 kdeinit4: kdeinit4 Running... robert 2080 0.0 0.2 306228 10784 ? S 19:33 0:00 kdeinit4: klauncher [kdeinit] --fd=9 robert 2082 0.4 0.7 648944 29328 ? Sl 19:33 0:06 kdeinit4: kded4 [kdeinit] 104 2087 0.0 0.1 58812 5128 ? Ssl 19:33 0:00 /usr/sbin/hald root 2088 0.0 0.0 36408 1764 ? S 19:33 0:00 hald-runner root 2117 0.0 0.0 38528 1632 ? S 19:33 0:00 hald-addon-input: Listening on /dev/input/event5 /dev/input/event12 /dev/input/event0 /dev/input/event7 /dev/input/event3 /dev/input/event1 /dev/input/event9 /dev/input/event4 /dev/input/event2 root 2119 0.0 0.0 38520 1632 ? S 19:33 0:00 /usr/lib/hal/hald-addon-generic-backlight root 2120 0.0 0.0 38520 1636 ? S 19:33 0:00 /usr/lib/hal/hald-addon-generic-backlight root 2131 0.0 0.0 38524 1636 ? S 19:33 0:00 hald-addon-storage: polling /dev/sdb (every 2 sec) root 2139 0.0 0.0 38536 1636 ? S 19:33 0:00 /usr/lib/hal/hald-addon-cpufreq 104 2140 0.0 0.0 26440 1280 ? S 19:33 0:00 hald-addon-acpi: listening on acpid socket /var/run/acpid.socket root 2141 0.0 0.0 38524 1636 ? S 19:33 0:00 hald-addon-storage: polling /dev/sr0 (every 2 sec) robert 2143 0.0 0.4 278144 16124 ? S 19:33 0:00 /usr/bin/kglobalaccel root 2151 0.0 0.1 145720 4712 ? Sl 19:33 0:00 /usr/lib/upower/upowerd robert 2171 0.0 0.0 4048 324 ? S 19:33 0:00 kwrapper4 ksmserver robert 2172 0.0 0.4 493608 18748 ? Sl 19:33 0:00 kdeinit4: ksmserver [kdeinit] robert 2174 1.0 1.2 637860 49984 ? Sl 19:33 0:15 kwin robert 2180 0.0 0.4 282664 16948 ? S 19:33 0:00 /usr/bin/kactivitymanagerd root 2192 0.0 0.0 127464 3904 ? Sl 19:33 0:00 /usr/lib/udisks/udisks-daemon root 2199 0.0 0.0 45108 772 ? S 19:33 0:00 udisks-daemon: polling /dev/sr0 /dev/sdb root 2251 0.0 0.0 6948 1468 ? S 19:33 0:00 /sbin/dhclient -d -4 -sf /usr/lib/NetworkManager/nm-dhcp-client.action -pf /var/run/dhclient-wlan0.pid -lf /var/lib/dhcp/dhclient-4e12f4c5-07b4-4c89-906e-76a2e06f7d75-wlan0.lease -cf /var/run/nm-dhclient- robert 2256 0.0 1.0 1408656 40928 ? Sl 19:33 0:00 /usr/bin/knotify4 robert 2260 0.7 3.0 923344 121112 ? Sl 19:33 0:11 /usr/bin/plasma-desktop robert 2308 0.0 0.4 274636 16276 ? S 19:33 0:00 /usr/bin/kuiserver robert 2311 0.0 0.0 9084 1212 ? S 19:33 0:00 ksysguardd robert 2327 0.0 0.1 138840 5064 ? Sl 19:33 0:00 /usr/bin/akonadi_control robert 2330 0.0 0.2 248096 7932 ? Sl 19:33 0:00 akonadiserver robert 2333 0.0 0.8 223340 31512 ? Sl 19:33 0:00 /usr/sbin/mysqld --defaults-file=/home/robert/.local/share/akonadi//mysql.conf --datadir=/home/robert/.local/share/akonadi/db_data/ --socket=/home/robert/.local/share/akonadi/socket-debian/mysql.socket robert 2358 0.0 0.5 296456 20932 ? S 19:33 0:00 /usr/bin/akonadi_contacts_resource --identifier akonadi_contacts_resource_0 robert 2359 0.0 0.5 313168 22004 ? S 19:33 0:00 /usr/bin/akonadi_ical_resource --identifier akonadi_ical_resource_0 robert 2360 0.0 0.5 302816 21136 ? S 19:33 0:00 /usr/bin/akonadi_maildir_resource --identifier akonadi_maildir_resource_0 robert 2361 0.0 0.5 298888 21296 ? S 19:33 0:00 /usr/bin/akonadi_maildispatcher_agent --identifier akonadi_maildispatcher_agent robert 2362 0.0 0.5 309192 22392 ? Sl 19:33 0:00 /usr/bin/akonadi_nepomuk_contact_feeder --identifier akonadi_nepomuk_contact_feeder robert 2363 0.0 0.5 296472 21072 ? S 19:33 0:00 /usr/bin/akonadi_vcard_resource --identifier akonadi_vcard_resource_0 robert 2381 0.0 0.2 214488 9696 ? Sl 19:33 0:00 /usr/bin/nepomukserver robert 2393 0.0 0.4 331040 17288 ? S 19:33 0:00 /usr/bin/kaccess robert 2403 0.0 0.0 24152 1264 ? S 19:33 0:00 /usr/bin/xsettings-kde robert 2409 0.0 0.4 374604 17884 ? Sl 19:33 0:00 /usr/lib/kde4/libexec/polkit-kde-authentication-agent-1 robert 2410 0.0 1.1 744924 43756 ? Sl 19:33 0:00 /usr/bin/krunner robert 2411 0.0 0.7 585208 29832 ? Sl 19:33 0:00 /usr/bin/kmix robert 2415 0.0 0.4 287772 18024 ? S 19:33 0:00 /usr/bin/klipper robert 2417 0.0 0.5 433996 20976 ? S 19:33 0:00 /usr/bin/korgac --icon korgac robert 2460 15.1 7.6 730696 297744 ? Sl 19:34 3:44 /usr/lib/opera/opera robert 2519 0.0 0.0 11840 748 ? S 19:34 0:00 /usr/lib/opera//operaplugincleaner 2460 robert 2660 0.6 0.7 433048 27732 ? Rl 19:38 0:07 /usr/bin/konsole robert 2662 0.0 0.0 21576 2180 pts/1 Ss 19:38 0:00 /bin/bash root 2775 0.0 0.0 0 0 ? S 19:44 0:00 [kworker/u:1] root 2776 0.0 0.0 0 0 ? S 19:46 0:00 [kworker/2:1] root 2777 0.0 0.0 0 0 ? S 19:46 0:00 [kworker/3:0] root 2778 0.0 0.0 0 0 ? S 19:47 0:00 [kworker/1:0] root 2781 0.0 0.0 0 0 ? S 19:50 0:00 [kworker/u:2] root 2782 0.0 0.0 0 0 ? S 19:52 0:00 [kworker/0:2] root 2783 0.0 0.0 0 0 ? S 19:53 0:00 [kworker/1:2] root 2785 0.0 0.0 54060 1704 pts/1 S 19:55 0:00 su root 2793 0.0 0.0 23716 2304 pts/1 S 19:55 0:00 bash root 2800 0.0 0.0 0 0 ? S 19:56 0:00 [kworker/u:0] root 2875 0.0 0.0 0 0 ? S 19:58 0:00 [kworker/0:1] root 2876 0.0 0.0 16532 1196 pts/1 R+ 19:59 0:00 ps aux
Ostatnio edytowany przez bobycob (2011-11-21 15:44:09)
Offline
Strony: 1
- Forum Debian Users Gang
- » Hardware
- » problem z dyskiem w Acer Aspire 5830 ciągłe usypianie wybudzanie
Informacje debugowania
| Time (s) | Query |
|---|---|
| 0.00012 | SET CHARSET latin2 |
| 0.00005 | SET NAMES latin2 |
| 0.00135 | 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.152.189' WHERE u.id=1 |
| 0.00107 | UPDATE punbb_online SET logged=1732755046 WHERE ident='3.133.152.189' |
| 0.00048 | SELECT * FROM punbb_online WHERE logged<1732754746 |
| 0.00058 | 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=20093 AND t.moved_to IS NULL |
| 0.00005 | SELECT search_for, replace_with FROM punbb_censoring |
| 0.00180 | 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=20093 ORDER BY p.id LIMIT 0,25 |
| 0.00072 | UPDATE punbb_topics SET num_views=num_views+1 WHERE id=20093 |
| Total query time: 0.00622 s | |