Available Property

Holesovice Brewery
Unique high standard residential project of a brewery conversion together with a new build construction in the outer centre of Prague
Location: Czech Republic, Prague
Dolni Brezany
Unique multifunctional project allowing high standard of living and full public facilities right in the middle of nature and within the reach of the city.
Location: Czech Republic, Prague
ÄŒimice Residence
Residence ÄŒimice offers 32 upmarket studios in a completely reconstructed 4 stories panel building built in the year 1986.
Location: Czech Republic, Prague
Page Execution: 118.82ms
Peak Memory: 2072 Kb (2.25 MB)

Debug Output


Executed 26 queries in 25.83ms
16.94msSELECT user_id,last_active FROM active_sessions WHERE session_id='cac4197fee90756d0225bc80ae54bfe4'
6.58msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('cac4197fee90756d0225bc80ae54bfe4','','38.103.63.60',UNIX_TIMESTAMP())
0.19msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('cac4197fee90756d0225bc80ae54bfe4','/property-for-sale/prague/',UNIX_TIMESTAMP());
0.13msSELECT * 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=3) && (t.tag_type_id=2) GROUP BY td.id ORDER BY COUNT(c.id) DESC LIMIT 10;
0.11msSELECT tag_id,name FROM tag_data WHERE simple_name='prague';
0.09msSELECT 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=212) && (c.type=3);
0.09msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=212) && (c.type=3) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=518
0.08msSELECT name as RTN FROM content_type WHERE id=3;
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=518 && revision_id=2 && content_type_id=3;
0.08msSELECT filename,title FROM content_file WHERE content_id=518
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=518
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=518
0.09msSELECT id,filename,pri FROM content_image WHERE content_id=517
0.08msSELECT name as RTN FROM content_type WHERE id=3;
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=517 && revision_id=2 && content_type_id=3;
0.09msSELECT filename,title FROM content_file WHERE content_id=517
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=517
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=517
0.08msSELECT id,filename,pri FROM content_image WHERE content_id=514
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=514 && revision_id=5 && content_type_id=3;
0.09msSELECT filename,title FROM content_file WHERE content_id=514
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=514
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=514