Page Execution: 219.23ms
Peak Memory: 2654 Kb (2.75 MB)

Debug Output


Executed 15 queries in 107.18ms
94.24msSELECT user_id,last_active FROM active_sessions WHERE session_id='cb84ec5a8c9f3f78292280aa9bc342b0'
10.42msINSERT INTO active_sessions (session_id,user_id,ip_address,last_active) VALUES ('cb84ec5a8c9f3f78292280aa9bc342b0','','38.103.63.60',UNIX_TIMESTAMP())
0.19msINSERT INTO active_session_pages (session_id,uri,timestamp) VALUES ('cb84ec5a8c9f3f78292280aa9bc342b0','/news/sun-investments/',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.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=2) GROUP BY td.id ORDER BY COUNT(c.id) DESC LIMIT 10;
0.11msSELECT tag_id,name FROM tag_data WHERE simple_name='sun investments';
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=220) && (c.type=1);
0.16msSELECT * FROM content c LEFT JOIN tag_content_assoc cta ON (c.id=cta.content_id) WHERE active=1 && (cta.tag_id=220) && (c.type=1) GROUP BY c.id ORDER BY timestamp DESC LIMIT 0,10;
0.13msSELECT id,filename,pri FROM content_image WHERE content_id=528
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=528 && revision_id=3 && content_type_id=1;
0.09msSELECT filename,title FROM content_file WHERE content_id=528
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=528
1.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=528