Вход
Постове
Постове
Хора
Групи
Начало
Потребители
Групи
ОК
Следващ пост
Профил на bgmdb
Предишен пост
bgmdb
Много готино направена формула, се кара от вътре, а скоростите са лудница.
http://bggdb.com/%D1%83%D0%BB%D1%82%D0%B8%D0%BC%D0%B5%D0%B9%D1%82-%D1%84%D0%BE%D1%80...html
Jun 19 2012, 06:02
DB Queries: 9
(0.0047s) |
CACHE Queries: 14
(0.0011s) | Script Execution Time: 0.008 | Memory usage: 0.83MB | Server Load Average: 0.04, 0.07, 0.08
0.00020
SELECT id, type, data FROM posts_attachments WHERE post_id="1428126" LIMIT 1
0.00044
SELECT * FROM posts WHERE id<"1428545" AND user_id="17067" ORDER BY id DESC LIMIT 1
0.00026
SELECT id, type, data FROM posts_attachments WHERE post_id="1430725" LIMIT 1
0.00048
SELECT * FROM posts WHERE id>"1428545" AND user_id="17067" ORDER BY id ASC LIMIT 1
0.00023
SELECT id FROM groups WHERE is_public=0
0.00032
SELECT id, type, data FROM posts_attachments WHERE post_id="1428545" LIMIT 1
0.00027
SELECT * FROM posts WHERE id="1428545" LIMIT 1
0.00030
SELECT * FROM settings
0.00222
CONNECT 49.12.223.183:9906
0.00006
GET
f5dad|1000|n:1,group_invited_members:365
array
0.00010
GET
f5dad|1000|n:1,groupid:365
object
0.00007
GET
f5dad|1000|n:1,group_invited_members:358
array
0.00006
GET
f5dad|1000|n:1,groupid:358
object
0.00006
GET
f5dad|1000|n:1,group_invited_members:343
array
0.00006
GET
f5dad|1000|n:1,groupid:343
object
0.00005
GET
f5dad|1000|n:1,group_invited_members:240
array
0.00011
GET
f5dad|1000|n:1,groupid:240
object
0.00005
GET
f5dad|1000|n:1,group_invited_members:221
array
0.00007
GET
f5dad|1000|n:1,groupid:221
object
0.00007
GET
f5dad|1000|n:1,group_invited_members:132
array
0.00008
GET
f5dad|1000|n:1,groupid:132
object
0.00024
GET
f5dad|1000|n:1,userid:17067
object
0.00001
CONNECT
172.20.0.6:11211
TRUE