What locals are saying about what's best in Philadelphia, PA

Meta: What locals are saying about what's best in Philadelphia, PA

[0.00025606155395508] Connecting to MySQL server

[0.00057482719421387] SELECT * FROM countries ORDER BY country_name ASC

[0.0043370723724365] 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 ('3')) 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, 10

[0.0022151470184326] 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 = '6' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00094008445739746] 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 = '8' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00084400177001953] 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 = '113' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00064682960510254] 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 = '70' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00057411193847656] 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 = '123' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00071001052856445] 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 = '35' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00048089027404785] 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 = '9' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00053191184997559] 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 = '29' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.00056886672973633] 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 = '173' AND r.location_id = '3' AND r.total > 0 ORDER BY r.total DESC, r.rs_id ASC LIMIT 0,4

[0.0014960765838623] 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 ('3')) 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.0013670921325684] 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.463789 AND -74.863789 AND l.latitude BETWEEN 39.652335 AND 40.252335

[0.0068209171295166] 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 ('11','12','13','14','1803','1807','1809','1810','1811','1812','1814','1816','1817','1819','1820','1821','1822','1823','1824','1825','1826','1827','1830','1831','1833','1835','1836','1837','1838','1840','1841','1843','1844','1845','1846','1847','1848','1852','1854','1855','1856','1858','1860','1861','1862','1863','1867','1868','1870','1873','1875','1876','1877','4586','4587','4588','4589','4590','4591','4592','4593','4595','4596','4597','4598','4599','4601','4602','4603','4604','4605','4606','4607','4608','4610','4612','4613','4615','4616','4617','4618','4619','4620','4621','4622','4623','4624','4625','4626','4627','4628','4629','4632','4636','4656','4657','4658','4661','4672','25729','25734','33595','33596')) 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 )) ORDER BY `d`.`ql_id` DESC , RAND() LIMIT 0, 6

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

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

[0.00030803680419922] 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.0074951648712158] SELECT user_id, username, first_name, last_name, profile_pic, questions, answers FROM users WHERE default_location IN ('3') AND answers > 0 ORDER BY answers DESC LIMIT 0, 5

getting prod_location_philadelphia,pa,united-states (apc)

getting prod_location_3 (apc)

getting prod_questions_starter_3, prod_questions_trending_3, prod_questions_newest_3 (apc)

getting prod_questions_newest_3 (apc)

setting prod_questions_newest_3 (apc)

getting prod_location_33596, prod_location_4672, prod_location_33595 (apc)

getting prod_location_33596 (apc)

setting prod_location_chestnut-hill,pa,united-states (apc)

setting prod_location_33596 (apc)

getting prod_location_4672 (apc)

setting prod_location_plymouth-meeting,pa,united-states (apc)

setting prod_location_4672 (apc)

getting prod_location_33595 (apc)

setting prod_location_conshohocken,pa,united-states (apc)

setting prod_location_33595 (apc)

getting prod_top5_users_3 (apc)

setting prod_top5_users_3 (apc)

getting prod_location_closest_3 (apc)

getting prod_location_11, prod_location_14, prod_location_1875, prod_location_12, prod_location_13 (apc)