time: 0.000151 query: SELECT * FROM salt params:

time: 0.000090 query: SELECT * FROM salt params:

time: 0.000043 query: SELECT * FROM city WHERE (url = 'самара') params:

time: 0.000198 query: SELECT * FROM groups WHERE (url = 'областные-и-районные-военные-комиссариаты') params:

time: 0.000035 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000081 query: SELECT * FROM groups WHERE (id = '65') params:

time: 0.000442 query: SELECT * FROM canonical_groups WHERE (groups_id = '65') params:

time: 0.000216 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 65, 10007

time: 0.000231 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 609412, 609413, 609414, 609415, 609416, 609417, 609418, 609419, 609420, 609421, 3095341, 3136302, 3136318

time: 0.000208 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 609412, 609413, 609414, 609415, 609416, 609417, 609418, 609419, 609420, 609421, 3095341, 3136302, 3136318

time: 0.000178 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 609412, 609413, 609414, 609415, 609416, 609417, 609418, 609419, 609420, 609421, 3095341, 3136302, 3136318

time: 0.000291 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: 65, 10007

time: 0.000265 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: 65, 10007

time: 0.000246 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?) ) ORDER BY random LIMIT 25 params: 609412, 609413, 609414, 609415, 609416, 609417, 609418, 609419, 609420, 609421, 3095341, 3136302, 3136318

time: 0.000324 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609417') params:

time: 0.000187 query: SELECT * FROM comment WHERE (comment.firm_id IN (609417, 609420, 609419, 609421, 609414, 609418, 609415, 609416, 3095341, 609413, 609412, 3136318, 3136302)) params:

time: 0.000137 query: SELECT * FROM firm_contacts WHERE (firm_id = '609417') params:

time: 0.000093 query: SELECT * FROM city WHERE (city.id IN (10007)) params:

time: 0.000122 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609420') params:

time: 0.000139 query: SELECT * FROM firm_contacts WHERE (firm_id = '609420') params:

time: 0.000122 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609419') params:

time: 0.000110 query: SELECT * FROM firm_contacts WHERE (firm_id = '609419') params:

time: 0.000137 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609421') params:

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

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

time: 0.000145 query: SELECT * FROM firm_contacts WHERE (firm_id = '609414') params:

time: 0.000105 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609418') params:

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

time: 0.000111 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609415') params:

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

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

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

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

time: 0.000093 query: SELECT * FROM firm_contacts WHERE (firm_id = '3095341') params:

time: 0.000119 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609413') params:

time: 0.000084 query: SELECT * FROM firm_contacts WHERE (firm_id = '609413') params:

time: 0.000081 query: SELECT AVG(score) FROM comment WHERE (firm_id = '609412') params:

time: 0.000081 query: SELECT * FROM firm_contacts WHERE (firm_id = '609412') params:

time: 0.000118 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3136318') params:

time: 0.000139 query: SELECT * FROM firm_contacts WHERE (firm_id = '3136318') params:

time: 0.000115 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3136302') params:

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

time: 0.000167 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 65, 10007

time: 0.000330 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: 65, 10007

time: 0.000033 query: SELECT * FROM city WHERE (city.id IN (10007)) params:

time: 0.000083 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000059 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000056 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000056 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000028 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000026 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000054 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000055 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000027 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000025 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000026 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000028 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000056 query: SELECT * FROM city WHERE (id = '10007') params:

time: 0.000059 query: SELECT * FROM city WHERE (url = 'самара') params:

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