Who Serves The Best Fast Food In Phoenixville, PA?

Meta: Who Serves The Best Fast Food In Phoenixville, PA?, Results: ; TalkFavorites.me

[0.00026917457580566] Connecting to MySQL server

[0.00050997734069824] SELECT * FROM countries ORDER BY country_name ASC

[0.00055694580078125] 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 = 'phoenixville' AND slug = 'who-serves-the-best-fast-food-in-phoenixville' AND c.country_slug = 'pa'

[0.00037193298339844] 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 = 'phoenixville' AND slug = 'who-serves-the-best-fast-food-in-phoenixville' AND c.country_slug = 'pa'

[7.2002410888672E-5] SELECT * FROM questions_location WHERE location_id = '4671' AND question_id = '58' LIMIT 1

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

[9.0122222900391E-5] 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 = '58' AND r.location_id = '4671' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,11

[0.00015401840209961] 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 ('4671')) 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.0001068115234375] 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 ('4671')) 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.00034999847412109] 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 ('4671')) WHERE (`a`.`status` IN ('new','open') AND `d`.`ql_id` IS NULL )

[0.0012588500976562] 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.8149128 AND -75.2149128 AND l.latitude BETWEEN 39.8303822 AND 40.4303822

[0.0021491050720215] 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','4355','4369','4370','4371','4554','4558','4563','4565','4576','4580','4581','4586','4587','4588','4590','4594','4595','4610','4612','4613','4615','4616','4622','4623','4624','4625','4626','4630','4632','4633','4634','4636','4637','4638','4639','4640','4650','4651','4652','4655','4656','4657','4658','4659','4660','4661','4662','4663','4664','4665','4666','4667','4668','4669','4670','4671','4672','4673','4674','4675','4676','4677','4678','4679','4680','4684','4687','4689','4691','4693','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 ) AND `a`.`subject_id` IN ('41') AND `d`.`ql_id` <> '0') ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

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

[0.0013020038604736] 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.8149128 AND -75.2149128 AND l.latitude BETWEEN 39.8303822 AND 40.4303822

[0.0018649101257324] SELECT location_id, COUNT(response_id) AS activity FROM responses WHERE location_id IN ('2','4576','4590','4616','4625','4626','4630','4632','4636','4637','4639','4656','4657','4658','4659','4660','4662','4663','4664','4665','4667','4669','4672','4673','4674','4675','4676','4677','4678','4679','4680','25735','25738','33595') AND date_answered > '2013-05-12 03:06:16' GROUP BY location_id ORDER BY activity DESC LIMIT 5

[9.4890594482422E-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 = '33595'

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

[8.9883804321289E-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 = '4678'

[8.082389831543E-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 = '4676'

getting prod_location_who-serves-the-best-fast-food-in-phoenixville,phoenixville,pa (apc)

getting prod_location_phoenixville,pa,united-states (apc)

getting prod_location_4671 (apc)

getting prod_question_who-serves-the-best-fast-food (apc)

getting prod_question_58 (apc)

getting prod_responses_58_4671 (apc)

setting prod_responses_58_4671 (apc)

setting prod_responses_58_4671 (apc)

getting prod_questions_starter_4671, prod_questions_trending_4671, prod_questions_newest_4671 (apc)

getting prod_questions_trending_4671 (apc)

setting prod_questions_trending_4671 (apc)

getting prod_questions_newest_4671 (apc)

setting prod_questions_newest_4671 (apc)

setting prod_questions_starter_4671 (apc)

getting prod_subject_related_41 (apc)

getting prod_top5_users_4671 (apc)

setting prod_top5_users_4671 (apc)

getting prod_location_closest_4671 (apc)

setting prod_location_closest_4671 (apc)

getting prod_location_2, prod_location_33595, prod_location_4669, prod_location_4678, prod_location_4676 (apc)

getting prod_location_33595 (apc)

setting prod_location_conshohocken,pa,united-states (apc)

setting prod_location_33595 (apc)

getting prod_location_4669 (apc)

setting prod_location_mont-clare,pa,united-states (apc)

setting prod_location_4669 (apc)

getting prod_location_4678 (apc)

setting prod_location_valley-forge,pa,united-states (apc)

setting prod_location_4678 (apc)

getting prod_location_4676 (apc)

setting prod_location_spring-city,pa,united-states (apc)

setting prod_location_4676 (apc)