time: 0.000124 query: SELECT * FROM salt params:

time: 0.000055 query: SELECT * FROM salt params:

time: 0.000283 query: SELECT * FROM city WHERE (url = 'чита') params:

time: 0.000219 query: SELECT * FROM groups WHERE (url = 'органы-государственного-надзора-и-инспекции') params:

time: 0.000109 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000100 query: SELECT * FROM groups WHERE (id = '78') params:

time: 0.000430 query: SELECT * FROM canonical_groups WHERE (groups_id = '78') params:

time: 0.000286 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 78, 10767

time: 0.000494 query: SELECT COUNT(*) FROM firm_contacts WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1523434, 1523435, 1523436, 1523437, 1523438, 1523439, 1523440, 1523441, 1523442, 1523443, 1523444, 1523445, 1523511, 1523512, 1523513, 1523514, 1523515, 1523516, 1523517, 1523518, 1523519, 3216829, 3216957, 3319848, 3328324, 3328436, 3328987, 3333433, 3334094, 3334099, 3334104, 3334108, 3334120, 3335614, 3337680, 3338377, 3340861, 3343599, 3345579

time: 0.000326 query: SELECT COUNT(DISTINCT user) FROM comment WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1523434, 1523435, 1523436, 1523437, 1523438, 1523439, 1523440, 1523441, 1523442, 1523443, 1523444, 1523445, 1523511, 1523512, 1523513, 1523514, 1523515, 1523516, 1523517, 1523518, 1523519, 3216829, 3216957, 3319848, 3328324, 3328436, 3328987, 3333433, 3334094, 3334099, 3334104, 3334108, 3334120, 3335614, 3337680, 3338377, 3340861, 3343599, 3345579

time: 0.000274 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) params: 1523434, 1523435, 1523436, 1523437, 1523438, 1523439, 1523440, 1523441, 1523442, 1523443, 1523444, 1523445, 1523511, 1523512, 1523513, 1523514, 1523515, 1523516, 1523517, 1523518, 1523519, 3216829, 3216957, 3319848, 3328324, 3328436, 3328987, 3333433, 3334094, 3334099, 3334104, 3334108, 3334120, 3335614, 3337680, 3338377, 3340861, 3343599, 3345579

time: 0.000382 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: 78, 10767

time: 0.000344 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: 78, 10767

time: 0.000488 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) ) ORDER BY random LIMIT 25 params: 1523434, 1523435, 1523436, 1523437, 1523438, 1523439, 1523440, 1523441, 1523442, 1523443, 1523444, 1523445, 1523511, 1523512, 1523513, 1523514, 1523515, 1523516, 1523517, 1523518, 1523519, 3216829, 3216957, 3319848, 3328324, 3328436, 3328987, 3333433, 3334094, 3334099, 3334104, 3334108, 3334120, 3335614, 3337680, 3338377, 3340861, 3343599, 3345579

time: 0.000247 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523511') params:

time: 0.000277 query: SELECT * FROM comment WHERE (comment.firm_id IN (1523511, 3216957, 3334104, 3334120, 1523445, 1523441, 1523516, 3335614, 1523444, 3345579, 1523442, 3334108, 1523517, 3334094, 1523443, 3328987, 1523434, 3319848, 1523438, 1523513, 1523436, 1523437, 1523512, 1523440, 1523515)) params:

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

time: 0.000134 query: SELECT * FROM city WHERE (city.id IN (10767)) params:

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

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

time: 0.000112 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3334104') params:

time: 0.000115 query: SELECT * FROM firm_contacts WHERE (firm_id = '3334104') params:

time: 0.000106 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3334120') params:

time: 0.000120 query: SELECT * FROM firm_contacts WHERE (firm_id = '3334120') params:

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

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

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

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

time: 0.000126 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523516') params:

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

time: 0.000109 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3335614') params:

time: 0.000114 query: SELECT * FROM firm_contacts WHERE (firm_id = '3335614') params:

time: 0.000162 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523444') params:

time: 0.000178 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523444') params:

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

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

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

time: 0.000131 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523442') params:

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

time: 0.000109 query: SELECT * FROM firm_contacts WHERE (firm_id = '3334108') params:

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

time: 0.000127 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523517') params:

time: 0.000142 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3334094') params:

time: 0.000142 query: SELECT * FROM firm_contacts WHERE (firm_id = '3334094') params:

time: 0.000144 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523443') params:

time: 0.000138 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523443') params:

time: 0.000143 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3328987') params:

time: 0.000154 query: SELECT * FROM firm_contacts WHERE (firm_id = '3328987') params:

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

time: 0.000165 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523434') params:

time: 0.000139 query: SELECT AVG(score) FROM comment WHERE (firm_id = '3319848') params:

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

time: 0.000141 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523438') params:

time: 0.000151 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523438') params:

time: 0.000130 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523513') params:

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

time: 0.000155 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523436') params:

time: 0.000163 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523436') params:

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

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

time: 0.000132 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523512') params:

time: 0.000146 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523512') params:

time: 0.000155 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523440') params:

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

time: 0.000159 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1523515') params:

time: 0.000150 query: SELECT * FROM firm_contacts WHERE (firm_id = '1523515') params:

time: 0.000270 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 78, 10767

time: 0.000770 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: 78, 10767

time: 0.000044 query: SELECT * FROM city WHERE (city.id IN (10767)) params:

time: 0.000063 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000044 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000044 query: SELECT * FROM city WHERE (id = '10767') params:

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

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

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

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

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

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

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

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

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

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

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

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

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

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

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

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

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

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

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000038 query: SELECT * FROM city WHERE (id = '10767') params:

time: 0.000042 query: SELECT * FROM city WHERE (url = 'чита') params:

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