What Is The Best Place To Buy Lunch In Coopersburg, PA?

Meta: What Is The Best Place To Buy Lunch In Coopersburg, PA?, Results: #1. good earth grains and creamery; TalkFavorites.me

[0.0036211013793945] Connecting to MySQL server

[0.0038580894470215] SELECT * FROM countries ORDER BY country_name ASC

[0.00043702125549316] 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 = 'coopersburg' AND slug = 'what-is-the-best-place-to-buy-lunch-in-coopersburg' AND c.country_slug = 'pa'

[0.00039887428283691] 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 = 'coopersburg' AND slug = 'what-is-the-best-place-to-buy-lunch-in-coopersburg' AND c.country_slug = 'pa'

[8.2015991210938E-5] SELECT * FROM questions_location WHERE location_id = '4346' AND question_id = '3' LIMIT 1

[0.0013940334320068] 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 = '4346' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,11

[0.00012111663818359] 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 = '4346' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,11

[0.0015120506286621] 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 ('4346')) 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.00078892707824707] 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 ('4346')) 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.0081160068511963] 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 ('4346')) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NULL )

[0.00037002563476562] SELECT subject2_id FROM questions_subject_related WHERE subject1_id IN ('2')

[0.011492967605591] 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.690458 AND -75.090458 AND l.latitude BETWEEN 40.2114885 AND 40.8114885

[0.0036890506744385] 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 ('1','7','8','9','10','20','2012','2021','4338','4340','4342','4343','4344','4345','4346','4347','4349','4350','4351','4352','4353','4355','4356','4357','4359','4360','4361','4362','4364','4365','4366','4369','4370','4371','4372','4373','4374','4375','4550','4553','4554','4555','4557','4558','4560','4562','4563','4568','4569','4570','4571','4572','4574','4576','4577','4578','4580','4581','4582','4583','4664','4665','4666','4674','4677','4680','4682','4683','4684','4689','4693','4699','4700')) 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') AND `d`.`ql_id` <> '1874') ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

[0.00041079521179199] 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 = '4365'

[0.00013518333435059] 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 = '20'

[0.00011897087097168] 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 = '10'

[0.00011706352233887] 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 = '9'

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

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

[0.0012860298156738] SELECT user_id, username, first_name, last_name, profile_pic, questions, answers FROM users WHERE default_location IN ('7','9','20','4344','4346','4350','4351','4356','4357','4360','4361','4366','4572','4574','4582') AND answers > 0 ORDER BY answers DESC LIMIT 0, 5

[0.0016210079193115] 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.690458 AND -75.090458 AND l.latitude BETWEEN 40.2114885 AND 40.8114885

[0.0014429092407227] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('7','9','20','4338','4342','4343','4344','4347','4349','4350','4351','4353','4355','4356','4357','4360','4361','4364','4365','4366','4369','4371','4372','4375','4550','4562','4568','4569','4572','4574','4577','4578','4582','4682') AND date_answered > '2013-05-14 22:49:00' GROUP BY location_id ORDER BY activity DESC LIMIT 5

[0.00028491020202637] 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 = '4344'

[0.00051999092102051] 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 = '4360'

[0.00030708312988281] 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 = '4574'

[0.00031781196594238] 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 = '4356'

getting prod_location_what-is-the-best-place-to-buy-lunch-in-coopersburg,coopersburg,pa (apc)

getting prod_location_coopersburg,pa,united-states (apc)

getting prod_location_4346 (apc)

getting prod_question_what-is-the-best-place-to-buy-lunch (apc)

getting prod_question_3 (apc)

getting prod_responses_3_4346 (apc)

setting prod_responses_3_4346 (apc)

setting prod_responses_3_4346 (apc)

getting prod_questions_starter_4346, prod_questions_trending_4346, prod_questions_newest_4346 (apc)

getting prod_questions_trending_4346 (apc)

setting prod_questions_trending_4346 (apc)

getting prod_questions_newest_4346 (apc)

setting prod_questions_newest_4346 (apc)

setting prod_questions_starter_4346 (apc)

getting prod_subject_related_2 (apc)

setting prod_subject_related_2 (apc)

getting prod_location_4365, prod_location_20, prod_location_10, prod_location_9, prod_location_8, prod_location_7 (apc)

getting prod_location_4365 (apc)

setting prod_location_orefield,pa,united-states (apc)

setting prod_location_4365 (apc)

getting prod_location_20 (apc)

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

setting prod_location_20 (apc)

getting prod_location_10 (apc)

setting prod_location_schnecksville,pa,united-states (apc)

setting prod_location_10 (apc)

getting prod_location_9 (apc)

setting prod_location_bethlehem,pa,united-states (apc)

setting prod_location_9 (apc)

getting prod_location_7 (apc)

setting prod_location_allentown,pa,united-states (apc)

setting prod_location_7 (apc)

getting prod_top5_users_4346 (apc)

setting prod_top5_users_4346 (apc)

getting prod_location_closest_4346 (apc)

setting prod_location_closest_4346 (apc)

getting prod_location_4344, prod_location_4360, prod_location_4574, prod_location_4356 (apc)

getting prod_location_4344 (apc)

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

setting prod_location_4344 (apc)

getting prod_location_4360 (apc)

setting prod_location_limeport,pa,united-states (apc)

setting prod_location_4360 (apc)

getting prod_location_4574 (apc)

setting prod_location_richlandtown,pa,united-states (apc)

setting prod_location_4574 (apc)

getting prod_location_4356 (apc)

setting prod_location_hellertown,pa,united-states (apc)

setting prod_location_4356 (apc)