SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00031
SELECT * FROM posts_comments WHERE post_id="1469825" ORDER BY id ASC
0.00040
SELECT * FROM posts_comments WHERE post_id="1469878" ORDER BY id ASC
1.08992
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%Im14andthisisdeep%" OR id=1469825) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
0.50848
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%Im14andthisisdeep%" OR id=1469825) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00028
SELECT id FROM groups WHERE is_public=0
0.08208
SELECT post_id FROM posts_comments WHERE message LIKE "%Im14andthisisdeep%"
0.00048
SELECT id FROM searches WHERE user_id="" AND search_key="347c870da6d312ea6b9e6c6ad96a0b2c" LIMIT 1
0.00036
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1
По-доброто решение.
Feb 15 2017, 20:12is good, ма до едно време - пролетта, например
Feb 17 2017, 14:45