Deprecated: preg_replace(): The /e modifier is deprecated, use preg_replace_callback instead in /var/www/html/system/classes/class_post.php on line 382
"A HOWTO on Optimizing PHP" via Phplens http://bit.ly/bH7gFA
SELECT id, search_key, search_string FROM searches WHERE user_id="" ORDER BY id DESC
1.01457
SELECT *, "public" AS `type` FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%optimizing%") AND group_id NOT IN(132, 221, 240, 343, 358, 365) ORDER BY id DESC LIMIT 0, 15
0.46582
SELECT COUNT(id) FROM posts WHERE (api_id=2 OR user_id<>0) AND (message LIKE "%optimizing%") AND group_id NOT IN(132, 221, 240, 343, 358, 365)
0.00029
SELECT id FROM groups WHERE is_public=0
0.08001
SELECT post_id FROM posts_comments WHERE message LIKE "%optimizing%"
0.00027
SELECT id FROM searches WHERE user_id="" AND search_key="235d7b3548bc1bdf5882fe3a200d44ed" LIMIT 1
0.00022
SELECT FROM_UNIXTIME(date,"%Y") FROM posts ORDER BY id ASC LIMIT 1