SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
1.00360
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%football%" OR id IN(1366207, 1352174, 1377300, 1467574, 1428492, 1459087, 1463414)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 75, 15
0.47598
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%football%" OR id IN(1366207, 1352174, 1377300, 1467574, 1428492, 1459087, 1463414)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00036
SELECT id FROM groups WHERE is_public=0
0.08983
SELECT post_id FROM posts_comments WHERE message LIKE "%football%"
0.00042
SELECT id FROM searches WHERE user_id="" AND search_key="726db5545289d755074c06763d4afbc2" LIMIT 1
0.00041
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1