Available Property

Mosaic
Mosaic – 5% deposit & 20% discount in the next big thing Stateside
Location: USA, Houston
Page Execution: 556.93ms
Peak Memory: 2025 Kb (2 MB)

Debug Output


Executed 14 queries in 449.93ms
12.71msSELECT user_id,last_active FROM active_sessions WHERE session_id='86198c673f9124628db4554ac41737bf'
13.76msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('86198c673f9124628db4554ac41737bf','','38.103.63.60',UNIX_TIMESTAMP())
0.19msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('86198c673f9124628db4554ac41737bf','/property-for-sale/usa/',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=3) && (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';
214.53msSELECT 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=3);
174.14msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=182) && (c.type=3) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
0.19msSELECT id,filename,pri FROM content_image WHERE content_id=515
0.08msSELECT name as RTN FROM content_type WHERE id=3;
27.71msSELECT 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=515 && revision_id=2 && content_type_id=3;
3.48msSELECT filename,title FROM content_file WHERE content_id=515
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=515
2.66msSELECT 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=515