Разнообразие! Тази вечер ще се яде KFC. Ще взема да си отворя изцяло кулинарен микроблог и ще описвам само какво нагъвам. Така ще ми се карате като ям боклуци.
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
1.00369
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%KFC%" OR id IN(1446154, 1453412, 1453412, 1464740)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 45, 15
0.47468
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%KFC%" OR id IN(1446154, 1453412, 1453412, 1464740)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00037
SELECT id FROM groups WHERE is_public=0
0.07512
SELECT post_id FROM posts_comments WHERE message LIKE "%KFC%"
0.00028
SELECT id FROM searches WHERE user_id="" AND search_key="388af63eefc4f3eb50a0c7bef0df8f3e" LIMIT 1
0.00029
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1