Available Property

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

Debug Output


Executed 14 queries in 145.03ms
34.01msSELECT user_id,last_active FROM active_sessions WHERE session_id='4fceb25754e3a4a70f81d1224ad7a679'
6.85msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('4fceb25754e3a4a70f81d1224ad7a679','','38.103.63.60',UNIX_TIMESTAMP())
0.25msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('4fceb25754e3a4a70f81d1224ad7a679','/property-for-sale/houston/',UNIX_TIMESTAMP());
0.17msSELECT * FROM top_navigation ORDER BY list_order;
0.16msSELECT 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;
70.83msSELECT tag_id,name FROM tag_data WHERE simple_name='houston';
1.3msSELECT 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=217) && (c.type=3);
30.81msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=217) && (c.type=3) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
0.21msSELECT id,filename,pri FROM content_image WHERE content_id=515
0.08msSELECT name as RTN FROM content_type WHERE id=3;
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=515 && revision_id=2 && content_type_id=3;
0.08msSELECT 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
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=515