What Is The Best Diner In Schnecksville, PA?

Meta: What Is The Best Diner In Schnecksville, PA?, Results: #1. Schnecksville Diner, #2. whitehall diner; TalkFavorites.me

[0.00028085708618164] Connecting to MySQL server

[0.00052189826965332] SELECT * FROM countries ORDER BY country_name ASC

[0.0010590553283691] 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 = 'schnecksville' AND slug = 'what-is-the-best-diner-in-schnecksville' AND c.country_slug = 'pa'

[0.00033283233642578] 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 = 'schnecksville' AND slug = 'what-is-the-best-diner-in-schnecksville' AND c.country_slug = 'pa'

[8.0108642578125E-5] SELECT * FROM questions_location WHERE location_id = '10' AND question_id = '32' LIMIT 1

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

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

[0.0049540996551514] 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 ('10')) 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.0010459423065186] 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 ('10')) 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.00021195411682129] SELECT subject2_id FROM questions_subject_related WHERE subject1_id IN ('16')

[0.0080738067626953] 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.9163889 AND -75.3163889 AND l.latitude BETWEEN 40.3758333 AND 40.9758333

[0.0015408992767334] 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','9','10','20','4338','4340','4341','4342','4343','4344','4345','4346','4347','4348','4351','4352','4353','4354','4356','4357','4358','4359','4360','4361','4363','4364','4365','4366','4367','4375','4376','4380','4383','4388','4389','4390','4392','4394','4397','4411','4695','4696','4698','4699','4700','4710','4713','30409')) 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 ('16') AND `d`.`ql_id` <> '462') ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

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

[0.00048112869262695] 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.9163889 AND -75.3163889 AND l.latitude BETWEEN 40.3758333 AND 40.9758333

[0.002432107925415] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('7','9','20','4338','4340','4341','4342','4343','4345','4347','4348','4351','4352','4353','4354','4359','4360','4361','4363','4364','4365','4367','4375','4376','4380','4390','4394','4695','4696','4699','4700','4710','4713','30409') AND date_answered > '2013-05-13 14:54:21' GROUP BY location_id ORDER BY activity DESC LIMIT 5

[0.00030994415283203] 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.00031614303588867] 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 = '30409'

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

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

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

getting prod_location_what-is-the-best-diner-in-schnecksville,schnecksville,pa (apc)

getting prod_location_schnecksville,pa,united-states (apc)

getting prod_location_10 (apc)

getting prod_question_what-is-the-best-diner (apc)

getting prod_question_32 (apc)

getting prod_responses_32_10 (apc)

setting prod_responses_32_10 (apc)

setting prod_responses_32_10 (apc)

getting prod_questions_starter_10, prod_questions_trending_10, prod_questions_newest_10 (apc)

getting prod_questions_trending_10 (apc)

setting prod_questions_trending_10 (apc)

getting prod_questions_newest_10 (apc)

setting prod_questions_newest_10 (apc)

getting prod_subject_related_16 (apc)

setting prod_subject_related_16 (apc)

getting prod_location_20, prod_location_9, prod_location_7 (apc)

getting prod_top5_users_10 (apc)

setting prod_top5_users_10 (apc)

getting prod_location_closest_10 (apc)

setting prod_location_closest_10 (apc)

getting prod_location_4365, prod_location_30409, prod_location_4354, prod_location_4376, prod_location_4359 (apc)

getting prod_location_4365 (apc)

setting prod_location_orefield,pa,united-states (apc)

setting prod_location_4365 (apc)

getting prod_location_30409 (apc)

setting prod_location_slatington,pa,united-states (apc)

setting prod_location_30409 (apc)

getting prod_location_4354 (apc)

setting prod_location_germansville,pa,united-states (apc)

setting prod_location_4354 (apc)

getting prod_location_4376 (apc)

setting prod_location_walnutport,pa,united-states (apc)

setting prod_location_4376 (apc)

getting prod_location_4359 (apc)

setting prod_location_laurys-station,pa,united-states (apc)

setting prod_location_4359 (apc)