Chris D. of West Chester, PA

Meta: TalkFavorites.me is a Q&A site focused on helping you find the best stuff in your neighborhood.

[0.00027084350585938] Connecting to MySQL server

[0.00051593780517578] SELECT * FROM countries ORDER BY country_name ASC

[0.00096607208251953] SELECT * FROM users WHERE username = 'chris-d-1' LIMIT 1

[0.00015711784362793] 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 -0.3 AND 0.3 AND l.latitude BETWEEN -0.3 AND 0.3

[0.013740062713623] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`text` , `g`.`text_slug` 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`) 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` AS `g` ON (`g`.`question_id` = `d`.`question_id` AND `g`.`location_id` = `d`.`location_id` AND `g`.`user_id` IN ('12')) 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`.`user_id` IN ('12')) ORDER BY `g`.`date_answered` DESC LIMIT 0, 5

[0.0013151168823242] SELECT `a`.* , `b`.`subject` , `c`.`prefix` , `d`.`answers` , `d`.`location_id` , `d`.`ql_id` , `g`.`text` , `g`.`text_slug` 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`) 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` AS `g` ON (`g`.`question_id` = `d`.`question_id` AND `g`.`location_id` = `d`.`location_id` AND `g`.`user_id` IN ('12')) 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 `d`.`user_id` IN ('12')) ORDER BY `d`.`ql_id` DESC LIMIT 0, 5

[0.00034308433532715] 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 = '20017'

[0.00028681755065918] 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 = '8275'

[0.0002892017364502] 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 = '3362'

[0.010751008987427] SELECT u.*, followed_date FROM followers f LEFT JOIN users u on f.user_id = u.user_id WHERE f.followed_user_id = '12' ORDER BY u.username ASC LIMIT 10

[0.0029609203338623] SELECT u.*, followed_date FROM followers f LEFT JOIN users u on f.followed_user_id = u.user_id WHERE f.user_id = '12' ORDER BY u.username ASC LIMIT 10

getting prod_user_chris-d-1 (apc)

setting prod_user_12 (apc)

setting prod_user_chrisdima@me.com (apc)

setting prod_user_chris-d-1 (apc)

getting prod_location_3 (apc)

getting prod_location_33590, prod_location_2 (apc)

getting prod_location_20017, prod_location_8275, prod_location_3362 (apc)

getting prod_location_20017 (apc)

setting prod_location_houston,tx,united-states (apc)

setting prod_location_20017 (apc)

getting prod_location_8275 (apc)

setting prod_location_mccalla,al,united-states (apc)

setting prod_location_8275 (apc)

getting prod_location_3362 (apc)

setting prod_location_belle-vernon,pa,united-states (apc)

setting prod_location_3362 (apc)