SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00021
SELECT user_id FROM posts_mentioned WHERE post_id="443668" LIMIT 1
0.00023
SELECT id, type, data FROM posts_attachments WHERE post_id="1217034" LIMIT 1
0.00024
SELECT * FROM users_details WHERE user_id="1523" LIMIT 1
0.00037
SELECT * FROM users WHERE id="1523" LIMIT 1
2.10613
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%хотел пампорово%" OR MATCH(message) AGAINST("+хотел +пампорово" IN BOOLEAN MODE)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
1.50235
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%хотел пампорово%" OR MATCH(message) AGAINST("+хотел +пампорово" IN BOOLEAN MODE)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00035
SELECT id FROM groups WHERE is_public=0
0.25018
SELECT post_id FROM posts_comments WHERE message LIKE "%хотел пампорово%" OR MATCH(message) AGAINST("+хотел +пампорово" IN BOOLEAN MODE)
0.00028
SELECT id FROM searches WHERE user_id="" AND search_key="8d3be8fda0ec0c2c686fdee75b1ac7ad" LIMIT 1
0.00028
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1