What locals are saying about what's best in Westtown, PA

Meta: What locals are saying about what's best in Westtown, PA

[0.00024795532226562] Connecting to MySQL server

[0.00049901008605957] SELECT * FROM countries ORDER BY country_name ASC

[0.00091886520385742] 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 state = 'pa' AND slug = 'westtown' AND c.country_slug = 'united-states'

[0.0013749599456787] 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 ('4655')) 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.0012681484222412] 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 = '97' AND r.location_id = '4655' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00044107437133789] 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 = '83' AND r.location_id = '4655' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00076079368591309] 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 = '134' AND r.location_id = '4655' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00081014633178711] 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 ('4655')) 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.00066304206848145] 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 ('4655')) 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.0050108432769775] 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 ('4655')) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NULL )

[0.0050249099731445] 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 -75.852222 AND -75.252222 AND l.latitude BETWEEN 39.630833 AND 40.230833

[0.0047328472137451] 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 ('2','1812','1820','1848','1850','1862','4587','4588','4590','4592','4593','4594','4595','4597','4598','4602','4603','4605','4607','4610','4612','4613','4615','4616','4617','4619','4620','4621','4622','4623','4624','4625','4626','4628','4630','4631','4632','4633','4634','4636','4637','4638','4639','4640','4643','4644','4645','4650','4651','4652','4653','4654','4656','4657','4658','4659','4660','4662','4663','4669','4671','4676','4678','4717','4719','4722','4725','4726','4727','25735','25737','25738','33589','33590','33595')) 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.00016593933105469] 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 = '33595'

[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 = '2'

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

[0.00095391273498535] 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 -75.852222 AND -75.252222 AND l.latitude BETWEEN 39.630833 AND 40.230833

[0.0027480125427246] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('2','4588','4592','4593','4594','4612','4613','4615','4616','4622','4624','4626','4628','4630','4632','4633','4634','4636','4637','4638','4639','4640','4643','4650','4651','4652','4662','4678','4717','4725','4726','25735','25737','25738') AND date_answered > '2013-05-11 20:32:56' GROUP BY location_id ORDER BY activity DESC LIMIT 5

[9.5129013061523E-5] 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 = '4634'

[0.00050497055053711] 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 = '4652'

[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 = '4640'

[0.00030207633972168] 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 = '4638'

getting prod_location_westtown,pa,united-states (apc)

setting prod_location_westtown,pa,united-states (apc)

setting prod_location_4655 (apc)

getting prod_questions_starter_4655, prod_questions_trending_4655, prod_questions_newest_4655 (apc)

getting prod_questions_trending_4655 (apc)

setting prod_questions_trending_4655 (apc)

getting prod_questions_newest_4655 (apc)

setting prod_questions_newest_4655 (apc)

setting prod_questions_starter_4655 (apc)

getting prod_location_33595, prod_location_2 (apc)

getting prod_location_33595 (apc)

setting prod_location_conshohocken,pa,united-states (apc)

setting prod_location_33595 (apc)

getting prod_location_2 (apc)

setting prod_location_west-chester,pa,united-states (apc)

setting prod_location_2 (apc)

getting prod_top5_users_4655 (apc)

setting prod_top5_users_4655 (apc)

getting prod_location_closest_4655 (apc)

setting prod_location_closest_4655 (apc)

getting prod_location_4634, prod_location_4652, prod_location_4640, prod_location_4638 (apc)

getting prod_location_4634 (apc)

setting prod_location_cheyney,pa,united-states (apc)

setting prod_location_4634 (apc)

getting prod_location_4652 (apc)

setting prod_location_thornton,pa,united-states (apc)

setting prod_location_4652 (apc)

getting prod_location_4640 (apc)

setting prod_location_glen-mills,pa,united-states (apc)

setting prod_location_4640 (apc)

getting prod_location_4638 (apc)

setting prod_location_concordville,pa,united-states (apc)

setting prod_location_4638 (apc)