time: 0.000147 query: SELECT * FROM salt params:

time: 0.000043 query: SELECT * FROM salt params:

time: 0.000292 query: SELECT * FROM city WHERE (url = 'хомутово') params:

time: 0.000274 query: SELECT * FROM groups WHERE (url = 'оптовая-продажа-пива-и-на-разлив') params:

time: 0.000137 query: SELECT * FROM city WHERE (id = '10657') params:

time: 0.000124 query: SELECT * FROM groups WHERE (id = '588') params:

time: 0.000675 query: SELECT * FROM canonical_groups WHERE (groups_id = '588') params:

time: 0.000318 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 588, 10657

time: 0.005548 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?) ) params: 976254, 976257, 2394336, 2417020, 3518665, 3536382

time: 0.000334 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?,?,?,?,?) ) params: 976254, 976257, 2394336, 2417020, 3518665, 3536382

time: 0.000237 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?) ) params: 976254, 976257, 2394336, 2417020, 3518665, 3536382

time: 0.000363 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: 588, 10657

time: 0.000304 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: 588, 10657

time: 0.000331 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?) ) ORDER BY random LIMIT 25 params: 976254, 976257, 2394336, 2417020, 3518665, 3536382

time: 0.000263 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3536382') params:

time: 0.000198 query: SELECT * FROM comment WHERE (comment.firm_id IN (3536382, 976254, 2394336, 2417020, 976257, 3518665)) params:

time: 0.000140 query: SELECT * FROM firm_contacts WHERE (firm_id = '3536382') params:

time: 0.000163 query: SELECT * FROM city WHERE (city.id IN (10657)) params:

time: 0.000134 query: SELECT AVG(score) FROM comment WHERE (firm_id = '976254') params:

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

time: 0.000184 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2394336') params:

time: 0.000170 query: SELECT * FROM firm_contacts WHERE (firm_id = '2394336') params:

time: 0.000136 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2417020') params:

time: 0.000130 query: SELECT * FROM firm_contacts WHERE (firm_id = '2417020') params:

time: 0.000175 query: SELECT AVG(score) FROM comment WHERE (firm_id = '976257') params:

time: 0.000144 query: SELECT * FROM firm_contacts WHERE (firm_id = '976257') params:

time: 0.000135 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3518665') params:

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

time: 0.000221 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 588, 10657

time: 0.000383 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: 588, 10657

time: 0.000054 query: SELECT * FROM city WHERE (city.id IN (10657)) params:

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

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

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

time: 0.000049 query: SELECT * FROM city WHERE (id = '10657') params:

time: 0.000048 query: SELECT * FROM city WHERE (id = '10657') params:

time: 0.000049 query: SELECT * FROM city WHERE (id = '10657') params:

time: 0.000059 query: SELECT * FROM city WHERE (url = 'хомутово') params:

time: 0.000050 query: SELECT * FROM city WHERE (id = '10657') params: