time: 0.000137 query: SELECT * FROM salt params:

time: 0.000076 query: SELECT * FROM salt params:

time: 0.000261 query: SELECT * FROM city WHERE (url = 'смоленское') params:

time: 0.000181 query: SELECT * FROM groups WHERE (url = 'услуги-детективов-и-вневедомственных-охранных-агентств') params:

time: 0.000102 query: SELECT * FROM city WHERE (id = '10147') params:

time: 0.000085 query: SELECT * FROM groups WHERE (id = '545') params:

time: 0.000470 query: SELECT * FROM canonical_groups WHERE (groups_id = '545') params:

time: 0.000223 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 545, 10147

time: 0.000139 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?) ) params: 1641292, 2222521

time: 0.000127 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?) ) params: 1641292, 2222521

time: 0.000090 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?) ) params: 1641292, 2222521

time: 0.000239 query: SELECT firm.street_url,firm.street FROM firm_group LEFT JOIN firm ON firm_group.firm_id = firm.id WHERE (firm_group.groups_id = ? AND firm_group.city_id = ?) GROUP BY firm.street_url params: 545, 10147

time: 0.000254 query: SELECT firm.district_url,firm.district FROM firm_group LEFT JOIN firm ON firm_group.firm_id = firm.id WHERE (firm_group.groups_id = ? AND firm_group.city_id = ?) GROUP BY firm.district_url params: 545, 10147

time: 0.000175 query: SELECT * FROM firm WHERE (id IN(?,?) ) ORDER BY random LIMIT 25 params: 1641292, 2222521

time: 0.000199 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1641292') params:

time: 0.000121 query: SELECT * FROM comment WHERE (comment.firm_id IN (1641292, 2222521)) params:

time: 0.000099 query: SELECT * FROM firm_contacts WHERE (firm_id = '1641292') params:

time: 0.000105 query: SELECT * FROM city WHERE (city.id IN (10147)) params:

time: 0.000147 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2222521') params:

time: 0.000134 query: SELECT * FROM firm_contacts WHERE (firm_id = '2222521') params:

time: 0.000145 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 545, 10147

time: 0.000258 query: SELECT DISTINCT firm_group.firm_id AS id,firm.name,firm.url,firm.subtitle,firm.city_id,firm.address FROM firm_group LEFT JOIN firm ON firm_group.firm_id = firm.id WHERE (firm_group.groups_id = ? AND firm_group.city_id = ?) ORDER BY id DESC LIMIT 3 params: 545, 10147

time: 0.000032 query: SELECT * FROM city WHERE (city.id IN (10147)) params:

time: 0.000065 query: SELECT * FROM city WHERE (id = '10147') params:

time: 0.000051 query: SELECT * FROM city WHERE (id = '10147') params:

time: 0.000048 query: SELECT * FROM city WHERE (url = 'смоленское') params:

time: 0.000041 query: SELECT * FROM city WHERE (id = '10147') params: