News

Pages 1 | 2

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

Rates on 30-year mortgages dip to 5.85%

27 Jul 2008 9:19pm

Rates on 30-year mortgages edged down slightly this week, staying below 6%, although rates on other types of mortgages rose.
Tags: Mortgages, USA, Bear Stearns

Home builders' confidence mired near record low

19 Mar 2008 7:39pm

A reading of U.S. home builders' sentiment was stuck near its lowest level in March
Tags: Development, USA

Fannie, Freddie free to pump billions into mortgage market

19 Mar 2008 7:37pm

WASHINGTON — The government has freed up billions of dollars at Fannie Mae
Tags: Mortgages, USA

Red flags in Bear Stearns' collapse

18 Mar 2008 1:38pm

If the U.S. economy were a car, all of its warning lights would be flashing red.
Tags: USA, Sub Prime Mortgages, Credit, Economy

Where To Find Million-Dollar Foreclosures

18 Mar 2008 1:10pm

In Detroit and Southern California, foreclosure opportunists are going after cheap homes in downtrodden neighborhoods, which are selling in the five-figure range.
Tags: USA, Foreclosures, California, Detroit

US in housing starts 'surprise'

08 Mar 2008 3:35pm

Annual housing starts in the US have increased in spite of the ongoing subprime crisis...
Tags: USA, Sub Prime Mortgages

Homes Of The Billionaires

05 Mar 2008 1:15pm

The world's richest man lives in the same five-bedroom, gray stucco house he bought in 1958 for $31,500.
Tags: USA, Investors

Top Suburbs To Live Well

08 Jan 2008 8:53pm

Atop the Oakland Hills, boasts good schools, plenty of parks, and safe streets where the local kids gather.
Tags: USA, California

Florida lures property investors

27 Jun 2007 9:16am

Good potential for high rental returns is luring British property investors to Florida in the USA, according to one industry observer.
Tags: Property Investment, USA
Pages 1 | 2
Page Execution: 323.32ms
Peak Memory: 3588 Kb (3.75 MB)

Debug Output


Executed 69 queries in 112.56ms
0.42msSELECT user_id,last_active FROM active_sessions WHERE session_id='e924299fb2fa5550c98788a0bddd203e'
11.22msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('e924299fb2fa5550c98788a0bddd203e','','38.103.63.60',UNIX_TIMESTAMP())
0.18msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('e924299fb2fa5550c98788a0bddd203e','/news/usa/',UNIX_TIMESTAMP());
0.15msSELECT * FROM top_navigation ORDER BY list_order;
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=1) GROUP BY td.id ORDER BY COUNT(c.id) DESC LIMIT 10;
0.11msSELECT 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.1msSELECT tag_id,name FROM tag_data WHERE simple_name='usa';
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=182) && (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=182) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=530
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.1msSELECT 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.08msSELECT filename,title FROM content_file WHERE content_id=530
0.09msSELECT 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
40.3msSELECT 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
0.15msSELECT id,filename,pri FROM content_image WHERE content_id=549
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.1msSELECT 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=549 && revision_id=3 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=549
0.09msSELECT 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=549
1.1msSELECT 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=549
0.13msSELECT id,filename,pri FROM content_image WHERE content_id=524
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.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=524 && revision_id=3 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=524
0.08msSELECT 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=524
2.82msSELECT 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=524
0.1msSELECT id,filename,pri FROM content_image WHERE content_id=523
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.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=523 && revision_id=3 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=523
0.08msSELECT 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=523
2.61msSELECT 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=523
0.11msSELECT id,filename,pri FROM content_image WHERE content_id=512
0.08msSELECT name as RTN FROM content_type WHERE id=1;
12.96msSELECT 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=512 && revision_id=3 && content_type_id=1;
0.09msSELECT filename,title FROM content_file WHERE content_id=512
0.08msSELECT 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=512
2.65msSELECT 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=512
0.1msSELECT id,filename,pri FROM content_image WHERE content_id=509
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.1msSELECT 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=509 && revision_id=4 && content_type_id=1;
0.09msSELECT filename,title FROM content_file WHERE content_id=509
0.08msSELECT 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=509
2.61msSELECT 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=509
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=529
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.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=529 && revision_id=3 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=529
0.08msSELECT 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=529
2.62msSELECT 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=529
0.1msSELECT id,filename,pri FROM content_image WHERE content_id=510
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.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=510 && revision_id=6 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=510
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=510
7.07msSELECT 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=510
0.11msSELECT id,filename,pri FROM content_image WHERE content_id=548
0.08msSELECT name as RTN FROM content_type WHERE id=1;
8.79msSELECT 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=548 && revision_id=3 && content_type_id=1;
0.09msSELECT filename,title FROM content_file WHERE content_id=548
0.08msSELECT 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=548
9.17msSELECT 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=548
0.12msSELECT id,filename,pri FROM content_image WHERE content_id=159
0.08msSELECT name as RTN FROM content_type WHERE id=1;
0.49msSELECT 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=159 && revision_id=1 && content_type_id=1;
0.09msSELECT filename,title FROM content_file WHERE content_id=159
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=159
2.61msSELECT 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=159