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

[0.00035786628723145] Connecting to MySQL server

[0.00064301490783691] SELECT * FROM countries ORDER BY country_name ASC

[0.00046110153198242] 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 = 'what-is-the-best-grocery-store' AND c.country_slug = 'on'

[0.00034689903259277] 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 = 'what-is-the-best-grocery-store' AND c.country_slug = 'on'

[0.00080180168151855] 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.00048613548278809] 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.00019311904907227] 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_what-is-the-best-grocery-store,scarborough,on (apc)

getting prod_location_scarborough,on,united-states (apc)

getting prod_location_3 (apc)