library/includes/datastore/build_cat_forums.php(40) [0,000s] 1 rows | [MySQL] db1.b238565_ivtorrent :: Query #1 |
|---|
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | | 1 | SIMPLE | bb_categories | system | | | | | 1 | |
| |
SELECT * FROM bb_categories ORDER BY cat_order
library/includes/datastore/build_cat_forums.php(53) [0,000s] 1 rows | [MySQL] db1.b238565_ivtorrent :: Query #2 |
|---|
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | | 1 | SIMPLE | f | system | cat_id | | | | 1 | | | 1 | SIMPLE | c | system | PRIMARY | | | | 1 | |
| |
SELECT f.* FROM bb_forums f, bb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order
library/includes/datastore/build_cat_forums.php(142) [0,000s] 1 rows | [MySQL] db1.b238565_ivtorrent :: Query #3 |
|---|
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | | 1 | SIMPLE | bb_topics | system | forum_id | | | | 1 | |
| |
SELECT topic_id, topic_time, topic_title, forum_id FROM bb_topics WHERE forum_id IN (1) AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 5
library/includes/datastore/build_cat_forums.php(161) [0,000s] | [MySQL] db1.b238565_ivtorrent :: Query #4 |
|---|
id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra | | 1 | SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
| |
SELECT topic_id, topic_time, topic_title, forum_id FROM bb_topics WHERE forum_id IN (2) AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 5
database: db1 [MySQL]
0,001s [44%] connect to: '78.108.80.36:3306' # library/includes/datastore/build_cat_forums.php(40)
0,000s [5%] select db: 'b238565_ivtorrent' # library/includes/datastore/build_cat_forums.php(40)
0,000s [12%] SELECT * FROM bb_categories ORDER BY cat_order # 1 rows [library/includes/datastore/build_cat_forums.php(40)]
0,000s [14%] SELECT f.* FROM bb_forums f, bb_categories c WHERE f.cat_id = c.cat_id ORDER BY c.cat_order, f.forum_order # 1 rows [library/includes/datastore/build_cat_forums.php(53)]
0,000s [14%] SELECT topic_id, topic_time, topic_title, forum_id FROM bb_topics WHERE forum_id IN (1) AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 5 # 1 rows [library/includes/datastore/build_cat_forums.php(142)]
0,000s [13%] SELECT topic_id, topic_time, topic_title, forum_id FROM bb_topics WHERE forum_id IN (2) AND topic_moved_id = 0 ORDER BY topic_time DESC LIMIT 5 # library/includes/datastore/build_cat_forums.php(161)
cache: bb_config [Filecache]
0,000s [100%] cache->get('config_bb_config') # library/includes/cache/file.php(24)
cache: bb_cache [Filecache]
0,000s [23%] cache->get('censored') # library/includes/cache/file.php(24)
0,000s [25%] cache->get('index_sql_dc343f5b9864f0e4a25b2d23a9486435') # library/includes/cache/file.php(24)
0,000s [23%] cache->get('btu_2') # library/includes/cache/file.php(24)
0,000s [28%] cache->get('online_short_ru') # library/includes/cache/file.php(24)
cache: session_cache [Filecache]
0,000s [100%] cache->get('NGaFoO2IkTLqC9MbqolF') # library/includes/cache/file.php(24)
cache: datastore [Filecache]
0,000s [14%] cache->get('cat_forums') # library/includes/datastore/file.php(74)
0,000s [8%] cache->get('stats') # library/includes/datastore/file.php(74)
0,000s [6%] cache->get('moderators') # library/includes/datastore/file.php(74)
0,000s [6%] cache->get('latest_news') # library/includes/datastore/file.php(74)
0,000s [5%] cache->get('network_news') # library/includes/datastore/file.php(74)
0,000s [7%] cache->get('ranks') # library/includes/datastore/file.php(74)
0,000s [17%] cache->set('cat_forums') # library/includes/datastore/file.php(21)
0,000s [9%] cache->set('jumpbox') # library/includes/datastore/file.php(21)
0,000s [9%] cache->set('viewtopic_forum_select') # library/includes/datastore/file.php(21)
0,000s [9%] cache->set('latest_news') # library/includes/datastore/file.php(21)
0,000s [8%] cache->set('network_news') # library/includes/datastore/file.php(21)
