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

Rent to Home Buy scheme unveiled

16 Jul 2008 4:50pm

The government has announced plans for "a rent now, buy later" scheme in a bid to ease the burden of first time buyers and stimulate the flagging property market.
Tags: United Kingdom, Auctions, California, Houston, Bear Stearns

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

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
Pages 1
Page Execution: 188.81ms
Peak Memory: 3174 Kb (3.25 MB)

Debug Output


Executed 33 queries in 40.53ms
32.07msSELECT user_id,last_active FROM active_sessions WHERE session_id='648a100c17ec58bf169fd0670e73adf2'
0.24msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('648a100c17ec58bf169fd0670e73adf2','','38.103.63.60',UNIX_TIMESTAMP())
0.13msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('648a100c17ec58bf169fd0670e73adf2','/news/california/',UNIX_TIMESTAMP());
0.13msSELECT * FROM top_navigation ORDER BY list_order;
0.13msSELECT 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.1msSELECT 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;
4.42msSELECT tag_id,name FROM tag_data WHERE simple_name='california';
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=209) && (c.type=1);
0.09msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=209) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
0.08msSELECT id,filename,pri FROM content_image WHERE content_id=530
0.07msSELECT 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=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
0.78msSELECT 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.12msSELECT id,filename,pri FROM content_image WHERE content_id=661
0.07msSELECT 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=661 && revision_id=1 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=661
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=661
0.5msSELECT 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=661
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=509
0.07msSELECT 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=509 && revision_id=4 && content_type_id=1;
0.08msSELECT 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
0.08msSELECT 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.08msSELECT id,filename,pri FROM content_image WHERE content_id=548
0.07msSELECT 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=548 && revision_id=3 && content_type_id=1;
0.08msSELECT filename,title FROM content_file WHERE content_id=548
0.07msSELECT 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
0.08msSELECT 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