time: 0.000132 query: SELECT * FROM salt params:

time: 0.000059 query: SELECT * FROM salt params:

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

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

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

time: 0.000171 query: SELECT * FROM groups WHERE (id = '561') params:

time: 0.000415 query: SELECT * FROM canonical_groups WHERE (groups_id = '561') params:

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

time: 0.000255 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1397148, 1397168, 1397170, 1397183, 1397194, 1397196, 1397199, 1397231, 2277948, 2278235, 2278277, 2278404

time: 0.000187 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1397148, 1397168, 1397170, 1397183, 1397194, 1397196, 1397199, 1397231, 2277948, 2278235, 2278277, 2278404

time: 0.000153 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1397148, 1397168, 1397170, 1397183, 1397194, 1397196, 1397199, 1397231, 2277948, 2278235, 2278277, 2278404

time: 0.000251 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: 561, 9121

time: 0.000259 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: 561, 9121

time: 0.000236 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?) ) ORDER BY random LIMIT 25 params: 1397148, 1397168, 1397170, 1397183, 1397194, 1397196, 1397199, 1397231, 2277948, 2278235, 2278277, 2278404

time: 0.000268 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2278277') params:

time: 0.000196 query: SELECT * FROM comment WHERE (comment.firm_id IN (2278277, 1397199, 1397168, 1397170, 1397183, 2278235, 1397194, 1397196, 1397148, 2278404, 1397231, 2277948)) params:

time: 0.000122 query: SELECT * FROM firm_contacts WHERE (firm_id = '2278277') params:

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

time: 0.000128 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397199') params:

time: 0.000141 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397199') params:

time: 0.000120 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397168') params:

time: 0.000112 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397168') params:

time: 0.000133 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397170') params:

time: 0.000118 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397170') params:

time: 0.000100 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397183') params:

time: 0.000116 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397183') params:

time: 0.000114 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2278235') params:

time: 0.000123 query: SELECT * FROM firm_contacts WHERE (firm_id = '2278235') params:

time: 0.000146 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397194') params:

time: 0.000125 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397194') params:

time: 0.000131 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397196') params:

time: 0.000147 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397196') params:

time: 0.000110 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397148') params:

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

time: 0.000100 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2278404') params:

time: 0.000132 query: SELECT * FROM firm_contacts WHERE (firm_id = '2278404') params:

time: 0.000128 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1397231') params:

time: 0.000121 query: SELECT * FROM firm_contacts WHERE (firm_id = '1397231') params:

time: 0.000110 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2277948') params:

time: 0.000122 query: SELECT * FROM firm_contacts WHERE (firm_id = '2277948') params:

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

time: 0.000333 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: 561, 9121

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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