time: 0.000082 query: SELECT * FROM salt params:

time: 0.000040 query: SELECT * FROM salt params:

time: 0.000095 query: SELECT * FROM city WHERE (url = 'молочное') params:

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

time: 0.000075 query: SELECT * FROM city WHERE (id = '9121') params:

time: 0.000136 query: SELECT * FROM groups WHERE (id = '108') params:

time: 0.000428 query: SELECT * FROM canonical_groups WHERE (groups_id = '108') params:

time: 0.000227 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 108, 9121

time: 0.000173 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?) ) params: 1392716

time: 0.000161 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?) ) params: 1392716

time: 0.000146 query: SELECT COUNT(*) FROM firm WHERE (id IN(?) ) params: 1392716

time: 0.000192 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: 108, 9121

time: 0.000188 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: 108, 9121

time: 0.000118 query: SELECT * FROM firm WHERE (id IN(?) ) ORDER BY random LIMIT 25 params: 1392716

time: 0.000170 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1392716') params:

time: 0.000131 query: SELECT * FROM comment WHERE (comment.firm_id IN (1392716)) params:

time: 0.000119 query: SELECT * FROM firm_contacts WHERE (firm_id = '1392716') params:

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

time: 0.000150 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 108, 9121

time: 0.000284 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: 108, 9121

time: 0.000046 query: SELECT * FROM city WHERE (city.id IN (9121)) params:

time: 0.000057 query: SELECT * FROM city WHERE (id = '9121') params:

time: 0.000045 query: SELECT * FROM city WHERE (url = 'молочное') params:

time: 0.000033 query: SELECT * FROM city WHERE (id = '9121') params: