Meta: China House II in Lehigh Valley, PA was Answered in the Following Questions

[0.00027203559875488] Connecting to MySQL server

[0.00045394897460938] SELECT * FROM countries ORDER BY country_name ASC

[0.00043010711669922] 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 = 'lehigh-valley' AND slug = 'china-house-ii' AND c.country_slug = 'pa'

[0.00034594535827637] 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_name = 'lehigh-valley' AND slug = 'china-house-ii' AND c.country_slug = 'pa'

[0.00059819221496582] 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 = 'lehigh-valley' AND c.country_slug = 'united-states'

[0.00093412399291992] SELECT `a`.* , `b`.`subject` , `c`.`prefix` 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`) WHERE (`a`.`question_slug` IN ('china-house-ii') OR `a`.`response_slug` IN ('china-house-ii'))

[0.00049877166748047] SELECT * FROM places WHERE location_id = '1' AND place_slug = 'china-house-ii' LIMIT 1

[0.0083658695220947] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`total` , `h`.`comment_id` , `h`.`comment_text` 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 ('1')) 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 `responses_summary` AS `g` ON (`g`.`question_id` = `a`.`question_id` AND `g`.`location_id` = `d`.`location_id`) LEFT JOIN `comments` AS `h` ON (`h`.`question_id` = `a`.`question_id` AND `h`.`user_id` IN ('0') AND `h`.`place_id` IN ('535')) 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 ) AND `g`.`text_slug` IN ('china-house-ii') AND `g`.`total` > '0')

[0.0033040046691895] 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 ('1')) 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.00067400932312012] 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 ('1')) 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.00036907196044922] SELECT subject2_id FROM questions_subject_related WHERE subject1_id IN ('2','14','18')

[0.0060310363769531] 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.5479061 AND -74.9479061 AND l.latitude BETWEEN 40.4291847 AND 41.0291847

[0.0038208961486816] 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 ('7','8','9','20','1744','1766','1774','1986','1987','1998','2000','2012','2021','2022','2032','4339','4340','4343','4344','4345','4346','4347','4348','4349','4351','4353','4356','4358','4359','4360','4362','4364','4368','4372','4373','4374','4377','4403','4406','4408','4409','4411','4417','4421','4423','4424','4426','4556','4562','4568','4574','4583')) 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 ) AND `a`.`subject_id` IN ('2','14','18')) ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

[0.0043299198150635] 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 = '4346'

[0.00049304962158203] 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 = '4362'

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

[0.0011279582977295] 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.5479061 AND -74.9479061 AND l.latitude BETWEEN 40.4291847 AND 41.0291847

[0.0035018920898438] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('7','8','9','1744','1766','1774','1986','1987','2012','2021','2032','4339','4340','4343','4345','4347','4348','4349','4353','4356','4358','4359','4362','4364','4368','4372','4373','4374','4377','4417','4423','4424','4562','4583') AND date_answered > '2013-05-11 01:25:28' GROUP BY location_id ORDER BY activity DESC LIMIT 5

getting prod_location_china-house-ii,lehigh-valley,pa (apc)

getting prod_location_lehigh-valley,pa,united-states (apc)

setting prod_location_lehigh-valley,pa,united-states (apc)

setting prod_location_1 (apc)

getting prod_question_china-house-ii (apc)

getting prod_questions_starter_1, prod_questions_trending_1, prod_questions_newest_1 (apc)

getting prod_questions_trending_1 (apc)

setting prod_questions_trending_1 (apc)

getting prod_questions_newest_1 (apc)

setting prod_questions_newest_1 (apc)

getting prod_location_4346, prod_location_4362, prod_location_20, prod_location_8, prod_location_9, prod_location_7 (apc)

getting prod_location_4346 (apc)

setting prod_location_coopersburg,pa,united-states (apc)

setting prod_location_4346 (apc)

getting prod_location_4362 (apc)

setting prod_location_nazareth,pa,united-states (apc)

setting prod_location_4362 (apc)

getting prod_top5_users_1 (apc)

setting prod_top5_users_1 (apc)

getting prod_location_closest_1 (apc)

setting prod_location_closest_1 (apc)

getting prod_location_4374, prod_location_4373, prod_location_2021 (apc)