time: 0.000115 query: SELECT * FROM salt params:

time: 0.000043 query: SELECT * FROM salt params:

time: 0.000188 query: SELECT * FROM city WHERE (url = 'медвежьи-озёра') params:

time: 0.000043 query: SELECT * FROM groups WHERE (url = 'служба-скорой-помощи-и-пожарной-охраны') params:

time: 0.000106 query: SELECT * FROM city WHERE (id = '9031') params:

time: 0.000043 query: SELECT * FROM groups WHERE (id = '6') params:

time: 0.000040 query: SELECT * FROM canonical_groups WHERE (groups_id = '6') params:

time: 0.000202 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 6, 9031

time: 0.000193 query: SELECT * FROM firm WHERE (street_url = 'юбилейная') LIMIT 1 params:

time: 0.000169 query: SELECT COUNT(*) FROM firm_contacts LEFT JOIN firm ON firm_contacts.firm_id = firm.id WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?) AND firm.street_url = ? ) params: 3473672, юбилейная

time: 0.000212 query: SELECT COUNT(DISTINCT user) FROM comment LEFT JOIN firm ON comment.firm_id = firm.id WHERE (comment.firm_id IN(?) AND firm.street_url = ? ) params: 3473672, юбилейная

time: 0.000106 query: SELECT COUNT(*) FROM firm WHERE (id IN(?) AND firm.street_url = ? ) params: 3473672, юбилейная

time: 0.000196 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: 6, 9031

time: 0.000185 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: 6, 9031

time: 0.000148 query: SELECT * FROM firm WHERE (id IN(?) AND firm.street_url = ? ) ORDER BY random LIMIT 25 params: 3473672, юбилейная

time: 0.000158 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3473672') params:

time: 0.000119 query: SELECT * FROM comment WHERE (comment.firm_id IN (3473672)) params:

time: 0.000129 query: SELECT * FROM firm_contacts WHERE (firm_id = '3473672') params:

time: 0.000115 query: SELECT * FROM city WHERE (city.id IN (9031)) params:

time: 0.000166 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 6, 9031

time: 0.000247 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: 6, 9031

time: 0.000077 query: SELECT * FROM city WHERE (city.id IN (9031)) params:

time: 0.000085 query: SELECT * FROM city WHERE (id = '9031') params:

time: 0.000092 query: SELECT * FROM city WHERE (url = 'медвежьи-озёра') params:

time: 0.000077 query: SELECT * FROM city WHERE (id = '9031') params: