time: 0.000115 query: SELECT * FROM salt params:

time: 0.000027 query: SELECT * FROM salt params:

time: 0.000248 query: SELECT * FROM city WHERE (url = 'гурьевск') params:

time: 0.000182 query: SELECT * FROM groups WHERE (url = 'контрактные-автозапчасти-и-запчасти-для-иномарок') params:

time: 0.000087 query: SELECT * FROM city WHERE (id = '7885') params:

time: 0.000060 query: SELECT * FROM groups WHERE (id = '25') params:

time: 0.000056 query: SELECT * FROM canonical_groups WHERE (groups_id = '25') params:

time: 0.000255 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 25, 7885

time: 0.000280 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?) ) params: 1245182, 1245557, 1817404, 1817422, 1817589, 2150283, 2400046, 2416051, 2428656, 2468401, 2542453

time: 0.000226 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?) ) params: 1245182, 1245557, 1817404, 1817422, 1817589, 2150283, 2400046, 2416051, 2428656, 2468401, 2542453

time: 0.000214 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?) ) params: 1245182, 1245557, 1817404, 1817422, 1817589, 2150283, 2400046, 2416051, 2428656, 2468401, 2542453

time: 0.000256 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: 25, 7885

time: 0.000244 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: 25, 7885

time: 0.000210 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?) ) ORDER BY random LIMIT 25 params: 1245182, 1245557, 1817404, 1817422, 1817589, 2150283, 2400046, 2416051, 2428656, 2468401, 2542453

time: 0.000239 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2542453') params:

time: 0.000164 query: SELECT * FROM comment WHERE (comment.firm_id IN (2542453, 2428656, 2150283, 1817589, 1817404, 1245182, 1817422, 2416051, 1245557, 2400046, 2468401)) params:

time: 0.000126 query: SELECT * FROM firm_contacts WHERE (firm_id = '2542453') params:

time: 0.000120 query: SELECT * FROM city WHERE (city.id IN (7885)) params:

time: 0.000099 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2428656') params:

time: 0.000105 query: SELECT * FROM firm_contacts WHERE (firm_id = '2428656') params:

time: 0.000101 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2150283') params:

time: 0.000106 query: SELECT * FROM firm_contacts WHERE (firm_id = '2150283') params:

time: 0.000099 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1817589') params:

time: 0.000155 query: SELECT * FROM firm_contacts WHERE (firm_id = '1817589') params:

time: 0.000107 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1817404') params:

time: 0.000107 query: SELECT * FROM firm_contacts WHERE (firm_id = '1817404') params:

time: 0.000098 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1245182') params:

time: 0.000105 query: SELECT * FROM firm_contacts WHERE (firm_id = '1245182') params:

time: 0.000117 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1817422') params:

time: 0.000105 query: SELECT * FROM firm_contacts WHERE (firm_id = '1817422') params:

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

time: 0.000106 query: SELECT * FROM firm_contacts WHERE (firm_id = '2416051') params:

time: 0.000104 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1245557') params:

time: 0.000104 query: SELECT * FROM firm_contacts WHERE (firm_id = '1245557') params:

time: 0.000103 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2400046') params:

time: 0.000104 query: SELECT * FROM firm_contacts WHERE (firm_id = '2400046') params:

time: 0.000102 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2468401') params:

time: 0.000106 query: SELECT * FROM firm_contacts WHERE (firm_id = '2468401') params:

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

time: 0.000302 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: 25, 7885

time: 0.000043 query: SELECT * FROM city WHERE (city.id IN (7885)) params:

time: 0.000061 query: SELECT * FROM city WHERE (id = '7885') params:

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

time: 0.000040 query: SELECT * FROM city WHERE (id = '7885') params:

time: 0.000040 query: SELECT * FROM city WHERE (id = '7885') params:

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

time: 0.000040 query: SELECT * FROM city WHERE (id = '7885') params:

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

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

time: 0.000037 query: SELECT * FROM city WHERE (id = '7885') params:

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

time: 0.000037 query: SELECT * FROM city WHERE (id = '7885') params:

time: 0.000042 query: SELECT * FROM city WHERE (url = 'гурьевск') params:

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