@ameli не уча бе. Само задачи решавам, шото е интригуващо сеш ли са? Ай няама. Излизам вече. Ядох, нанпраВИХ 'ъпдейт' в плеяра и време за хек. Приятен ден!
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="10034" LIMIT 1
0.00024
SELECT * FROM users_details WHERE user_id="204" LIMIT 1
0.00034
SELECT * FROM users WHERE id="204" LIMIT 1
1.01656
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%хек%" OR id IN(1293903, 1416346, 1457888)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 45, 15
0.49768
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%хек%" OR id IN(1293903, 1416346, 1457888)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00033
SELECT id FROM groups WHERE is_public=0
0.09398
SELECT post_id FROM posts_comments WHERE message LIKE "%хек%"
0.00033
SELECT id FROM searches WHERE user_id="" AND search_key="5b45f0057f886d82afb86ebccfca6474" LIMIT 1
0.00031
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1