root@sub [~]# tail /var/lib/mysql/slow.log
                                                                        ORDER BY                                                                           `rating` DESC LIMIT 72, 12;
# Time: 130411 12:32:27
# User@Host: davym123_gallery[davym123_gallery] @ localhost []
# Query_time: 4.937780  Lock_time: 0.000057 Rows_sent: 12  Rows_examined: 252041                                                                          02
SET timestamp=1365697947;
SELECT `images`.*, (SELECT AVG(`score`)
                                                                        FROM `ra                                                                          tings` WHERE `image_id`=`images`.`image_id`) AS `rating`,
                                                                        (SELECT                                                                           COUNT(*) FROM `ratings` WHERE `image_id`=`images`.`image_id`) AS `votes`
                                                                        FROM `im                                                                          ages` WHERE `champion_id`='27' AND `approved`='1'
                                                                        ORDER BY                                                                           `rating` DESC LIMIT 48, 12;
root@sub [~]# tail /var/lib/mysql/slow.log
                                                                        ORDER BY `rating` DESC LIMIT 24, 12;
# Time: 130411 12:32:39
# User@Host: davym123_gallery[davym123_gallery] @ localhost []
# Query_time: 52.766777  Lock_time: 0.000066 Rows_sent: 48  Rows_examined: 312030741
SET timestamp=1365697959;
SELECT `images`.*, (SELECT AVG(`score`)
                                                                        FROM `ratings` WHERE `image_id`=`images`.`image_id`) AS `rating`,
                                                                        (SELECT COUNT(*) FROM `ratings` WHERE `image_id`=`images`.`image_id`) AS `votes`
                                                                        FROM `images` WHERE `approved`='1'
                                                                        ORDER BY `rating` DESC LIMIT 672, 48;
root@sub [~]# tail /var/lib/mysql/slow.log
                                                                        ORDER BY `rating` DESC LIMIT 24, 12;
# Time: 130411 12:32:39
# User@Host: davym123_gallery[davym123_gallery] @ localhost []
# Query_time: 52.766777  Lock_time: 0.000066 Rows_sent: 48  Rows_examined: 312030741
SET timestamp=1365697959;
SELECT `images`.*, (SELECT AVG(`score`)
                                                                        FROM `ratings` WHERE `image_id`=`images`.`image_id`) AS `rating`,
                                                                        (SELECT COUNT(*) FROM `ratings` WHERE `image_id`=`images`.`image_id`) AS `votes`
                                                                        FROM `images` WHERE `approved`='1'
                                                                        ORDER BY `rating` DESC LIMIT 672, 48;