Meta: Who Serves The Best Pizza In West Chester, PA?, Results: #1. America's Pie, #2. Saucey, #3. Riggtown Oven, #4. Amore Pizza, #5. Las Vegas Pizza, #6. Culinary Deliveries, #7. Brothers Pizza & Pasta, #8. Peace a Pizza, #9. New Haven Style Pizza, #10. Fiorello's Cafe; TalkFavorites.me
[0.00028705596923828] Connecting to MySQL server
[0.00051784515380859] 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 = 'west-chester' AND slug = 'who-serves-the-best-pizza-in-west-chester' AND c.country_slug = 'pa'
[0.00032496452331543] 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 = 'west-chester' AND slug = 'who-serves-the-best-pizza-in-west-chester' AND c.country_slug = 'pa'
[8.1062316894531E-5] SELECT * FROM questions_location WHERE location_id = '2' AND question_id = '2' LIMIT 1
[0.0026459693908691] 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 = '2' AND r.location_id = '2' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,11
[0.00014901161193848] 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 = '2' AND r.location_id = '2' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,11
[0.0033359527587891] SELECT subject2_id FROM questions_subject_related WHERE subject1_id IN ('1')
[0.0010809898376465] 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.9054882 AND -75.3054882 AND l.latitude BETWEEN 39.6606643 AND 40.2606643
[0.0023131370544434] 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','1812','1848','1850','4588','4590','4592','4593','4594','4597','4603','4607','4612','4613','4615','4616','4619','4620','4622','4623','4624','4625','4626','4628','4630','4631','4632','4633','4634','4636','4637','4638','4639','4640','4643','4644','4645','4650','4651','4652','4653','4654','4655','4656','4657','4658','4659','4660','4662','4663','4669','4671','4676','4678','4692','4717','4719','4725','4726','4727','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 ('1') AND `d`.`ql_id` <> '518') ORDER BY `d`.`ql_id` DESC LIMIT 0, 6
[0.00037407875061035] 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 = '4717'
[0.00035309791564941] 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 = '4727'
getting prod_location_who-serves-the-best-pizza-in-west-chester,west-chester,pa (apc)
getting prod_location_west-chester,pa,united-states (apc)
getting prod_location_2 (apc)
getting prod_question_who-serves-the-best-pizza (apc)
getting prod_question_2 (apc)
getting prod_responses_2_2 (apc)
setting prod_responses_2_2 (apc)
setting prod_responses_2_2 (apc)
getting prod_questions_starter_2, prod_questions_trending_2, prod_questions_newest_2 (apc)
getting prod_subject_related_1 (apc)
setting prod_subject_related_1 (apc)
getting prod_location_4717, prod_location_4727 (apc)
getting prod_location_4717 (apc)
setting prod_location_claymont,de,united-states (apc)
setting prod_location_4717 (apc)
getting prod_location_4727 (apc)
setting prod_location_wilmington,de,united-states (apc)
setting prod_location_4727 (apc)
getting prod_top5_users_2 (apc)
getting prod_location_closest_2 (apc)
getting prod_location_4655, prod_location_4650, prod_location_4634, prod_location_25737, prod_location_4639 (apc)
Login type: ;