@sandprince на мен от картинките и трейлърите като гледам филма (за Аватар говоря) ми изглежда малко тъп, гледа ли "Цирк на изродите:Чиракът на вампира"?
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
0.00029
SELECT user_id FROM posts_mentioned WHERE post_id="340644" LIMIT 1
0.00030
SELECT user_id FROM posts_mentioned WHERE post_id="452394" LIMIT 1
0.00034
SELECT * FROM users_details WHERE user_id="342" LIMIT 1
0.00057
SELECT * FROM users WHERE id="342" LIMIT 1
1.12519
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%трейлъри%" OR id IN(1382288, 1424591)) AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 15, 15
0.56086
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%трейлъри%" OR id IN(1382288, 1424591)) AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00035
SELECT id FROM groups WHERE is_public=0
0.08840
SELECT post_id FROM posts_comments WHERE message LIKE "%трейлъри%"
0.00034
SELECT id FROM searches WHERE user_id="" AND search_key="3014763f44178e0b22a62cc27d1617b1" LIMIT 1
0.00035
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1