Meta: my little taco truck across from sams pizza island in West Chester, PA was Answered in the Following Questions

[0.00030994415283203] Connecting to MySQL server

[0.00066304206848145] SELECT * FROM countries ORDER BY country_name ASC

[0.00081110000610352] 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 = 'my-little-taco-truck-across-from-sams-pizza-island' AND c.country_slug = 'pa'

[0.00044393539428711] 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 = 'my-little-taco-truck-across-from-sams-pizza-island' AND c.country_slug = 'pa'

[0.00056195259094238] SELECT `a`.* , `b`.`subject` , `c`.`prefix` 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`) WHERE (`a`.`question_slug` IN ('my-little-taco-truck-across-from-sams-pizza-island') OR `a`.`response_slug` IN ('my-little-taco-truck-across-from-sams-pizza-island'))

[0.00070714950561523] SELECT * FROM places WHERE location_id = '2' AND place_slug = 'my-little-taco-truck-across-from-sams-pizza-island' LIMIT 1

[0.011137962341309] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`total` , `h`.`comment_id` , `h`.`comment_text` 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')) 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 `responses_summary` AS `g` ON (`g`.`question_id` = `a`.`question_id` AND `g`.`location_id` = `d`.`location_id`) LEFT JOIN `comments` AS `h` ON (`h`.`question_id` = `a`.`question_id` AND `h`.`user_id` IN ('0') AND `h`.`place_id` IN ('1892')) 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 `g`.`text_slug` IN ('my-little-taco-truck-across-from-sams-pizza-island') AND `g`.`total` > '0')

[0.00026392936706543] 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 ('2')) 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.00020885467529297] 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 ('2')) 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.0015969276428223] 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.0019340515136719] 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 ('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 ('7')) ORDER BY `d`.`ql_id` DESC LIMIT 0, 6

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

[0.00010991096496582] 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 = '4655'

[0.00010204315185547] 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 = '4650'

[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 = '4634'

getting prod_location_my-little-taco-truck-across-from-sams-pizza-island,west-chester,pa (apc)

getting prod_location_west-chester,pa,united-states (apc)

getting prod_location_2 (apc)

getting prod_question_my-little-taco-truck-across-from-sams-pizza-island (apc)

getting prod_questions_starter_2, prod_questions_trending_2, prod_questions_newest_2 (apc)

getting prod_questions_trending_2 (apc)

setting prod_questions_trending_2 (apc)

getting prod_questions_newest_2 (apc)

setting prod_questions_newest_2 (apc)

getting prod_subject_related_7 (apc)

getting prod_top5_users_2 (apc)

setting 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)

getting prod_location_4655 (apc)

setting prod_location_westtown,pa,united-states (apc)

setting prod_location_4655 (apc)

getting prod_location_4650 (apc)

setting prod_location_pocopson,pa,united-states (apc)

setting prod_location_4650 (apc)

getting prod_location_4634 (apc)

setting prod_location_cheyney,pa,united-states (apc)

setting prod_location_4634 (apc)