решено Оптимизация запросов Mysql

L

ler

Гость
Что посоветуете?
[ Время выполнения: 0.529 сек | MySQL: 0.236 сек (45%) · 89 запр. | GZIP вкл | Память: 616.4 KB / 3.2 MB / 2.86 MB | Лимит: 2 2 1.9 ]
Код: 
0.0008 [ 0] connect to: localhost # includes/sessions.php(112)
0.0004 [ 0] select db: me_tracker # includes/sessions.php(112)
0.0013 [ 0] SELECT u.*, s.*, th.topic_id_csv AS torhelp FROM bb_sessions s INNER JOIN bb_users u ON(u.user_id = s.session_user_id) LEFT JOIN bb_bt_torhelp th ON(u.user_id = th.user_id) WHERE s.session_id = '07wI2C1lV29RaISjgF4A' # 1 rows [includes/sessions.php(112)]
0.0007 [ 0] UPDATE bb_sessions SET session_time = 1414616298 WHERE session_id = '07wI2C1lV29RaISjgF4A' LIMIT 1 # Rows matched: 1 Changed: 1 Warnings: 0 [includes/sessions.php(168)]
0.0011 [ 0] UPDATE bb_users SET curpage_topic = 279, curpage_topic_time = 1414616298 WHERE user_id = 2 # Rows matched: 1 Changed: 1 Warnings: 0 [viewtopic.php(60)]
0.1446 [61] SELECT username, user_id, user_rank, user_karma, curpage_topic_time FROM bb_users WHERE curpage_topic = 279 AND (curpage_topic_time > 1414615998) # 1 rows [viewtopic.php(66)]
0.0010 [ 0] SELECT t.*, f.*, c.cat_title FROM bb_topics t, bb_forums f, bb_categories c WHERE t.topic_id = 279 AND f.forum_id = t.forum_id AND c.cat_id = f.cat_id LIMIT 1 # 1 rows [viewtopic.php(165)]
0.0003 [ 0] SELECT notify_status FROM bb_topics_watch WHERE topic_id = 279 AND user_id = 2 # viewtopic.php(373)
0.0059 [ 2] SELECT u.username, u.user_id, u.user_timer, u.user_allow_viewonline, u.user_posts, u.user_from, u.user_regdate, u.user_rank, u.user_sig, u.user_avatar, u.user_avatar_type,u.user_karma, u.user_opt, p.*, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) WHERE p.topic_id = 279 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 50 # 37 rows [viewtopic.php(538)]
0.0022 [ 0] SELECT a.post_id, d.*, r.thanked, r.rating FROM bb_attachments a join bb_attachments_desc d on a.attach_id = d.attach_id left join bb_attachments_rating r on r.attach_id=a.attach_id and r.user_id=2 WHERE a.post_id IN (508) ORDER BY d.filetime DESC # 1 rows [attach_mod/includes/functions_attach.php(488)]
0.0005 [ 0] INSERT INTO buf_topic_view (topic_id, topic_views) VALUES (279, 1) ON DUPLICATE KEY UPDATE topic_views = topic_views + 1 # 1 rows [viewtopic.php(967)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0411 [17] SELECT t.*, u.user_id, u.username, f.forum_id, f.forum_name, tor.size FROM bb_topics t, bb_users u, bb_forums f, bb_bt_torrents tor WHERE t.topic_id != 279 AND tor.topic_id = t.topic_id AND t.topic_title LIKE '%Руководство%' AND f.allow_reg_tracker = 1 AND t.forum_id = f.forum_id AND t.forum_id != 170 AND t.topic_poster = u.user_id GROUP BY t.topic_title LIMIT 10 # 1 rows [viewtopic.php(1325)]
0.0007 [ 0] SELECT * FROM bb_bt_torrents WHERE attach_id = 209 LIMIT 1 # 1 rows [attach_mod/displaying_torrent.php(123)]
0.0006 [ 0] SELECT auth_key FROM bb_bt_users WHERE user_id = 2 LIMIT 1 # 1 rows [attach_mod/displaying_torrent.php(163)]
0.0008 [ 0] SELECT user_status FROM bb_bt_dlstatus_mrg WHERE user_id = 2 AND topic_id = 279 LIMIT 1 # attach_mod/displaying_torrent.php(189)
0.0005 [ 0] SELECT username FROM bb_users WHERE user_id = 525 LIMIT 1 # 1 rows [includes/functions.php(1159)]
0.0007 [ 0] SELECT sn.seeders, sn.leechers, sn.speed_up, sn.speed_down, tor.tor_seeders, tor.tor_leechers FROM bb_bt_torrents tor LEFT JOIN bb_bt_tracker_snap sn ON(sn.topic_id = tor.topic_id) WHERE tor.topic_id = 279 LIMIT 1 # 1 rows [attach_mod/displaying_torrent.php(371)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0004 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 515 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 515 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0004 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1251)]
0.0004 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1252)]
0.0020 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 755 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 755 # 1 rows [viewtopic.php(1252)]
0.0009 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 980 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 980 # 1 rows [viewtopic.php(1252)]
0.0007 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1087 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1087 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1784 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1784 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0004 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1784 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1784 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2249 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2249 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 525 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2130 # 1 rows [viewtopic.php(1251)]
0.0013 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2130 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2130 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2130 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2474 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2474 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2369 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2369 # 1 rows [viewtopic.php(1252)]
0.0007 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2849 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2849 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1528 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1528 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1326 # 1 rows [viewtopic.php(1251)]
0.0018 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 1326 # 1 rows [viewtopic.php(1252)]
0.0009 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 6659 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 6659 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 7442 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 7442 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 6634 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 6634 # 1 rows [viewtopic.php(1252)]
0.0006 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 12050 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 12050 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 14966 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 14966 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2847 # 1 rows [viewtopic.php(1251)]
0.0014 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 2847 # 1 rows [viewtopic.php(1252)]
0.0026 [ 1] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 15114 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 15114 # 1 rows [viewtopic.php(1252)]
0.0010 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 18725 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 18725 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 21508 # 1 rows [viewtopic.php(1251)]
0.0002 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 21508 # 1 rows [viewtopic.php(1252)]
0.0005 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 34214 # 1 rows [viewtopic.php(1251)]
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id = 34214 # 1 rows [viewtopic.php(1252)]
0.0003 [ 0] SELECT COUNT(report_id) AS report_count FROM bb_reports WHERE report_status IN(0, 1) # 1 rows [includes/functions_report.php(663)]
0.0006 [ 0] UPDATE bb_users SET user_timer = '1414616299' WHERE user_id = 2 # Rows matched: 1 Changed: 1 Warnings: 0 [includes/page_header.php(456)]
cache: bb_cache [Filecache]
0.0014 [14] cache->set('config_bb_config') # includes/functions.php(1275)
0.0006 [ 6] cache->set('censored') # includes/functions.php(1863)
0.0006 [ 5] cache->set('report_modules') # includes/functions_report.php(55)
0.0005 [ 5] cache->set('attach_config') # attach_mod/attachment_mod.php(77)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0006 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0006 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
0.0005 [ 5] cache->set('censored') # includes/functions.php(1863)
cache: session_cache [Filecache]
0.0004 [42] cache->set('07wI2C1lV29RaISjgF4A') # includes/sessions.php(848)
0.0005 [57] cache->set('07wI2C1lV29RaISjgF4A') # includes/sessions.php(858)
$datastore [Filecache]
0.0001 [21] cache->get('cat_forums') # includes/functions.php(2844)
0.0002 [28] cache->get('smile_replacements') # includes/functions.php(2844)
0.0002 [25] cache->get('ranks') # includes/functions.php(2844)
0.0002 [24] cache->get('attach_extensions') # attach_mod/includes/functions_attach.php(547)
 
Последнее редактирование модератором:
nord51

nord51

Пользователь
[ Время выполнения: 0.529 сек | MySQL: 0.236 сек (45%) · 89 запр. | GZIP вкл | Память: 616.4 KB / 3.2 MB / 2.86 MB | Лимит: 2 2 1.9 ]
Нажмите для раскрытия...
Нух.я себе. :confused:
Кешируй, с таким количеством запросов сервак мигом на лопатки положить можно. Ты там что за говномоды наставил ?
 
Последнее редактирование:
Exile

Exile

Администратор
я разве непонятно в соседней теме про похожие раздачи написал что не надо делать цикл в цикле? Чему удивляться?
 
L

ler

Гость
На серваке еще висит transmission и раздает 2000 торрентов
Но при этом свободно половина оперативки из 2Гб и загрузка процессора не более 10

Сейчас убрал запрос торрент статистики для каждого юзера select u_up_release, u_up_total....
и стало 15 запросов вместо 89
 
Exile

Exile

Администратор
Код: 
0.1446 [61] SELECT username, user_id, user_rank, user_karma, curpage_topic_time FROM bb_users WHERE curpage_topic = 279 AND (curpage_topic_time > 1414615998) # 1 rows [viewtopic.php(66)]
В таблице на полях явно нет индекса - время исполнения ненормальное.
Код: 
0.0003 [ 0] select u_up_release, u_up_total FROM bb_bt_users WHERE user_id =
Куча запросов такого плана - если прям очень надо, то эти данные можно кешировать на несколько часов. Будет относительно актуально и такого числа запросов не будет.
Код: 
0.0011 [ 0] UPDATE bb_users SET curpage_topic = 279, curpage_topic_time = 1414616298 WHERE user_id = 2 # Rows matched: 1 Changed: 1 Warnings: 0 [viewtopic.php(60)]
Опять же мод какой-то. Как понимаю отображает на какой странице сейчас пользователь. Обновление при каждой запросе - плохая идея.
Код: 
bb_cache [Filecache]
СРОЧНО заменить на мемкеш.
 
L

ler

Гость
Ок. А что лучше для поиска похожих раздач? LIKE или MATCH AGAINST или еще что
Нашел вот такую функцию в движке get_title_match_topics
 
L

ler

Гость
Ну вот, уже куда лучше
[ Время выполнения: 0.289 сек | MySQL: 0.022 сек (8%) · 15 запр. | GZIP вкл | Память: 611.57 KB / 3.21 MB / 2.88 MB | Лимит: 1.6 1.5 1.4 ] show log full explain [ wrap · max ]
Код: 
db1 [MySQL
0.0006 [ 2] connect to: localhost # viewtopic.php(60)
0.0002 [ 1] select db: me_tracker # viewtopic.php(60)
0.0006 [ 2] UPDATE bb_users SET curpage_topic = 279, curpage_topic_time = 1414621728 WHERE user_id = 2 # Rows matched: 1 Changed: 1 Warnings: 0 [viewtopic.php(60)]
0.0006 [ 2] SELECT username, user_id, user_rank, user_karma, curpage_topic_time FROM bb_users WHERE curpage_topic = 279 AND (curpage_topic_time > 1414621428) # 1 rows [viewtopic.php(66)]
0.0003 [ 1] SELECT t.*, f.*, c.cat_title FROM bb_topics t, bb_forums f, bb_categories c WHERE t.topic_id = 279 AND f.forum_id = t.forum_id AND c.cat_id = f.cat_id LIMIT 1 # 1 rows [viewtopic.php(165)]
0.0004 [ 1] SELECT notify_status FROM bb_topics_watch WHERE topic_id = 279 AND user_id = 2 # viewtopic.php(373)
0.0079 [36] SELECT u.username, u.user_id, u.user_timer, u.user_allow_viewonline, u.user_posts, u.user_from, u.user_regdate, u.user_rank, u.user_sig, u.user_avatar, u.user_avatar_type,u.user_karma, u.user_opt, p.*, h.post_html, IF(h.post_html IS NULL, pt.post_text, NULL) AS post_text FROM bb_posts p LEFT JOIN bb_users u ON(u.user_id = p.poster_id) LEFT JOIN bb_posts_text pt ON(pt.post_id = p.post_id) LEFT JOIN bb_posts_html h ON(h.post_id = p.post_id) WHERE p.topic_id = 279 GROUP BY p.post_id ORDER BY p.post_time asc LIMIT 0, 50 # 37 rows [viewtopic.php(538)]
0.0005 [ 2] SELECT a.post_id, d.*, r.thanked, r.rating FROM bb_attachments a join bb_attachments_desc d on a.attach_id = d.attach_id left join bb_attachments_rating r on r.attach_id=a.attach_id and r.user_id=2 WHERE a.post_id IN (508) ORDER BY d.filetime DESC # 1 rows [attach_mod/includes/functions_attach.php(488)]
0.0006 [ 2] INSERT INTO buf_topic_view (topic_id, topic_views) VALUES (279, 1) ON DUPLICATE KEY UPDATE topic_views = topic_views + 1 # 2 rows [viewtopic.php(967)]
0.0074 [33] SELECT t.*, u.user_id, u.username, f.forum_id, f.forum_name, tor.size FROM bb_topics t, bb_users u, bb_forums f, bb_bt_torrents tor WHERE t.topic_id != 279 AND tor.topic_id = t.topic_id AND MATCH (topic_title) AGAINST ('Руководство%') AND f.allow_reg_tracker = 1 AND t.forum_id = f.forum_id AND t.forum_id != 170 AND t.topic_poster = u.user_id GROUP BY t.topic_title LIMIT 10 # 10 rows [viewtopic.php(1325)]
0.0005 [ 2] SELECT * FROM bb_bt_torrents WHERE attach_id = 209 LIMIT 1 # 1 rows [attach_mod/displaying_torrent.php(123)]
0.0004 [ 1] SELECT auth_key FROM bb_bt_users WHERE user_id = 2 LIMIT 1 # 1 rows [attach_mod/displaying_torrent.php(163)]
0.0003 [ 1] SELECT user_status FROM bb_bt_dlstatus_mrg WHERE user_id = 2 AND topic_id = 279 LIMIT 1 # attach_mod/displaying_torrent.php(189)
0.0007 [ 3] SELECT username FROM bb_users WHERE user_id = 525 LIMIT 1 # 1 rows [includes/functions.php(1159)]
0.0004 [ 1] SELECT sn.seeders, sn.leechers, sn.speed_up, sn.speed_down, tor.tor_seeders, tor.tor_leechers FROM bb_bt_torrents tor LEFT JOIN bb_bt_tracker_snap sn ON(sn.topic_id = tor.topic_id) WHERE tor.topic_id = 279 LIMIT 1 # 1 rows [attach_mod/displaying_torrent.php(371)]
0.0004 [ 1] SELECT COUNT(report_id) AS report_count FROM bb_reports WHERE report_status IN(0, 1) # 1 rows [includes/functions_report.php(663)]
0.0008 [ 3] UPDATE bb_users SET user_timer = '1414621728' WHERE user_id = 2 # Rows matched: 1 Changed: 1 Warnings: 0 [includes/page_header.php(456)]
cache: bb_cache [Memcache]
0.0003 [ 8] pconnect 127.0.0.1:11211 # includes/functions.php(1275)
0.0001 [ 3] cache->get('config_bb_config') # includes/functions.php(1275)
0.0002 [ 6] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 6] cache->get('report_modules') # includes/functions_report.php(55)
0.0002 [ 6] cache->get('attach_config') # attach_mod/attachment_mod.php(77)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 6] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 6] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
0.0002 [ 5] cache->get('censored') # includes/functions.php(1863)
cache: session_cache [Memcache]
0.0002 [70] pconnect 127.0.0.1:11211 # includes/sessions.php(848)
0.0001 [29] cache->get('07wI2C1lV29RaISjgF4A') # includes/sessions.php(848)
$datastore [Memcache]
0.0002 [23] pconnect 127.0.0.1:11211 # includes/functions.php(2844)
0.0001 [11] cache->get('cat_forums') # includes/functions.php(2844)
0.0002 [21] cache->get('smile_replacements') # includes/functions.php(2844)
0.0002 [18] cache->get('ranks') # includes/functions.php(2844)
0.0003 [26] cache->get('attach_extensions') # attach_mod/includes/functions_attach.php(547)
 
Последнее редактирование модератором:
Сверху