SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
1.61660
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%the mysterious world of Spellforce%" OR MATCH(message) AGAINST("+the +mysterious +world +of +Spellforce" IN BOOLEAN MODE)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00021
SELECT * FROM groups WHERE id="365" LIMIT 1
0.00024
SELECT * FROM groups WHERE id="358" LIMIT 1
0.00023
SELECT * FROM groups WHERE id="343" LIMIT 1
0.00021
SELECT * FROM groups WHERE id="240" LIMIT 1
0.00025
SELECT * FROM groups WHERE id="221" LIMIT 1
0.00030
SELECT * FROM groups WHERE id="132" LIMIT 1
0.00034
SELECT id FROM groups WHERE is_public=0
0.27863
SELECT post_id FROM posts_comments WHERE message LIKE "%the mysterious world of Spellforce%" OR MATCH(message) AGAINST("+the +mysterious +world +of +Spellforce" IN BOOLEAN MODE)
0.00028
SELECT id FROM searches WHERE user_id="" AND search_key="38a2030fd9ac4dc13c6a14a652bc8db2" LIMIT 1
0.00034
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1