time: 0.000103 query: SELECT * FROM salt params:

time: 0.000043 query: SELECT * FROM salt params:

time: 0.000169 query: SELECT * FROM city WHERE (url = 'липецк') params:

time: 0.000045 query: SELECT * FROM groups WHERE (url = 'служба-скорой-помощи-и-пожарной-охраны') params:

time: 0.000115 query: SELECT * FROM city WHERE (id = '8838') params:

time: 0.000046 query: SELECT * FROM groups WHERE (id = '6') params:

time: 0.000040 query: SELECT * FROM canonical_groups WHERE (groups_id = '6') params:

time: 0.000280 query: SELECT DISTINCT firm_id AS id FROM firm_group WHERE (groups_id = ? AND city_id = ?) params: 6, 8838

time: 0.000234 query: SELECT * FROM firm WHERE (street_url = 'московская') LIMIT 1 params:

time: 0.000228 query: SELECT * FROM firm WHERE (district_url = 'октябрьский-округ') LIMIT 1 params:

time: 0.000877 query: SELECT COUNT(*) FROM firm_contacts LEFT JOIN firm ON firm_contacts.firm_id = firm.id WHERE (firm_contacts.type = 'phone' AND firm_contacts.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) params: 1400637, 1400638, 1400640, 1400641, 1400642, 1400643, 1400670, 1400671, 1400672, 1400673, 1400674, 1400675, 2574507, 2582463, 2591599, 2599915, 2604548, 2607986, 2611576, 2612255, 2618785, 2618802, 2621180, 2623397, 2626221, 2632762, московская, октябрьский-округ

time: 0.000631 query: SELECT COUNT(DISTINCT user) FROM comment LEFT JOIN firm ON comment.firm_id = firm.id WHERE (comment.firm_id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) params: 1400637, 1400638, 1400640, 1400641, 1400642, 1400643, 1400670, 1400671, 1400672, 1400673, 1400674, 1400675, 2574507, 2582463, 2591599, 2599915, 2604548, 2607986, 2611576, 2612255, 2618785, 2618802, 2621180, 2623397, 2626221, 2632762, московская, октябрьский-округ

time: 0.000500 query: SELECT COUNT(*) FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) params: 1400637, 1400638, 1400640, 1400641, 1400642, 1400643, 1400670, 1400671, 1400672, 1400673, 1400674, 1400675, 2574507, 2582463, 2591599, 2599915, 2604548, 2607986, 2611576, 2612255, 2618785, 2618802, 2621180, 2623397, 2626221, 2632762, московская, октябрьский-округ

time: 0.000418 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: 6, 8838

time: 0.000405 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: 6, 8838

time: 0.000561 query: SELECT * FROM firm WHERE (id IN(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) AND firm.street_url = ? AND firm.district_url = ?) ORDER BY random LIMIT 25 params: 1400637, 1400638, 1400640, 1400641, 1400642, 1400643, 1400670, 1400671, 1400672, 1400673, 1400674, 1400675, 2574507, 2582463, 2591599, 2599915, 2604548, 2607986, 2611576, 2612255, 2618785, 2618802, 2621180, 2623397, 2626221, 2632762, московская, октябрьский-округ

time: 0.000176 query: SELECT AVG(score) FROM comment WHERE (firm_id = '1400670') params:

time: 0.000171 query: SELECT * FROM comment WHERE (comment.firm_id IN (1400670, 2599915, 2582463)) params:

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

time: 0.000173 query: SELECT * FROM city WHERE (city.id IN (8838)) params:

time: 0.000169 query: SELECT AVG(score) FROM comment WHERE (firm_id = '2599915') params:

time: 0.000158 query: SELECT * FROM firm_contacts WHERE (firm_id = '2599915') params:

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

time: 0.000169 query: SELECT * FROM firm_contacts WHERE (firm_id = '2582463') params:

time: 0.000212 query: SELECT * FROM comment WHERE (groups_id = ? AND city_id = ?) ORDER BY date DESC LIMIT 3 params: 6, 8838

time: 0.000513 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: 6, 8838

time: 0.000051 query: SELECT * FROM city WHERE (city.id IN (8838)) params:

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

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

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

time: 0.000056 query: SELECT * FROM city WHERE (url = 'липецк') params:

time: 0.000047 query: SELECT * FROM city WHERE (id = '8838') params: