Anyone care to enlighten me as to why 188 queries are used on a page?
I implemented a query-count-and-tracking system on my site. And boy, I was shocked.
The following is what you get if you load adopt.php. There are 3 adoptables up to adopt, but... well, look at the 188 queries...
Code:
188 queries were taken for this page. They are the following:
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username='Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_adoptables
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='1'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='2'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='3'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='4'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='5'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='6'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='7'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='8'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='9'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='10'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='11'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='12'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='13'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='14'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='15'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='16'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='19'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='18'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='20'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='21'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='22'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='23'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='24'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='25'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='26'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='27'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='28'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='29'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='30'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='31'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='32'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='33'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='34'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='35'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='36'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_groups WHERE gid = '1'
SELECT * FROM adopts_adoptables WHERE id='38'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_messages WHERE touser='Arianna' and status='unread'
SELECT * FROM `adopts_users` WHERE `username`='Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
And for myadopts, it's this:
Code:
89 queries were taken for this page. They are the following:
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_users WHERE username='Arianna'
SELECT * FROM adopts_users WHERE username = 'Arianna'
SELECT * FROM adopts_owned_adoptables WHERE owner='Arianna' ORDER BY type, totalclicks DESC
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 441 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 461 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1268 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1777 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 219 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 217 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 222 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 211 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1095 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 2208 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 2203 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1781 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1273 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 289 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 681 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 187 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 218 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 2258 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1638 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 712 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 738 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1523 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1778 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 10 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 9 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 154 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 258 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 221 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 259 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 224 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 460 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1074 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1072 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1175 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1176 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1233 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 269 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 150 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1269 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1415 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1082 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1117 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1089 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1087 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 811 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 771 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 810 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 413 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 703 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 148 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 213 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 513 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 392 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 514 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1073 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1137 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1136 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1135 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 2209 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 2207 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1779 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1780 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 973 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1066 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 879 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1094 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 880 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1270 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1272 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1271 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 270 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 149 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 208 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 214 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1244 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 186 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 256 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 673 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1075 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 1637 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_adoptables, adopts_owned_adoptables, adopts_levels WHERE `adopts_owned_adoptables`.`aid` = 704 AND `adopts_owned_adoptables`.`type` = `adopts_adoptables`.`type` AND `adopts_levels`.`adoptiename` = `adopts_adoptables`.`type` AND `adopts_levels`.`thisislevel` = `adopts_owned_adoptables`.`currentlevel` LIMIT 0 , 30
SELECT * FROM adopts_users WHERE username = 'Arianna'
How is this /happening/? It's disgusting. 188 queries. :( No wonder my web host suspended me a few months ago.
7 queries are taken for a page with nothing on it, 9 for the index, and 90 queries (0.o) for myadopts. The first two are acceptable, these aren't.
Is there any way I can stop this? (I'm rewriting the whole script for TwigAdopts anyway, but I want to have this stopped.)
|