scheduler ran
ran: engine/scheduler/chat_cleanup.php
ran: engine/scheduler/online.php
ran: engine/scheduler/min_age.php
ran: engine/scheduler/newsletter.php
Query count: 54
SELECT iso_code FROM sn_langs WHERE abv='en' LIMIT 1
SHOW TABLES LIKE 'int_products'
SELECT 1 FROM int_products WHERE path='' AND product='webnetwork' AND enabled='1' LIMIT 1
SELECT theme FROM sn_themes WHERE active='1'
SELECT theme FROM sn_themes WHERE `default`='1'
SELECT id FROM sn_usersonline WHERE ip='38.107.179.229' AND login='guest'
UPDATE sn_usersonline SET timestamp=1337411286 WHERE ip ='38.107.179.229' AND login='guest'
DELETE FROM sn_usersonline WHERE timestamp<1337408786 AND login='guest'
SELECT DISTINCT ip FROM sn_usersonline WHERE (login ='guest') AND (timestamp>1337408786)
SELECT DISTINCT userid,login FROM sn_usersonline WHERE (login<>'guest') AND
(timestamp>1337408786)
SELECT id FROM sn_pages WHERE name = 'collaborators_top_collaborators.php'
DELETE FROM sn_room_members WHERE last_activity<'1337410986'
SELECT room_id FROM sn_rooms
DELETE FROM sn_chat_messages WHERE message_timestamp<'1337411286'
DELETE FROM sn_usersonline WHERE (timestamp < 1337410986)
SELECT u_max FROM sn_section_basic WHERE input_name='birth_year' LIMIT 1
UPDATE sn_section_basic SET u_min ='1932', u_max='1994' WHERE input_name='birth_year' LIMIT 1
UPDATE sn_section_basic SET u_min = '18' WHERE input_name = 'age' LIMIT 1
SELECT id FROM sn_newsletter_queue LIMIT 1
SELECT 1 FROM sn_zipcodes LIMIT 1
SELECT 1 FROM sn_rooms LIMIT 1
SHOW COLUMNS FROM sn_groups WHERE Field='phpbb_id'
SHOW COLUMNS FROM sn_members WHERE Field='last_webcam'
SELECT 1 FROM sn_translations LIMIT 1
DELETE FROM sn_feed_entries WHERE timestamp<'1332219600'
SELECT f.feed_id, f.type, f.user_id, f.for_id, f.item_id, f.timestamp, f.ext FROM sn_feed_entries AS f JOIN sn_members AS m ON f.user_id=m.id WHERE f.user_id>='0' OR (f.type='NFIFriends' AND f.for_id>='0') ORDER BY f.timestamp DESC LIMIT 50
SELECT `id`, `firstname`, `lastname`, `gender`, `username`, profile_type, profile_id FROM sn_members AS m WHERE m.id IN ('2') LIMIT 1
SELECT `_profile_name` FROM sn_profile_profile WHERE id=2
SELECT name_en FROM sn_sections WHERE section_name='basic' LIMIT 1
SELECT `id`, `firstname`, `lastname`, `gender`, `username`, profile_type, profile_id FROM sn_members AS m WHERE m.id IN ('2') LIMIT 1
SELECT `_profile_name` FROM sn_profile_profile WHERE id=2
SELECT name_en FROM sn_sections WHERE section_name='basic' LIMIT 1
SELECT `id`, `firstname`, `lastname`, `gender`, `username`, profile_type, profile_id FROM sn_members AS m WHERE m.id IN ('2') LIMIT 1
SELECT `_profile_name` FROM sn_profile_profile WHERE id=2
SELECT `id`, `firstname`, `lastname`, `gender`, `username`, profile_type, profile_id FROM sn_members AS m WHERE m.id IN ('1') LIMIT 1
SELECT `_profile_name` FROM sn_profile_profile WHERE id=1
SELECT id, name_en FROM sn_badwords
SELECT
DISTINCT v.id, v.title, v.image
FROM sn_videos AS v
LEFT JOIN sn_privacy_settings AS ps ON v.member_id=ps.member_id
LEFT JOIN sn_friends AS f ON f.member_id=v.member_id
WHERE (v.member_id='0' OR ps.content='0' OR ps.content IS NULL
OR (ps.content='1' AND v.member_id=f.member_id AND f.friend_id='0'))
AND v.visibility=1 AND v.approval!=1 AND v.status=1
ORDER BY v.timestamp DESC LIMIT 8
SELECT
DISTINCT p.id, p.title, p.photo_thumbnail_name
FROM sn_photos AS p
LEFT JOIN sn_friends AS f ON f.member_id=p.member_id
LEFT JOIN sn_privacy_settings AS ps ON p.member_id=ps.member_id
WHERE (p.member_id='0' OR ps.content='0' OR ps.content IS NULL
OR (ps.content='1' AND p.member_id=f.member_id AND f.friend_id='0'))
AND p.visibility=1 AND p.approval!=1 AND p.status=1
ORDER BY p.timestamp DESC LIMIT 4
SELECT
DISTINCT f.member_id, p.id, p._profile_name, f.photo_thumbnail_name
FROM
(sn_profile_profile AS p,
sn_photos AS f,
sn_members AS m)
LEFT JOIN sn_privacy_settings AS ps ON m.id=ps.member_id
WHERE
m.profile_id=p.id AND m.profile_type='profile'
AND f.profile_image='1' AND f.member_id=m.id AND (ps.profile='0' OR ps.profile IS NULL)
GROUP BY f.member_id ORDER BY m.join_date DESC LIMIT 4
SELECT label FROM sn_sub_menu_sections
SELECT use_submenu_from FROM sn_themes WHERE theme='clean_blue'
SELECT * FROM sn_sub_menus WHERE page='Home' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='People' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Film' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Music' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Blog' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Groups' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Events' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Videos' ORDER BY relative_order ASC
SELECT * FROM sn_sub_menus WHERE page='Photos' ORDER BY relative_order ASC
SELECT input_text, required FROM sn_form_fields WHERE page='index'
SELECT iso_code FROM sn_langs WHERE abv='en' LIMIT 1
SELECT name_en, type, filename, text_id FROM sn_translations WHERE type='webbox' AND filename='main'
Page generation took 0.224503994 seconds.