| time: 0 | SELECT * FROM place WHERE parent_id = 1 |
| time: 0 | SELECT text FROM meta_tags WHERE location=1 AND type='keywords' AND page='people' |
| time: 0 | SELECT text FROM meta_tags WHERE location=1 AND type='description' AND page='people' |
| time: 0 | SELECT text FROM meta_tags WHERE location=1 AND type='title' AND page='people' |
| time: 0 | SELECT * FROM blog WHERE name = 'tracyb' AND type=0 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0.45 | SELECT COUNT(*) AS c FROM message WHERE member_id = 9 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0.45 | SELECT MAX(g_date_created) FROM global INNER JOIN message ON id = g_tid WHERE g_is_comment = 0 AND member_id = 9 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0 | SELECT * FROM friend INNER JOIN members ON members.id = friend_id WHERE member_id = 9 AND status = 1 ORDER by member_name LIMIT 10 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0 | SELECT * FROM group_member INNER JOIN blog ON blog.id = channel_id WHERE member_id = 9 AND role >= 0 LIMIT 10 |
| time: 0.45 | SELECT MONTHNAME(FROM_UNIXTIME(g_date_created)) AS month, YEAR(FROM_UNIXTIME(g_date_created)) AS year, count(*) AS count FROM global INNER JOIN message ON message.id = global.g_tid WHERE g_channel =0 AND g_is_comment =0 AND member_id = 9 GROUP BY month, year ORDER BY g_date_created LIMIT 10 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0.18 | SELECT * FROM global INNER JOIN message ON message.id = g_tid AND g_type = 2 WHERE member_id=9 AND g_is_comment =0 AND g_channel =0 ORDER BY g_date_created DESC LIMIT 3 |
| time: 0 | SELECT message.*, members.member_name, members.myicon_fname FROM message LEFT JOIN members ON members.id = member_id WHERE message.id = '1763' |
| time: 0 | SELECT * FROM global_image WHERE g_id = 3513 |
| time: 0 | SELECT message.*, members.member_name, members.myicon_fname FROM message LEFT JOIN members ON members.id = member_id WHERE message.id = '1723' |
| time: 0 | SELECT * FROM global_image WHERE g_id = 3405 |
| time: 0 | SELECT message.*, members.member_name, members.myicon_fname FROM message LEFT JOIN members ON members.id = member_id WHERE message.id = '1718' |
| time: 0.15 | SELECT * FROM global_image WHERE g_id = 3390 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0.18 | SELECT * FROM global INNER JOIN message ON message.id = g_tid AND g_type = 3 WHERE member_id=9 AND g_is_comment =0 AND g_channel =0 ORDER BY g_date_created DESC LIMIT 2 |
| time: 0 | SELECT message.*, members.member_name, members.myicon_fname FROM message LEFT JOIN members ON members.id = member_id WHERE message.id = '1381' |
| time: 0.39 | SELECT * FROM global_image WHERE g_id = 1301 |
| time: 0 | SELECT id FROM members WHERE member_name='tracyb' |
| time: 0.01 | SELECT ratings.*,ROUND(ROUND(rating*2,0)/2,1) AS rating, ROUND(ROUND(rating1*2,0)/2,1) AS rating1, ROUND(ROUND(rating2*2,0)/2,1) AS rating2, ROUND(ROUND(rating3*2,0)/2,1) AS rating3, members.member_name, members.myicon_fname FROM ratings INNER JOIN members ON members.id = ratings.member_id WHERE member_id =9 ORDER BY date_posted DESC LIMIT 1 |
The not so interesting ramblings of a foreigner in Norfolk.
40 posts
Cost: 
