News

Pages 1

California Screamin' as prices plunge

03 Aug 2008 10:38am

New figures have revealed that house prices across California plunged in February...
Tags: USA, California, Property Prices, Housing
Pages 1
Page Execution: 207.71ms
Peak Memory: 2652 Kb (2.75 MB)

Debug Output


Executed 15 queries in 99.62ms
0.42msSELECT user_id,last_active FROM active_sessions WHERE session_id='8ad799e271ad88e034ea34627ce83809'
19.8msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('8ad799e271ad88e034ea34627ce83809','','38.103.63.60',UNIX_TIMESTAMP())
0.2msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('8ad799e271ad88e034ea34627ce83809','/news/housing/',UNIX_TIMESTAMP());
0.14msSELECT * FROM top_navigation ORDER BY list_order;
0.15msSELECT td.tag_id,td.name,td.simple_name FROM content c LEFT JOIN tag_content_assoc tca ON (tca.content_id=c.id) LEFT JOIN tag_data td on (td.tag_id=tca.tag_id) LEFT JOIN tag t ON (t.id=tca.tag_id) WHERE active=1 && td.pri=1 && (c.type=1) && (t.tag_type_id=1) GROUP BY td.id ORDER BY COUNT(c.id) DESC LIMIT 10;
0.14msSELECT td.tag_id,td.name,td.simple_name FROM content c LEFT JOIN tag_content_assoc tca ON (tca.content_id=c.id) LEFT JOIN tag_data td on (td.tag_id=tca.tag_id) LEFT JOIN tag t ON (t.id=tca.tag_id) WHERE active=1 && td.pri=1 && (c.type=1) && (t.tag_type_id=2) GROUP BY td.id ORDER BY COUNT(c.id) DESC LIMIT 10;
0.12msSELECT tag_id,name FROM tag_data WHERE simple_name='housing';
0.08msSELECT COUNT(DISTINCT(c.id)) as RTN FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=222) && (c.type=1);
0.1msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=222) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
18.66msSELECT id,filename,pri FROM content_image WHERE content_id=530
0.09msSELECT name as RTN FROM content_type WHERE id=1;
12.09msSELECT cd.content_data_type_id,data,ctdta.data_name,ctdta.content_processor FROM content_data cd LEFT JOIN content_type_data_type_assoc ctdta ON (ctdta.content_data_type_id=cd.content_data_type_id) WHERE content_id=530 && revision_id=3 && content_type_id=1;
0.1msSELECT filename,title FROM content_file WHERE content_id=530
0.1msSELECT td.tag_id,td.name,td.simple_name FROM tag_content_assoc cta LEFT JOIN tag_data td ON (td.tag_id=cta.tag_id) WHERE pri=1 && content_id=530
47.46msSELECT cc.id,cc.body,cc.timestamp,u.first_name,u.id as user_id FROM content_comment cc LEFT JOIN user u ON (u.id=cc.user_id) WHERE content_id=530