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

[0.00025296211242676] Connecting to MySQL server

[0.00047206878662109] SELECT * FROM countries ORDER BY country_name ASC

[0.0040090084075928] 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 = 'scarborough' AND slug = 'where-is-the-best-breakfast-place' AND c.country_slug = 'on'

[0.00081396102905273] 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 = 'scarborough' AND slug = 'where-is-the-best-breakfast-place' AND c.country_slug = 'on'

[0.00097203254699707] 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 = 'on' AND slug = 'scarborough' AND c.country_slug = 'united-states'

[0.00087904930114746] 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 = 'on' AND slug = 'scarborough' AND c.country_slug = 'united-states'

[0.0001380443572998] 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

getting prod_location_where-is-the-best-breakfast-place,scarborough,on (apc)

getting prod_location_scarborough,on,united-states (apc)

getting prod_location_3 (apc)