Where Is The Best Breakfast Place In Kennett Square, PA?

Meta: Where Is The Best Breakfast Place In Kennett Square, PA?, Results: #1. Sunrise Cafe; TalkFavorites.me

[0.00028204917907715] Connecting to MySQL server

[0.00055313110351562] SELECT * FROM countries ORDER BY country_name ASC

[0.00053596496582031] 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 = 'kennett-square' AND slug = 'where-is-the-best-breakfast-place-in-kennett-square' AND c.country_slug = 'pa'

[0.00037002563476562] 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 = 'kennett-square' AND slug = 'where-is-the-best-breakfast-place-in-kennett-square' AND c.country_slug = 'pa'

[8.7976455688477E-5] SELECT * FROM questions_location WHERE location_id = '4643' AND question_id = '127' LIMIT 1

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

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

[0.0001678466796875] 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 ('4643')) 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.00014686584472656] 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 ('4643')) 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.00039196014404297] 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 ('4643')) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NULL )

[0.00024700164794922] SELECT subject2_id FROM questions_subject_related WHERE subject1_id IN ('109')

[0.00084590911865234] 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 -76.0116032 AND -75.4116032 AND l.latitude BETWEEN 39.5467767 AND 40.1467767

[0.0022931098937988] 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','1848','1850','1851','4594','4630','4631','4633','4634','4635','4637','4638','4639','4640','4643','4644','4645','4646','4648','4649','4650','4651','4652','4653','4654','4655','4662','4716','4717','4719','4721','4722','4725','4726','4727','5145','25735','25737','25738','33589','33590')) 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 ('109') AND `d`.`ql_id` <> '1482') ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

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

[0.00077605247497559] 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 -76.0116032 AND -75.4116032 AND l.latitude BETWEEN 39.5467767 AND 40.1467767

[0.0026159286499023] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('2','1848','1850','4594','4631','4633','4634','4635','4637','4638','4639','4640','4644','4645','4646','4648','4649','4650','4651','4652','4653','4654','4655','4716','4717','4719','4721','4722','4725','4726','4727','25737','33589','33590') AND date_answered > '2013-05-13 03:46:46' GROUP BY location_id ORDER BY activity DESC LIMIT 5

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

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

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

[9.8943710327148E-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 = '4719'

getting prod_location_where-is-the-best-breakfast-place-in-kennett-square,kennett-square,pa (apc)

getting prod_location_kennett-square,pa,united-states (apc)

getting prod_location_4643 (apc)

getting prod_question_where-is-the-best-breakfast-place (apc)

getting prod_question_127 (apc)

getting prod_responses_127_4643 (apc)

setting prod_responses_127_4643 (apc)

setting prod_responses_127_4643 (apc)

getting prod_questions_starter_4643, prod_questions_trending_4643, prod_questions_newest_4643 (apc)

getting prod_questions_trending_4643 (apc)

setting prod_questions_trending_4643 (apc)

getting prod_questions_newest_4643 (apc)

setting prod_questions_newest_4643 (apc)

setting prod_questions_starter_4643 (apc)

getting prod_subject_related_109 (apc)

setting prod_subject_related_109 (apc)

getting prod_location_2 (apc)

getting prod_top5_users_4643 (apc)

setting prod_top5_users_4643 (apc)

getting prod_location_closest_4643 (apc)

setting prod_location_closest_4643 (apc)

getting prod_location_4653, prod_location_4726, prod_location_4631, prod_location_4719 (apc)

getting prod_location_4653 (apc)

setting prod_location_toughkenamon,pa,united-states (apc)

setting prod_location_4653 (apc)

getting prod_location_4726 (apc)

setting prod_location_yorklyn,de,united-states (apc)

setting prod_location_4726 (apc)

getting prod_location_4631 (apc)

setting prod_location_avondale,pa,united-states (apc)

setting prod_location_4631 (apc)

getting prod_location_4719 (apc)

setting prod_location_hockessin,de,united-states (apc)

setting prod_location_4719 (apc)