What locals are saying about what's best in San Francisco, CA

Meta: What locals are saying about what's best in San Francisco, CA

[0.00035500526428223] Connecting to MySQL server

[0.00054693222045898] SELECT * FROM countries ORDER BY country_name ASC

[0.0017721652984619] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`username` , `g`.`last_name` , `g`.`first_name` FROM `questions` AS `a` LEFT JOIN `questions_subject` AS `b` ON (`b`.`qs_id` = `a`.`subject_id`) LEFT JOIN `questions_prefix` AS `c` ON (`c`.`qp_id` = `a`.`prefix_id`) LEFT JOIN `questions_location` AS `d` ON (`d`.`question_id` = `a`.`question_id` AND `d`.`location_id` IN ('22675')) LEFT JOIN `locations` AS `e` ON (`e`.`location_id` = `d`.`location_id`) LEFT JOIN `states` AS `f` ON (`f`.`state_id` = `e`.`state_id`) LEFT JOIN `users` AS `g` ON (`g`.`user_id` = `d`.`user_id`) LEFT JOIN `responses` AS `h` ON (`h`.`question_id` = `d`.`question_id` AND `h`.`location_id` = `d`.`location_id`) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NOT NULL AND (`f`.`country_id` IN ('1') OR `d`.`ql_id` IS NULL )) GROUP BY `a`.`question_id` ORDER BY `d`.`answers` DESC LIMIT 0, 10

[0.098449945449829] SELECT r.text, r.text_slug, r.total, p.comments, p.place_id, r.question_id, r.location_id FROM responses_summary r LEFT JOIN places p ON p.location_id = r.location_id AND p.place_slug = r.text_slug WHERE r.question_id = '3' AND r.location_id = '22675' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00078582763671875] SELECT r.text, r.text_slug, r.total, p.comments, p.place_id, r.question_id, r.location_id FROM responses_summary r LEFT JOIN places p ON p.location_id = r.location_id AND p.place_slug = r.text_slug WHERE r.question_id = '99' AND r.location_id = '22675' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00053787231445312] SELECT r.text, r.text_slug, r.total, p.comments, p.place_id, r.question_id, r.location_id FROM responses_summary r LEFT JOIN places p ON p.location_id = r.location_id AND p.place_slug = r.text_slug WHERE r.question_id = '58' AND r.location_id = '22675' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00042009353637695] SELECT r.text, r.text_slug, r.total, p.comments, p.place_id, r.question_id, r.location_id FROM responses_summary r LEFT JOIN places p ON p.location_id = r.location_id AND p.place_slug = r.text_slug WHERE r.question_id = '127' AND r.location_id = '22675' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00046706199645996] SELECT r.text, r.text_slug, r.total, p.comments, p.place_id, r.question_id, r.location_id FROM responses_summary r LEFT JOIN places p ON p.location_id = r.location_id AND p.place_slug = r.text_slug WHERE r.question_id = '5' AND r.location_id = '22675' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.0010759830474854] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`username` , `g`.`last_name` , `g`.`first_name` FROM `questions` AS `a` LEFT JOIN `questions_subject` AS `b` ON (`b`.`qs_id` = `a`.`subject_id`) LEFT JOIN `questions_prefix` AS `c` ON (`c`.`qp_id` = `a`.`prefix_id`) LEFT JOIN `questions_location` AS `d` ON (`d`.`question_id` = `a`.`question_id` AND `d`.`location_id` IN ('22675')) LEFT JOIN `locations` AS `e` ON (`e`.`location_id` = `d`.`location_id`) LEFT JOIN `states` AS `f` ON (`f`.`state_id` = `e`.`state_id`) LEFT JOIN `users` AS `g` ON (`g`.`user_id` = `d`.`user_id`) LEFT JOIN `responses` AS `h` ON (`h`.`question_id` = `d`.`question_id` AND `h`.`location_id` = `d`.`location_id`) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NOT NULL AND (`f`.`country_id` IN ('1') OR `d`.`ql_id` IS NULL )) GROUP BY `a`.`question_id` ORDER BY `d`.`answers` DESC LIMIT 0, 6

[0.00094103813171387] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`username` , `g`.`last_name` , `g`.`first_name` FROM `questions` AS `a` LEFT JOIN `questions_subject` AS `b` ON (`b`.`qs_id` = `a`.`subject_id`) LEFT JOIN `questions_prefix` AS `c` ON (`c`.`qp_id` = `a`.`prefix_id`) LEFT JOIN `questions_location` AS `d` ON (`d`.`question_id` = `a`.`question_id` AND `d`.`location_id` IN ('22675')) LEFT JOIN `locations` AS `e` ON (`e`.`location_id` = `d`.`location_id`) LEFT JOIN `states` AS `f` ON (`f`.`state_id` = `e`.`state_id`) LEFT JOIN `users` AS `g` ON (`g`.`user_id` = `d`.`user_id`) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NOT NULL AND (`f`.`country_id` IN ('1') OR `d`.`ql_id` IS NULL )) ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

[0.0057239532470703] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE l.status IN ('new','pending','validated') AND l.longitude BETWEEN -122.72267213 AND -122.12267213 AND l.latitude BETWEEN 37.47153279 AND 38.07153279

[0.0018329620361328] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` FROM `questions` AS `a` LEFT JOIN `questions_subject` AS `b` ON (`b`.`qs_id` = `a`.`subject_id`) LEFT JOIN `questions_prefix` AS `c` ON (`c`.`qp_id` = `a`.`prefix_id`) LEFT JOIN `questions_location` AS `d` ON (`d`.`question_id` = `a`.`question_id` AND `d`.`location_id` IN ('22653','22654','22655','22664','22665','22666','22668','22671','22673','22679','22680','22698','22703','22708','22712','22713','22723','22724','22732','22733','22734','22735','22736','22737','22738','22739','22740','22741','22742','22746','22750','22753','22755','22762','22763','22765','22766','22767')) LEFT JOIN `locations` AS `e` ON (`e`.`location_id` = `d`.`location_id`) LEFT JOIN `states` AS `f` ON (`f`.`state_id` = `e`.`state_id`) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NOT NULL AND (`f`.`country_id` IN ('1') OR `d`.`ql_id` IS NULL )) ORDER BY `d`.`ql_id` DESC , RAND() LIMIT 0, 6

[0.00049495697021484] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22698'

[0.00034308433532715] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22732'

[0.00069999694824219] SELECT user_id, username, first_name, last_name, profile_pic, questions, answers FROM users WHERE default_location IN ('22675') AND answers > 0 ORDER BY answers DESC LIMIT 0, 5

[0.00064396858215332] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE l.status IN ('new','pending','validated') AND l.longitude BETWEEN -122.72267213 AND -122.12267213 AND l.latitude BETWEEN 37.47153279 AND 38.07153279

[0.0016279220581055] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('22653','22654','22655','22664','22665','22666','22668','22671','22673','22679','22680','22698','22708','22712','22723','22732','22733','22734','22735','22736','22737','22738','22739','22740','22741','22742','22746','22753','22755','22762','22763','22765','22766','22767') AND date_answered > '2013-05-13 02:24:23' GROUP BY location_id ORDER BY activity DESC LIMIT 5

[0.00031185150146484] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22655'

[0.00031304359436035] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22653'

[0.00030303001403809] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22766'

[0.00029897689819336] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22673'

[0.00029397010803223] SELECT * FROM locations l LEFT JOIN states s ON s.state_id = l.state_id LEFT JOIN countries c ON c.country_id = s.country_id WHERE location_id = '22742'

getting prod_location_san-francisco,ca,united-states (apc)

getting prod_location_22675 (apc)

getting prod_questions_starter_22675, prod_questions_trending_22675, prod_questions_newest_22675 (apc)

getting prod_questions_trending_22675 (apc)

setting prod_questions_trending_22675 (apc)

getting prod_questions_newest_22675 (apc)

setting prod_questions_newest_22675 (apc)

getting prod_location_22698, prod_location_22732 (apc)

getting prod_location_22698 (apc)

setting prod_location_el-cerrito,ca,united-states (apc)

setting prod_location_22698 (apc)

getting prod_location_22732 (apc)

setting prod_location_oakland,ca,united-states (apc)

setting prod_location_22732 (apc)

getting prod_top5_users_22675 (apc)

setting prod_top5_users_22675 (apc)

getting prod_location_closest_22675 (apc)

setting prod_location_closest_22675 (apc)

getting prod_location_22655, prod_location_22653, prod_location_22766, prod_location_22673, prod_location_22742 (apc)

getting prod_location_22655 (apc)

setting prod_location_daly-city,ca,united-states (apc)

setting prod_location_22655 (apc)

getting prod_location_22653 (apc)

setting prod_location_brisbane,ca,united-states (apc)

setting prod_location_22653 (apc)

getting prod_location_22766 (apc)

setting prod_location_sausalito,ca,united-states (apc)

setting prod_location_22766 (apc)

getting prod_location_22673 (apc)

setting prod_location_south-san-francisco,ca,united-states (apc)

setting prod_location_22673 (apc)

getting prod_location_22742 (apc)

setting prod_location_belvedere-tiburon,ca,united-states (apc)

setting prod_location_22742 (apc)